Report Period (Historical)
Returns the report period identifier.
Syntax
=hf_Report_Period(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Quarter (1-4)
TTMstring
TTM for trailing twelve months
Returns
string
Report period
Examples
=hf_Report_Period("AAPL", 2023, 4)When to Use
- Understanding data periods
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Calendar date | hf_Calendar_Date() |
Common Issues & FAQ
What format is the period?
Typically YYYY-QN format.
Excel Templates Using Report Period (Historical)
These ready-made MarketXLS templates call hf_Report_Period() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Repurchase Of Capital Stock (Historical)
- Research & Development Expense As Percentage Of Revenue (Historical)
- Research And Development Expense As Percentage Of Revenue (Historical)
- Restricted Cash (Historical)
- Retun On Invested Capital (ROIC - Historical)
- Return Equity Indicator (Historical)
- Return On Average Assets (ROA - Historical)
- Return On Average Equity (ROE - Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?