Vanguard MM Funds (shared)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGIJKLMOPQRSUVWXYAAAB
1
Days to load ->379Last date loaded ->12/13/201930DateYield C
Prime MM Yield
62DateYield CCA MM TEY45DateYield CMuni MM TEY11DateYield CTreasury MM TEY
2
I believe the largest number of days that can be loaded while still getting
12/3/20182.31%2.31%12/3/20181.49%2.29%12/03/20181.60%2.26%12/3/20182.20%2.47%
3
the most recent data is 365 plus the number of the current day in the month
12/4/20182.32%2.32%12/4/20181.49%2.29%12/04/20181.60%2.26%12/4/20182.21%2.48%
4
minus one, so I have set Days to load with a formula that calculates that:
12/6/20182.32%2.32%12/6/20181.47%2.26%12/06/20181.59%2.25%12/6/20182.21%2.48%
5
=365+DAY(today())-112/7/20182.33%2.33%12/7/20181.47%2.26%12/07/20181.59%2.25%12/7/20182.22%2.49%
6
Set days to load to 0 to prevent loading data; may be useful when editing.
12/10/20182.33%2.33%12/10/20181.46%2.25%12/10/20181.58%2.24%12/10/20182.22%2.49%
7
12/11/20182.33%2.33%12/11/20181.45%2.23%12/11/20181.58%2.24%12/11/20182.23%2.50%
8
12/12/20182.34%2.34%12/12/20181.45%2.23%12/12/20181.57%2.22%12/12/20182.23%2.50%
9
Marginal State Tax Rate8.00%
<- Set to your rate
12/13/20182.34%2.34%12/13/20181.46%2.25%12/13/20181.57%2.22%12/13/20182.24%2.52%
10
Marginal Federal Tax Rate27.00%
<- Set to your rate
12/14/20182.34%2.34%12/14/20181.46%2.25%12/14/20181.57%2.22%12/14/20182.24%2.52%
11
Combined Marginal Rate35.00%
<- Calculated
12/17/20182.35%2.35%12/17/20181.46%2.25%12/17/20181.57%2.22%12/17/20182.25%2.53%
12
12/18/20182.36%2.36%12/18/20181.46%2.25%12/18/20181.57%2.22%12/18/20182.25%2.53%
13
FundFund IDSECTEYRows12/19/20182.36%2.36%12/19/20181.46%2.25%12/19/20181.57%2.22%12/19/20182.25%2.53%
14
Vanguard Prime Money Market301.71%1.71%26012/20/20182.37%2.37%12/20/20181.46%2.25%12/20/20181.57%2.22%12/20/20182.25%2.53%
15
Vanguard CA Muni Money Market620.87%1.34%26012/21/20182.38%2.38%12/21/20181.47%2.26%12/21/20181.58%2.24%12/21/20182.26%2.54%
16
Vanguard Muni Money Market451.04%1.47%26012/24/20182.40%2.40%12/24/20181.48%2.28%12/24/20181.59%2.25%12/24/20182.26%2.54%
17
Vanguard Treasury MM111.61%1.81%26012/26/20182.41%2.41%12/26/20181.49%2.29%12/26/20181.60%2.26%12/26/20182.26%2.54%
18
12/27/20182.41%2.41%12/27/20181.50%2.31%12/27/20181.61%2.28%12/27/20182.27%2.55%
19
12/28/20182.42%2.42%12/28/20181.50%2.31%12/28/20181.61%2.28%12/28/20182.27%2.55%
20
12/31/20182.42%2.42%12/31/20181.50%2.31%12/31/20181.62%2.29%12/31/20182.28%2.56%
21
1/2/20192.43%2.43%1/2/20191.50%2.31%01/02/20191.63%2.31%1/2/20192.29%2.57%
22
1/3/20192.43%2.43%1/3/20191.49%2.29%01/03/20191.62%2.29%1/3/20192.29%2.57%
23
1/4/20192.43%2.43%1/4/20191.47%2.26%01/04/20191.61%2.28%1/4/20192.29%2.57%
24
1/7/20192.44%2.44%1/7/20191.43%2.20%01/07/20191.57%2.22%1/7/20192.30%2.58%
25
1/8/20192.44%2.44%1/8/20191.40%2.15%01/08/20191.56%2.21%1/8/20192.30%2.58%
26
1/9/20192.44%2.44%1/9/20191.38%2.12%01/09/20191.55%2.19%1/9/20192.30%2.58%
27
1/10/20192.44%2.44%1/10/20191.35%2.08%01/10/20191.52%2.15%1/10/20192.30%2.58%
28
1/11/20192.45%2.45%1/11/20191.33%2.05%01/11/20191.50%2.12%1/11/20192.30%2.58%
29
1/14/20192.46%2.46%1/14/20191.25%1.92%01/14/20191.42%2.01%1/14/20192.30%2.58%
30
1/15/20192.46%2.46%1/15/20191.22%1.88%01/15/20191.40%1.98%1/15/20192.30%2.58%
31
1/16/20192.46%2.46%1/16/20191.20%1.85%01/16/20191.38%1.95%1/16/20192.31%2.59%
32
1/17/20192.47%2.47%1/17/20191.19%1.83%01/17/20191.36%1.92%1/17/20192.31%2.59%
33
1/18/20192.47%2.47%1/18/20191.17%1.80%01/18/20191.35%1.91%1/18/20192.31%2.59%
34
1/22/20192.47%2.47%1/22/20191.13%1.74%01/22/20191.30%1.84%1/22/20192.31%2.59%
35
1/23/20192.47%2.47%1/23/20191.14%1.75%01/23/20191.30%1.84%1/23/20192.31%2.59%
36
1/24/20192.47%2.47%1/24/20191.14%1.75%01/24/20191.30%1.84%1/24/20192.31%2.59%
37
1/25/20192.48%2.48%1/25/20191.14%1.75%01/25/20191.30%1.84%1/25/20192.31%2.59%
38
1/28/20192.48%2.48%1/28/20191.16%1.78%01/28/20191.31%1.85%1/28/20192.32%2.61%
39
1/29/20192.48%2.48%1/29/20191.17%1.80%01/29/20191.31%1.85%1/29/20192.32%2.61%
40
1/30/20192.48%2.48%1/30/20191.19%1.83%01/30/20191.32%1.87%1/30/20192.32%2.61%
41
1/31/20192.48%2.48%1/31/20191.21%1.86%01/31/20191.33%1.88%1/31/20192.32%2.61%
42
2/1/20192.48%2.48%2/1/20191.23%1.89%02/01/20191.35%1.91%2/1/20192.32%2.61%
43
2/4/20192.48%2.48%2/4/20191.27%1.95%02/04/20191.39%1.97%2/4/20192.32%2.61%
44
2/5/20192.47%2.47%2/5/20191.28%1.97%02/05/20191.41%2.00%2/5/20192.32%2.61%
45
2/6/20192.47%2.47%2/6/20191.29%1.98%02/06/20191.42%2.01%2/6/20192.32%2.61%
46
2/7/20192.47%2.47%2/7/20191.30%2.00%02/07/20191.43%2.02%2/7/20192.32%2.61%
47
2/8/20192.47%2.47%2/8/20191.30%2.00%02/08/20191.44%2.04%2/8/20192.33%2.62%
48
2/11/20192.47%2.47%2/11/20191.32%2.03%02/11/20191.47%2.08%2/11/20192.33%2.62%
49
2/12/20192.47%2.47%2/12/20191.33%2.05%02/12/20191.48%2.09%2/12/20192.33%2.62%
50
2/13/20192.47%2.47%2/13/20191.35%2.08%02/13/20191.49%2.11%2/13/20192.33%2.62%
51
2/14/20192.47%2.47%2/14/20191.36%2.09%02/14/20191.50%2.12%2/14/20192.33%2.62%
52
2/15/20192.47%2.47%2/15/20191.38%2.12%02/15/20191.52%2.15%2/15/20192.33%2.62%
53
2/19/20192.46%2.46%2/19/20191.46%2.25%02/19/20191.61%2.28%2/19/20192.34%2.63%
54
2/20/20192.46%2.46%2/20/20191.47%2.26%02/20/20191.63%2.31%2/20/20192.34%2.63%
55
2/21/20192.46%2.46%2/21/20191.48%2.28%02/21/20191.65%2.34%2/21/20192.34%2.63%
56
2/22/20192.46%2.46%2/22/20191.48%2.28%02/22/20191.65%2.34%2/22/20192.34%2.63%
57
2/25/20192.46%2.46%2/25/20191.49%2.29%02/25/20191.67%2.36%2/25/20192.34%2.63%
58
2/26/20192.46%2.46%2/26/20191.49%2.29%02/26/20191.67%2.36%2/26/20192.34%2.63%
59
2/27/20192.46%2.46%2/27/20191.49%2.29%02/27/20191.67%2.36%2/27/20192.34%2.63%
60
2/28/20192.46%2.46%2/28/20191.49%2.29%02/28/20191.67%2.36%2/28/20192.35%2.64%
61
3/1/20192.46%2.46%3/1/20191.49%2.29%03/01/20191.67%2.36%3/1/20192.35%2.64%
62
3/4/20192.46%2.46%3/4/20191.49%2.29%03/04/20191.65%2.34%3/4/20192.35%2.64%
63
3/5/20192.46%2.46%3/5/20191.48%2.28%03/05/20191.65%2.34%3/5/20192.35%2.64%
64
3/6/20192.46%2.46%3/6/20191.48%2.28%03/06/20191.64%2.32%3/6/20192.35%2.64%
65
3/7/20192.46%2.46%3/7/20191.47%2.26%03/07/20191.63%2.31%3/7/20192.35%2.64%
66
3/8/20192.46%2.46%3/8/20191.46%2.25%03/08/20191.63%2.31%3/8/20192.35%2.64%
67
3/11/20192.45%2.45%3/11/20191.44%2.22%03/11/20191.61%2.28%3/11/20192.35%2.64%
68
3/12/20192.45%2.45%3/12/20191.43%2.20%03/12/20191.60%2.26%3/12/20192.35%2.64%
69
3/13/20192.45%2.45%3/13/20191.43%2.20%03/13/20191.59%2.25%3/13/20192.35%2.64%
70
3/14/20192.45%2.45%3/14/20191.43%2.20%03/14/20191.58%2.24%3/14/20192.35%2.64%
71
3/15/20192.45%2.45%3/15/20191.42%2.18%03/15/20191.58%2.24%3/15/20192.35%2.64%
72
3/18/20192.45%2.45%3/18/20191.41%2.17%03/18/20191.55%2.19%3/18/20192.35%2.64%
73
3/19/20192.45%2.45%3/19/20191.41%2.17%03/19/20191.55%2.19%3/19/20192.35%2.64%
74
3/20/20192.45%2.45%3/20/20191.40%2.15%03/20/20191.54%2.18%3/20/20192.36%2.65%
75
3/21/20192.45%2.45%3/21/20191.40%2.15%03/21/20191.53%2.17%3/21/20192.36%2.65%
76
3/22/20192.45%2.45%3/22/20191.39%2.14%03/22/20191.53%2.17%3/22/20192.36%2.65%
77
3/25/20192.45%2.45%3/25/20191.38%2.12%03/25/20191.50%2.12%3/25/20192.36%2.65%
78
3/26/20192.45%2.45%3/26/20191.37%2.11%03/26/20191.49%2.11%3/26/20192.36%2.65%
79
3/27/20192.45%2.45%3/27/20191.36%2.09%03/27/20191.49%2.11%3/27/20192.36%2.65%
80
3/28/20192.46%2.46%3/28/20191.36%2.09%03/28/20191.49%2.11%3/28/20192.36%2.65%
81
3/29/20192.46%2.46%3/29/20191.36%2.09%03/29/20191.48%2.09%3/29/20192.36%2.65%
82
4/1/20192.46%2.46%4/1/20191.36%2.09%04/01/20191.48%2.09%4/1/20192.36%2.65%
83
4/2/20192.46%2.46%4/2/20191.35%2.08%04/02/20191.47%2.08%4/2/20192.36%2.65%
84
4/3/20192.46%2.46%4/3/20191.35%2.08%04/03/20191.47%2.08%4/3/20192.36%2.65%
85
4/4/20192.45%2.45%4/4/20191.34%2.06%4/4/20191.47%2.08%4/4/20192.36%2.65%
86
4/5/20192.45%2.45%4/5/20191.34%2.06%4/5/20191.46%2.07%4/5/20192.36%2.65%
87
4/8/20192.45%2.45%4/8/20191.33%2.05%4/8/20191.45%2.05%4/8/20192.35%2.64%
88
4/9/20192.45%2.45%4/9/20191.33%2.05%4/9/20191.45%2.05%4/9/20192.35%2.64%
89
4/10/20192.45%2.45%4/10/20191.33%2.05%4/10/20191.45%2.05%4/10/20192.35%2.64%
90
4/11/20192.45%2.45%4/11/20191.34%2.06%4/11/20191.46%2.07%4/11/20192.35%2.64%
91
4/12/20192.45%2.45%4/12/20191.35%2.08%4/12/20191.47%2.08%4/12/20192.35%2.64%
92
4/15/20192.45%2.45%4/15/20191.38%2.12%4/15/20191.49%2.11%4/15/20192.35%2.64%
93
4/16/20192.45%2.45%4/16/20191.40%2.15%4/16/20191.50%2.12%4/16/20192.35%2.64%
94
4/17/20192.45%2.45%4/17/20191.42%2.18%4/17/20191.52%2.15%4/17/20192.35%2.64%
95
4/18/20192.45%2.45%4/18/20191.47%2.26%4/18/20191.57%2.22%4/18/20192.35%2.64%
96
4/22/20192.44%2.44%4/22/20191.65%2.54%4/22/20191.77%2.51%4/22/20192.35%2.64%
97
4/23/20192.44%2.44%4/23/20191.69%2.60%4/23/20191.82%2.58%4/23/20192.35%2.64%
98
4/24/20192.44%2.44%4/24/20191.73%2.66%4/24/20191.87%2.65%4/24/20192.35%2.64%
99
4/25/20192.44%2.44%4/25/20191.75%2.69%4/25/20191.90%2.69%4/25/20192.35%2.64%
100
4/26/20192.44%2.44%4/26/20191.78%2.74%4/26/20191.92%2.72%4/26/20192.35%2.64%
Loading...