Reported Fundamentals - Excel Documentation | Intrinio

Excel Documentation

We are hiring Software Engineers!   Visit Our Careers Page

Reported Fundamentals

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)
Available in Sandbox

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