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.
*You will need Excel 2013 or higher to use the Webservice formula.
8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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