On 19/11/2019 16:27, Derek Robinson via gnucash-user wrote:
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.
I had a look at the code and I like it. Thing is Vanguard isn't just
USA these days as you should know if you follow bogleheads
My suggestion is you make Vanguard USA distinct from Vanguard in future.
That way the rest of the world (the actual majority) needn't be arsed
with parochial code [1]
[1] I'm hitting harder than I intend there, DerekR, I am aiming at
people that don't realize there are people outside their immediate environ.
--
Wm
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
