Fund Report Period Date
Returns the start date of the most recent SEC reporting period for an ETF or mutual fund. Funds are required to file periodic reports with the SEC, and this date indicates when the covered period begins.
Return Value
A date string (raw, unformatted from the API). Returns "NA" for invalid symbols or stocks.
Notes
- Use with FundReportPeriodEndDate() to get the full reporting period range
- Returns raw data (not passed through FormatResult)
- Reporting periods are typically quarterly or semi-annually
Syntax
=FundReportPeriodDate(Symbol)Parameters
symbolstringRequired
ETF or mutual fund ticker symbol
Returns
string
The start date of the most recent reporting period as a date string
Examples
=FundReportPeriodDate("SPY")=FundReportPeriodDate("QQQ")=FundReportPeriodDate("VFIAX")=FundReportPeriodDate(A1)When to Use
- Determining the freshness of fund data
- Compliance workflows requiring report period verification
- Understanding which period fund metrics (net assets, holdings) refer to
When NOT to Use
\
Common Issues & FAQ
What's the difference between FundReportPeriodDate and FundReportPeriodEndDate?
FundReportPeriodDate is the START of the reporting period. FundReportPeriodEndDate is the END. Together they define the period covered by the fund's most recent filing.
The date is text, not an Excel date.?
Use =DATEVALUE(FundReportPeriodDate("SPY")) to convert.
Related Formulas
More MarketXLS ETF & Funds 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?