Financial Statement Updates Calendar
Use the SF_CALENDAR() function with type="financials" to find when financial statements were added to the universe. The calendar returns a row for each statement update within your requested date range, showing the company, the reporting period it covers, and when the statement became available.
=SF_CALENDAR(searchTerms, "financials", startDate, endDate, metrics, options)Two separate limits apply. A single call supports at most 5,000 symbols in an exact symbol list, and returns at most 5,000 rows. If a call exceeds either limit, SheetsFinance returns an error asking you to narrow the date range or symbol filter.
Available metrics
Chain metrics together with & or use "all" to return every column.
Symbol (
"symbol")Period (
"period")Calendar Year (
"calendarYear")Period End Date (
"date")Statement Available At (
"dateAdded")
Period End Date vs Statement Available At
Period End Date is the last day of the reporting period the statement covers. Statement Available At is when the statement became available. Use Statement Available At to track when new filings land in the universe; the two dates are rarely the same.
Search by company and date
Financial statement updates require a symbol or exchange filter in searchTerms. Use one or more exact symbols, an exchange filter such as .US, or a cell range of symbols. A symbol range must contain at least one valid symbol.
Date filtering uses the time zone of your spreadsheet. Missing startDate defaults to seven days before endDate, and a missing endDate defaults to the current date.
Examples
Filter by exact symbol
Return the statement updates for Microsoft within the last 90 days.
=SF_CALENDAR("$MSFT", "financials", TODAY()-90, TODAY(), "all")Filter by a range of symbols
Return statement updates for the symbols listed in cells A1 to A5.
=SF_CALENDAR(A1:A5, "financials", TODAY()-90, TODAY(), "symbol&period&dateAdded")For full syntax details, including searchTerms filtering and the options parameter, see the Financial Calendars overview. For what each statement type and period means, see the Financial Statements guide.