Excel VBA - Yahoo Finance

We are trying to build the formula to extract a single point of historical price data in Excel from Yahoo Finance.

For example, in the attached spreadsheet, we have used the =Webservice and Yahoo quotes formula to extract the stock and managed fund prices from Yahoo. However, this is only limited to the latest trading price and not a historical price say 31/3/17 or 30/04/17.

We would like someone to build a formula or alternatively using other methods such as VBA so we can get the historical price from Yahoo Finance at any historical dates. For instance, we can enter 31/12/16 and the price as at that date for BHP, CBA, Fidelity and Platinum, etc will be automatically displayed.

Thank you.

*You will need Excel 2013 or higher to use the Webservice formula.

Taidot: Excel, Microsoft, Tietojen kaavinta verkosta

Näytä lisää: excel vba finance options derivatives, excel vba macro yahoo finance historical prices, excel vba finance project, excel, visual basic, visual basic for apps, excel vba yahoo finance, excel vba real time pricing yahoo finance, excel vba finance yahoo com, data yahoo finance excel vba addin, excel vba finance, excel vba yahoo finance api, free excel vba finance programmes, download quotes excel vba yahoo finance, excel vba download historical prices yahoo finance, yahoo finance historical price excel vba, historical price yahoo finance excel vba, excel vba yahoo finance stock quote

Tietoa työnantajasta:
( 3 arvostelua ) Sydney, Australia

Projektin tunnus: #14187837

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in Automated Web Scrapping using Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bi Lisää

$150 AUD 2 päivässä
(556 arvostelua)

Hello sir/madam, However, I am relatively new here in freelancer.com I have over 10 years of experience in Excel VBA programming. I am going to write you small VBA function which extracts necessary data. I am availa Lisää

$30 AUD 0 päivässä
(82 arvostelua)

I am a professional Freelancer. I would like to work on this project. I have done a lot of similar project of this. Feel free to let me know if you would like to look a sample

$30 AUD 2 päivässä
(161 arvostelua)

Hi there, I use Excel extensively and my job entails data analysis using Excel. I have the required skills and experience. lets get started

$50 AUD 1 päivässä
(13 arvostelua)

"Rate and duration will be fixed on discussion" Greetings, I got interested in your project and would be glad to discuss all the issues with you. I am an expert in these fields. I have already completed several pro Lisää

$25 AUD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$45 AUD 3 päivässä
(0 arvostelua)

Dear Hiring Manager, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel Lisää

$15 AUD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$16 AUD 5 päivässä
(0 arvostelua)