Spreadsheet: 24686d1215415570-return-the-earliest-day-of-a-month-moving-day
Sheet: Sheet1

 | 8951 JP EQUITY
EQY_INIT_PO_DT | 9/10/2001
Recent Return
Current MTD | 0.04800000000000004 |  | 0.04800000000000004
2008-06-30 00:00:00 |  |  | -0.107142857142857
2008-05-31 00:00:00 |  |  | 0.02941176470588291
2008-04-30 00:00:00 |  |  | 0.0793650793650793
Historical Return
2008-07-07 00:00:00 | -0.007575757575757576
2008-07-04 00:00:00 | 0.01538461538461539
2008-07-03 00:00:00 | 0.04
2008-07-02 00:00:00 | -0.03846153846153846
2008-07-01 00:00:00 | 0.04
2008-06-30 00:00:00 | 0.01626016260162602
2008-06-27 00:00:00 | -0.02380952380952381
2008-06-26 00:00:00 | 0
2008-06-25 00:00:00 | -0.03816793893129771
2008-06-24 00:00:00 | 0.01550387596899225
2008-06-23 00:00:00 | -0.007692307692307693
2008-06-20 00:00:00 | -0.01515151515151515
2008-06-19 00:00:00 | -0.02222222222222222
2008-06-18 00:00:00 | 0.007462686567164179
2008-06-17 00:00:00 | 0.007518796992481203
2008-06-16 00:00:00 | 0.0310077519379845
2008-06-13 00:00:00 | -0.01526717557251908
2008-06-12 00:00:00 | 0.0234375
2008-06-11 00:00:00 | -0.04477611940298507
2008-06-10 00:00:00 | -0.0218978102189781
2008-06-09 00:00:00 | -0.007246376811594203
2008-06-06 00:00:00 | 0.0072992700729927
2008-06-05 00:00:00 | -0.01438848920863309
2008-06-04 00:00:00 | 0.007246376811594203
2008-06-03 00:00:00 | -0.01428571428571429
2008-06-02 00:00:00 | 0
2008-05-30 00:00:00 | 0.0218978102189781
2008-05-29 00:00:00 | 0.01481481481481482
2008-05-28 00:00:00 | -0.0145985401459854
2008-05-27 00:00:00 | 0.04580152671755725
2008-05-26 00:00:00 | -0.01503759398496241
2008-05-23 00:00:00 | 0.0310077519379845
2008-05-22 00:00:00 | -0.02272727272727273
2008-05-21 00:00:00 | -0.0364963503649635
2008-05-20 00:00:00 | -0.01438848920863309
2008-05-19 00:00:00 | -0.007142857142857143
2008-05-16 00:00:00 | 0.01449275362318841
2008-05-15 00:00:00 | 0
2008-05-14 00:00:00 | -0.007194244604316547
2008-05-13 00:00:00 | 0.007246376811594203
2008-05-12 00:00:00 | -0.01428571428571429
2008-05-09 00:00:00 | -0.02777777777777778
2008-05-08 00:00:00 | 0
2008-05-07 00:00:00 | 0.006993006993006993
2008-05-02 00:00:00 | 0.02877697841726619
2008-05-01 00:00:00 | 0.02205882352941177
2008-04-30 00:00:00 | 0.02255639097744361
2008-04-28 00:00:00 | 0.01526717557251908
2008-04-25 00:00:00 | -0.007575757575757576
2008-04-24 00:00:00 | -0.01492537313432836
2008-04-23 00:00:00 | 0
2008-04-22 00:00:00 | -0.007407407407407408
2008-04-21 00:00:00 | 0
2008-04-18 00:00:00 | 0
2008-04-17 00:00:00 | 0.03053435114503817
2008-04-16 00:00:00 | 0
2008-04-15 00:00:00 | 0.03968253968253968
2008-04-14 00:00:00 | -0.03816793893129771
2008-04-11 00:00:00 | 0.0234375
2008-04-10 00:00:00 | 0
2008-04-09 00:00:00 | -0.04477611940298507
2008-04-08 00:00:00 | -0.007407407407407408
2008-04-07 00:00:00 | 0.01503759398496241
2008-04-04 00:00:00 | -0.01481481481481482
2008-04-03 00:00:00 | 0.007462686567164179
2008-04-02 00:00:00 | 0.05511811023622047
2008-04-01 00:00:00 | 0.007936507936507936
2008-03-31 00:00:00 | 0.04132231404958678
2008-03-28 00:00:00 | -0.01626016260162602
2008-03-27 00:00:00 | -0.03149606299212598
2008-03-26 00:00:00 | 0.007936507936507936
2008-03-25 00:00:00 | 0.03278688524590164
2008-03-24 00:00:00 | 0.008264462809917356
2008-03-21 00:00:00 | 0.03418803418803419
2008-03-19 00:00:00 | 0.03539823008849557
2008-03-18 00:00:00 | 0.05607476635514019
2008-03-17 00:00:00 | -0.05309734513274336
2008-03-14 00:00:00 | -0.02586206896551724
2008-03-13 00:00:00 | -0.03333333333333333
2008-03-12 00:00:00 | 0.008403361344537815
2008-03-11 00:00:00 | 0.04385964912280702
2008-03-10 00:00:00 | -0.03389830508474576
2008-03-07 00:00:00 | -0.02479338842975207
2008-03-06 00:00:00 | 0.01680672268907563
2008-03-05 00:00:00 | -0.048
2008-03-04 00:00:00 | -0.0234375
2008-03-03 00:00:00 | -0.01538461538461539
2008-02-29 00:00:00 | -0.02255639097744361
2008-02-28 00:00:00 | -0.007462686567164179
2008-02-27 00:00:00 | 0.007518796992481203
2008-02-26 00:00:00 | 0
2008-02-25 00:00:00 | -0.007462686567164179
2008-02-22 00:00:00 | -0.007407407407407408
2008-02-21 00:00:00 | 0.02272727272727273
2008-02-20 00:00:00 | -0.02222222222222222
2008-02-19 00:00:00 | 0
2008-02-18 00:00:00 | 0.03846153846153846
2008-02-15 00:00:00 | 0.007751937984496124
2008-02-14 00:00:00 | 0.02380952380952381
2008-02-13 00:00:00 | 0.008
2008-02-12 00:00:00 | -0.007936507936507936
2008-02-08 00:00:00 | 0.008
2008-02-07 00:00:00 | 0.02459016393442623
2008-02-06 00:00:00 | -0.046875
2008-02-05 00:00:00 | 0
2008-02-04 00:00:00 | 0.03225806451612903
2008-02-01 00:00:00 | 0.008130081300813009
2008-01-31 00:00:00 | 0.01652892561983471
2008-01-30 00:00:00 | -0.00819672131147541
2008-01-29 00:00:00 | -0.008130081300813009
2008-01-28 00:00:00 | -0.07518796992481203
2008-01-25 00:00:00 | 0.0310077519379845
2008-01-24 00:00:00 | 0.04032258064516129
2008-01-23 00:00:00 | 0.03333333333333333
2008-01-22 00:00:00 | -0.06976744186046512
2008-01-21 00:00:00 | 0.02380952380952381
2008-01-18 00:00:00 | 0.01612903225806452
2008-01-17 00:00:00 | -0.04615384615384616
2008-01-16 00:00:00 | -0.05797101449275362
2008-01-15 00:00:00 | -0.02127659574468085
2008-01-11 00:00:00 | -0.02758620689655172
2008-01-10 00:00:00 | -0.03333333333333333
2008-01-09 00:00:00 | -0.0131578947368421
2008-01-08 00:00:00 | -0.006535947712418301
2008-01-07 00:00:00 | -0.01923076923076923
2008-01-04 00:00:00 | -0.006369426751592357
2007-12-28 00:00:00 | 0
2007-12-27 00:00:00 | -0.01875
2007-12-26 00:00:00 | 0
2007-12-25 00:00:00 | 0.03225806451612903
2007-12-21 00:00:00 | 0
2007-12-20 00:00:00 | 0.006493506493506494
2007-12-19 00:00:00 | 0.01986754966887417
2007-12-18 00:00:00 | -0.0130718954248366
2007-12-17 00:00:00 | -0.01923076923076923
2007-12-14 00:00:00 | -0.03703703703703703
2007-12-13 00:00:00 | 0.006211180124223602
2007-12-12 00:00:00 | -0.006172839506172839
2007-12-11 00:00:00 | -0.01818181818181818
2007-12-10 00:00:00 | -0.01785714285714286
2007-12-07 00:00:00 | 0
2007-12-06 00:00:00 | 0.01818181818181818
2007-12-05 00:00:00 | 0.03125
2007-12-04 00:00:00 | 0
2007-12-03 00:00:00 | 0.006289308176100629
2007-11-30 00:00:00 | -0.00625
2007-11-29 00:00:00 | 0.006289308176100629
2007-11-28 00:00:00 | 0
2007-11-27 00:00:00 | -0.0245398773006135
2007-11-26 00:00:00 | 0.07236842105263158
2007-11-22 00:00:00 | -0.01298701298701299
2007-11-21 00:00:00 | -0.006451612903225806
2007-11-20 00:00:00 | -0.01273885350318471
2007-11-19 00:00:00 | 0.01290322580645161
2007-11-16 00:00:00 | -0.0189873417721519
2007-11-15 00:00:00 | 0.006369426751592357
2007-11-14 00:00:00 | 0.03289473684210526
2007-11-13 00:00:00 | 0
2007-11-12 00:00:00 | -0.006535947712418301
2007-11-09 00:00:00 | -0.01290322580645161
2007-11-08 00:00:00 | -0.0189873417721519
2007-11-07 00:00:00 | 0
2007-11-06 00:00:00 | 0
2007-11-05 00:00:00 | -0.006289308176100629
2007-11-02 00:00:00 | -0.03636363636363636
2007-11-01 00:00:00 | -0.006024096385542169
2007-10-31 00:00:00 | 0.01840490797546012
2007-10-30 00:00:00 | 0.02515723270440252
2007-10-29 00:00:00 | 0.02580645161290323
2007-10-26 00:00:00 | 0.03333333333333333
2007-10-25 00:00:00 | -0.0131578947368421
2007-10-24 00:00:00 | 0
2007-10-23 00:00:00 | 0.02013422818791946
2007-10-22 00:00:00 | -0.03870967741935484
2007-10-19 00:00:00 | -0.00641025641025641
2007-10-18 00:00:00 | 0.01298701298701299
2007-10-17 00:00:00 | -0.03144654088050314
2007-10-16 00:00:00 | -0.04216867469879518
2007-10-15 00:00:00 | 0.01219512195121951
2007-10-12 00:00:00 | -0.01796407185628742
2007-10-11 00:00:00 | 0.006024096385542169
2007-10-10 00:00:00 | -0.005988023952095809
2007-10-09 00:00:00 | 0.01829268292682927
2007-10-05 00:00:00 | 0.025
2007-10-04 00:00:00 | -0.04191616766467066
2007-10-03 00:00:00 | 0.006024096385542169
2007-10-02 00:00:00 | 0.006060606060606061
2007-10-01 00:00:00 | -0.01197604790419162
2007-09-28 00:00:00 | 0.0245398773006135
2007-09-27 00:00:00 | 0.04487179487179487
2007-09-26 00:00:00 | 0.04
2007-09-25 00:00:00 | 0.01351351351351351
2007-09-21 00:00:00 | -0.01333333333333333
2007-09-20 00:00:00 | 0
2007-09-19 00:00:00 | 0.08695652173913043
2007-09-18 00:00:00 | -0.06756756756756757
2007-09-14 00:00:00 | -0.006711409395973154
2007-09-13 00:00:00 | -0.006666666666666667
2007-09-12 00:00:00 | 0.06382978723404255
2007-09-11 00:00:00 | 0.02173913043478261
2007-09-10 00:00:00 | -0.02816901408450704
2007-09-07 00:00:00 | -0.01388888888888889
2007-09-06 00:00:00 | -0.04
2007-09-05 00:00:00 | 0
2007-09-04 00:00:00 | -0.006622516556291391
2007-09-03 00:00:00 | 0.01342281879194631
2007-08-31 00:00:00 | -0.006666666666666667
2007-08-30 00:00:00 | 0.04895104895104895
2007-08-29 00:00:00 | -0.05298013245033113
2007-08-28 00:00:00 | -0.02580645161290323
2007-08-27 00:00:00 | 0.03333333333333333
2007-08-24 00:00:00 | -0.0625
2007-08-23 00:00:00 | 0.05960264900662252
2007-08-22 00:00:00 | 0.03424657534246575
2007-08-21 00:00:00 | 0.04285714285714286
2007-08-20 00:00:00 | 0.04477611940298507
2007-08-17 00:00:00 | -0.1066666666666667
2007-08-16 00:00:00 | -0.05063291139240506
2007-08-15 00:00:00 | -0.03067484662576687
2007-08-14 00:00:00 | 0
2007-08-13 00:00:00 | -0.006097560975609756
2007-08-10 00:00:00 | -0.03529411764705882
2007-08-09 00:00:00 | 0.03658536585365853
2007-08-08 00:00:00 | 0.01863354037267081
2007-08-07 00:00:00 | 0.00625
2007-08-06 00:00:00 | -0.006211180124223602
2007-08-03 00:00:00 | 0.03205128205128205
2007-08-02 00:00:00 | -0.006369426751592357
2007-08-01 00:00:00 | -0.006329113924050633
2007-07-31 00:00:00 | 0.006369426751592357
2007-07-30 00:00:00 | 0.0261437908496732
2007-07-27 00:00:00 | -0.03773584905660377
2007-07-26 00:00:00 | -0.0124223602484472
2007-07-25 00:00:00 | 0.00625
2007-07-24 00:00:00 | 0.006289308176100629
2007-07-23 00:00:00 | -0.03048780487804878
2007-07-20 00:00:00 | 0.006134969325153374
2007-07-19 00:00:00 | -0.03550295857988166
2007-07-18 00:00:00 | -0.01169590643274854
2007-07-17 00:00:00 | -0.01724137931034483
2007-07-13 00:00:00 | 0.02352941176470588
2007-07-12 00:00:00 | -0.01162790697674419
2007-07-11 00:00:00 | -0.02272727272727273
2007-07-10 00:00:00 | 0.005714285714285714
2007-07-09 00:00:00 | -0.005681818181818182
2007-07-06 00:00:00 | 0.005714285714285714
2007-07-05 00:00:00 | -0.005681818181818182
2007-07-04 00:00:00 | -0.01675977653631285
2007-07-03 00:00:00 | 0.01704545454545454
2007-07-02 00:00:00 | 0.02923976608187134
2007-06-29 00:00:00 | -0.005813953488372093
2007-06-28 00:00:00 | 0.02994011976047904
2007-06-27 00:00:00 | -0.03468208092485549
2007-06-26 00:00:00 | -0.01142857142857143
2007-06-25 00:00:00 | -0.0223463687150838
2007-06-22 00:00:00 | -0.005555555555555556
2007-06-21 00:00:00 | -0.01098901098901099
2007-06-20 00:00:00 | 0.01111111111111111
2007-06-19 00:00:00 | 0.01123595505617977
2007-06-18 00:00:00 | 0.04705882352941176
2007-06-15 00:00:00 | -0.005847953216374269
2007-06-14 00:00:00 | -0.005813953488372093
2007-06-13 00:00:00 | -0.01714285714285714
2007-06-12 00:00:00 | 0.01744186046511628
2007-06-11 00:00:00 | -0.04444444444444445
2007-06-08 00:00:00 | -0.02173913043478261
2007-06-07 00:00:00 | -0.04166666666666666
2007-06-06 00:00:00 | -0.01030927835051546
2007-06-05 00:00:00 | 0.005181347150259068
2007-06-04 00:00:00 | -0.02030456852791878
2007-06-01 00:00:00 | 0
2007-05-31 00:00:00 | 0.02072538860103627
2007-05-30 00:00:00 | -0.005154639175257732
2007-05-29 00:00:00 | -0.005128205128205128
2007-05-28 00:00:00 | 0.01036269430051814
2007-05-25 00:00:00 | -0.02030456852791878
2007-05-24 00:00:00 | 0
2007-05-23 00:00:00 | 0.0154639175257732
2007-05-22 00:00:00 | -0.0202020202020202
2007-05-21 00:00:00 | 0
2007-05-18 00:00:00 | 0.02061855670103093
2007-05-17 00:00:00 | -0.005128205128205128
2007-05-16 00:00:00 | 0
2007-05-15 00:00:00 | 0
2007-05-14 00:00:00 | 0
2007-05-11 00:00:00 | -0.00510204081632653
2007-05-10 00:00:00 | -0.0101010101010101
2007-05-09 00:00:00 | 0.005076142131979695
2007-05-08 00:00:00 | -0.005050505050505051
2007-05-07 00:00:00 | -0.005025125628140704
2007-05-02 00:00:00