Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
iShares TIPS ETF vs Vanguard T...
by
thefinancebuff
414 views
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
iShares TIPS ETF vs Vanguard TIPS Fund
Copyright: Explore Bonds
This spreadsheet compares the portfolio holdings of a TIPS ETF and a TIPS mutual fund:
iShares Barclays TIPS Bond ETF (TIP) and Vanguard Inflation Protected Securities (VIPSX).
For more information, see
TIPS ETFs
% of Fund Portfolio
Maturity
Coupon
TIP (6/30/2009)
Vanguard (6/30/2009)
2011-01-15
3.500%
2.7%
1.4%
2011-04-15
2.375%
4.1%
3.4%
2012-01-15
3.375%
1.7%
1.9%
2012-04-15
2.000%
2.9%
0.0%
2012-07-15
3.000%
6.1%
6.7%
2013-04-15
0.625%
2.8%
0.0%
2013-07-15
1.875%
5.0%
5.1%
2014-01-15
2.000%
5.3%
8.4%
2014-04-15
1.250%
1.7%
2.9%
2014-07-15
2.000%
4.8%
3.9%
2015-01-15
1.625%
4.5%
6.5%
2015-07-15
1.875%
4.1%
5.8%
2016-01-15
2.000%
4.0%
3.9%
2016-07-15
2.500%
4.3%
3.3%
2017-01-15
2.375%
3.6%
4.2%
2017-07-15
2.625%
2.7%
5.3%
2018-01-15
1.625%
2.8%
3.1%
2018-07-15
1.375%
2.6%
2.8%
2019-01-15
2.125%
3.1%
1.2%
2025-01-15
2.375%
6.2%
8.5%
2026-01-15
2.000%
3.9%
6.2%
2027-01-15
2.375%
3.3%
5.9%
2028-01-15
1.750%
2.8%
2.8%
2028-04-15
3.625%
5.2%
3.2%
2029-01-15
2.500%
1.8%
1.5%
2029-04-15
3.875%
5.7%
2.1%
2032-04-15
3.375%
1.6%
0.0%
Total
99%
100%
iShares
Vanguard
iShares - Vanguard
< 5 Years
32%
30%
3%
5 - 10 Years
37%
40%
-3%
> 10 Years
31%
30%
1%
Source:
Holdings data retrieved from iShares and Vanguard web site on 8/2/2009.
Holdings
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More