Spreadsheet: 81842d1281990062-output-specific-cell-based-on-last-occurrence-of-a-value-test-sheet
Sheet: Raw Data

Note # | Date | Invested | Interest | Principal | Fee | This Fee % | Pay=Int | [NAME] | Made $ | Principal off by
1 | 2009-09-16 00:00:00 | 25 | 0 | 0 | 0 | L:439344 15.65% |  | 25 | -25
2 | 2009-10-09 00:00:00 | 25 | 0 | 0 | 0 | L:445808 14.61% |  | 25 | -25
1 | 2009-10-22 00:00:00 | 0 | 0.32 | 0.55 | 0.01 | 0.03125 | 0.3563218390804597 | 24.45 | -24.14
3 | 2009-11-04 00:00:00 | 75 | 0 | 0 | 0 | L:453516 19.13% |  | 75 | -75
2 | 2009-11-16 00:00:00 | 0 | 0.3 | 0.56 | 0.01 | 0.03333333333333333 | 0.3372093023255813 | 24.44 | -24.15
1 | 2009-11-20 00:00:00 | 0 | 0.32 | 0.55 | 0.01 | 0.03125 | 0.3563218390804597 | 23.9 | -23.28
4 | 2009-12-09 00:00:00 | 25 | 0 | 0 | 0 | L:465537 8.94% |  | 25 | -25
3 | 2009-12-11 00:00:00 | 0 | 1.19 | 1.56 | 0.03 | 0.02521008403361345 | 0.4218181818181818 | 73.44 | -72.28
2 | 2009-12-16 00:00:00 | 0 | 0.3 | 0.56 | 0.01 | 0.03333333333333333 | 0.3372093023255813 | 23.88 | -23.3
1 | 2009-12-22 00:00:00 | 0 | 0.31 | 0.56 | 0.01 | 0.03225806451612903 | 0.3448275862068965 | 23.34 | -22.42000000000001
3 | 2010-01-08 00:00:00 | 0 | 1.17 | 1.58 | 0.03 | 0.02564102564102564 | 0.4145454545454545 | 71.86 | -69.56
5 | 2010-01-13 00:00:00 | 25 | 0 | 0 | 0 | L:475648 12.18% |  | 25 | -25
2 | 2010-01-14 00:00:00 | 0 | 0.29 | 0.57 | 0.01 | 0.03448275862068966 | 0.3255813953488372 | 23.31 | -22.45000000000001
1 | 2010-01-22 00:00:00 | 0 | 0.3 | 0.57 | 0.01 | 0.03333333333333333 | 0.3333333333333334 | 22.77 | -21.56000000000001
4 | 2010-01-22 00:00:00 | 0 | 0.19 | 0.6 | 0.01 | 0.05263157894736842 | 0.2278481012658228 | 24.4 | -24.22
6 | 2010-02-03 00:00:00 | 25 | 0 | 0 | 0 | L:474218 14.96% |  | 25 | -25
3 | 2010-02-10 00:00:00 | 0 | 1.14 | 1.61 | 0.03 | 0.02631578947368421 | 0.4036363636363636 | 70.25 | -66.84
2 | 2010-02-22 00:00:00 | 0 | 0.28 | 0.58 | 0.01 | 0.03571428571428571 | 0.313953488372093 | 22.73 | -21.60000000000001
1 | 2010-02-22 00:00:00 | 0 | 0.3 | 0.57 | 0.01 | 0.03333333333333333 | 0.3333333333333334 | 22.2 | -20.70000000000001 | 0.01
4 | 2010-02-23 00:00:00 | 0 | 0.18 | 0.61 | 0.01 | 0.05555555555555556 | 0.2151898734177215 | 23.79 | -23.44 | 0.01
5 | 2010-03-03 00:00:00 | 0 | 0.25 | 0.58 | 0.01 | 0.04 | 0.2891566265060241 | 24.42 | -24.18
7 | 2010-03-06 00:00:00 | 25 | 0 | 0 | 0 | L:491480 21.64% |  | 25 | -25
3 | 2010-03-10 00:00:00 | 0 | 1.12 | 1.63 | 0.03 | 0.02678571428571428 | 0.3963636363636364 | 68.62 | -64.12
2 | 2010-03-15 00:00:00 | 0 | 0.28 | 0.58 | 0.01 | 0.03571428571428571 | 0.313953488372093 | 22.15000000000001 | -20.75000000000001
6 | 2010-03-16 00:00:00 | 0 | 0.31 | 0.55 | 0.01 | 0.03225806451612903 | 0.3488372093023255 | 24.45 | -24.15
1 | 2010-03-22 00:00:00 | 0 | 0.29 | 0.58 | 0.01 | 0.03448275862068966 | 0.3218390804597701 | 21.62 | -19.84000000000001 | 0.02
4 | 2010-03-23 00:00:00 | 0 | 0.18 | 0.61 | 0.01 | 0.05555555555555556 | 0.2151898734177215 | 23.18 | -22.66 | 0.01
5 | 2010-03-31 00:00:00 | 0 | 0.25 | 0.58 | 0.01 | 0.04 | 0.2891566265060241 | 23.84 | -23.36000000000001
3 | 2010-04-08 00:00:00 | 0 | 1.09 | 1.66 | 0.03 | 0.02752293577981651 | 0.3854545454545455 | 66.96000000000001 | -61.40000000000001
8 | 2010-04-08 00:00:00 | 25 | 0 | 0 | 0 | L:422571 14.59% |  | 50 | -50
2 | 2010-04-15 00:00:00 | 0 | 0.27 | 0.59 | 0.01 | 0.03703703703703703 | 0.3023255813953489 | 21.56000000000001 | -19.90000000000001 | 0.01
6 | 2010-04-15 00:00:00 | 0 | 0.3 | 0.56 | 0.01 | 0.03333333333333333 | 0.3372093023255813 | 23.89 | -23.3
1 | 2010-04-22 00:00:00 | 0 | 0.28 | 0.59 | 0.01 | 0.03571428571428571 | 0.3103448275862069 | 21.03 | -18.98000000000001 | 0.02
4 | 2010-04-22 00:00:00 | 0 | 0.17 | 0.62 | 0.01 | 0.05882352941176471 | 0.2025316455696203 | 22.56 | -21.88 | 0.02
7 | 2010-04-23 00:00:00 | 0 | 0.45 | 0.5 | 0.01 | 0.02222222222222222 | 0.4631578947368421 | 24.5 | -24.06
5 | 2010-04-29 00:00:00 | 0 | 0.24 | 0.59 | 0.01 | 0.04166666666666667 | 0.2771084337349398 | 23.25 | -22.54000000000001
9 | 2010-05-03 00:00:00 | 25 | 0 | 0 | 0 | L:509679 13.85% |  | 25 | -25
3 | 2010-05-10 00:00:00 | 0 | 1.07 | 1.68 | 0.03 | 0.02803738317757009 | 0.3781818181818182 | 65.28 | -58.68000000000001 | 0.01
2 | 2010-05-13 00:00:00 | 0 | 0.26 | 0.6 | 0.01 | 0.03846153846153846 | 0.2906976744186047 | 20.96 | -19.05000000000001 | 0.01
6 | 2010-05-17 00:00:00 | 0 | 0.3 | 0.56 | 0.01 | 0.03333333333333333 | 0.3372093023255813 | 23.33 | -22.45000000000001 | 0.01
1 | 2010-05-20 00:00:00 | 0 | 0.27 | 0.6 | 0.01 | 0.03703703703703703 | 0.2988505747126437 | 20.43 | -18.12000000000001 | 0.02
4 | 2010-05-21 00:00:00 | 0 | 0.17 | 0.62 | 0.01 | 0.05882352941176471 | 0.2025316455696203 | 21.94 | -21.1 | 0.02
7 | 2010-05-25 00:00:00 | 0 | 0.44 | 0.51 | 0.01 | 0.02272727272727273 | 0.4526315789473684 | 23.99 | -23.12
8 | 2010-05-27 00:00:00 | 0 | 0.61 | 1.11 | 0.02 | 0.03278688524590164 | 0.3430232558139534 | 48.89 | -48.3
5 | 2010-06-01 00:00:00 | 0 | 0.24 | 0.59 | 0.01 | 0.04166666666666667 | 0.2771084337349398 | 22.66 | -21.72000000000001 | 0.01
10 | 2010-06-10 00:00:00 | 25 | 0 | 0 | 0 | L:524714 15.58% |  | 25 | -25
3 | 2010-06-10 00:00:00 | 0 | 1.04 | 1.71 | 0.03 | 0.02884615384615384 | 0.3672727272727273 | 63.57 | -55.96000000000001 | 0.01
2 | 2010-06-15 00:00:00 | 0 | 0.25 | 0.61 | 0.01 | 0.04 | 0.2790697674418605 | 20.35 | -18.20000000000001
6 | 2010-06-17 00:00:00 | 0 | 0.29 | 0.57 | 0.01 | 0.03448275862068966 | 0.3255813953488372 | 22.76 | -21.60000000000001 | 0.02
9 | 2010-06-18 00:00:00 | 0 | 0.29 | 0.56 | 0.01 | 0.03448275862068966 | 0.3294117647058823 | 24.44 | -24.16
1 | 2010-06-22 00:00:00 | 0 | 0.26 | 0.61 | 0.01 | 0.03846153846153846 | 0.2873563218390804 | 19.82 | -17.26000000000001 | 0.02
4 | 2010-06-23 00:00:00 | 0 | 0.16 | 0.63 | 0.01 | 0.0625 | 0.189873417721519 | 21.31 | -20.32 | 0.02
7 | 2010-06-24 00:00:00 | 0 | 0.43 | 0.52 | 0.01 | 0.02325581395348837 | 0.4421052631578947 | 23.47 | -22.18
8 | 2010-06-25 00:00:00 | 0 | 0.59 | 1.13 | 0.02 | 0.03389830508474576 | 0.3313953488372093 | 47.76 | -46.6
5 | 2010-07-01 00:00:00 | 0 | 0.23 | 0.6 | 0.01 | 0.04347826086956522 | 0.2650602409638554 | 22.06 | -20.90000000000001 | 0.01
11 | 2010-07-07 00:00:00 | 25 | 0 | 0 | 0 | L:542443 17.93% |  | 50 | -50
3 | 2010-07-09 00:00:00 | 0 | 1.01 | 1.74 | 0.03 | 0.0297029702970297 | 0.3563636363636364 | 61.83 | -53.24000000000001 | 0.01
2 | 2010-07-15 00:00:00 | 0 | 0.25 | 0.61 | 0.01 | 0.04 | 0.2790697674418605 | 19.74000000000001 | -17.35000000000002 | 0.01
6 | 2010-07-15 00:00:00 | 0 | 0.28 | 0.58 | 0.01 | 0.03571428571428571 | 0.313953488372093 | 22.18 | -20.75000000000001 | 0.02
9 | 2010-07-16 00:00:00 | 0 | 0.28 | 0.57 | 0.01 | 0.03571428571428571 | 0.3176470588235294 | 23.87 | -23.32
1 | 2010-07-22 00:00:00 | 0 | 0.26 | 0.61 | 0.01 | 0.03846153846153846 | 0.2873563218390804 | 19.21 | -16.40000000000001 | 0.03
10 | 2010-07-22 00:00:00 | 0 | 0.32 | 0.28 | 0.01 | 0.03125 | 0.5166666666666666 | 24.72 | -24.41
4 | 2010-07-22 00:00:00 | 0 | 0.16 | 0.63 | 0.01 | 0.0625 | 0.189873417721519 | 20.68 | -19.54000000000001 | 0.03
7 | 2010-07-23 00:00:00 | 0 | 0.42 | 0.53 | 0.01 | 0.02380952380952381 | 0.4315789473684211 | 22.94 | -21.24 | 0.01
8 | 2010-07-27 00:00:00 | 0 | 0.58 | 1.14 | 0.02 | 0.03448275862068966 | 0.3255813953488372 | 46.62 | -44.90000000000001 | 0.01
5 | 2010-07-29 00:00:00 | 0 | 0.22 | 0.61 | 0.01 | 0.04545454545454546 | 0.2530120481927711 | 21.45 | -20.08000000000002 | 0.01
12 | 2010-08-02 00:00:00 | 25 | 0 | 0 | 0 | L:554660 18.3% |  | 25 | -25
3 | 2010-08-10 00:00:00 | 0 | 0.98 | 1.77 | 0.03 | 0.03061224489795918 | 0.3454545454545455 | 60.06 | -50.52000000000001 | 0.01
 |  |  |  |  |  |  |  |  |  |  |  | 20.68