Excel Documentation

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.

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
income_statement
type
* required
The type of periods requested - includes fiscal years for annual data, quarters for quarterly data.
Options:
FY
QTR
FY
item
The return value for the fundamental.
Options:
fiscal_year
end_date
start_date
fiscal_period
filing_date
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 Example
fiscal_year the fiscal year of the fundamental nuber 2017
end_date the last date of the fundamental date 2018-07-15
start_date (not available on the balance sheet) the first date of the fundamental date 2011-09-15
fiscal_period the fiscal period of the fundamental string FY
filing_date datetime 2017-11-03 08:01:37 +0000
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