Report Period (Historical)

Returns the report period identifier.

Syntax

=hf_Report_Period(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

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.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Report Period (Historical) and Other Financial Formulas
How does MarketXLS work?