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)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.
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?