Data retrieval (mining/scraping) from web to excel
$30-250 USD
Paid on delivery
I need an Excel workbook that automatically retrieves data from some specific websites for personal use. For example, I write a ticker symbol in a blank, click a button and it automatically shows me all the data that I want to see. This can be done through web query functions in excel. I will be using Excel 2016 and I need that all numbers retrieved are in a format that I can use for calculations. For example, if a number has letters or spaces, I need those characters to be removed so we only have numbers in the cell. I will provide all the specific web addresses that I need to retrieve data from, like Yahoo Finance and others.
Project ID: #10019859
About the project
Awarded to:
Hello I have a lot of experience working on VBA so I belive I can help you. Please feel free to contact me with some example data that you need scrapped. Lets say we go to Yahoo Finance for ticker AAPL. Which other d More
6 freelancers are bidding on average $135 for this job
I have excellent command on MS Excel and have used web query before. About my experience: I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a More
hi. i have much experience in ms excel,webscraping and data intergration. i would like to assist. please feel free to approach me. enrico