Up and running again!

Alrighty, so I fixed a two out of three of my spreadsheets. These include:

I had to remove the “Previous Close” download feature which Yahoo! Finance used to facilitate. Unfortunately, this means users now need to enter this information in manually. I don’t believe this is a big issue though since this information is not crucial to the calculations carried out in the spreadsheets. Hope this isn’t too much of an inconvenience to anyone.

I’ve yet to find a fix for my Stock Screener spreadsheet unfortunately. It appears Yahoo! Finance was the only company who made such a good range of stock metrics available for download via API. Such a shame they no longer facilitate this feature.

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.

 

Cheers.

Bugs

It was recently brought to my attention that some of my spreadsheets were malfunctioning. It turns out that the Yahoo! Finance has discontinued their API feature and have no intentions of  reintroducing its functionality. As a result, some of my spreadsheets are not able to download the necessary data to carry out the intended calculations. My research indicates there is a way around this road block but it will require some time to implement. Therefore, until further notice, the following spreadsheets are not functioning at capacity:

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

Apologies for any inconvenience caused. I hope to have everything up and running again soon.

Cheers.

%d bloggers like this: