does anyone else randomly get errors with google sheets ??
It was working yesterday and now it does not, if anyone knows a fix it would be greatly appreciated
The weird thing is it was working last night and today I opened it and it doesn’t work, I have the same sort of formula for other time frames and it works, but the full volume for 5 years has decided to stop working
Seems like googlefinance is buggy, I’ve also tried the classic off and on
Maybe it’s something to do with us approaching the end of the year but I really can’t see that being the problem
OK - your spreadsheet has TODAY()-365x5 which is 25/12/2014 and TODAY()-365x3 which is 24/12/2016. Google Finance holds no close data for these dates eg: