Write a macro to scrape stock prices from the web

Hi Freelancers

I have attached a spreadsheet showing data I would like scraped from the internet in relation to stock prices. This should be fairly simply for the right person I hope:

- The spreadsheet should extract the Closing stock price for each stock code (in Col C) for each particular date (in Row 3)

- It should place the data into the yellow section below

- Should be able to update for future dates, and different stock codes if I add more.

But basically, I want to be able to roll this analysis over each week with the click of a macro.

I'm happy to chat if that's helpful also.

Skills: Data Entry, Data Processing, Excel, PHP, Web Scraping

See more: excel clout stock quotes, get stock quotes in excel from google finance, real time stock quotes excel, excel vba stock quotes, how to download historical data from yahoo finance to excel, yahoo finance stock quotes in excel, download yahoo finance data into excel vba, stock quotes in excel 2013, excel macro yahoo stock prices, macro historical stock prices, vba macro historical stock prices, scrape stock prices yahoo, net scrape stock prices, historical stock prices macro, excel macro historical stock prices, yahoo stock prices historical macro, add stock feeds web site, download historical stock prices macro, yahoo historical stock prices excel sheet macro, yahoo excel macro download historical stock prices

About the Employer:
( 11 reviews ) Fairlight, Australia

Project ID: #16467931

Awarded to:


Hello, I am clear with the project requirements, ready to start the work anytime. Price for the project is $30, fast delivery, complete within 24 hours. Regards, Santos

$30 AUD in 1 day
(194 Reviews)

23 freelancers are bidding on average $43 for this job


Dear sir, This is Lin and I am scraping expert, I have did many scraping projects, please check my reviews then you wil know. I have checked all details for your project, but there are some details that i want to More

$55 AUD in 2 days
(408 Reviews)

Hi there..... Warm Greetings We came along with your request for Write a macro to scrape stock prices from the web and we reviewed your project description. We'd like to help you with confidence and satisfying r More

$30 AUD in 1 day
(312 Reviews)

Hi there, I can scrape e-commerce website for any product details. I have scraped huge websites in the past and have more than 7 years of professional experience in this field. I can scrape you clean and accurate data More

$35 AUD in 3 days
(187 Reviews)
$222 AUD in 1 day
(102 Reviews)

I'm Ready It does not matter how much you pay after the work is finally delivered We will work on it now I will deliver you the same day Quick execution Dealing seriously Work 24 hours a day Relevant Skills More

$25 AUD in 0 days
(46 Reviews)

I have excellent command on MS Excel and have done similar projects related to stock market and cryptocurrencies before along with many other complex projects. For instance - Get match details, odds and stats of ten More

$80 AUD in 2 days
(82 Reviews)

I understood it but question about website from where I can scrap data ?

$30 AUD in 9 days
(39 Reviews)

Hello, Samples [login to view URL] [login to view URL] I charge $2 for For 400 words. Also some Packages for Bulk Writing!! 1. 100 Articles - $195 2. 200 Articles - $375 My bid is for Quality arti More

$25 AUD in 1 day
(48 Reviews)
$35 AUD in 1 day
(54 Reviews)

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Statistics Data Processing Data Collecting (Using Macro) MS More

$30 AUD in 1 day
(34 Reviews)

A proposal has not yet been provided

$30 AUD in 1 day
(54 Reviews)

Hello! I have 10+ years of experience in Mobile/Web Development. I'm myself high skilled developer. I have already experienced it and have enough power to do it. If you hire me, I will do my best to complete it.

$20 AUD in 1 day
(31 Reviews)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$77 AUD in 3 days
(28 Reviews)

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas and Macros using VB, the most important thing is that I can d More

$30 AUD in 2 days
(15 Reviews)

Hi, I am interested in this job. I understand what you required. I will provide you fast,quality and error free work because I am professional and experienced in it. Waiting to discuss with you more. Regards.

$61 AUD in 3 days
(41 Reviews)

Greetings, We have read the project description and we are experienced professionals in the field of web scrapping, data mining, data processing, data manipulation and data analysis. Having more than 3 years experie More

$25 AUD in 1 day
(2 Reviews)

I have 3 years of experience in this and I'm sure I'm perfect for this and hope you'll like it more than anyone

$35 AUD in 3 days
(0 Reviews)

I intrested your project

$10 AUD in 1 day
(0 Reviews)
$25 AUD in 1 day
(0 Reviews)

i have good command on data entry projects and can manage this task easily. I will be very corporation and humble with my client. i will submit the said task in 7 days.

$35 AUD in 7 days
(0 Reviews)