Excel Documentation

Switch to:

Reported Fundamentals

Returns a list of available as reported fundamentals (fiscal year, fiscal period, start date, and end date) for a given ticker and statement.

Function:

=IntrinioReportedFundamentals(identifier, statement, type, sequence, item)

Parameters

Name	Description	Example
identifier * required	The stock market ticker symbol associated with the companies common stock securities.	AAPL
statement * required	The financial statement requested, options include the income statement, balance sheet and statement of cash flows. Options: income_statement balance_sheet cash_flow_statement show more show less	income_statement
type * required	The type of periods requested - includes fiscal years for annual data, quarters for quarterly data. Options: FY QTR 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.	0
identifier * required The stock market ticker symbol associated with the companies common stock securities.
statement * required The financial statement requested, options include the income statement, balance sheet and statement of cash flows.
type * required The type of periods requested - includes fiscal years for annual data, quarters for quarterly data.
item * required The return value for the fundamental.
sequence * required An integer 0 or greater for calling a single fundamental from the first entry.

Output Fields

Name	Description	Type
fiscal_year	the fiscal year of the fundamental	nuber
end_date	the last date of the fundamental	date
start_date	(not available on the balance sheet) the first date of the fundamental	date
fiscal_period	the fiscal period of the fundamental	string
filing_date		datetime
fiscal_year the fiscal year of the fundamental
end_date the last date of the fundamental
start_date (not available on the balance sheet) the first date of the fundamental
fiscal_period the fiscal period of the fundamental
filing_date