Fund Report Period End Date
Returns the end date of the most recent SEC reporting period for an ETF or mutual fund. This indicates the "as-of" date for the fund's reported metrics like net assets and holdings.
Return Value
A date string (raw, unformatted from the API). Returns "NA" for invalid symbols or stocks.
Notes
- Use with FundReportPeriodDate() to get the full reporting period range
- Returns raw data (not passed through FormatResult)
- The end date is often the "as-of" date for fund holdings data
Syntax
=FundReportPeriodEndDate(Symbol)Examples
=FundReportPeriodEndDate("SPY")=FundReportPeriodEndDate("QQQ")=FundReportPeriodEndDate("VFIAX")Symbol from cell reference
When to Use
- Checking when fund data was last reported
- Determining if fund holdings data is current
- Compliance and audit requiring filing date verification
When NOT to Use
\
Common Issues & FAQ
The date is text, not an Excel date.?
Use =DATEVALUE(FundReportPeriodEndDate("SPY")) to convert to an Excel date.
The end date seems old.?
Fund reports are filed quarterly or semi-annually, so there's a natural lag. The most recent filing may be from the prior quarter.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
- Fund Total Assets
- Mutual Fund Inception Date
- Mutual Fund Previous Close
- Mutual Fund Price
- Mutual Fund Yield
- ETF Category
- ETF Fund Family
- ETF Fund Family CIK Number
See FundReportPeriodEndDate used in a complete workbook: ETF Holdings in Excel: Pull Live Fund Constituents With MarketXLS Formulas
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?