Sign up for free
Functions

GET_COMPANY_OVERVIEW_ALPHAVANTAGE

Get company information, financial ratios and other key metrics for the equity specified. 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_COMPANY_OVERVIEW_ALPHAVANTAGE(symbol, 
[property]
)
symbol

The stock symbol, i.e.: "AAPL" or "AMZN".

[optional] property

The company property. For example, i.e.: "MarketCapitalization" or "EBITDA".

Selected options:
Asset Type
Name
Description
CIK
Exchange
Currency
Country
Sector
Industry
Address
Fiscal Year End
Latest Quarter
Market Capitalization
EBITDA
PE Ratio
PEG Ratio
Book Value
Dividend Per Share
Dividend Yield
EPS
Revenue Per Share (TTM)
Profit Margin
Operating Margin (TTM)
Return On Assets (TTM)
Return On Equity (TTM)
Revenue (TTM)
Gross Profit (TTM)
Diluted EPS (TTM)
Quarterly Earnings Growth (YOY)
Quarterly Revenue Growth (YOY)
Analyst Target Price
Analyst Rating: Strong Buy
Analyst Rating: Buy
Analyst Rating: Hold
Analyst Rating: Sell
Analyst Rating: Strong Sell
Trailing PE
Forward PE
Price To Sales Ratio (TTM)
Price To Book Ratio
EV To Revenue
EV To EBITDA
Beta
52 Week High
52 Week Low
50 Day Moving Average
200 Day Moving Average
Shares Outstanding
Dividend Date
Ex-Dividend Date

Examples

GET_COMPANY_OVERVIEW_ALPHAVANTAGE("AAPL", "MarketCapitalization") returns Apple's Market Capitalization.