Well, this seems to have worked. This is the example that
shows both Split SAFE and use of the "vealies" with Am.
Century's Ultra Fund. The columns aren't arranged the same
as Mr. L's, but you should be able to follow all the calcs.
Note that the Buy/Sell Advice and Market Order columns are
far to the right.
ACTUAL ACTUAL
ORDER ORDER
DATE SHARES PRICE EQUITY CASH TOTAL VALUE SHARES % CASH SAFE P. C. B/S ADV MKT ORDER
Jan-82 1670 4.550 7600 2400 10000 0 0 24 608 7600 0 0
Feb-82 1670 4.410 7366 2410 9776 0 0 25 0 7600 234 234
Mar-82 1670 3.850 6431 2420 8851 1,169 304 27 0 7600 1169 1169
Apr-82 1974 4.480 8845 1261 10106 0 0 12 708 8185 -660 0
May-82 1974 4.450 8786 1266 10052 0 0 13 703 8185 -601 0
Jun-82 1974 3.950 7799 1271 9070 0 0 14 0 8185 386 386
Jul-82 1974 4.190 8272 1277 9549 0 0 13 662 8185 -88 0
Aug-82 1974 3.670 7246 1282 8528 939 256 15 0 8185 939 939
Sep-82 2230 4.640 10349 349 10697 (867) -187 3 828 8654 -1695 -867
Oct-82 2043 5.140 10503 1217 11719 0 0 10 840 7345 -3158 -2317
Nov-82 2043 6.000 12260 1222 13482 (626) -104 9 981 7887 -4373 -3392
Dec-82 1939 6.270 12160 1853 14013 0 0 13 973 8374 -3786 -2813
Jan-83 1939 6.990 13556 1861 15417 (676) -97 12 1084 8788 -4768 -3683
Feb-83 1842 7.500 13817 2544 16362 0 0 16 1105 9359 -4458 -3353
Mar-83 1842 7.670 14131 2555 16686 0 0 15 1130 9757 -4374 -3243
Apr-83 1842 8.220 15144 2566 17710 (4,175) -508 14 1212 9757 -5387 -4175
May-83 1334 9.200 12276 6752 19028 0 0 35 982 9757 -2519 -1537
Jun-83 1334 10.540 14064 6780 20844 (1,151) -109 33 1125 10617 -3447 -2322
Jul-83 1225 9.650 11824 7959 19784 0 0 40 946 10617 -1207 -261
Aug-83 1225 9.200 11273 7992 19265 0 0 41 902 10617 -656 0
Sep-83 1225 9.330 11432 8026 19458 0 0 41 915 10617 -815 0
Oct-83 1225 8.950 10967 8059 19026 0 0 42 877 10617 -350 0
Nov-83 1225 8.580 10513 8093 18606 0 0 43 0 10617 104 104
Dec-83 1225 8.120 9950 8126 18076 667 82 45 0 10617 667 667
Jan-84 1307 8.140 10642 7493 18135 0 39 41 0 10951 309 309
Feb-84 1346 6.420 8643 7524 16167 2,308 359 47 0 10951 2308 2308
Mar-84 1705 6.670 11374 5248 16622 730 109 32 0 12104 730 730
Apr-84 1814 6.250 11339 4540 15879 1,130 181 29 0 12469 1130 1130
May-84 1995 6.240 12451 3428 15879 584 94 22 0 13035 584 584
Jun-84 2089 6.120 12786 2859 15645 540 88 18 0 13327 540 540
Jul-84 2177 6.180 13456 2330 15786 0 0 15 0 13597 141 141
Aug-84 2177 6.910 15045 2340 17385 0 0 13 1204 13597 -1448 -245
Sep-84 2177 6.920 15067 2350 17417 0 0 13 1205 13597 -1470 -265
Oct-84 2177 6.450 14043 2360 16403 0 0 14 1123 13597 -447 0
Nov-84 2177 6.290 13695 2369 16065 0 0 15 1096 13597 -98 0
Dec-84 2177 6.140 13369 2379 15748 0 0 15 0 13597 228 228
Jan-85 2177 6.770 14740 2389 17129 0 0 14 1179 13597 -1144 0
Feb-85 2177 7.450 16221 2399 18620 (1,326) -178 13 1298 13597 -2624 -1326
Mar-85 1999 7.020 14035 3736 17771 0 0 21 1123 13597 -438 0
Apr-85 1999 7.060 14115 3751 17866 0 0 21 1129 13597 -518 0
May-85 1999 7.450 14895 3767 18661 0 0 20 1192 13597 -1298 -106
Jun-85 1999 7.270 14535 3782 18317 0 0 21 1163 13597 -938 0
Jul-85 1999 7.610 15215 3798 19013 0 0 20 1217 13597 -1618 -401
Aug-85 1999 7.230 14455 3814 18269 0 0 21 1156 13597 -858 0
Sep-85 1999 6.950 13895 3830 17725 0 0 22 1112 13597 -298 0
Oct-85 1999 7.200 14395 3846 18241 0 0 21 1152 13597 -798 0
Nov-85 1999 7.550 15095 3862 18957 0 0 20 1208 13597 -1498 -290
Dec-85 1999 8.140 16274 3878 20152 (1,376) -169 19 1302 13597 -2677 -1376
Jan-86 1830 8.010 14661 5270 19930 0 0 26 1173 13597 -1064 0
Feb-86 1830 8.750 16015 5292 21307 (1,137) -130 25 1281 13597 -2418 -1137
Mar-86 1700 9.510 16170 6451 22621 (1,279) -135 29 1294 13597 -2573 -1279
Apr-86 1565 10.210 15982 7757 23739 (1,106) -108 33 1279 13597 -2385 -1106
May-86 1457 9.550 13917 8896 22813 0 0 39 1113 13597 -320 0
Jun-86 1457 10.070 14675 8933 23608 0 0 38 1174 13597 -1078 0
Jul-86 1457 9.130 13305 8970 22275 0 0 40 0 13597 292 292
Aug-86 1457 9.400 13698 9007 22706 0 0 40 1096 13597 -102 0
Sep-86 1457 7.910 11527 9045 20572 2,070 262 44 0 13597 2070 2070
Oct-86 1719 8.730 15009 7013 22022 0 0 32 1201 14631 -378 0
Nov-86 1719 8.970 15422 7042 22464 0 0 31 1234 14631 -790 0
Dec-86 1719 9.090 15628 7072 22700 0 0 31 1250 14631 -997 0
Jan-87 1719 10.560 18156 7101 25257 (2,072) -196 28 1452 14631 -3524 -2072
Feb-87 1523 12.340 18797 9202 28000 (875) -71 33 1504 15830 -2967 -1464
Mar-87 1452 12.490 18139 10116 28255 (858) -69 36 1451 15830 -2309 -858
Apr-87 1383 12.480 17263 11016 28279 0 0 39 1381 15830 -1433 -52
May-87 1383 13.330 18439 11062 29501 0 0 37 1475 16415 -2024 -549
Jun-87 1383 12.610 17443 11108 28551 0 0 39 1395 16415 -1028 0
Jul-87 1383 12.440 17208 11154 28362 0 0 39 1377 16415 -793 0
Aug-87 1383 13.060 18066 11201 29266 0 0 38 1445 16415 -1651 -205
Sep-87 1383 12.640 17485 11247 28732 0 0 39 1399 16415 -1070 0
Oct-87 1383 11.480 15880 11294 27174 535 47 42 0 16415 535 535
Nov-87 1430 8.390 12000 10806 22806 4,682 1051 47 0 16682 4682 4682
Dec-87 2482 6.190 15362 6169 21531 3,662 592 29 0 19024 3662 3662
Jan-88 3074 6.110 18780 2533 21313 594 97 12 0 20855 2074 2074
Feb-88 3171 6.340 20102 1949 22051 0 0 9 0 21152 1049 1049
Mar-88 3171 7.160 22702 1957 24660 0 0 8 1816 21152 -1551 0
Apr-88 3171 7.060 22385 1966 24351 0 0 8 1791 21152 -1234 0
May-88 3171 7.040 22322 1974 24295 0 0 8 1786 21152 -1170 0
Jun-88 3171 7.480 23717 1982 25699 (668) -89 8 1897 21152 -2565 -668
Jul-88 3082 7.500 23113 2658 25771 0 0 10 1849 21152 -1961 -112
Aug-88 3082 6.650 20493 2669 23162 658 99 12 0 21152 658 658
Sep-88 3181 6.940 22074 2022 24096 0 0 8 1766 21481 -593 0
Oct-88 3181 7.060 22456 2030 24486 0 0 8 1796 21481 -975 0
Nov-88 3181 6.500 20675 2039 22713 0 0 9 0 21481 806 806
Dec-88 3181 6.880 21883 2047 23931 0 0 9 1751 21481 -402 0
Jan-89 3181 7.270 23124 2056 25180 0 0 8 1850 21481 -1643 0
Feb-89 3181 7.960 25318 2064 27383 (1,812) -228 8 2025 21481 -3838 -1812
Mar-89 2953 8.110 23946 3885 27832 (550) -68 14 1916 21481 -2466 -550
Apr-89 2885 8.660 24981 4451 29433 (1,502) -173 15 1999 21481 -3501 -1502
May-89 2712 9.260 25110 5972 31082 (1,621) -175 19 2009 21481 -3630 -1621
Jun-89 2537 9.210 23363 7618 30981 0 0 25 1869 21481 -1882 -13
Jul-89 2537 9.880 25063 7649 32712 (1,577) -160 23 2005 21481 -3582 -1577
Aug-89 2377 10.130 24076 9258 33334 (669) -66 28 1926 21481 -2595 -669
Sep-89 2311 10.530 24332 9966 34297 (904) -86 29 1947 21481 -2851 -904
Oct-89 2225 9.910 22047 10912 32958 0 0 33 1764 21481 -566 0
Nov-89 2225 9.750 21691 10957 32648 0 0 34 1735 21481 -210 0
Dec-89 2225 8.570 19066 11003 30068 2,415 553 37 0 21481 2415 2415
Jan-90 2778 8.050 22362 8634 30996 0 0 28 0 22688 326 326
Feb-90 2778 8.020 22279 8670 30949 0 0 28 0 22688 409 409
Mar-90 2778 8.080 22446 8706 31151 0 0 28 0 22688 242 242
Apr-90 2778 8.300 23057 8742 31799 0 0 27 1845 22688 -369 0
May-90 2778 7.830 21751 8778 30530 937 120 29 0 22688 937 937
Jun-90 2898 9.250 26806 7878 34684 (1,505) -163 23 2144 23157 -3649 -1505
Jul-90 2735 10.040 27459 9416 36874 (2,105) -210 26 2197 23157 -4302 -2105
Aug-90 2525 7.640 19291 11560 30851 3,866 506 37 0 23157 3866 3866
Sep-90 3031 8.640 26187 7742 33930 0 0 23 2095 25090 -1098 0
Oct-90 3031 7.100 21520 7774 29294 3,570 503 27 0 25090 3570 3570
Nov-90 3534 8.350 29508 4237 33745 0 0 13 2361 26875 -2634 -273
Dec-90 3534 9.060 32018 4254 36272 (2,581) -285 12 2561 26875 -5143 -2581
Jan-91 3249 10.590 34406 6853 41260 (4,779) -451 17 2753 26875 -7531 -4779
Feb-91 2798 11.370 31813 11661 43473 0 0 27 2545 28020 -3793 -1248
Mar-91 2798 12.630 35338 11709 47047 0 0 25 2827 30234 -5104 -2277
Apr-91 2798 13.640 38164 11758 49922 (3,366) -247 24 3053 30955 -7209 -4156
May-91 2551 13.170 33596 15173 48769 0 0 31 2688 30955 -2641 0
Jun-91 2551 12.130 30943 15236 46179 0 0 33 0 30955 12 12
Jul-91 2551 13.730 35024 15300 50324 0 0 30 2802 31855 -3169 -368
Aug-91 2551 14.470 36912 15364 52276 0 0 29 2953 32721 -4191 -1238
Sep-91 2551 14.970 38188 15428 53615 0 0 29 3055 33890 -4298 -1243
Oct-91 2551 14.360 36632 15492 52123 0 0 30 2931 33890 -2742 0
Nov-91 2551 16.220 41376 15556 56933 (2,051) -126 27 3310 34912 -6464 -3154
Dec-91 2425 17.340 42049 17672 59721 0 0 30 3364 36755 -5294 -1930
Jan-92 2425 18.680 45298 17746 63044 0 0 28 3624 39169 -6129 -2505
Feb-92 2425 16.920 41030 17820 58850 0 0 30 3282 39169 -1861 0
Mar-92 2425 16.520 40060 17894 57954 0 0 31 3205 39169 -891 0
Apr-92 2425 15.460 37490 17969 55458 1,679 109 32 0 39169 1679 1679
May-92 2534 14.710 37274 16364 53638 2,734 186 31 0 40009 2734 2734
Jun-92 2720 13.780 37481 13698 51179 3,895 283 27 0 41376 3895 3895
Jul-92 3003 14.360 43122 9860 52982 0 0 19 0 43323 201 201
Aug-92 3003 14.730 44233 9901 54134 0 0 18 3539 43323 -910 0
Sep-92 3003 15.560 46726 9942 56668 0 0 18 3738 43323 -3402 0
Oct-92 3003 15.390 46215 9984 56199 0 0 18 3697 43323 -2892 0
Nov-92 3003 16.420 49308 10025 59334 (2,040) -124 17 3945 43323 -5985 -2040
Dec-92 2879 17.560 50554 12107 62662 (3,187) -181 19 4044 43323 -7231 -3187
Jan-93 2698 18.360 49534 15344 64879 (2,248) -122 24 3963 43323 -6211 -2248
Feb-93 2576 16.040 41318 17656 58975 2,005 125 30 0 43323 2005 2005
Mar-93 2701 17.340 46834 15725 62559 0 0 25 3747 44326 -2508 0
Apr-93 2701 16.800 45376 15790 61166 0 0 26 3630 44326 -1050 0
May-93 2701 19.740 53317 15856 69173 (4,725) -239 23 4265 44326 -8991 -4725
Jun-93 2462 19.990 49214 20648 69862 (951) -48 30 3937 44326 -4888 -951
Jul-93 2414 20.270 48931 21685 70615 0 0 31 3914 44755 -4176 -261
Aug-93 2414 20.950 50572 21775 72347 0 0 30 4046 45685 -4887 -841
Sep-93 2414 21.440 51755 21866 73621 (1,930) -90 30 4140 45685 -6070 -1930
Oct-93 2324 22.800 52986 23886 76872 0 0 31 4239 47222 -5764 -1525
Nov-93 2324 19.750 45898 23986 69884 1,324 67 34 0 47222 1324 1324
Dec-93 2391 21.080 50401 22762 73163 0 0 31 4032 47884 -2517 0
Jan-94 2391 22.820 54561 22857 77418 (2,312) -101 30 4365 47884 -6677 -2312
Feb-94 2290 22.420 51341 25264 76605 0 0 33 4107 47884 -3457 0
Mar-94 2290 21.930 50218 25370 75588 0 0 34 4017 47884 -2334 0
Apr-94 2290 19.790 45318 25475 70793 2,566 130 36 0 47884 2566 2566
May-94 2420 20.670 50020 23015 73036 0 0 32 4002 49167 -853 0
Jun-94 2420 19.620 47479 23111 70591 1,688 86 33 0 49167 1688 1688
Jul-94 2506 20.030 50194 21520 71714 0 0 30 4016 50011 -183 0
Aug-94 2506 20.370 51046 21609 72656 0 0 30 4084 50011 -1035 0
Sep-94 2506 20.490 51347 21700 73046 0 0 30 4108 50011 -1336 0
Oct-94 2506 19.920 49918 21790 71708 0 0 30 0 50011 93 93
Nov-94 2506 19.860 49768 21881 71649 0 0 31 0 50011 243 243
Dec-94 2506 19.530 48941 21972 70913 1,070 55 31 0 50011 1070 1070
Jan-95 2561 20.100 51475 20994 72469 0 0 29 4118 50546 -929 0
Feb-95 2561 20.400 52243 21081 73324 0 0 29 4179 50546 -1697 0
Mar-95 2561 20.670 52935 21169 74104 0 0 29 4235 50546 -2389 0
Apr-95 2561 20.550 52627 21257 73885 0 0 29 4210 50546 -2082 0
May-95 2561 21.890 56059 21346 77405 0 0 28 4485 51054 -5005 -520
Jun-95 2561 23.160 59311 21435 80746 (3,513) -152 27 4745 51054 -8257 -3513
Jul-95 2409 26.080 62825 25036 87862 0 0 28 5026 54434 -8391 -3365
Aug-95 2409 26.430 63668 25141 88809 0 0 28 5093 56512 -7156 -2063
Sep-95 2409 28.510 68679 25246 93925 (3,193) -112 27 5494 58259 -10420 -4926
Oct-95 2297 26.600 61099 28544 89642 0 0 32 4888 58259 -2840 0
Nov-95 2297 29.050 66726 28663 95389 0 0 30 5338 59832 -6894 -1556
Dec-95 2416 25.000 60408 28782 89190 0 0 32 4833 59832 -576 0
Jan-96 2416 24.180 58426 28902 87328 1,406 58 33 0 59832 1406 1406
Feb-96 2474 27.560 68192 27617 95808 0 0 29 5455 61628 -6564 -1108
Mar-96 2474 26.280 65025 27732 92756 0 0 30 5202 61628 -3397 0
Apr-96 2474 25.850 63961 27847 91808 0 0 30 5117 61628 -2333 0
May-96 2474 28.670 70938 27963 98902 (3,635) -127 28 5675 61628 -9310 -3635
Jun-96 2347 29.070 68236 31715 99951 (1,149) -40 32 5459 61628 -6608 -1149
Jul-96 2307 26.330 60751 32996 93748 877 33 35 0 61628 877 877
Aug-96 2340 26.840 62814 32257 95071 0 0 34 5025 62066 -747 0
Sep-96 2340 26.510 62041 32392 94433 0 0 34 0 62066 25 25
Oct-96 2340 29.930 70045 32526 102572 0 0 32 5604 63259 -6786 -1183
Nov-96 2340 30.480 71332 32662 103994 0 0 31 5707 64452 -6880 -1174
Dec-96 2477 28.980 71771 32798 104569 (1,578) -54 31 5742 64452 -7319 -1578
Jan-97 2423 29.350 71103 34512 105615 (962) -33 33 5688 64452 -6651 -962
Feb-97 2390 30.520 72930 35619 108548 0 0 33 5834 65769 -7161 -1327
Mar-97 2390 29.720 71018 35767 106785 0 0 33 5681 65769 -5249 0
Apr-97 2390 27.230 65068 35916 100984 701 26 36 0 65769 701 701
May-97 2416 30.800 74400 35365 109765 0 0 32 5952 67281 -7119 -1167
Jun-97 2416 31.350 75728 35512 111241 0 0 32 6058 68471 -7257 -1199
Jul-97 2416 34.670 83748 35660 119408 (5,886) -170 30 6700 69813 -13935 -7235
Aug-97 2246 35.600 79943 41695 121637 0 0 34 6395 71676 -8267 -1871
Sep-97 2246 34.820 78191 41869 120060 0 0 35 6255 71676 -6515 -260
Oct-97 2246 36.790 82615 42043 124658 (4,330) -118 34 6609 71676 -10939 -4330
Nov-97 2128 33.970 72274 46548 118822 0 0 39 5782 71676 -598 0
Dec-97 2695 26.540 71538 46742 118280 0 0 40 0 71676 138 138
Jan-98 2695 26.150 70487 46936 117423 1,189 45 40 0 71676 1189 1189
Feb-98 2740 28.560 78268 45943 124211 0 0 37 6261 72271 -5998 0
Mar-98 2740 30.140 82598 46134 128732 0 0 36 6608 74137 -8461 -1853
Apr-98 2740 32.110 87997 46327 134323 0 0 34 7040 77561 -10436 -3396
May-98 2740 32.450 88929 46520 135448 (4,253) -131 34 7114 77561 -11368 -4253
Jun-98 2609 31.120 81207 50967 132174 0 0 39 6497 77561 -3646 0
Jul-98 2609 36.300 94724 51179 145903 0 0 35 7578 82352 -12372 -4794
Aug-98 2609 32.060 83660 51392 135052 0 0 38 6693 82352 -1308 0
Sep-98 2609 30.050 78415 51607 130021 3,937 131 40 0 82352 3937 3937
Oct-98 2740 28.070 76925 47885 124810 7,395 263 38 0 84321 7395 7395
Nov-98 3003 31.880 95751 40689 136440 0 0 30 7660 88018 -7733 -73
Dec-98 3302 31.370 103596 40858 144455 0 0 28 8288 96295 -7301 0
Jan-99 3302 34.210 112975 41029 154004 (7,642) -223 27 9038 96295 -16680 -7642
You'll see there are times when there's Market Orders in
the far right column but no order has been placed in the
ACTUAL ORDER columns. This is when "vealies" occurred.
Also note that I used 0.0% SAFE for buying and 8% SAFE for
the sell side. You'll note that in buys that the Buy/Sell
Advice and the Market Order value is the same because of
this.
Once in a while, usually in December, you'll find an
increase in the # of shares without an order. These are the
shares that were "reinvested" from distribution of capital
gains and income.
Hope this helps you to figure everything out!!!
Best regards, Tom |
