Stock/ Share Prices

1

Update

Hi there,

The original Stock pack that was developed by Coda is no longer working, because the API provider no longer provides the service.

I have started a new pack, with one formula, getStockInfo() supplied by Alpha Vantage. Alpha Vantage is one of the best rated share price information providers - they should be around for the long haul.

They have a free API, and then various paid subscriptions. You will need to get your own API key from Alpha Vantage, and then use that to set up your user specific authorisation. (Coda will ask you fro the API key when you install the pack.)

They provide a large number of API functions, across the following 8 categories:. (1) Core Time Series Stock Data APIs, (2) US Options Data APIs, (3) Alpha Intelligenceā„¢, (4) Fundamental Data, (5) Physical and Digital/Crypto Currencies (e.g., Bitcoin), (6) Commodities, (7) Economic Indicators, and (8) Technical Indicators

Since I am not a trader myself (anymore) please let me know which functions you would be interested in, and how you would use this in a Coda doc. If there is demand, I will build a free and a pro pack based on your feedback.

1 Like
2

I have added three sync tables to the pack to retrieve fundamentals, one each for

  • Balance Sheet
    38 values ranging from high level summaries like Total Assets, to details like Cash and Cash Equivalents at carrying value
  • Income Statement
    26 values ranging from Revenue to EBIT and EBITDA
  • Cash Flow.
    29 values ranging from Operating Cashflow to Change in Exchange rate

I added this in response to a request from a community member.

1 Like
3

Unfortunately Alpha Vantage is incorrectly blocking API calls, and they are not responding to my support requests.

I will keep looking for ways to get them to resolve the error.

P