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
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
I need a freelancer to do web research to find the first name and email address of ~100 website owners. I will give you an Excel spreadsheet that lists ~100 URLs. You will need to go to the URL, then look around the site to see if you can find the first name and email address of the person who owns the site. Note: some of the URLs are blogs, while
...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]
We need to find someone who can hide our server IP address against : Hacking, Competirors, Brands etc .... We need a total privacy + server assistance + backup for our online selling shop.
Hello, I require an excel expert to work on an existing 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
I need to have a list of college names and information, as well as coaches/athletic 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
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
Hi. I need a SNIPPED that 1) hides the "shipping to another address" option, when shipping method "local pick up" is selected // [log masuk untuk melihat URL] 2) and hides or leaves emtpy the shipping details - so they are not shown in emails to the customer // [log masuk untuk melihat URL] Plugins I use: - [log masuk untuk melihat URL]
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 have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
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.
Change A Business Listing In Online Directories (Updating the Name, Address, Phone Number) lOOKING FOR SOMEONE TO HELP ME WITH SEO and update my existing local business listing names info ASAP Also looking for someone to help me creaTE a software to read data from id card smart card chip and reweite the data onto a new smartcard chipcxard, i think
I'd like a HTTP Proxy (i.e. HAProxy) setup which rotates any incoming traffic through a random IP address from an IPv6 /64 routed to my machine. I am running Ubuntu 18 LTE on a dedicated server. I'll be making around 10000 requests /per sec.
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 in
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
In this project, please 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
...great. Our existing system is a web-based system. This is the system we want to expand by incorporating a few new modules. The system is running off PHP7 + IIS + Windows and then the core application is running off VB, VBA, .NET and some C#. Some of the screens within the application are scripted so we could provide the VBA that drives the screen (this
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
...I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo 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
We need a required field („House Number”) at the part of „Shipping Address” and „Billing Address”. Also, we need another field to be filled out („Tax Number”) - it should be appears only at the „Billing Address” - it's required only when the order’s amount of VAT exceeds 100,000 HUF (one hundred thousand Hu...
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 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.
...ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2. Apply the Excel Forecast Function to the monthly data for each product and output in the following format for the next 12
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 "Service De...
We are looking to 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... C# should be coding languag...
Please see how Vip72 works: [log masuk untuk melihat URL] I need to be able to get the forth IP block from the IPs that they are providing where the user can connect to. The full IP is seen as soon as one connects to it which costs the user a credit. I want to be able to get all the full IPs without connecting to them.
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