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
#N/AFrom:3/4/2019To:12/6/2019Days:200Today:
12/8/2019
Return7.43%GreedyAdd
2
Ticker[/Bench]
Time
Change
Price
Intraday
LowAvgHiMedReturnValueER% Mod% Cat% TotalSharesTotal$114TRUE$1,000
3
VTSAX/VTI#N/A0.91%$78.01$68.36$72.92$78.22$72.6510.52%$340.04%30.10%100.00%29.43%0.430AllocActualEnableGoalAddSharesTickerPriceValue
4
VTIAX/VXUS#N/A0.76%$29.22$26.39$28.02$29.24$28.124.17%$180.11%15.81%100.00%15.46%0.604TOT US29.43%
<--------->
23.00%$2723.49VTSAX$78.01$34
5
VCAIX/PWZ#N/A-0.08%$12.08$11.70$12.00$12.22$12.033.33%$300.19%27.02%100.00%26.43%2.496TOT INT15.46%
<--------->
15.00%$1505.13VTIAX$29.22$18
6
VTEB#N/A-0.06%$53.47$51.39$53.02$54.17$53.214.07%$109.18%100.00%8.98%0.192CA MUNI26.43%
<--------->
30.00%$30425.14VCAIX$12.08$30
7
VSCSX/VCSH#N/A-0.05%$22.02$21.45$21.87$22.11$21.932.70%$150.07%13.53%100.00%13.23%0.686MUNI8.98%
<--------->
10.00%$1011.89VTEB$53.47$10
8
VFIIX#N/A-0.09%$10.56$10.27$10.47$10.60$10.502.92%$50.21%4.36%100.00%4.27%0.461CORP B13.23%
<--------->
15.00%$1536.93VSCSX$22.02$15
9
GNMA4.27%5.00%$0$5
10
MATS2.21%
<--------->
2.00%$210.16VAW$131.38$3
11
0.00%
<--------->
$0$0
12
0.00%
<--------->
$0$0
13
0.00%
<--------->
$0$0
14
5.59%$1120.00%
<--------->
$0$0
15
TOTAL100%100.00%$1,000$114
16
17
VTI#N/A0.89%$160.29$140.41$149.84$160.74$149.2910.53%
18
VXUS#N/A0.85%$54.48$49.02$52.21$54.47$52.424.39%
19
PWZ#N/A0.08%$27.33$25.80$26.95$27.69$27.015.77%
20
21
VCSH#N/A-0.05%$80.91$78.87$80.39$81.30$80.632.64%
22
VIPSX#N/A-0.08%$13.31$12.61$13.13$13.55$13.195.55%0.20%0.08%
23
VAW#N/A0.90%$131.38$115.16$125.25$131.93$125.665.24%$3100.00%100.00%2.21%0.019
24
25
26
#N/A
27
28
5.24%$3
29
30
31
CSLT#N/A0.00%$1.32$1.24$2.52$4.00$2.88-66.67%
32
33
34
35
36
37
38
39
40
41
42
0.00%$0
43
44
45
46
47
48
49
50
VTAPX/VTIP#N/A0.04%$24.74$24.22$24.63$24.89$24.662.11%0.06%
51
52
53
54
55
56
0.00%$0
57
58
59
60
61
62
63
64
VFITX#N/A-0.18%$11.37$10.91$11.29$11.60$11.324.40%0.20%
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...