Spreadsheet: 111611d1307977234-putting-data-on-the-right-date-question-13-june
Sheet: Blad1

Date | SP |  |  | Date | long interest |  | difference date
2000-10-20 00:00:00 | 1342.13 |  |  | 2000-10-20 00:00:00 | 5.95
2000-10-23 00:00:00 | 1388.76 |  |  | 2000-10-23 00:00:00 | 5.89
2000-10-24 00:00:00 | 1396.93 |  |  | 2000-10-24 00:00:00 | 5.93 |  |  |  |  | So long interest (column F) must be placed on the right date of column A
2000-10-25 00:00:00 | 1395.78 |  |  | 2000-10-25 00:00:00 | 5.97
2000-10-26 00:00:00 | 1398.13 |  |  | 2000-10-26 00:00:00 | 5.96
2000-10-27 00:00:00 | 1364.9 |  |  | 2000-10-27 00:00:00 | 5.96
2000-10-30 00:00:00 | 1364.44 |  |  | 2000-10-30 00:00:00 | 5.98
2000-10-31 00:00:00 | 1379.58 |  |  | 2000-10-31 00:00:00 | 6.02
2000-11-01 00:00:00 | 1398.66 |  |  | 2000-11-01 00:00:00 | 6
2000-11-02 00:00:00 | 1429.4 |  |  | 2000-11-02 00:00:00 | 6.01
2000-11-03 00:00:00 | 1421.22 |  |  | 2000-11-03 00:00:00 | 6.09
2000-11-06 00:00:00 | 1428.32 |  |  | 2000-11-06 00:00:00 | 6.12
2000-11-07 00:00:00 | 1426.69 |  |  | 2000-11-07 00:00:00 | 6.12
2000-11-08 00:00:00 | 1432.19 |  |  | 2000-11-08 00:00:00 | 6.09
2000-11-09 00:00:00 | 1431.87 |  |  | 2000-11-09 00:00:00 | 6.06
2000-11-10 00:00:00 | 1409.28 |  |  | 2000-11-10 00:00:00 | 6.07
2000-11-13 00:00:00 | 1400.14 |  |  | 2000-11-13 00:00:00 | 6.04
2000-11-14 00:00:00 | 1365.98 |  |  | 2000-11-14 00:00:00 | 6.01
2000-11-15 00:00:00 | 1351.26 |  |  | 2000-11-15 00:00:00 | 5.97
2000-11-16 00:00:00 | 1382.95 |  |  | 2000-11-16 00:00:00 | 5.94
2000-11-17 00:00:00 | 1389.81 |  |  | 2000-11-17 00:00:00 | 5.97
2000-11-20 00:00:00 | 1372.32 |  |  | 2000-11-20 00:00:00 | 5.96
2000-11-21 00:00:00 | 1367.72 |  |  | 2000-11-21 00:00:00 | 5.93
2000-11-22 00:00:00 | 1342.62 |  |  | 2000-11-22 00:00:00 | 5.87
2000-11-24 00:00:00 | 1347.35 |  |  | 2000-11-23 00:00:00
2000-11-27 00:00:00 | 1322.36 |  |  | 2000-11-24 00:00:00 | 5.86
2000-11-28 00:00:00 | 1341.77 |  |  | 2000-11-27 00:00:00 | 5.89
2000-11-29 00:00:00 | 1348.97 |  |  | 2000-11-28 00:00:00 | 5.86
2000-11-30 00:00:00 | 1336.09 |  |  | 2000-11-29 00:00:00 | 5.84
2000-12-01 00:00:00 | 1341.93 |  |  | 2000-11-30 00:00:00 | 5.78
2000-12-04 00:00:00 | 1314.95 |  |  | 2000-12-01 00:00:00 | 5.82
2000-12-05 00:00:00 | 1315.23 |  |  | 2000-12-04 00:00:00 | 5.84
2000-12-06 00:00:00 | 1324.97 |  |  | 2000-12-05 00:00:00 | 5.76
2000-12-07 00:00:00 | 1376.54 |  |  | 2000-12-06 00:00:00 | 5.68
2000-12-08 00:00:00 | 1351.46 |  |  | 2000-12-07 00:00:00 | 5.67
2000-12-11 00:00:00 | 1343.55 |  |  | 2000-12-08 00:00:00 | 5.71
2000-12-12 00:00:00 | 1369.89 |  |  | 2000-12-11 00:00:00 | 5.71
2000-12-13 00:00:00 | 1380.2 |  |  | 2000-12-12 00:00:00 | 5.7
2000-12-14 00:00:00 | 1371.18 |  |  | 2000-12-13 00:00:00 | 5.64
2000-12-15 00:00:00 | 1359.99 |  |  | 2000-12-14 00:00:00 | 5.6
2000-12-18 00:00:00 | 1340.93 |  |  | 2000-12-15 00:00:00 | 5.59
2000-12-19 00:00:00 | 1312.15 |  |  | 2000-12-18 00:00:00 | 5.59
2000-12-20 00:00:00 | 1322.74 |  |  | 2000-12-19 00:00:00 | 5.61
2000-12-21 00:00:00 | 1305.6 |  |  | 2000-12-20 00:00:00 | 5.55
2000-12-22 00:00:00 | 1264.74 |  |  | 2000-12-21 00:00:00 | 5.53
2000-12-26 00:00:00 | 1274.86 |  |  | 2000-12-22 00:00:00 | 5.52
2000-12-27 00:00:00 | 1305.95 |  |  | 2000-12-25 00:00:00
2000-12-28 00:00:00 | 1315.19 |  |  | 2000-12-26 00:00:00 | 5.54
2000-12-29 00:00:00 | 1328.92 |  |  | 2000-12-27 00:00:00 | 5.58
2001-01-02 00:00:00 | 1334.22 |  |  | 2000-12-28 00:00:00 | 5.59
2001-01-03 00:00:00 | 1320.28 |  |  | 2000-12-29 00:00:00 | 5.59
2001-01-04 00:00:00 | 1283.27 |  |  | 2001-01-01 00:00:00
2001-01-05 00:00:00 | 1347.56 |  |  | 2001-01-02 00:00:00 | 5.46
2001-01-08 00:00:00 | 1333.34 |  |  | 2001-01-03 00:00:00 | 5.62
2001-01-09 00:00:00 | 1298.35 |  |  | 2001-01-04 00:00:00 | 5.56
2001-01-10 00:00:00 | 1295.86 |  |  | 2001-01-05 00:00:00 | 5.5
2001-01-11 00:00:00 | 1300.8 |  |  | 2001-01-08 00:00:00 | 5.52
2001-01-12 00:00:00 | 1313.27 |  |  | 2001-01-09 00:00:00 | 5.53
2001-01-16 00:00:00 | 1326.82 |  |  | 2001-01-10 00:00:00 | 5.6
2001-01-17 00:00:00 | 1318.55 |  |  | 2001-01-11 00:00:00 | 5.67
2001-01-18 00:00:00 | 1326.65 |  |  | 2001-01-12 00:00:00 | 5.74
2001-01-19 00:00:00 | 1329.47 |  |  | 2001-01-15 00:00:00
2001-01-22 00:00:00 | 1347.97 |  |  | 2001-01-16 00:00:00 | 5.71
2001-01-23 00:00:00 | 1342.54 |  |  | 2001-01-17 00:00:00 | 5.64
2001-01-24 00:00:00 | 1342.9 |  |  | 2001-01-18 00:00:00 | 5.57
2001-01-25 00:00:00 | 1360.4 |  |  | 2001-01-19 00:00:00 | 5.67
2001-01-26 00:00:00 | 1364.3 |  |  | 2001-01-22 00:00:00 | 5.71
2001-01-29 00:00:00 | 1357.51 |  |  | 2001-01-23 00:00:00 | 5.76
2001-01-30 00:00:00 | 1354.95 |  |  | 2001-01-24 00:00:00 | 5.78
2001-01-31 00:00:00 | 1364.17 |  |  | 2001-01-25 00:00:00 | 5.73
2001-02-01 00:00:00 | 1373.73 |  |  | 2001-01-26 00:00:00 | 5.75
2001-02-02 00:00:00 | 1366.01 |  |  | 2001-01-29 00:00:00 | 5.78
2001-02-05 00:00:00 | 1373.47 |  |  | 2001-01-30 00:00:00 | 5.68
2001-02-06 00:00:00 | 1349.47 |  |  | 2001-01-31 00:00:00 | 5.65
2001-02-07 00:00:00 | 1354.31 |  |  | 2001-02-01 00:00:00 | 5.55
2001-02-08 00:00:00 | 1352.26 |  |  | 2001-02-02 00:00:00 | 5.6
2001-02-09 00:00:00 | 1340.89 |  |  | 2001-02-05 00:00:00 | 5.58
2001-02-12 00:00:00 | 1332.53 |  |  | 2001-02-06 00:00:00 | 5.61
2001-02-13 00:00:00 | 1314.76 |  |  | 2001-02-07 00:00:00 | 5.61
2001-02-14 00:00:00 | 1330.31 |  |  | 2001-02-08 00:00:00 | 5.62
2001-02-15 00:00:00 | 1318.8 |  |  | 2001-02-09 00:00:00 | 5.55
2001-02-16 00:00:00 | 1315.92 |  |  | 2001-02-12 00:00:00 | 5.6
2001-02-20 00:00:00 | 1326.61 |  |  | 2001-02-13 00:00:00 | 5.62
2001-02-21 00:00:00 | 1301.53 |  |  | 2001-02-14 00:00:00 | 5.64
2001-02-22 00:00:00 | 1278.94 |  |  | 2001-02-15 00:00:00 | 5.71
2001-02-23 00:00:00 | 1255.27 |  |  | 2001-02-16 00:00:00 | 5.67
2001-02-26 00:00:00 | 1252.82 |  |  | 2001-02-19 00:00:00
2001-02-27 00:00:00 | 1245.86 |  |  | 2001-02-20 00:00:00 | 5.66
2001-02-28 00:00:00 | 1267.65 |  |  | 2001-02-21 00:00:00 | 5.7
2001-03-01 00:00:00 | 1257.94 |  |  | 2001-02-22 00:00:00 | 5.72
2001-03-02 00:00:00 | 1239.94 |  |  | 2001-02-23 00:00:00 | 5.66
2001-03-05 00:00:00 | 1241.23 |  |  | 2001-02-26 00:00:00 | 5.62
2001-03-06 00:00:00 | 1234.18 |  |  | 2001-02-27 00:00:00 | 5.51
2001-03-07 00:00:00 | 1241.41 |  |  | 2001-02-28 00:00:00 | 5.51
2001-03-08 00:00:00 | 1253.8 |  |  | 2001-03-01 00:00:00 | 5.45
2001-03-09 00:00:00 | 1261.89 |  |  | 2001-03-02 00:00:00 | 5.55
2001-03-12 00:00:00 | 1264.74 |  |  | 2001-03-05 00:00:00 | 5.55
2001-03-13 00:00:00 | 1233.42 |  |  | 2001-03-06 00:00:00 | 5.56
2001-03-14 00:00:00 | 1180.16 |  |  | 2001-03-07 00:00:00 | 5.49
2001-03-15 00:00:00 | 1197.66 |  |  | 2001-03-08 00:00:00 | 5.48
2001-03-16 00:00:00 | 1166.71 |  |  | 2001-03-09 00:00:00 | 5.5
2001-03-19 00:00:00 | 1173.56 |  |  | 2001-03-12 00:00:00 | 5.48
2001-03-20 00:00:00 | 1150.53 |  |  | 2001-03-13 00:00:00 | 5.5
2001-03-21 00:00:00 | 1170.81 |  |  | 2001-03-14 00:00:00 | 5.43
2001-03-22 00:00:00 | 1142.62 |  |  | 2001-03-15 00:00:00 | 5.43
2001-03-23 00:00:00 | 1122.14 |  |  | 2001-03-16 00:00:00 | 5.41
2001-03-26 00:00:00 | 1117.58 |  |  | 2001-03-19 00:00:00 | 5.44
2001-03-27 00:00:00 | 1139.83 |  |  | 2001-03-20 00:00:00 | 5.41
2001-03-28 00:00:00 | 1152.69 |  |  | 2001-03-21 00:00:00 | 5.42
2001-03-29 00:00:00 | 1182.17 |  |  | 2001-03-22 00:00:00 | 5.38
2001-03-30 00:00:00 | 1153.29 |  |  | 2001-03-23 00:00:00 | 5.43
2001-04-02 00:00:00 | 1147.95 |  |  | 2001-03-26 00:00:00 | 5.5
2001-04-03 00:00:00 | 1160.33 |  |  | 2001-03-27 00:00:00 | 5.61
2001-04-04 00:00:00 | 1145.87 |  |  | 2001-03-28 00:00:00 | 5.61
2001-04-05 00:00:00 | 1106.46 |  |  | 2001-03-29 00:00:00 | 5.63
2001-04-06 00:00:00 | 1103.25 |  |  | 2001-03-30 00:00:00 | 5.6
2001-04-09 00:00:00 | 1151.44 |  |  | 2001-04-02 00:00:00 | 5.64
2001-04-10 00:00:00 | 1128.43 |  |  | 2001-04-03 00:00:00 | 5.62
2001-04-11 00:00:00 | 1137.59 |  |  | 2001-04-04 00:00:00 | 5.62
2001-04-12 00:00:00 | 1168.38 |  |  | 2001-04-05 00:00:00 | 5.66
2001-04-16 00:00:00 | 1165.89 |  |  | 2001-04-06 00:00:00 | 5.57
2001-04-17 00:00:00 | 1183.5 |  |  | 2001-04-09 00:00:00 | 5.61
2001-04-18 00:00:00 | 1179.68 |  |  | 2001-04-10 00:00:00 | 5.76
2001-04-19 00:00:00 | 1191.81 |  |  | 2001-04-11 00:00:00 | 5.75
2001-04-20 00:00:00 | 1238.16 |  |  | 2001-04-12 00:00:00 | 5.77
2001-04-23 00:00:00 | 1253.69 |  |  | 2001-04-13 00:00:00
2001-04-24 00:00:00 | 1242.98 |  |  | 2001-04-16 00:00:00 | 5.86
2001-04-25 00:00:00 | 1224.36 |  |  | 2001-04-17 00:00:00 | 5.8
2001-04-26 00:00:00 | 1209.47 |  |  | 2001-04-18 00:00:00 | 5.79
2001-04-27 00:00:00 | 1228.75 |  |  | 2001-04-19 00:00:00 | 5.91
2001-04-30 00:00:00 | 1234.52 |  |  | 2001-04-20 00:00:00 | 5.92
2001-05-01 00:00:00 | 1253.05 |  |  | 2001-04-23 00:00:00 | 5.84
2001-05-02 00:00:00 | 1249.46 |  |  | 2001-04-24 00:00:00 | 5.87
2001-05-03 00:00:00 | 1266.44 |  |  | 2001-04-25 00:00:00 | 5.91
2001-05-04 00:00:00 | 1267.43 |  |  | 2001-04-26 00:00:00 | 5.82
2001-05-07 00:00:00 | 1248.58 |  |  | 2001-04-27 00:00:00 | 5.94
2001-05-08 00:00:00 | 1266.61 |  |  | 2001-04-30 00:00:00 | 5.92
2001-05-09 00:00:00 | 1263.51 |  |  | 2001-05-01 00:00:00 | 5.87
2001-05-10 00:00:00 | 1261.2 |  |  | 2001-05-02 00:00:00 | 5.83
2001-05-11 00:00:00 | 1255.54 |  |  | 2001-05-03 00:00:00 | 5.75
2001-05-14 00:00:00 | 1255.18 |  |  | 2001-05-04 00:00:00 | 5.77
2001-05-15 00:00:00 | 1245.67 |  |  | 2001-05-07 00:00:00 | 5.78
2001-05-16 00:00:00 | 1248.92 |  |  | 2001-05-08 00:00:00 | 5.81
2001-05-17 00:00:00 | 1249.44 |  |  | 2001-05-09 00:00:00 | 5.76
2001-05-18 00:00:00 | 1284.99 |  |  | 2001-05-10 00:00:00 | 5.86
2001-05-21 00:00:00 | 1288.49 |  |  | 2001-05-11 00:00:00 | 6.02
2001-05-22 00:00:00 | 1291.96 |  |  | 2001-05-14 00:00:00 | 5.99
2001-05-23 00:00:00 | 1312.83 |  |  | 2001-05-15 00:00:00 | 6.03
2001-05-24 00:00:00 | 1309.38 |  |  | 2001-05-16 00:00:00 | 6.01
2001-05-25 00:00:00 | 1289.05 |  |  | 2001-05-17 00:00:00 | 5.96
2001-05-29 00:00:00 | 1293.17 |  |  | 2001-05-18 00:00:00 | 5.93