Percentages of REITs present in Vanguard index funds

The Excel 2007 file used to create this table is available for download below.

The Vanguard REIT Index Fund was used as the master list for REIT company names in the Vanguard fund universe. If a company is listed here, it should be listed in other Vanguard funds. This is a more accurate approach, as some company names do not contain identifying words such as REIT, Property, or Realty in their title.

The data was obtained directly from the SEC's EDGAR database. Vanguard does not file holding information every quarter with the SEC. In some cases, Vanguard's reports will have newer information. However, the EDGAR website data is easily copied into Excel via a web browser. Holdings are submitted on Form N-Q.


 * Enter the ticker symbol in the EDGAR Search for Mutual Funds, such as VGSIX
 * Select the link from the search result fund, such as S000002924 (the fund ticker is to the right of this link).
 * Enter "N-Q" in the filter box, Filing Type.
 * Pick the most recent Format Documents (2009-12-29)
 * Pick the top HTML file, Seq 1, Type N-Q, specializedfundsfinal.htm
 * Search the page for the fund. Copy and paste into Excel. Additional formatting is necessary, but the data is there. See the Excel file for the formulas used to extract the data.