Google sheet which uses RapidAPI to populate NAV at 6:30 - 7pm daily

Discuss all general (i.e. non-personal) investing questions and issues, investing news, and theory.
Post Reply
Topic Author
milktoast
Posts: 625
Joined: Wed Jul 10, 2019 8:17 pm

Google sheet which uses RapidAPI to populate NAV at 6:30 - 7pm daily

Post by milktoast »

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
Post Reply