GET_BALANCE_SHEET_ALPHAVANTAGE

Get annual and quarterly balance sheets of a company for the last 5 years. This finance data is generally refreshed on the same day a company reports its latest earnings and financials.

icon of Alpha VantageAlpha Vantage
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
GET_BALANCE_SHEET_ALPHAVANTAGE(symbol
[report]
[fiscal_date]
)
symbol

The stock symbol, i.e.: "AAPL" or "AMZN". Must be companies listed in the U.S. Securities and Exchange Commission.

[optional] report

The report granularity. This paramater accepts two values "annual" or "quarterly". Both reports are shown by default.

[optional] fiscal_date

Date interval for the fiscal date ending, example "[2020-05-01;2020-12-01]" or ">2020-12-01". The last five years are shown by default.

Examples

GET_BALANCE_SHEET_ALPHAVANTAGE("AAPL") returns the latest balance sheets of Apple by quarter and year.