Excel Documentation

Switch to:

API CSV

We are hiring Software Engineers! Visit Our Careers Page

Standardized Fundamentals

Returns a list of available standardized fundamentals (fiscal year and fiscal period) for a given ticker and statement.

Function:

=IntrinioFinancials(identifier, statement, fiscal_year, fiscal_period, tag, rounding)

Function:

=IntrinioFinancials(identifier, statement, sequence, type, tag, rounding)

Available in Sandbox

Parameters

Name	Description	Example
identifier * required	The stock market ticker symbol associated with the companies common stock ecurities.	AAPL
statement * required	The financial statement requested, options include the income statement, balance sheet, statement of cash flows and calculated metrics and ratios. Options: income_statement balance_sheet cash_flow_statement calculations show more show less	income_statement
type * required	The type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis. Options: FY QTR TTM YTD show more show less	FY
item	The return value for the fundamental. Options: fiscal_year end_date start_date fiscal_period filing_date show more show less	fiscal_year
sequence * required	An integer 0 or greater for calling a single fundamental from the first entry, most recent first.	0
identifier * required The stock market ticker symbol associated with the companies common stock ecurities.
statement * required The financial statement requested, options include the income statement, balance sheet, statement of cash flows and calculated metrics and ratios.
type * required The type of periods requested - includes fiscal years for annual data, quarters for quarterly data and trailing twelve months for annual data on a quarterly basis.
item * required The return value for the fundamental.
sequence * required An integer 0 or greater for calling a single fundamental from the first entry, most recent first.

Output Fields

Name	Description	Type
fiscal_year	the fiscal year of the fundamental	number
fiscal_period	the fiscal period of the fundamental	string
end_date	the last date of the fundamental	date
start_date	the first date of the fundamental (not available for balance sheets)	date
fiscal_year the fiscal year of the fundamental
fiscal_period the fiscal period of the fundamental
end_date the last date of the fundamental
start_date the first date of the fundamental (not available for balance sheets)