As many of you have noticed many of the baby bond stock quotes in spreadsheets went off last Friday and haven’t been back since that time.
Of course over the 14 years I have published websites this has been a persistent issue as Google doesn’t supply many baby bond quotes and Yahoo Finance cut us out maybe 3 years ago.
I am looking for alternatives, but thus far have not found a suitable alternative–I am about to the point where I am going to contract with a ‘real’ quote supplier for the quotes–we’ll see.
This API works ok for most baby bonds. Does not seem to work for most preferreds. Results returned in JSON. Have to register to get API key.
https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=GECCN&apikey=xxxxxx
I am not aware of a more reliable provider of large quantities of automated real time or delayed stock quotes that is free. We all know of many places to get manually input single stock quotes, but that is different than getting say 250 or 750 through an API(Application Programming Interface). The other issue is that you can get that much data from some brokerages, but only for private, non-commercial use. So even though III is not a for profit business, it would be excluded from using brokerage provided data that comes from a private account. As Tim has suggested, you might have to go with a paid data provider to get more reliable data. Several of them provide data that will go directly into Google Sheets. In NO WAY would I endorse Tim paying for this out of his pocket. If he goes that way, we users MUST fund the bill.
A couple of names comes to mind:
Quotemedia
https://www.quotemedia.com/apifeeds
Alpha Vantage
https://www.alphavantage.co/documentation/
Lots of Google services have been down. Not sure if your quotes rely on any of them, or their servers.
I am not sure where we would all go to be silenced, censored and told what to think if youtube and the rest were not to come back online ;o)
In all seriousness, we are way too reliant, on too few companies, for way too much.
Hi Scott–yes I know that Google had a large outage, but the bond quotes were coming from another source which has gone black. I agree that Google (and others) are way too important to most of us.
Yeah- we need to go all US news, etc… wait a minute…! Dang.
Plan B?
Google sent out a message today that several services were down- no explanation. Hack? Like the Treasury & Commerce depts?