Bug Fix 1

I’m pleased to report that all of my spreadsheets are up and running again. Big thanks to the guys over at XL Automation who have posted a work-around for Yahoo! Finance’s recent discontinuation of their API Feature. You can find a detailed explanation of the method they use as well as an example spreadsheet through their website here Yahoo Historical Price Extract. I modified the code slightly for compatibility reasons and implemented the fix into the following spreadsheets. All of which required the gathering of historical pricing data from Yahoo! Finance.

  1. Stock Valuation spreadsheet;
  2. Portfolio Risk spreadsheet;
  3. MV Portfolio Optimisation.

Thanks for your patience while I rectified this issue. Let you me of you experience any issues. As always, happy to assist wherever possible.



%d bloggers like this: