[GNC] Vanguard investments module for Gnucash / Finance ::Quote

[Derek Robinson]

Vanguard investors using GnuCash may be frustrated that many Vanguard products (like their 529 portfolios, any 401(k) / 403(b) products with the word "Trust" in the title) do not have prices that are easily obtainable from one of the regular price sources. The attached module extracts prices from the Vanguard price history page and adds them to the GnuCash price database.

VanguardSite.pm will retrieve the most recent daily closing price (NAV) for Vanguard investments (funds, collective investment trusts, 529 portfolios ...) using Finance::Quote and add it to the GnuCash price history.

Instructions
Drop VanguardSite.pm into path\to\Strawberry\perl\site\lib\Finance\Quote
Make path\to\Strawberry\perl\site\lib\Finance\Quote.pm writable
Add VanguardSite to the @modules array in the new sub of Quote.pm. Save.
Make Quote.pm read-only.

Open gnucash.

Add a Vanguard security.
Attributes:
- Full name, Display symbol, ISIN don't matter.
- Type is FUND
- Fraction traded is 1/1000 for most Vanguard investments - check your statement if in doubt.
- Symbol/abbreviation must be the INTERNAL VANGUARD FUND ID (like 0052), NOT the ticker (like VGHCX).
- Check Get Online Quotes, select the "Unknown" radio button, and select "vanguardsite" from the dropdown.
- Timezone doesn't matter.


Get online prices. You should see a price entry from the last full business day with type = nav.

Feel free to message me with questions.
-Derek
-------------- next part --------------
A non-text attachment was scrubbed...
Name: VanguardSite.pm
Type: application/octet-stream
Size: 5258 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20191119/44c1e78b/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: vanguardsite_config.png
Type: image/png
Size: 50247 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20191119/44c1e78b/attachment-0001.png>