Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan
...expression on text sent by http request in body and extract text in json format as http response . The function should be triggered by http request with input text in body and output text in response. Similar to the one in below link except the sample is update and my requirement is extract with response. [log masuk untuk melihat URL]
...excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values from cells on one sheet (all cells are named with unique values)
...directors/strength and conditioning coaches/etc., copied from a website and pasted to an excel spreadsheet. I then need the emails to be extracted from the hyperlink, from the contact, and added to the correct contact on the spreadsheet. I have attached an example of the list you will be pulling from the online portal, and the spreadsheet information I
Extra data from one website ([log masuk untuk melihat URL]): Sub-category, business name, address, phone, email, etc. Only for category "Construction & Renovation" and a few other sub-categories Put them in Excel format
We have got a SQL dump which comes from our old ecommerce site (PHP DBMS). We need a programmer to extract the data from the SQL and build a new SQL with it. We also need some sort of admin to control / filter / output the data. The SQL contains customer info, previous orders, sold products, etc. It is a 200MB SQL file with loads of information
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
1) Figure out and extract main API calls from bumble app https://bumble.com. Most important are - login via phone number, setup profile, get people, swipe people, get chat messages, send chat message 2) Write api wrapper in java
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
You will be provided with a list of company names and websites. Extract four columns of details of companies (phone no, address, products and services and associated brands) in an excel sheet. Please place a proposal with a quote for 1000 companies.
I need a script or program to extract data from tradingview to [log masuk untuk melihat URL] csv file must contain Date, time, open, close, high, low and volume of each bars. In any timeframe I choose in the chart. In any timerange I choose. Example: ELET3/ELET4 in the 5 minute timeframe from 01/01/2014 until today. Get the prices of each bar, date, high,low,open,close ...
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el negocio. espe...
...create and excel sheet to extract the information of ingredients of the product listen in the catalogue: I would like to see the type of ingredient and the number of products it is used within. Please highlight the ingredients that are organic. Three are 40 products and you have 5 hours to complete the project starting from the moment you started
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
Hi , I need demo ro using userform in outlook use...userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then the new appointment will be from time 13-17
...have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
Necesito un código en VBA que extraiga la data que está en la siguiente web: [log masuk untuk melihat URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
Parse contract documents using ML so user can enter a clause name and it would extract it in any document structure.
We need the following extract created Data Source - LinkedIn Target industry - All industries Target Geography - Australia Company HQ Location - Australia Target Job Title contains or exactly matches - "Service Desk Manager” OR 'Service Desk Team Lead” OR "Information Technology Support Manager” OR "Telecommunications Manager” OR "Ser...
...extra data to a datagridview from Betfair api...The markets we need are soccer matches...We need to be able to select the markets that we need, ie select country , then league ,then select matches we need.....Selected matches need to be saved to sql database...and also displayed on a datagridview.....this is the first part of a multi-tiered website...
I need to extract only the dimensions (like 12 x 24 x 36 inch) from our product description column in our product csv file, and have the dimensions put in a separate column. I am hoping I can get this done for $200. There are roughly 2,500 product in the csv file. I think this could be done with a script or something instead of manually, but I do
I will provide working code which is currently used to extract English keywords from English texts. The working code does the following: 1. Tokenize the text into sentences. 2. Perform sentiment analysis on each sentence and assign the sentence score to each word. 3. Tokenize the sentence into words. 4. Find POS tags and filter out unwanted words
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[log masuk untuk melihat URL]" erfolgen. In dieser sind bereits Module und Code zur vorgesehenen
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
We need someone to extract FB users from specific pages, and insert in to CSV for use with FB Custom Audiences: - We will give you a list of specific pages to extract data from - You will need to export it in to a file suitable for uploading as a Custom Audience - Example: [log masuk untuk melihat URL] - Each page will need to be a separate CSV - Payment
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.