Spreadsheet: 289951d1389752314-excel-not-recognising-pattern-helpexamplemal
Sheet: Data

Name | Date | ClosePrice |  | Change
AAC | 2014-01-15 00:00:00 | 123
 | 2014-01-14 00:00:00 | 122.5
 | 2014-01-13 00:00:00 | 125
 | 2014-01-10 00:00:00 | 125
 | 2014-01-09 00:00:00 | 122.5
 | 2014-01-08 00:00:00 | 122.5
 | 2014-01-07 00:00:00 | 122.5
 | 2014-01-06 00:00:00 | 121.5
 | 2014-01-03 00:00:00 | 123
 | 2014-01-02 00:00:00 | 123.5
 | 2013-12-31 00:00:00 | 125
 | 2013-12-30 00:00:00 | 123.5
 | 2013-12-27 00:00:00 | 123
 | 2013-12-24 00:00:00 | 121.5
 | 2013-12-23 00:00:00 | 123
 | 2013-12-20 00:00:00 | 121.5
 | 2013-12-19 00:00:00 | 120
 | 2013-12-18 00:00:00 | 120.5
 | 2013-12-17 00:00:00 | 121
 | 2013-12-16 00:00:00 | 120
 | 2013-12-13 00:00:00 | 121
 | 2013-12-12 00:00:00 | 119
 | 2013-12-11 00:00:00 | 120
 | 2013-12-10 00:00:00 | 119.5
 | 2013-12-09 00:00:00 | 119.5
 | 2013-12-06 00:00:00 | 117
 | 2013-12-05 00:00:00 | 116
 | 2013-12-04 00:00:00 | 116.5
 | 2013-12-03 00:00:00 | 117.5
 | 2013-12-02 00:00:00 | 121
 | 2013-11-29 00:00:00 | 120
 | 2013-11-28 00:00:00 | 120.5
 | 2013-11-27 00:00:00 | 119.5
 | 2013-11-26 00:00:00 | 118
 | 2013-11-25 00:00:00 | 116.5
 | 2013-11-22 00:00:00 | 116.5
 | 2013-11-21 00:00:00 | 116
 | 2013-11-20 00:00:00 | 115
 | 2013-11-19 00:00:00 | 119.5
 | 2013-11-18 00:00:00 | 121
AAD | 2014-01-15 00:00:00 | 202
 | 2014-01-14 00:00:00 | 202
 | 2014-01-13 00:00:00 | 205
 | 2014-01-10 00:00:00 | 206
 | 2014-01-09 00:00:00 | 205
 | 2014-01-08 00:00:00 | 203
 | 2014-01-07 00:00:00 | 206
 | 2014-01-06 00:00:00 | 205
 | 2014-01-03 00:00:00 | 205
 | 2014-01-02 00:00:00 | 205
 | 2013-12-31 00:00:00 | 201
 | 2013-12-30 00:00:00 | 200
 | 2013-12-27 00:00:00 | 200
 | 2013-12-24 00:00:00 | 199
 | 2013-12-23 00:00:00 | 198.5
 | 2013-12-20 00:00:00 | 202
 | 2013-12-19 00:00:00 | 200
 | 2013-12-18 00:00:00 | 195
 | 2013-12-17 00:00:00 | 195.5
 | 2013-12-16 00:00:00 | 194
 | 2013-12-13 00:00:00 | 193
 | 2013-12-12 00:00:00 | 193.5
 | 2013-12-11 00:00:00 | 192
 | 2013-12-10 00:00:00 | 192
 | 2013-12-09 00:00:00 | 197
 | 2013-12-06 00:00:00 | 194.5
 | 2013-12-05 00:00:00 | 196
 | 2013-12-04 00:00:00 | 199
 | 2013-12-03 00:00:00 | 195
 | 2013-12-02 00:00:00 | 198.5
 | 2013-11-29 00:00:00 | 201
 | 2013-11-28 00:00:00 | 201
 | 2013-11-27 00:00:00 | 200
 | 2013-11-26 00:00:00 | 200
 | 2013-11-25 00:00:00 | 202
 | 2013-11-22 00:00:00 | 195
 | 2013-11-21 00:00:00 | 198
 | 2013-11-20 00:00:00 | 198
 | 2013-11-19 00:00:00 | 199
 | 2013-11-18 00:00:00 | 200
