Spreadsheet: 109277d1306183697-index-match-sumproduct_twist
Sheet: Sheet1

Friday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is what q3:R14 should be |  |  |  |  |  |  | NFP
Stats | TREND | DD | P Struc | NVD | INVD | NEUT | INEUT | ND | NTD | Unknown |  |  |  |  |  | Up | Down | Actual | ActualUp | Asctual Dn |  |  |  | Up | Down | Before |  | Up | Down | After |  | STATS | trend | dd | P struc | nvd | [NAME] | neut | ineut | nd | ntd | unknown
January | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 |  |  |  |  | 3 | 2 | 1 | January | 1 |  |  |  |  | 1 |  | January | 1 | 1 |  | January |  | Before |  |  | 1 | 1 |  |  | 3 |  |  |  | 5
February | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 |  | right now the B3:k14 |  |  | 3 | 3 | 0 | February |  | 1 |  |  |  | 1 |  | February | 1 | 1 |  | February |  | Actual |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  | 5
March | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 |  | and B17:k21 |  |  | 3 | 3 | 0 | March | 1 |  |  |  |  | 1 |  | March | 1 | 1 |  | March |  | After |  |  |  | 1 | 1 |  | 2 | 1 |  |  | 5
April | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 |  | and Q3:R14 are |  |  | 3 | 3 | 0 | April | 1 |  |  |  |  | 1 |  | April | 1 | 1 |  | April |  | 15 | 0 | 0 | 2 | 3 | 2 | 0 | 6 | 2 | 0 | 0 | 15
May | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |  | Taking the totals from the Ro2 25 |  |  | 3 | 3 | 0 | May | 1 |  |  |  |  | 1 |  | May | 1 | 1 |  | May
June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | through 40 |  |  | 0 | 0 | 0 | June |  |  |  |  |  |  |  | June | 0 |  |  | June
July | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | July |  |  |  |  |  |  |  | July | 0 |  |  | July
August | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Whats requireds is to |  |  | 0 | 0 | 0 | August |  |  |  |  |  |  |  | August | 0 |  |  | August
September | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | spilt out the before and after |  |  | 0 | 0 | 0 | September |  |  |  |  |  |  |  | September | 0 |  |  | September
October | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | to place |  |  | 0 | 0 | 0 | October |  |  |  |  |  |  |  | October | 0 |  |  | October
November | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | November |  |  |  |  |  |  |  | November | 0 |  |  | November
December | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | December |  |  |  |  |  |  |  | December | 0 |  |  | December
15 | 0 | 0 | 2 | 3 | 2 | 0 | 6 | 2 | 0 | 0 |  |  |  |  | 15 | Up | Down |  |  |  |  |  |  |  |  | 5 | 5 |  |  | 5
Stats | TREND | DD | P Struc | NVD | INVD | NEUT | INEUT | ND | NTD | Unknown |  |  |  |  |  | 14 | 1 | 15 |  |  |  |  |  | Up | Down |  |  | Up | Down
Monday | 0 | 0 | 0 | 1 | 1 | 0 | 2 | 1 | 0 | 0 |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 5 | 0 | 5 |  | 5 | 0 | 5
Tuesday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0
Wednesday | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0
Thursday | 0 | 0 | 1 | 1 | 0 | 0 | 3 | 0 | 0 | 0 |  |  |  |  | 5
Friday | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | This A25:U:40 section is in the real world linked to another sheet to bring in the data
Comment 1 |  |  |  |  |  | Comment 2 |  |  |  | Date 2 |  | Year | Day of Month | Day of Year | Month | Date 1 | Weekday | empty | Actual | Event | Close to Close sequence | This col could be added if it helps
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 3 | 3 | 2007-01-04 00:00:00 | 2007-01-04 00:00:00 | 2007-01-04 00:00:00 |  | INEUT | Factory Orders | blue | Before
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 4 | 4 | 2007-01-05 00:00:00 | 2007-01-05 00:00:00 | 2007-01-05 00:00:00 |  | NVD | NFP / FED Chair Speaks | Red | Actual
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 5 | 5 | 2007-01-08 00:00:00 | 2007-01-08 00:00:00 | 2007-01-08 00:00:00 |  | NVD | 0 | blue | After
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 1 | 23 | 2007-02-01 00:00:00 | 2007-02-01 00:00:00 | 2007-02-01 00:00:00 |  | INEUT | 0 | blue | Before
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 2 | 24 | 2007-02-02 00:00:00 | 2007-02-02 00:00:00 | 2007-02-02 00:00:00 |  | P Struc | NFP / Michigan / FM / Factory Orders | blue | Actual
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 3 | 25 | 2007-02-05 00:00:00 | 2007-02-05 00:00:00 | 2007-02-05 00:00:00 |  | INVD | 0 | blue | After
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 6 | 48 | 2007-03-08 00:00:00 | 2007-03-08 00:00:00 | 2007-03-08 00:00:00 |  | INEUT | Roll / BoE/ECB | blue | Before
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 7 | 49 | 2007-03-09 00:00:00 | 2007-03-09 00:00:00 | 2007-03-09 00:00:00 |  | INVD | NFP | blue | Actual
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 8 | 50 | 2007-03-12 00:00:00 | 2007-03-12 00:00:00 | 2007-03-12 00:00:00 |  | INEUT | 0 | blue | After
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 4 | 68 | 2007-04-05 00:00:00 | 2007-04-05 00:00:00 | 2007-04-05 00:00:00 |  | NVD | BoE | blue | Before
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 5 | 69 | 2007-04-06 00:00:00 | 2007-04-06 00:00:00 | 2007-04-06 00:00:00 |  | ND | NFP / Easter Holiday | blue | Actual
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 6 | 70 | 2007-04-09 00:00:00 | 2007-04-09 00:00:00 | 2007-04-09 00:00:00 |  | INEUT | Easter | blue | After
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 3 | 88 | 2007-05-03 00:00:00 | 2007-05-03 00:00:00 | 2007-05-03 00:00:00 |  | P Struc | 0 | blue | Before
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 4 | 89 | 2007-05-04 00:00:00 | 2007-05-04 00:00:00 | 2007-05-04 00:00:00 |  | INEUT | NFP | blue | Actual
 |  |  |  |  |  |  |  |  |  |  |  | 2007 | 5 | 90 | 2007-05-07 00:00:00 | 2007-05-07 00:00:00 | 2007-05-07 00:00:00 |  | ND | 0 | blue | After