Spreadsheet: 737669d1624536359-xlookup-with-multiple-criteria-finding-if-a-date-time-falls-within-two-dates-and-times-sample-book
Sheet: News

2020-06-17 17:00:00 | [NAME] |  | 06-17-2020 | 5:00 pm | USD | L | CB Leading Index m/m | 0.013 | 0.013 | 0.013
2020-06-17 17:30:00 | 6/17/20 17:30:00 |  | 06-17-2020 | 5:30 pm | USD | L | Natural Gas Storage | 16B | 71B | 98B
2020-06-18 02:30:00 | [NAME] |  | 06-18-2020 | 2:30 am | [NAME] | L | National Core CPI y/y | 0.001 | 0 | -0.001
2020-06-18 06:30:00 | [NAME] |  | 06-18-2020 | 6:30 am | [NAME] | M | Monetary Policy Statement
2020-06-18 06:30:00 | [NAME] |  | 06-18-2020 | 6:30 am | [NAME] | L | BOJ Policy Rate | -0.001 | -0.001 | -0.001
2020-06-18 09:00:00 | [NAME] |  | 06-18-2020 | 9:00 am | EUR | L | German PPI m/m | 0.015 | 0.007 | 0.008
2020-06-18 09:00:00 | [NAME] |  | 06-18-2020 | 9:00 am | GBP | M | Retail Sales m/m | -0.014 | 0.015 | 0.092
2020-06-18 09:30:00 | [NAME] |  | 06-18-2020 | 9:30 am | [NAME] | M | BOJ Press Conference
2020-06-18 11:00:00 | [NAME] |  | 06-18-2020 | 11:00 am | EUR | L | Current Account | 22.8B | 20.3B | 17.8B
2020-06-18 11:30:00 | [NAME] |  | 06-18-2020 | 11:30 am | GBP | L | Consumer Inflation Expectations | 0.024 |  | 0.027
 | [NAME] |  | 06-18-2020 | All Day | EUR | L | ECOFIN Meetings
