Reported Financials - Excel Documentation | Intrinio

Excel Documentation

We are hiring Software Engineers!   Visit Our Careers Page

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
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