Looking for a STOCK Ticker APP?? - I have an alternative..
S
Steven K
started a topic
about 2 months ago
I tried the only stock ticker I could find on the Marketplace, and for one symbol it worked, but then causes "Too many API" calls errors - so its not much use really....
I was going to write an API for Google sheets to work around this, but then found the "My Data (Google Sheets)" App - and just did a fudge around using the Google Finance functions in Google Sheets to create a decent looking stock ticker.
You can find a sample Google Sheet I use here - it has some instructions - is very simple to adjust the formulaes if you need to, and works pretty well with up to 9 or 10 tickers.
Steven K
I tried the only stock ticker I could find on the Marketplace, and for one symbol it worked, but then causes "Too many API" calls errors - so its not much use really....
I was going to write an API for Google sheets to work around this, but then found the "My Data (Google Sheets)" App - and just did a fudge around using the Google Finance functions in Google Sheets to create a decent looking stock ticker.
You can find a sample Google Sheet I use here - it has some instructions - is very simple to adjust the formulaes if you need to, and works pretty well with up to 9 or 10 tickers.
https://docs.google.com/spreadsheets/d/13faNl9F5Q5lRnCy0WFrNCvX6reJWq3cVs11ZGDQ0k6M/edit?usp=sharing
If you copy this - please post a reply and let me know if you found it useful!!