Filing Date To Report Type Mapping
Maps filing dates to SEC report types.
Syntax
=hf_Filing_Date_to_Report_Type_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 report type mapping
Examples
=hf_Filing_Date_to_Report_Type_Mapping("AAPL", 2023, 4)When to Use
- Understanding SEC filing types
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Report period | hf_Report_Period() |
Common Issues & FAQ
What report types are returned?
10-K for annual, 10-Q for quarterly filings.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Financial Leverage (Historical)
- Finished Goods (Historical)
- Foreign Currency to USD Exchange Rate (Historical)
- Foreign Sales (Historical)
- Free Cash Flow (Historical)
- Free Cash Flow Per Share (Historical)
- Goodwill And Intangible Assets (Historical)
- Gross Fixed Assets Plant Property And Equipment (Historical)
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?