Economic Events Calendar

Use the SF_CALENDAR() function with type="economic" to retrieve historic and upcoming macroeconomic event data. The function returns rows for each event within the requested date range and the metrics you select.

=SF_CALENDAR(searchTerms, "economic", startDate, endDate, metrics, options)

The maximum date range for a single call is 90 days. If the range between startDate and endDate is larger, it is truncated to 90 days. For longer ranges, make multiple calls and combine them with HSTACK or VSTACK.

Available metrics

Chain metrics together with & or use "all" to return every column.

Date ("date")
Country ("country")
Event ("event")
Currency ("currency")
Previous ("previous")
Estimate ("estimate")
Actual ("actual")
Change ("change")
Change Percentage ("changePercentage")
Impact ("impact")

Examples

Filter by country and select key metrics

Return US and UK economic events for the next two weeks with date, country, event, currency, and impact.

=SF_CALENDAR("US&UK", "economic", TODAY(), TODAY()+14, "date&country&event&currency&impact")

Filter by a single country

Return all economic events for the US over the next 30 days.

=SF_CALENDAR("US", "economic", TODAY(), TODAY()+30, "all")

For full syntax details, including searchTerms filtering and the options parameter, see the Financial Calendars overview.

Was this helpful?