Filing Date to Report Period Mapping
Maps SEC filing dates to reporting periods.
Syntax
=hf_Filing_Date_to_Report_Period_Mapping(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
Filing date to period mapping
Examples
=hf_Filing_Date_to_Report_Period_Mapping("AAPL", 2023, 4)When to Use
- Understanding reporting timelines
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Report period | hf_Report_Period() |
Common Issues & FAQ
What is this used for?
Understanding when financial data was filed vs. the period it covers.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?