Re: [GNC] Vanguard investments module for Gnucash / Finance ::Quote
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.
Re: [GNC] Vanguard investments module for Gnucash / Finance ::Quote
Frank - thanks for your message and the suggestion. I made two updates to the module and posted it to the Finance::Quote developers list. Those updates are: - Changed the logic that retrieves the last price to directly extract the last (most current) row of the price table, instead of iterating from the top. Probably doesn't make much difference but this is a little cleaner. - Provided two links in the SEE ALSO documentation section, one for 529 portfolios and one for all other Vanguard products. Best,Derek On Tuesday, November 19, 2019, 04:28:15 PM EST, Frank H. Ellenberger wrote: Hi Derek, Am Di., 19. Nov. 2019 um 17:28 Uhr schrieb Derek Robinson via gnucash-user : > > 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. : > Feel free to message me with questions. > -Derek you should consider to offer it to the finance-quote project. One nitpick:the help section "See also" links to http://www.vanguard.com, which is a redirect to https://investor.vanguard.com/corporate-portal/# which then offers several sites. Can you be more specific there, ideally the page explaining which symbols a used, ... Background: That is my starting point, when I update https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html#gnc-tbl-fq-individual-source etc. for official modules. Regards Frank ___ 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.
Re: [GNC] Vanguard investments module for Gnucash / Finance ::Quote
Hi Derek, Am Di., 19. Nov. 2019 um 17:28 Uhr schrieb Derek Robinson via gnucash-user : > > 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. : > Feel free to message me with questions. > -Derek you should consider to offer it to the finance-quote project. One nitpick:the help section "See also" links to http://www.vanguard.com, which is a redirect to https://investor.vanguard.com/corporate-portal/# which then offers several sites. Can you be more specific there, ideally the page explaining which symbols a used, ... Background: That is my starting point, when I update https://code.gnucash.org/docs/C/gnucash-help/fq-sources.html#gnc-tbl-fq-individual-source etc. for official modules. Regards Frank ___ 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.
[GNC] Vanguard investments module for Gnucash / Finance ::Quote
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 VanguardSite.pm Description: Binary data ___ 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.