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 ->390Last date loaded ->1/24/202030DateYield 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
1/2/20192.43%2.43%1/2/20191.50%2.31%01/02/20191.63%2.31%1/2/20192.29%2.57%
3
the most recent data is 365 plus the number of the current day in the month
1/3/20192.43%2.43%1/3/20191.49%2.29%01/03/20191.62%2.29%1/3/20192.29%2.57%
4
minus one, so I have set Days to load with a formula that calculates that:
1/4/20192.43%2.43%1/4/20191.47%2.26%01/04/20191.61%2.28%1/4/20192.29%2.57%
5
=365+DAY(today())-11/7/20192.44%2.44%1/7/20191.43%2.20%01/07/20191.57%2.22%1/7/20192.30%2.58%
6
Set days to load to 0 to prevent loading data; may be useful when editing.
1/8/20192.44%2.44%1/8/20191.40%2.15%01/08/20191.56%2.21%1/8/20192.30%2.58%
7
1/9/20192.44%2.44%1/9/20191.38%2.12%01/09/20191.55%2.19%1/9/20192.30%2.58%
8
1/10/20192.44%2.44%1/10/20191.35%2.08%01/10/20191.52%2.15%1/10/20192.30%2.58%
9
Marginal State Tax Rate8.00%
<- Set to your rate
1/11/20192.45%2.45%1/11/20191.33%2.05%01/11/20191.50%2.12%1/11/20192.30%2.58%
10
Marginal Federal Tax Rate27.00%
<- Set to your rate
1/14/20192.46%2.46%1/14/20191.25%1.92%01/14/20191.42%2.01%1/14/20192.30%2.58%
11
Combined Marginal Rate35.00%
<- Calculated
1/15/20192.46%2.46%1/15/20191.22%1.88%01/15/20191.40%1.98%1/15/20192.30%2.58%
12
1/16/20192.46%2.46%1/16/20191.20%1.85%01/16/20191.38%1.95%1/16/20192.31%2.59%
13
FundFund IDSECTEYRows1/17/20192.47%2.47%1/17/20191.19%1.83%01/17/20191.36%1.92%1/17/20192.31%2.59%
14
Vanguard Prime Money Market301.67%1.67%2681/18/20192.47%2.47%1/18/20191.17%1.80%01/18/20191.35%1.91%1/18/20192.31%2.59%
15
Vanguard CA Muni Money Market620.71%1.09%2681/22/20192.47%2.47%1/22/20191.13%1.74%01/22/20191.30%1.84%1/22/20192.31%2.59%
16
Vanguard Muni Money Market450.82%1.16%2681/23/20192.47%2.47%1/23/20191.14%1.75%01/23/20191.30%1.84%1/23/20192.31%2.59%
17
Vanguard Treasury MM111.53%1.72%2681/24/20192.47%2.47%1/24/20191.14%1.75%01/24/20191.30%1.84%1/24/20192.31%2.59%
18
1/25/20192.48%2.48%1/25/20191.14%1.75%01/25/20191.30%1.84%1/25/20192.31%2.59%
19
1/28/20192.48%2.48%1/28/20191.16%1.78%01/28/20191.31%1.85%1/28/20192.32%2.61%
20
1/29/20192.48%2.48%1/29/20191.17%1.80%01/29/20191.31%1.85%1/29/20192.32%2.61%
21
1/30/20192.48%2.48%1/30/20191.19%1.83%01/30/20191.32%1.87%1/30/20192.32%2.61%
22
1/31/20192.48%2.48%1/31/20191.21%1.86%01/31/20191.33%1.88%1/31/20192.32%2.61%
23
2/1/20192.48%2.48%2/1/20191.23%1.89%02/01/20191.35%1.91%2/1/20192.32%2.61%
24
2/4/20192.48%2.48%2/4/20191.27%1.95%02/04/20191.39%1.97%2/4/20192.32%2.61%
25
2/5/20192.47%2.47%2/5/20191.28%1.97%02/05/20191.41%2.00%2/5/20192.32%2.61%
26
2/6/20192.47%2.47%2/6/20191.29%1.98%02/06/20191.42%2.01%2/6/20192.32%2.61%
27
2/7/20192.47%2.47%2/7/20191.30%2.00%02/07/20191.43%2.02%2/7/20192.32%2.61%
28
2/8/20192.47%2.47%2/8/20191.30%2.00%02/08/20191.44%2.04%2/8/20192.33%2.62%
29
2/11/20192.47%2.47%2/11/20191.32%2.03%02/11/20191.47%2.08%2/11/20192.33%2.62%
30
2/12/20192.47%2.47%2/12/20191.33%2.05%02/12/20191.48%2.09%2/12/20192.33%2.62%
31
2/13/20192.47%2.47%2/13/20191.35%2.08%02/13/20191.49%2.11%2/13/20192.33%2.62%
32
2/14/20192.47%2.47%2/14/20191.36%2.09%02/14/20191.50%2.12%2/14/20192.33%2.62%
33
2/15/20192.47%2.47%2/15/20191.38%2.12%02/15/20191.52%2.15%2/15/20192.33%2.62%
34
2/19/20192.46%2.46%2/19/20191.46%2.25%02/19/20191.61%2.28%2/19/20192.34%2.63%
35
2/20/20192.46%2.46%2/20/20191.47%2.26%02/20/20191.63%2.31%2/20/20192.34%2.63%
36
2/21/20192.46%2.46%2/21/20191.48%2.28%02/21/20191.65%2.34%2/21/20192.34%2.63%
37
2/22/20192.46%2.46%2/22/20191.48%2.28%02/22/20191.65%2.34%2/22/20192.34%2.63%
38
2/25/20192.46%2.46%2/25/20191.49%2.29%02/25/20191.67%2.36%2/25/20192.34%2.63%
39
2/26/20192.46%2.46%2/26/20191.49%2.29%02/26/20191.67%2.36%2/26/20192.34%2.63%
40
2/27/20192.46%2.46%2/27/20191.49%2.29%02/27/20191.67%2.36%2/27/20192.34%2.63%
41
2/28/20192.46%2.46%2/28/20191.49%2.29%02/28/20191.67%2.36%2/28/20192.35%2.64%
42
3/1/20192.46%2.46%3/1/20191.49%2.29%03/01/20191.67%2.36%3/1/20192.35%2.64%
43
3/4/20192.46%2.46%3/4/20191.49%2.29%03/04/20191.65%2.34%3/4/20192.35%2.64%
44
3/5/20192.46%2.46%3/5/20191.48%2.28%03/05/20191.65%2.34%3/5/20192.35%2.64%
45
3/6/20192.46%2.46%3/6/20191.48%2.28%03/06/20191.64%2.32%3/6/20192.35%2.64%
46
3/7/20192.46%2.46%3/7/20191.47%2.26%03/07/20191.63%2.31%3/7/20192.35%2.64%
47
3/8/20192.46%2.46%3/8/20191.46%2.25%03/08/20191.63%2.31%3/8/20192.35%2.64%
48
3/11/20192.45%2.45%3/11/20191.44%2.22%03/11/20191.61%2.28%3/11/20192.35%2.64%
49
3/12/20192.45%2.45%3/12/20191.43%2.20%03/12/20191.60%2.26%3/12/20192.35%2.64%
50
3/13/20192.45%2.45%3/13/20191.43%2.20%03/13/20191.59%2.25%3/13/20192.35%2.64%
51
3/14/20192.45%2.45%3/14/20191.43%2.20%03/14/20191.58%2.24%3/14/20192.35%2.64%
52
3/15/20192.45%2.45%3/15/20191.42%2.18%03/15/20191.58%2.24%3/15/20192.35%2.64%
53
3/18/20192.45%2.45%3/18/20191.41%2.17%03/18/20191.55%2.19%3/18/20192.35%2.64%
54
3/19/20192.45%2.45%3/19/20191.41%2.17%03/19/20191.55%2.19%3/19/20192.35%2.64%
55
3/20/20192.45%2.45%3/20/20191.40%2.15%03/20/20191.54%2.18%3/20/20192.36%2.65%
56
3/21/20192.45%2.45%3/21/20191.40%2.15%03/21/20191.53%2.17%3/21/20192.36%2.65%
57
3/22/20192.45%2.45%3/22/20191.39%2.14%03/22/20191.53%2.17%3/22/20192.36%2.65%
58
3/25/20192.45%2.45%3/25/20191.38%2.12%03/25/20191.50%2.12%3/25/20192.36%2.65%
59
3/26/20192.45%2.45%3/26/20191.37%2.11%03/26/20191.49%2.11%3/26/20192.36%2.65%
60
3/27/20192.45%2.45%3/27/20191.36%2.09%03/27/20191.49%2.11%3/27/20192.36%2.65%
61
3/28/20192.46%2.46%3/28/20191.36%2.09%03/28/20191.49%2.11%3/28/20192.36%2.65%
62
3/29/20192.46%2.46%3/29/20191.36%2.09%03/29/20191.48%2.09%3/29/20192.36%2.65%
63
4/1/20192.46%2.46%4/1/20191.36%2.09%04/01/20191.48%2.09%4/1/20192.36%2.65%
64
4/2/20192.46%2.46%4/2/20191.35%2.08%04/02/20191.47%2.08%4/2/20192.36%2.65%
65
4/3/20192.46%2.46%4/3/20191.35%2.08%04/03/20191.47%2.08%4/3/20192.36%2.65%
66
4/4/20192.45%2.45%4/4/20191.34%2.06%04/04/20191.47%2.08%4/4/20192.36%2.65%
67
4/5/20192.45%2.45%4/5/20191.34%2.06%04/05/20191.46%2.07%4/5/20192.36%2.65%
68
4/8/20192.45%2.45%4/8/20191.33%2.05%04/08/20191.45%2.05%4/8/20192.35%2.64%
69
4/9/20192.45%2.45%4/9/20191.33%2.05%04/09/20191.45%2.05%4/9/20192.35%2.64%
70
4/10/20192.45%2.45%4/10/20191.33%2.05%04/10/20191.45%2.05%4/10/20192.35%2.64%
71
4/11/20192.45%2.45%4/11/20191.34%2.06%04/11/20191.46%2.07%4/11/20192.35%2.64%
72
4/12/20192.45%2.45%4/12/20191.35%2.08%04/12/20191.47%2.08%4/12/20192.35%2.64%
73
4/15/20192.45%2.45%4/15/20191.38%2.12%04/15/20191.49%2.11%4/15/20192.35%2.64%
74
4/16/20192.45%2.45%4/16/20191.40%2.15%04/16/20191.50%2.12%4/16/20192.35%2.64%
75
4/17/20192.45%2.45%4/17/20191.42%2.18%04/17/20191.52%2.15%4/17/20192.35%2.64%
76
4/18/20192.45%2.45%4/18/20191.47%2.26%04/18/20191.57%2.22%4/18/20192.35%2.64%
77
4/22/20192.44%2.44%4/22/20191.65%2.54%04/22/20191.77%2.51%4/22/20192.35%2.64%
78
4/23/20192.44%2.44%4/23/20191.69%2.60%04/23/20191.82%2.58%4/23/20192.35%2.64%
79
4/24/20192.44%2.44%4/24/20191.73%2.66%04/24/20191.87%2.65%4/24/20192.35%2.64%
80
4/25/20192.44%2.44%4/25/20191.75%2.69%04/25/20191.90%2.69%4/25/20192.35%2.64%
81
4/26/20192.44%2.44%4/26/20191.78%2.74%04/26/20191.92%2.72%4/26/20192.35%2.64%
82
4/29/20192.44%2.44%4/29/20191.86%2.86%04/29/20192.01%2.84%4/29/20192.35%2.64%
83
4/30/20192.44%2.44%4/30/20191.88%2.89%04/30/20192.03%2.87%4/30/20192.35%2.64%
84
5/1/20192.44%2.44%5/1/20191.90%2.92%05/01/20192.05%2.90%5/1/20192.35%2.64%
85
5/2/20192.44%2.44%5/2/20191.88%2.89%5/2/20192.03%2.87%5/2/20192.35%2.64%
86
5/3/20192.44%2.44%5/3/20191.86%2.86%5/3/20192.02%2.86%5/3/20192.35%2.64%
87
5/6/20192.44%2.44%5/6/20191.79%2.75%5/6/20191.96%2.77%5/6/20192.35%2.64%
88
5/7/20192.44%2.44%5/7/20191.76%2.71%5/7/20191.95%2.76%5/7/20192.34%2.63%
89
5/8/20192.44%2.44%5/8/20191.73%2.66%5/8/20191.92%2.72%5/8/20192.34%2.63%
90
5/9/20192.43%2.43%5/9/20191.68%2.58%5/9/20191.86%2.63%5/9/20192.34%2.63%
91
5/10/20192.43%2.43%5/10/20191.62%2.49%5/10/20191.80%2.55%5/10/20192.34%2.63%
92
5/13/20192.43%2.43%5/13/20191.46%2.25%5/13/20191.63%2.31%5/13/20192.34%2.63%
93
5/14/20192.43%2.43%5/14/20191.41%2.17%5/14/20191.57%2.22%5/14/20192.34%2.63%
94
5/15/20192.42%2.42%5/15/20191.36%2.09%5/15/20191.52%2.15%5/15/20192.35%2.64%
95
5/16/20192.42%2.42%5/16/20191.34%2.06%5/16/20191.49%2.11%5/16/20192.35%2.64%
96
5/17/20192.42%2.42%5/17/20191.31%2.02%5/17/20191.47%2.08%5/17/20192.35%2.64%
97
5/20/20192.42%2.42%5/20/20191.24%1.91%5/20/20191.40%1.98%5/20/20192.35%2.64%
98
5/21/20192.42%2.42%5/21/20191.21%1.86%5/21/20191.37%1.94%5/21/20192.35%2.64%
99
5/22/20192.41%2.41%5/22/20191.20%1.85%5/22/20191.35%1.91%5/22/20192.35%2.64%
100
5/23/20192.41%2.41%5/23/20191.19%1.83%5/23/20191.35%1.91%5/23/20192.34%2.63%
Loading...