Data Import & Export

Copy Economic Calendar Events to a Trading Restriction Table in Excel

Amos GikundaAmos Gikunda Nov 18, 2026 868 views

Question details

Filter economic calendar events for BRL and USD, copy their details to a table, and identify the 10-minute restriction window after each event.

Copy Economic Calendar Events to a Trading Restriction Table in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to use imported economic calendar data to check whether trading should be restricted after a relevant event.
Observed behavior
The desired table contains BRL and USD events with full event dates and times, and a formula reports when a restriction is active.
Before you start

Obtain an economic calendar file or another source that Excel can import, and identify its currency, event, and date-and-time fields. Confirm that event times use the same time zone as the computer clock used by Excel.

Solution 1Recommended

Filter calendar events with Power Query and flag restriction windows

Use this method to create a refreshable Excel table of BRL and USD events and check whether the current time falls within a restriction window.

1
Import the calendar

In Excel, open the Data tab and choose Get Data, then select the appropriate source, such as From Text/CSV or From Workbook. Select the calendar file and choose Transform Data.

2
Filter and prepare the fields

In Power Query, use the Currency column filter to select BRL and USD. Keep or rename the relevant columns as Currency, Event, and EventTime, and set EventTime to the Date/Time data type. If the date and time are separate, combine them into a full date-and-time value first.

3
Load and name the table

Choose Home > Close & Load to load the results into an Excel table. Select the table, open Table Design, and set Table Name to News.

4
Add the restriction check

In a cell outside the News table, enter =IF(SUMPRODUCT((News[EventTime]<=NOW())*(News[EventTime]+TIME(0,10,0)>NOW()))>0,"Do not trade for 10 minutes","Trading allowed").

5
Refresh the data and calculation

Use Data > Refresh All to update the calendar table. Press F9 to recalculate the status when needed, and check that the imported event times and displayed status are correct.

Filter calendar events with Power Query and flag restriction windows
The formula is an indicator: The restriction runs from the event time up to, but not including, 10 minutes afterward. NOW() uses the computer's local clock and updates when Excel recalculates; the formula does not automatically block trades.
Work with calendar data in WPS Office

Build a trading restriction check in WPS Spreadsheets

Filter an imported calendar for BRL and USD events in WPS Spreadsheets, copy the matching rows to a separate table, and use a formula to flag the 10-minute window after each event.

  1. 1. Open the calendar: Open the calendar workbook or CSV file in WPS Spreadsheets and locate the currency, event, and full date-and-time columns.
  2. 2. Filter the currencies: Select the header row and choose Data > Filter. Open the currency filter and select BRL and USD.
  3. 3. Create the event list: Copy the filtered Currency, Event, and EventTime values to columns A, B, and C on a new sheet. Check that only BRL and USD rows were copied and that column C contains full date-and-time values.
  4. 4. Enter the status formula: In an empty cell outside the event list, enter =IF(SUMPRODUCT((C2:C1000<=NOW())*(C2:C1000+TIME(0,10,0)>NOW()))>0,"Do not trade for 10 minutes","Trading allowed"). Expand the C2:C1000 ranges if the list extends beyond row 1000.
  5. 5. Save and update the check: Choose File > Save As to save the workbook as XLSX. Update the copied event list when the calendar changes, and press F9 to recalculate the status when needed.
Filter economic calendar rows by currencyCheck event times with a SUMPRODUCT formulaOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for free
microsoft office alternative - wps office

Frequently Asked Questions

Why must EventTime include a date as well as a time?

NOW() returns the current date and time. A time-only value cannot reliably identify an event on a particular day, so use a full date-and-time value for each event.

How do I update the Excel table when the calendar changes?

If you loaded the calendar through Power Query, choose Data > Refresh All. Confirm that the source file or connection is still available and that the refreshed EventTime values are correct.

What happens if two events are less than 10 minutes apart?

The formula returns the restriction message whenever at least one event is within its 10-minute window. Overlapping windows therefore keep the indicator active until the later window ends.

Will the formula stop my trading platform from placing orders?

No. The formula only displays a status in the spreadsheet. It does not connect to a trading platform or prevent orders.

Why does the restriction status not change immediately?

NOW() updates when the workbook recalculates, not continuously. Press F9 to recalculate, and make sure the computer clock and calendar event times use the same time zone.