2020-06-18 15:30:00 | [NAME] |  | 06-18-2020 | 3:30 pm | CAD | L | NHPI m/m | 0.014 | 0.015 | 0.019
2020-06-19 15:30:00 | 6/19/20 15:30:00 |  | 06-19-2020 | 3:30 pm |  | L
2020-06-20 15:30:00 | 6/20/20 15:30:00 |  | 06-20-2020 | 3:30 pm |  | L
2020-06-21 02:01:00 | 6/21/20 02:01:00 |  | 06-21-2020 | 2:01 am | GBP | L | Rightmove HPI m/m | 0.008 |  | 0.018
2020-06-21 04:30:00 | 6/21/20 04:30:00 |  | 06-21-2020 | 4:30 am | AUD | M | Retail Sales m/m | 0.001 | 0.004 | 0.011
2020-06-21 13:00:00 | 6/21/20 13:00:00 |  | 06-21-2020 | 1:00 pm | EUR | L | German Buba Monthly Report
2020-06-21 15:30:00 | 6/21/20 15:30:00 |  | 06-21-2020 | 3:30 pm | EUR | L | ECB President [NAME]
2020-06-21 17:15:00 | 6/21/20 17:15:00 |  | 06-21-2020 | 5:15 pm | EUR | H | ECB President [NAME]
2020-06-21 22:00:00 | 6/21/20 22:00:00 |  | 06-21-2020 | 10:00 pm | USD | L | FOMC Member [NAME]
2020-06-22 00:00:00 | 6/22/20 00:00:00 |  | 06-22-2020 | 12:00 am | NZD | L | Westpac Consumer Sentiment | 107.1 |  | 105.2
2020-06-22 06:00:00 | 6/22/20 06:00:00 |  | 06-22-2020 | 6:00 am | NZD | L | Credit Card Spending y/y | 0.272 |  | 0.875
2020-06-22 07:59:00 | 6/22/20 07:59:00 |  | 06-22-2020 | 7:59 am | [NAME] | L | BOJ Core CPI y/y | 0 | 0 | -0.001
2020-06-22 09:00:00 | 6/22/20 09:00:00 |  | 06-22-2020 | 9:00 am | GBP | L | Public Sector Net Borrowing | 23.6B | 24.5B | 28.3B
2020-06-22 13:00:00 | 6/22/20 13:00:00 |  | 06-22-2020 | 1:00 pm | GBP | L | CBI Industrial Order Expectations | 19 | 16 | 17
2020-06-22 16:59:00 | 6/22/20 16:59:00 |  | 06-22-2020 | 4:59 pm | USD | L | Richmond Manufacturing Index | 22 | 18 | 18
2020-06-22 17:00:00 | 6/22/20 17:00:00 |  | 06-22-2020 | 5:00 pm | EUR | L | Consumer Confidence | -3 | -3 | -5
2020-06-22 17:00:00 | 6/22/20 17:00:00 |  | 06-22-2020 | 5:00 pm | USD | L | Existing Home Sales | 5.80M | 5.71M | 5.85M
2020-06-22 17:30:00 | 6/22/20 17:30:00 |  | 06-22-2020 | 5:30 pm | AUD | L | CB Leading Index m/m | 0.008 |  | 0.009
2020-06-22 18:00:00 | 6/22/20 18:00:00 |  | 06-22-2020 | 6:00 pm | USD | L | FOMC Member [NAME]
2020-06-22 21:00:00 | 6/22/20 21:00:00 |  | 06-22-2020 | 9:00 pm | USD | H | Fed Chair Powell Testifies
2020-06-23 02:00:00 | 6/23/20 [NAME] |  | 06-23-2020 | 2:00 am | AUD | L | Flash Manufacturing PMI | 58.4 |  | 60.4
2020-06-23 02:00:00 | 6/23/20 [NAME] |  | 06-23-2020 | 2:00 am | AUD | L | Flash Services PMI | 56 |  | 58
2020-06-23 02:50:00 | 6/23/20 02:50:00 |  | 06-23-2020 | 2:50 am | [NAME] | L | Monetary Policy Meeting Minutes
2020-06-23 03:30:00 | 6/23/20 03:30:00 |  | 06-23-2020 | 3:30 am | [NAME] | L | Flash Manufacturing PMI | 51.5 | 53.2 | 53
2020-06-23 04:30:00 | 6/23/20 04:30:00 |  | 06-23-2020 | 4:30 am | AUD | L | Goods Trade Balance | 13.32B |  | 9.67B
2020-06-23 06:15:00 | 6/23/20 06:15:00 |  | 06-23-2020 | 6:15 am | AUD | M | [NAME]
2020-06-23 10:15:00 | 6/23/20 10:15:00 |  | 06-23-2020 | 10:15 am | EUR | M | French Flash Manufacturing PMI | 58.6 | 59 | 59.4
2020-06-23 10:15:00 | 6/23/20 10:15:00 |  | 06-23-2020 | 10:15 am | EUR | M | French Flash Services PMI | 57.4 | 59.6 | 56.6
2020-06-23 10:30:00 | 6/23/20 10:30:00 |  | 06-23-2020 | 10:30 am | EUR | H | German Flash Manufacturing PMI | 64.9 | 63 | 64.4
2020-06-23 10:30:00 | 6/23/20 10:30:00 |  | 06-23-2020 | 10:30 am | EUR | H | German Flash Services PMI | 58.1 | 55.8 | 52.8
2020-06-23 11:00:00 | 6/23/20 11:00:00 |  | 06-23-2020 | 11:00 am | EUR | M | Flash Manufacturing PMI | 63.1 | 62.4 | 63.1
2020-06-23 11:00:00 | 6/23/20 11:00:00 |  | 06-23-2020 | 11:00 am | EUR | M | Flash Services PMI | 58 | 58.1 | 55.2
2020-06-23 11:30:00 | 6/23/20 11:30:00 |  | 06-23-2020 | 11:30 am | GBP | M | Flash Manufacturing PMI | 64.2 | 64.1 | 65.6
2020-06-23 11:30:00 | 6/23/20 11:30:00 |  | 06-23-2020 | 11:30 am | GBP | M | Flash Services PMI | 61.7 | 62.9 | 62.9
2020-06-23 15:30:00 | 6/23/20 15:30:00 |  | 06-23-2020 | 3:30 pm | CAD | M | Core Retail Sales m/m | -0.072 | -0.044 | 0.054
2020-06-23 15:30:00 | 6/23/20 15:30:00 |  | 06-23-2020 | 3:30 pm | CAD | M | Retail Sales m/m | -0.057 | -0.051 | 0.045
2020-06-23 15:30:00 | 6/23/20 15:30:00 |  | 06-23-2020 | 3:30 pm | USD | L | Current Account | -196B | -205B | -175B
2020-06-23 16:00:00 | 6/23/20 16:00:00 |  | 06-23-2020 | 4:00 pm | CHF | L | SNB Quarterly Bulletin
2020-06-23 16:00:00 | 6/23/20 16:00:00 |  | 06-23-2020 | 4:00 pm | USD | L | FOMC Member [NAME]
2020-06-23 16:45:00 | 6/23/20 16:45:00 |  | 06-23-2020 | 4:45 pm | USD | H | Flash Manufacturing PMI | 62.6 | 61.5 | 62.1
2020-06-23 16:45:00 | 6/23/20 16:45:00 |  | 06-23-2020 | 4:45 pm | USD | H | Flash Services PMI | 64.8 | 70 | 70.4
2020-06-23 17:00:00 | [NAME] |  | 06-23-2020 | 5:00 pm | USD | L | New Home Sales | 769K | 864K | 817K
2020-06-23 17:30:00 | 6/23/20 17:30:00 |  | 06-23-2020 | 5:30 pm | USD | M | Crude Oil Inventories | -7.6M | -3.6M | -7.4M
2020-06-23 18:00:00 | 6/23/20 18:00:00 |  | 06-23-2020 | 6:00 pm | USD | L | FOMC Member [NAME]
2020-06-23 19:00:00 | 6/23/20 19:00:00 |  | 06-23-2020 | 7:00 pm | EUR | L | ECB President [NAME]
2020-06-24 02:50:00 | 6/24/20 02:50:00 |  | 06-24-2020 | 2:50 am | [NAME] | L | SPPI y/y | 0.015 | 0.014 | 0.011
2020-06-24 11:00:00 | 6/24/20 11:00:00 |  | 06-24-2020 | 11:00 am | EUR | M | German ifo Business Climate | 101.8 | 100.8 | 99.2
2020-06-24 11:00:00 | 6/24/20 11:00:00 |  | 06-24-2020 | 11:00 am | EUR | L | ECB Economic Bulletin
 | 6/24/20  2:00 pm |  | 06-24-2020 | 2:00 pm | GBP | H | Asset Purchase Facility |  | 895B | 895B
 | 6/24/20  2:00 pm |  | 06-24-2020 | 2:00 pm | GBP | H | MPC Asset Purchase Facility Votes |  | 0-1-8 | 0-1-8
 | 6/24/20  2:00 pm |  | 06-24-2020 | 2:00 pm | GBP | H | Monetary Policy Summary
 | 6/24/20  2:00 pm |  | 06-24-2020 | 2:00 pm | GBP | M | MPC Official Bank Rate Votes |  | 0-0-9 | 0-0-9
 | 6/24/20  2:00 pm |  | 06-24-2020 | 2:00 pm | GBP | M | Official Bank Rate |  | 0.001 | 0.001
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | M | Final GDP q/q |  | 0.064 | 0.064
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | M | Unemployment Claims |  | 382K | 412K
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | L | Core Durable Goods Orders m/m |  | 0.008 | 0.01
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | L | Durable Goods Orders m/m |  | 0.029 | -0.013
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | L | Final GDP Price Index q/q |  | 0.043 | 0.043
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | L | Goods Trade Balance |  | -87.4B | -85.2B
2020-06-24 15:30:00 | 6/24/20 15:30:00 |  | 06-24-2020 | 3:30 pm | USD | L | Prelim Wholesale Inventories m/m |  | 0.008 | 0.008
2020-06-24 16:00:00 | 6/24/20 16:00:00 |  | 06-24-2020 | 4:00 pm | EUR | L | Belgian NBB Business Climate |  | 8.5 | 6.5
2020-06-24 16:30:00 | 6/24/20 16:30:00 |  | 06-24-2020 | 4:30 pm | USD | L | FOMC Member [NAME]
2020-06-24 17:30:00 | 6/24/20 17:30:00 |  | 06-24-2020 | 5:30 pm | USD | L | Natural Gas Storage |  | 64B | 16B
2020-06-24 18:00:00 | 6/24/20 18:00:00 |  | 06-24-2020 | 6:00 pm | USD | L | FOMC Member [NAME]
2020-06-24 23:30:00 | 6/24/20 23:30:00 |  | 06-24-2020 | 11:30 pm | USD | L | Bank Stress Test Results
2021-06-25 06:00:00 | 6/25/21 06:00:00 |  | 2021-06-25 00:00:00 | 6:00 am | EUR | L | German GfK Consumer Climate |  | -3.9 | -7
2021-06-25 08:00:00 | 6/25/21 08:00:00 |  | 2021-06-25 00:00:00 | 8:00 am | EUR | L | M3 Money Supply y/y |  | 0.086 | 0.092
2021-06-25 08:00:00 | 6/25/21 08:00:00 |  | 2021-06-25 00:00:00 | 8:00 am | EUR | L | Private Loans y/y |  | 0.037 | 0.038
2021-06-25 10:00:00 | 6/25/21 10:00:00 |  | 2021-06-25 00:00:00 | 10:00 am | GBP | L | CBI Realized Sales |  | 12 | 18
2021-06-25 11:00:00 | 6/25/21 11:00:00 |  | 2021-06-25 00:00:00 | 11:00 am | GBP | L | BOE Quarterly Bulletin
2021-06-25 12:30:00 | 6/25/21 12:30:00 |  | 2021-06-25 00:00:00 | 12:30 pm | USD | L | Personal Spending m/m |  | 0.004 | 0.005
2021-06-25 12:30:00 | 6/25/21 12:30:00 |  | 2021-06-25 00:00:00 | 12:30 pm | USD | L | Personal Income m/m |  | -0.025 | -0.131
2021-06-25 12:30:00 | 6/25/21 12:30:00 |  | 2021-06-25 00:00:00 | 12:30 pm | USD | M | Core PCE Price Index m/m |  | 0.006 | 0.007
2021-06-25 13:00:00 | 6/25/21 13:00:00 |  | 2021-06-25 00:00:00 | 1:00 pm | CNY | L | CB Leading Index m/m |  |  | 0.012
2021-06-25 14:00:00 | 6/25/21 14:00:00 |  | 2021-06-25 00:00:00 | 2:00 pm | USD | M | Revised UoM Consumer Sentiment |  | 86.5 | 86.4
 |  |  | 2021-06-25 00:00:00 | 2:00 pm | USD | L | Revised UoM Inflation Expectations |  |  | 0.04