Excel Documentation

Reported Financials

Reported Financials

Returns the As Reported Financials directly from the financial statements of the XBRL filings from the company.

Function:
=IntrinioReportedFinancials(identifier, statement, sequence, type, xbrl_tag, domain_tag)
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, 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
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
xbrl_tag
The specified XBRL tag. SalesRevenueNet
domain_tag
The specified domain XBRL tag, associated with certain data points on the financial statements that have a dimension associated with the data point. excel
fiscal_year
The fiscal year associated with the fundamental. 2015
fiscal_period
The fiscal period associated with the fundamental.
Options:
FY
Q1
Q2
Q3
Q4
Q1TTM
Q2TTM
Q3TTM
Q2YTD
Q3YTD
show more show less
FY
sequence
An integer 0 or greater for calling a single price from the first entry, based on sort order. 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, 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.
xbrl_tag
* required
The specified XBRL tag.
domain_tag
* required
The specified domain XBRL tag, associated with certain data points on the financial statements that have a dimension associated with the data point.
fiscal_year
* required
The fiscal year associated with the fundamental.
fiscal_period
* required
The fiscal period associated with the fundamental.
sequence
* required
An integer 0 or greater for calling a single price from the first entry, based on sort order.

Output Fields

Name Description Type Example
xbrl_tag the reported XBRL tag of the financial data point string -
domain_tag the reported domain XBRL tag string -
value the value of the XBRL tag of the financial data point number -
xbrl_tag
the reported XBRL tag of the financial data point
domain_tag
the reported domain XBRL tag
value
the value of the XBRL tag of the financial data point