Like many other people, my google sheet stopped working last week.
Anyway, I created a App Script that uses RapidAPI to populate NAV every day between 6:30 pm and 7pm EST. This is deliberately done only once a day because I want the spreadsheet to be stable during day.
I thought that maybe it would be widely useful and so I'm sharing it with this group.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
To use this, you'll need to make a copy. Then go to https://rapidapi.com/apidojo/api/cnbc/ and register for a free API key. Then customize for your API key and timezone via Extensions -> AppScripts. And add a 15 minute trigger to run pullNAVtrigger. Note that only 500 queries per month are free, so this works fine for daily updates. But not for hourly.
If anyone is interested, feel free to make comments on this thread and I'll try to deal with any issues that come up.
Alternatives:
- =GOOGLEFINANCE. The quotes on mutual funds are very delayed.
- retiringwhen spreadsheet viewtopic.php?p=5866025#p5866025