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.