how to calculate weekly and monthly percentage returns from daily figures

Hi Crooza,

Am having a few PC gliches as well as nodding off . Age. Your offer is .... huge. I feel guilty about it, considering how helpful the code you sent already has been. In fact I borrowed two excel beginner books today cos I'd like to understand it and be able to make charts etc.

If you're busy or otherwise occupied plse say so and I'll complete it in my plodding way. I'm not letting 'em off the hook as they cost me sleep and dollars with their false advertising and I'm gonna prove it using their own data.

I'll try upload.....

FRI 1/07/2011 0
SAT 2/07/2011 -0.0011
SUN 3/07/2011 -0.0011
MON 4/07/2011 0
TUE 5/07/2011 -0.1477
WED 6/07/2011 0.1474
THU 7/07/2011 0.1039
FRI 8/07/2011 0.0575
SAT 9/07/2011 -0.0011
SUN 10/07/2011 -0.0011
MON 11/07/2011 -0.0244
TUE 12/07/2011 0.0758
WED 13/07/2011 0.3606
THU 14/07/2011 0.3895
FRI 15/07/2011 -0.0348
SAT 16/07/2011 -0.0011
SUN 17/07/2011 -0.0011
MON 18/07/2011 0.0503
TUE 19/07/2011 0.0975
WED 20/07/2011 0.0732
THU 21/07/2011 0.0275
FRI 22/07/2011 -0.1733
SAT 23/07/2011 -0.0011
SUN 24/07/2011 -0.0011
MON 25/07/2011 -0.032
TUE 26/07/2011 0.0499
WED 27/07/2011 0.1295
THU 28/07/2011 -0.0142
FRI 29/07/2011 -0.0947
SAT 30/07/2011 -0.0011
SUN 31/07/2011 -0.0011
MON 1/08/2011 0.1506
TUE 2/08/2011 0.3857
WED 3/08/2011 0.0801
THU 4/08/2011 0.2252
FRI 5/08/2011 0.3624
SAT 6/08/2011 -0.0011
SUN 7/08/2011 -0.0011
MON 8/08/2011 -0.1103
TUE 9/08/2011 0.5186
WED 10/08/2011 -0.1453
THU 11/08/2011 0.0481
FRI 12/08/2011 0.0794
SAT 13/08/2011 -0.0011
SUN 14/08/2011 -0.0011
MON 15/08/2011 0.0623
TUE 16/08/2011 0.0954
WED 17/08/2011 -0.2847
THU 18/08/2011 0.1565
FRI 19/08/2011 0.1253
SAT 20/08/2011 -0.0011
SUN 21/08/2011 -0.0011
MON 22/08/2011 0.3522
TUE 23/08/2011 0.2383
WED 24/08/2011 -0.0804
THU 25/08/2011 -0.3908
FRI 26/08/2011 -0.0542
SAT 27/08/2011 0.3108
SUN 28/08/2011 -0.0011
MON 29/08/2011 -0.1042
TUE 30/08/2011 0.0619
WED 31/08/2011 -0.0807
THU 1/09/2011 0.1046
FRI 2/09/2011 0.0227
SAT 3/09/2011 -0.0011
SUN 4/09/2011 -0.0011
MON 5/09/2011 0.0227
TUE 6/09/2011 0.1752
WED 7/09/2011 0.4187
THU 8/09/2011 0.0462
FRI 9/09/2011 -0.2938
SAT 10/09/2011 -0.0011
SUN 11/09/2011 -0.0011
MON 12/09/2011 0.2475
TUE 13/09/2011 0.0417
WED 14/09/2011 0.3082
THU 15/09/2011 -0.1217
FRI 16/09/2011 0.1186
SAT 17/09/2011 -0.0011
SUN 18/09/2011 -0.0011
MON 19/09/2011 -0.205
TUE 20/09/2011 -0.138
WED 21/09/2011 0.3231
THU 22/09/2011 -0.0109
FRI 23/09/2011 -0.0655
SAT 24/09/2011 -0.1632
SUN 25/09/2011 -0.0011
MON 26/09/2011 0.3376
TUE 27/09/2011 0.0164
WED 28/09/2011 -0.0434
THU 29/09/2011 -0.5036
FRI 30/09/2011 -0.1216
SAT 1/10/2011 -0.0011
SUN 2/10/2011 -0.0011
MON 3/10/2011 0.0838
TUE 4/10/2011 0.1506
WED 5/10/2011 0.1546
THU 6/10/2011 0.4909
FRI 7/10/2011 -0.2766
SAT 8/10/2011 -0.0011
SUN 9/10/2011 -0.0011
MON 10/10/2011 -0.2256
TUE 11/10/2011 -0.1614
WED 12/10/2011 -0.1263
THU 13/10/2011 -0.1314
FRI 14/10/2011 -0.0135
SAT 15/10/2011 -0.0011
SUN 16/10/2011 -0.0011
MON 17/10/2011 -0.2436
TUE 18/10/2011 0.0333
WED 19/10/2011 -0.1408
THU 20/10/2011 0.2489
FRI 21/10/2011 -0.0148
SAT 22/10/2011 -0.0011
SUN 23/10/2011 -0.0011
MON 24/10/2011 0.1091
TUE 25/10/2011 -0.1369
WED 26/10/2011 -0.0119
THU 27/10/2011 0.1271
FRI 28/10/2011 0.3359
SAT 29/10/2011 0.0316
SUN 30/10/2011 -0.0011
MON 31/10/2011 -0.3706
TUE 1/11/2011 -0.0311
WED 2/11/2011 0.2605
THU 3/11/2011 0.388
FRI 4/11/2011 0.2881
SAT 5/11/2011 -0.0011
SUN 6/11/2011 -0.0011
MON 7/11/2011 0.0287
TUE 8/11/2011 -0.1368
WED 9/11/2011 0.1479
THU 10/11/2011 0.0952
FRI 11/11/2011 -0.0227
SAT 12/11/2011 -0.0011
SUN 13/11/2011 -0.0011
MON 14/11/2011 0.2339
TUE 15/11/2011 -0.1106
WED 16/11/2011 -0.1618
THU 17/11/2011 0.2312
FRI 18/11/2011 0.1543
SAT 19/11/2011 -0.0011
SUN 20/11/2011 -0.0011
MON 21/11/2011 -0.1262
TUE 22/11/2011 0.0636
WED 23/11/2011 -0.109
THU 24/11/2011 0.1262
FRI 25/11/2011 0.0991
SAT 26/11/2011 -0.0473
SUN 27/11/2011 -0.0011
MON 28/11/2011 0.0073
TUE 29/11/2011 -0.069
WED 30/11/2011 0.0255
THU 1/12/2011 -0.1696
FRI 2/12/2011 0.0729
SAT 3/12/2011 -0.0011
SUN 4/12/2011 -0.0011
MON 5/12/2011 -0.0633
TUE 6/12/2011 0.1306
WED 7/12/2011 0.2021
THU 8/12/2011 0.149
FRI 9/12/2011 -0.0754
SAT 10/12/2011 -0.0011
SUN 11/12/2011 -0.0011
MON 12/12/2011 0.0698
TUE 13/12/2011 0.1535
WED 14/12/2011 -0.108
THU 15/12/2011 0.1555
FRI 16/12/2011 -0.0058
SAT 17/12/2011 -0.0011
SUN 18/12/2011 -0.0011
MON 19/12/2011 0.2288
TUE 20/12/2011 -0.071
WED 21/12/2011 0.1644
THU 22/12/2011 -0.0338
FRI 23/12/2011 -0.1625
SAT 24/12/2011 0.0037
SUN 25/12/2011 -0.0011
MON 26/12/2011 0.0774
TUE 27/12/2011 -0.0307
WED 28/12/2011 -0.0011
THU 29/12/2011 -0.0011
FRI 30/12/2011 0.0536
SAT 31/12/2011 -0.0011
SUN 1/01/2012 -0.0011
MON 2/01/2012 0.1579
TUE 3/01/2012 0.0916
WED 4/01/2012 -0.0011
THU 5/01/2012 -0.3414
FRI 6/01/2012 0.0923
SAT 7/01/2012 -0.0011
SUN 8/01/2012 -0.0011
MON 9/01/2012 0.0886
TUE 10/01/2012 0.0668
WED 11/01/2012 0.1814
THU 12/01/2012 -0.092
FRI 13/01/2012 0.0713
SAT 14/01/2012 -0.0011
SUN 15/01/2012 -0.0011
MON 16/01/2012 0.0843
TUE 17/01/2012 -0.1015
WED 18/01/2012 0.3867
THU 19/01/2012 -0.2172
FRI 20/01/2012 0.045
SAT 21/01/2012 -0.0011
SUN 22/01/2012 -0.0011
MON 23/01/2012 -0.0011
TUE 24/01/2012 -0.2064
WED 25/01/2012 -0.0833
THU 26/01/2012 -0.0684
FRI 27/01/2012 -0.1723
SAT 28/01/2012 0.0715
SUN 29/01/2012 -0.0011
MON 30/01/2012 0.1237
TUE 31/01/2012 0.3944
WED 1/02/2012 0.2319
THU 2/02/2012 0.1557
FRI 3/02/2012 0.0838
SAT 4/02/2012 -0.0011
SUN 5/02/2012 -0.0011
MON 6/02/2012 -0.0286
TUE 7/02/2012 -0.0477
WED 8/02/2012 -0.139
THU 9/02/2012 -0.2505
FRI 10/02/2012 -0.0324
SAT 11/02/2012 -0.001121
SUN 12/02/2012 -0.001121
MON 13/02/2012 -0.120729
TUE 14/02/2012 0.164872
WED 15/02/2012 -0.030884
THU 16/02/2012 0.13322
FRI 17/02/2012 -0.056972
SAT 18/02/2012 -0.001121
SUN 19/02/2012 -0.001121
MON 20/02/2012 0.154083
TUE 21/02/2012 -0.233337
WED 22/02/2012 -0.119283
THU 23/02/2012 0.127704
FRI 24/02/2012 0.086555
SAT 25/02/2012 0.003306
SUN 26/02/2012 -0.001121
MON 27/02/2012 0.14644
TUE 28/02/2012 -0.085195
WED 29/02/2012 0.20593
THU 1/03/2012 0.141861
FRI 2/03/2012 0.000112
SAT 3/03/2012 -0.001121
SUN 4/03/2012 -0.001121
MON 5/03/2012 -0.151867
TUE 6/03/2012 -0.038684
WED 7/03/2012 0.13839
THU 8/03/2012 0.102081
FRI 9/03/2012 0.118105
SAT 10/03/2012 -0.001121
SUN 11/03/2012 -0.001121
MON 12/03/2012 0.041568
TUE 13/03/2012 -0.119212
WED 14/03/2012 0.215295
THU 15/03/2012 -0.071844
FRI 16/03/2012 -0.370832
SAT 17/03/2012 -0.001121
SUN 18/03/2012 -0.001121
MON 19/03/2012 -0.432316
TUE 20/03/2012 0.075894
WED 21/03/2012 -0.047505
THU 22/03/2012 0.033265
FRI 23/03/2012 0.055839
SAT 24/03/2012 0.114663
SUN 25/03/2012 -0.001121
MON 26/03/2012 0.127527
TUE 27/03/2012 0.109361
WED 28/03/2012 0.033913
THU 29/03/2012 0.102543
FRI 30/03/2012 0.181065
SAT 31/03/2012 -0.001121
SUN 1/04/2012 -0.001121
MON 2/04/2012 0.208447
TUE 3/04/2012 0.052962
WED 4/04/2012 -0.069294
THU 5/04/2012 0.110487
FRI 6/04/2012 -0.074827
SAT 7/04/2012 -0.001121
SUN 8/04/2012 -0.001121
MON 9/04/2012 0.056125
TUE 10/04/2012 -0.001121
WED 11/04/2012 -0.001121
THU 12/04/2012 0.48547
FRI 13/04/2012 -0.057534
SAT 14/04/2012 -0.001121
SUN 15/04/2012 -0.001121
MON 16/04/2012 -0.053079
TUE 17/04/2012 0.232889
WED 18/04/2012 0.082957
THU 19/04/2012 -0.013575
FRI 20/04/2012 -0.081567
SAT 21/04/2012 -0.001121
SUN 22/04/2012 -0.001121
MON 23/04/2012 0.068844
TUE 24/04/2012 -0.032086
WED 25/04/2012 0.203505
THU 26/04/2012 0.122012
FRI 27/04/2012 0.005521
SAT 28/04/2012 0.090316
SUN 29/04/2012 -0.001121
MON 30/04/2012 -0.062657
TUE 1/05/2012 0.178361
WED 2/05/2012 0.009708
THU 3/05/2012 0.366735
FRI 4/05/2012 -0.12354
SAT 5/05/2012 -0.001121
SUN 6/05/2012 -0.001121
MON 7/05/2012 0.201643
TUE 8/05/2012 0.104886
WED 9/05/2012 0.339094
THU 10/05/2012 0.020779
FRI 11/05/2012 0.08647
SAT 12/05/2012 -0.001121
SUN 13/05/2012 -0.001121
MON 14/05/2012 -0.027697
TUE 15/05/2012 0.158237
WED 16/05/2012 0.071883
THU 17/05/2012 0.021225
FRI 18/05/2012 0.04215
SAT 19/05/2012 -0.001121
SUN 20/05/2012 -0.001121
MON 21/05/2012 -0.054506
TUE 22/05/2012 0.317253
WED 23/05/2012 -0.181027
THU 24/05/2012 -0.138233
FRI 25/05/2012 0.197213
SAT 26/05/2012 -0.066257
SUN 27/05/2012 -0.001121
MON 28/05/2012 0.050966
TUE 29/05/2012 -0.033819
WED 30/05/2012 -0.030741
THU 31/05/2012 0.136072
FRI 1/06/2012 0.294679
SAT 2/06/2012 -0.001121
SUN 3/06/2012 -0.001121
MON 4/06/2012 0.38891
TUE 5/06/2012 0.230844
WED 6/06/2012 0.054997
THU 7/06/2012 -0.416563
FRI 8/06/2012 -0.179626
SAT 9/06/2012 -0.001121
SUN 10/06/2012 -0.001121
MON 11/06/2012 -0.157827
TUE 12/06/2012 0.153879
WED 13/06/2012 0.042331
THU 14/06/2012 -0.018781
FRI 15/06/2012 -0.164334
SAT 16/06/2012 -0.001121
SUN 17/06/2012 -0.001121
MON 18/06/2012 0.268691
TUE 19/06/2012 0.008593
WED 20/06/2012 -0.134899
THU 21/06/2012 0.172356
FRI 22/06/2012 -0.294506
SAT 23/06/2012 0.04916
SUN 24/06/2012 -0.001121
MON 25/06/2012 0.020007
TUE 26/06/2012 0.135073
WED 27/06/2012 0.149953
THU 28/06/2012 0.092747
FRI 29/06/2012 -0.092216
SAT 30/06/2012 -0.552221
SUN 1/07/2012 0
MON 2/07/2012 0
TUE 3/07/2012 0
WED 4/07/2012 0.025417
THU 5/07/2012 -0.001672
FRI 6/07/2012 -0.065355
SAT 7/07/2012 -0.001203
SUN 8/07/2012 -0.001203
MON 9/07/2012 0.259243
TUE 10/07/2012 0.038867
WED 11/07/2012 0.221651
THU 12/07/2012 0.095505
FRI 13/07/2012 0.042338
SAT 14/07/2012 -0.001203
SUN 15/07/2012 -0.001203
MON 16/07/2012 0.304163
TUE 17/07/2012 0.026897
WED 18/07/2012 0.016163
THU 19/07/2012 0.018437
FRI 20/07/2012 0.075977
SAT 21/07/2012 -0.001203
SUN 22/07/2012 -0.001203
MON 23/07/2012 -0.013506
TUE 24/07/2012 0.100641
WED 25/07/2012 0.280603
THU 26/07/2012 -0.074188
FRI 27/07/2012 0.069525
SAT 28/07/2012 -0.001203
SUN 29/07/2012 -0.001203
MON 30/07/2012 -0.065498
TUE 31/07/2012 -0.48564
WED 1/08/2012 -0.15696
THU 2/08/2012 0.117483
FRI 3/08/2012 -0.084002
SAT 4/08/2012 -0.001203
SUN 5/08/2012 -0.001203
MON 6/08/2012 0.015616
TUE 7/08/2012 -0.006755
WED 8/08/2012 0.087702
THU 9/08/2012 -0.374236
FRI 10/08/2012 -0.084318
SAT 11/08/2012 -0.001203
SUN 12/08/2012 -0.001203
MON 13/08/2012 -0.039113
TUE 14/08/2012 0.254427
WED 15/08/2012 -0.018201
THU 16/08/2012 -0.153537
FRI 17/08/2012 -0.198095
SAT 18/08/2012 -0.001203
SUN 19/08/2012 -0.001203
MON 20/08/2012 -0.22315
TUE 21/08/2012 0.066478
WED 22/08/2012 0.074659
THU 23/08/2012 -0.004697
FRI 24/08/2012 0.247648
SAT 25/08/2012 0.017703
SUN 26/08/2012 -0.001203
MON 27/08/2012 0.246227
TUE 28/08/2012 0.062324
WED 29/08/2012 0.129701
THU 30/08/2012 0.042312
FRI 31/08/2012 0.00969
SAT 1/09/2012 -0.001203
SUN 2/09/2012 -0.001203
MON 3/09/2012 0.203334
TUE 4/09/2012 0.137346
WED 5/09/2012 0.041208
THU 6/09/2012 -0.004191
FRI 7/09/2012 0.122405
SAT 8/09/2012 -0.001203
SUN 9/09/2012 -0.001203
MON 10/09/2012 -0.198554
TUE 11/09/2012 -0.123308
WED 12/09/2012 0.173723
THU 13/09/2012 0.028262
FRI 14/09/2012 -0.170169
SAT 15/09/2012 -0.001203
SUN 16/09/2012 -0.001203
MON 17/09/2012 -0.006516
TUE 18/09/2012 -0.120234
WED 19/09/2012 -0.182615
THU 20/09/2012 0.253684
FRI 21/09/2012 0.031656
SAT 22/09/2012 -0.001203
SUN 23/09/2012 -0.001203
MON 24/09/2012 0.309936
TUE 25/09/2012 -0.132963
WED 26/09/2012 0.187307
THU 27/09/2012 0.10392
FRI 28/09/2012 0.21333
SAT 29/09/2012 0.016791
SUN 30/09/2012 -0.001203
MON 1/10/2012 0.060958
TUE 2/10/2012 0.125291
WED 3/10/2012 0.026145
THU 4/10/2012 0.128299
FRI 5/10/2012 0.15422
SAT 6/10/2012 -0.001203
SUN 7/10/2012 -0.001203
MON 8/10/2012 -0.109087
TUE 9/10/2012 -0.135921
WED 10/10/2012 -0.019718
THU 11/10/2012 0.040616
FRI 12/10/2012 -0.008828
SAT 13/10/2012 -0.001203
SUN 14/10/2012 -0.001203
MON 15/10/2012 0.163797
TUE 16/10/2012 0.052983
WED 17/10/2012 0.059192
THU 18/10/2012 -0.069063
FRI 19/10/2012 -0.245312
SAT 20/10/2012 -0.001203
SUN 21/10/2012 -0.001203
MON 22/10/2012 -0.213427
TUE 23/10/2012 0.144087
WED 24/10/2012 0.053691
THU 25/10/2012 -0.078728
FRI 26/10/2012 -0.020334
SAT 27/10/2012 0.018259
SUN 28/10/2012 -0.001203
MON 29/10/2012 -0.128934
TUE 30/10/2012 0.118607
WED 31/10/2012 0.177704
THU 1/11/2012 0.100851
FRI 2/11/2012 0.03491
SAT 3/11/2012 -0.001203
SUN 4/11/2012 -0.001203
MON 5/11/2012 0.017796
TUE 6/11/2012 -0.135697
WED 7/11/2012 0.081279
THU 8/11/2012 -0.117721
FRI 9/11/2012 0.089767
SAT 10/11/2012 -0.001203
SUN 11/11/2012 -0.001203
MON 12/11/2012 0.094857
TUE 13/11/2012 0.097471
WED 14/11/2012 0.058333
THU 15/11/2012 0.05208
FRI 16/11/2012 -0.02792
SAT 17/11/2012 -0.001203
SUN 18/11/2012 -0.001203
MON 19/11/2012 0.080775
TUE 20/11/2012 -0.010525
WED 21/11/2012 -0.094417
THU 22/11/2012 -0.17152
FRI 23/11/2012 -0.080367
SAT 24/11/2012 0.136708
SUN 25/11/2012 -0.001203
MON 26/11/2012 -0.103432
TUE 27/11/2012 -0.078593
WED 28/11/2012 0.107474
THU 29/11/2012 -0.035926
FRI 30/11/2012 0.183555
SAT 1/12/2012 0.019504
SUN 2/12/2012 -0.001203
MON 3/12/2012 0.01676
TUE 4/12/2012 0.177282
WED 5/12/2012 0.069148
THU 6/12/2012 -0.039458
FRI 7/12/2012 0.017797
SAT 8/12/2012 -0.001203
SUN 9/12/2012 -0.001203
MON 10/12/2012 0.152156
TUE 11/12/2012 -0.023155
WED 12/12/2012 -0.058452
THU 13/12/2012 0.061212
FRI 14/12/2012 -0.204735
SAT 15/12/2012 -0.001203
SUN 16/12/2012 -0.001203
MON 17/12/2012 -0.165803
TUE 18/12/2012 -0.125793
WED 19/12/2012 0.031584
THU 20/12/2012 -0.089571
FRI 21/12/2012 0.02088
SAT 22/12/2012 -0.001203
SUN 23/12/2012 -0.001203
MON 24/12/2012 0.095933
TUE 25/12/2012 0.139761
WED 26/12/2012 -0.028873
THU 27/12/2012 -0.001203
FRI 28/12/2012 -0.001203
SAT 29/12/2012 -0.117312
SUN 30/12/2012 -0.001203
MON 31/12/2012 0.079447