I’m trying to get the information for a ticker based in the Australian Stock Market (ASX), but I get blank result, is that not supported?
Our data provider IEX does support some international exchanges but not all of them, and unfortunately not those in Australia yet. You can see mention of some of their supported regions and exchanges here: https://iexcloud.io/docs/api/#changelog
The ticker symbols they use for international exchanges are a bit unclear. They use a suffix but it’s a little hard to understand how the suffix maps to the exchange or region. For example, RY-CT is the symbol to use for IEX (and hence the Coda Stocks pack) for the Royal Bank of Canada on the Toronto stock exchange.
We currently have a bug where we’re not accepting dashes in ticker symbols, which will be fixed within a day or two.
You can see examples of international ticker simples by looking at IEX’s sample data at urls like https://sandbox.iexapis.com/stable/ref-data/region/ca/symbols?token=Tsk_40e91327dc3f4f85a25ce94695553411. Replace the /ca/ with the two-letter code of another country to see data for that country (if any). This is sandbox data from IEX but it seems to provide a decent representation of the real data.
3 Likes
@JonathanGoldman Ah I see, it does not support /au/ however.
If anyone else is looking for a temporary workaround, I have created a Google sheet which uses the formula =GOOGLEFINANCE(XYZ:XYZ). I then used Zapier to populate my Coda tables from Google Sheets to get the stock prices.
2 Likes
Love this work-around, @Mudassir_Ali!
I just shared a post outlining where one can retrieve the ticker symbols in the format required by the Stock Pack, find more info here:
Hope this is useful for others!
Nina
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
The old API provider for the Stocks Pack has stopped operations.
Hi All,
I have created a Stock Prices lite pack. It uses Alpha Vantage with a limit of is 25 requests per day, with a limit of 5 queries per minute. These limits apply to the API key, i.e. to all users of the pack.
It contains one formula getStockInfo(ticker) and one sync table. I have assumed that OHLC, history and other information would not be all that interesting for a Coda doc.
Their prices are as follows:
Please let me have feedback - Would you be willing to pay for this? How many API requests would you need.
Rambling Pete