Vanguard Fund Table Development

From Bogleheads

(Redirected from Vanguard Table Experiments)
Jump to: navigation, search

The is the Vanguard Fund Info table viewed directly by Google Docs Spreadsheet. The calculated cells in green use GoogleFinance(cell, "expenseratio") to dynamically lookup the expense ratio.

Money market funds return "no data" meaning that the expense ratio must be obtained from Vanguard directly (manual data entry in table). As the money market funds don't supply expense ratios, the spreadsheet is already automated as much as possible.

The table should be periodically checked for updates against the table in Vanguard Fund Info to check for updates. Not easy to convert wiki back to Excel format, so it's best done as side-by-side windows in the browser.

  • Last column on right (in green) contains the formulas to build the table rows. An example:
="|-"&char(10)&"|align=left|"&M3&"||"&"align=left|'''"&A3&"'''<br>"&if(isblank(B3),," [https://personal.vanguard.com/us/funds/snapshot?FundId="&C3&"&FundIntExt=INT Investor]")&if(isblank(E3),," [https://personal.vanguard.com/us/funds/snapshot?FundId="&F3&"&FundIntExt=INT Admiral]")&if(isblank(H3),," [https://personal.vanguard.com/us/funds/snapshot?FundId="&I3&"&FundIntExt=INT ETF]")&"||"&B3&"<br>"&C3&"||"&E3&"<br>"&F3&"||"&H3&"<br>"&I3&"||"&D3&"||"&G3&"||"&J3&"||"&K3&"||"&L3
  • Introductory text and the table header are in the first row, last column on right (in black).
  • Second to last column on right, Fund Type, is the fund type in wiki table syntax, which is included in the table formula directly.
  • The Vanguard web site links are built as part of the table formula.


}

Data Sources

You must have cookies enabled -or- a cookie stored by Google (enable cookies, do any Google search, then disable cookies)
Excel, Open Office or Adobe files do not contain GoogleFinance (value only) or table formulas (#NA). Use csv to export the table values. Manually copy-n-paste the formulas from Google into a local spreadsheet (you must have edit privileges).

See Also

How to Cite

You can link to this page from the Bogleheads Forum by copying and pasting the following text into your forum posting:

Please see [url=http://www.bogleheads.org/wiki/Vanguard_Fund_Table_Development]Vanguard Fund Table Development[/url] on the [url=http://www.bogleheads.org/wiki/Main_Page]Bogleheads Wiki[/url].
Notice something that needs correcting? Notify a wiki editor or become a wiki editor and fix it yourself!
Retrieved from "http://www.bogleheads.org/wiki/Vanguard_Fund_Table_Development"
Personal tools