Copy of Fund Distribution v1.8.2
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Edit only outlined cells
DuringFrom:01/01/00To:12/31/00Days:260Today:6/2/2020Return-57.22%GreedyAdd
2
Ticker[/Bench]
Time
Change
Price
Intraday
LowAvgHiMedReturnValueER% Mod% Cat% TotalSharesTotal$4,496TRUE$1,000
3
AllocActualEnableGoalAddSharesTickerPriceValue
4
TOT US0.00%
<--------->
23.00%$3845.09VTSAX$75.29$0
5
GE#N/A4.29%$7.05$41.71$51.82$60.00$52.02-4.12%$169100.00%100.00%3.76%24.000TOT INT84.68%
<--------->
15.00%$0VTIAX$25.94$3,807
6
CA MUNI3.76%
<--------->
30.00%$33227.26VCAIX$12.16$169
7
MUNI11.56%
<--------->
10.00%$0VTEB$53.81$520
8
CORP B0.00%
<--------->
15.00%$25111.29VSCSX$22.23$0
9
GNMA0.00%5.00%$0$0
10
MATS0.00%
<--------->
2.00%$340.28VAW$121.95$0
11
0.00%
<--------->
$0$0
12
0.00%
<--------->
$0$0
13
0.00%
<--------->
$0$0
14
-4.12%$1690.00%
<--------->
$0$0
15
TOTAL100%100.00%$1,000$4,496
16
17
18
MSFT#N/A1.14%$184.91$20.75$38.10$58.28$35.25-62.78%$3,80787.99%100.00%84.68%20.590
19
20
CSCO#N/A1.27%$46.89$36.50$60.56$80.25$62.67-29.34%$52012.01%100.00%11.56%11.084
21
22
23
24
25
26
27
28
-58.77%$4,327
29
30
31
32
33
34
35
36
37
38
39
40
41
42
0.00%$0
43
44
45
46
47
48
49
50
51
52
53
54
55
56
0.00%$0
57
58
59
60
61
62
63
64
65
66
67
68
69
70
0.00%$0
71
72
73
Changes in 1.1
74
Added ability to select from a greedy algorithm (always gives to the largest percentage difference calculated on each pass) or $1 minimum distribution (gives a minimum of $1 on each pass)
75
Fixed an issue where each stock module was calculating it's local percentage incorrectly.
76
Fixed an issue where the last dollar was not distributed all the way throughout the funds
77
Added a header on mutual funds that suggests that you can add a benchmark. The benchmark controls the EOD column -- This allows one to monitor progress on mutual funds throughout the trade day.
78
Changes in 1.1.1
79
Improved greedy algorithm to distribute based on relative ratio of actual to goal -- Larger lump sum additions now work better with lower percentage goals
80
Changes in 1.1.1a
81
Only show EOD price until 2:59pm
82
Changes in 1.1.2
83
Added another couple rows to each module
84
Changes in 1.2
85
Refactored distribution code to be a object oriented and a bit more functional
86
Fixed an issue in the non-greedy algorithm which caused the minimum amount to be added to securities over goal on a pass
87
Added some comments on the distribution api
88
Fixed a rounding error with the non-greedy algorithm which resulted in lower funds added by a slight amount
89
Improved performance of both greedy and non greedy algorithms
90
Greedy and non-greedy algorithm now increases on each pass by the max of 1 and amountToAdd * percentFromGoal
91
Fixed an issue where the greedy algorithm wasn't properly distributing to goal with larger numbers
92
Changes in 1.2.1a
93
Fixed an issue where not all cells were being added to the percent total for both goal and actual
94
Added another row to each module
95
Added outlines to each cell that can be edited manually
96
Changes in 1.2.1b
97
Added return percentage for date range specified on all securities
98
Fixed a bug with percent within module on the last three modules
99
Changes in 1.2.2
100
Updated return formula to support weekends and holidays
Loading...