AAX | 2014-01-15 00:00:00 | 66.5
 | 2014-01-14 00:00:00 | 66
 | 2014-01-13 00:00:00 | 67.5
 | 2014-01-10 00:00:00 | 70.5
 | 2014-01-09 00:00:00 | 69
 | 2014-01-08 00:00:00 | 64
 | 2014-01-07 00:00:00 | 62.5
 | 2014-01-06 00:00:00 | 63
 | 2014-01-03 00:00:00 | 61.5
 | 2014-01-02 00:00:00 | 62.5
 | 2013-12-31 00:00:00 | 63
 | 2013-12-30 00:00:00 | 60.5
 | 2013-12-27 00:00:00 | 64
 | 2013-12-24 00:00:00 | 63.5
 | 2013-12-23 00:00:00 | 64.5
 | 2013-12-20 00:00:00 | 64.5
 | 2013-12-19 00:00:00 | 64.5
 | 2013-12-18 00:00:00 | 64
 | 2013-12-17 00:00:00 | 66
 | 2013-12-16 00:00:00 | 68.5
 | 2013-12-13 00:00:00 | 65
 | 2013-12-12 00:00:00 | 61.5
 | 2013-12-11 00:00:00 | 61.5
 | 2013-12-10 00:00:00 | 62
 | 2013-12-09 00:00:00 | 65
 | 2013-12-06 00:00:00 | 65
 | 2013-12-05 00:00:00 | 60
 | 2013-12-04 00:00:00 | 57.99999999999999
 | 2013-12-03 00:00:00 | 60.5
 | 2013-12-02 00:00:00 | 66
 | 2013-11-29 00:00:00 | 106.6679978370667
 | 2013-11-28 00:00:00 | 106.6679978370667
 | 2013-11-27 00:00:00 | 106.6679978370667
 | 2013-11-26 00:00:00 | 106.6679978370667
 | 2013-11-25 00:00:00 | 106.6679978370667
 | 2013-11-22 00:00:00 | 106.6679978370667
 | 2013-11-21 00:00:00 | 110.2235977649689
 | 2013-11-20 00:00:00 | 112.00139772892
 | 2013-11-19 00:00:00 | 118.6681475937366
 | 2013-11-18 00:00:00 | 118.2236976027489
ABC | 2014-01-15 00:00:00 | 368
 | 2014-01-14 00:00:00 | 363
 | 2014-01-13 00:00:00 | 372
 | 2014-01-10 00:00:00 | 376
 | 2014-01-09 00:00:00 | 374
 | 2014-01-08 00:00:00 | 374
 | 2014-01-07 00:00:00 | 373
 | 2014-01-06 00:00:00 | 365
 | 2014-01-03 00:00:00 | 365
 | 2014-01-02 00:00:00 | 369
 | 2013-12-31 00:00:00 | 367
 | 2013-12-30 00:00:00 | 363
 | 2013-12-27 00:00:00 | 365
 | 2013-12-24 00:00:00 | 368
 | 2013-12-23 00:00:00 | 363
 | 2013-12-20 00:00:00 | 360
 | 2013-12-19 00:00:00 | 358
 | 2013-12-18 00:00:00 | 349
 | 2013-12-17 00:00:00 | 361
 | 2013-12-16 00:00:00 | 354
 | 2013-12-13 00:00:00 | 351
 | 2013-12-12 00:00:00 | 364
 | 2013-12-11 00:00:00 | 355
 | 2013-12-10 00:00:00 | 357
 | 2013-12-09 00:00:00 | 353
 | 2013-12-06 00:00:00 | 359
 | 2013-12-05 00:00:00 | 364
 | 2013-12-04 00:00:00 | 368
 | 2013-12-03 00:00:00 | 370
 | 2013-12-02 00:00:00 | 369
 | 2013-11-29 00:00:00 | 379
 | 2013-11-28 00:00:00 | 387
 | 2013-11-27 00:00:00 | 384
 | 2013-11-26 00:00:00 | 384
 | 2013-11-25 00:00:00 | 386
 | 2013-11-22 00:00:00 | 381
 | 2013-11-21 00:00:00 | 378
 | 2013-11-20 00:00:00 | 377
 | 2013-11-19 00:00:00 | 380
 | 2013-11-18 00:00:00 | 383
ABP | 2014-01-15 00:00:00 | 234
 | 2014-01-14 00:00:00 | 232
 | 2014-01-13 00:00:00 | 236
 | 2014-01-10 00:00:00 | 235
 | 2014-01-09 00:00:00 | 235
 | 2014-01-08 00:00:00 | 235
 | 2014-01-07 00:00:00 | 235
 | 2014-01-06 00:00:00 | 234
 | 2014-01-03 00:00:00 | 234
 | 2014-01-02 00:00:00 | 234
 | 2013-12-31 00:00:00 | 232
 | 2013-12-30 00:00:00 | 234
 | 2013-12-27 00:00:00 | 235
 | 2013-12-24 00:00:00 | 238
 | 2013-12-23 00:00:00 | 238
 | 2013-12-20 00:00:00 | 233
 | 2013-12-19 00:00:00 | 226
 | 2013-12-18 00:00:00 | 222
 | 2013-12-17 00:00:00 | 221
 | 2013-12-16 00:00:00 | 222
 | 2013-12-13 00:00:00 | 221
 | 2013-12-12 00:00:00 | 220
 | 2013-12-11 00:00:00 | 218
 | 2013-12-10 00:00:00 | 220
 | 2013-12-09 00:00:00 | 220
 | 2013-12-06 00:00:00 | 220
 | 2013-12-05 00:00:00 | 220
 | 2013-12-04 00:00:00 | 221
 | 2013-12-03 00:00:00 | 225
 | 2013-12-02 00:00:00 | 225
 | 2013-11-29 00:00:00 | 226
 | 2013-11-28 00:00:00 | 227
 | 2013-11-27 00:00:00 | 227
 | 2013-11-26 00:00:00 | 227
 | 2013-11-25 00:00:00 | 225
 | 2013-11-22 00:00:00 | 226
 | 2013-11-21 00:00:00 | 225
 | 2013-11-20 00:00:00 | 226
 | 2013-11-19 00:00:00 | 227
 | 2013-11-18 00:00:00 | 228