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] Voucher checks?
And if you have them printed by gnucash you save the risk of what’s in the register differing from what got printed, which for me is worth a lot Sent from my iPhone > On Nov 23, 2019, at 2:52 PM, John Ralls wrote: > > > >> On Nov 23, 2019, at 10:35 AM, Roderick Anderson wrote: >> >> Good Day. >> >> The organization I am treasurer for currently has three-up checks that I >> fill out by hand. >> >> We typically only use 10 or less a year and I have plenty on hand but I >> would prefer not hand writing them out. I don't need GnuCash to print the >> checks but do need something that is usable from LibreOffice - ready made >> template? >> >> My research (Google) turns some up but everyone mentions being compatible >> with commercial accounting software. Probably so they can be printed from >> the software. Since I do not need that I would still like any thoughts or >> suggestions for a good brand. > > GnuCash can print 3-up voucher checks, see > https://www.gnucash.org/docs/v3/C/gnucash-help/print-check.html. The only > reason not to use it would be if you get checks that don't have the MICR > routing id and account number pre-printed on them, but if you're currently > filling them out by hand you must already have those. > > Regards, > John Ralls > > ___ > 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. ___ 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On Saturday, 23 November 2019 08:40:04 GMT Wm via gnucash-user wrote: > On 25/08/2019 00:06, Richard Ullger wrote: > > On 23/08/2019 14:26, Wm via gnucash-user wrote: > >> heads up, folks > >> > >> morningtstar.co.uk (and possibly other European versions) have changed > >> some stuff that mean some F::Q requests have stopped working. > >> > >> This isn't gnc's fault. > >> > >> If you use a quote source such as > >> mstaruk > >> expect it to fail until the F::Q folks catch up. > >> > >> Would people with appropriate access let us know if the German / French > >> / Italian / Scandinavian / etc versions of morningstar are similarly > >> affected. > > > > I'm using Morningstar, GB as it appears in the quote source dropdown > > list for a couple of funds and am not seeing any issues. Prices have > > successfully loaded up to Friday 23/08/19. > > > > Works using mstaruk in gnc-fq-dump too. > > Hmmmn. Apols for time passing, etc > > What do you (or anyone else interested) get for > === > gnc-fq-dump -v mstaruk GB00B4PQW151 > === > > I get > > === > Finance::Quote fields Gnucash uses: > symbol: GB00B4PQW151 (deduced) <=== required >date: ** missing **<=== recommended >currency: ** missing **<=== required >last: <=\ > nav: <=== one of these > price: <=/ >timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock GB00B4PQW151 > > stock field value > - - - > GB00B4PQW151 errormsg: Error - failed to retrieve fund data > MSTARUK_LOOK_UP > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB0 > 0B4PQW151 > > GB00B4PQW151 last: **missing** > GB00B4PQW151nav: **missing** > GB00B4PQW151 price: **missing** > GB00B4PQW151success: 0 > === > > Note: the extra detail in the "errormsg:" is because I worked out where > mstaruk was breaking for me and I'm trying to work out what is wrong. > > The URL without the extra dot before the ISIN works, for clarity > === > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB0 > 0B4PQW151 = vs = > http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=GB00 > B4PQW151 === > > GB00B4PQW151 is Vanguard LifeStrategy 80% which I think more than one > person here might own a bit of. I get (on Saturday evening)... gnc-fq-dump -v mstaruk GB00B4PQW151 Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 <=== required date: 11/22/2019 <=== recommended currency: GBP <=== required last: 215.21 <=\ nav: 215.21 <=== one of these price: 215.21 <=/ timezone: <=== optional All fields returned by Finance::Quote for stock GB00B4PQW151 stock field value - - - GB00B4PQW151 currency: GBP GB00B4PQW151 date: 11/22/2019 GB00B4PQW151 errormsg: Success GB00B4PQW151isodate: 2019-11-22 GB00B4PQW151 last: 215.21 GB00B4PQW151 method: mstaruk GB00B4PQW151 name: Vanguard LifeStrategy 80% Equity A Acc GB00B4PQW151nav: 215.21 GB00B4PQW151net: 1.72168 GB00B4PQW151 p_change: 0.80 GB00B4PQW151 price: 215.21 GB00B4PQW151 source: http://www.morningstar.co.uk GB00B4PQW151success: 1 GB00B4PQW151 symbol: GB00B4PQW151 GB00B4PQW151 time: 12:00 Regards, Richard ___ 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] Voucher checks?
> On Nov 23, 2019, at 10:35 AM, Roderick Anderson wrote: > > Good Day. > > The organization I am treasurer for currently has three-up checks that I fill > out by hand. > > We typically only use 10 or less a year and I have plenty on hand but I would > prefer not hand writing them out. I don't need GnuCash to print the checks > but do need something that is usable from LibreOffice - ready made template? > > My research (Google) turns some up but everyone mentions being compatible > with commercial accounting software. Probably so they can be printed from > the software. Since I do not need that I would still like any thoughts or > suggestions for a good brand. GnuCash can print 3-up voucher checks, see https://www.gnucash.org/docs/v3/C/gnucash-help/print-check.html. The only reason not to use it would be if you get checks that don't have the MICR routing id and account number pre-printed on them, but if you're currently filling them out by hand you must already have those. Regards, John Ralls ___ 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] Voucher checks?
Good Day. The organization I am treasurer for currently has three-up checks that I fill out by hand. We typically only use 10 or less a year and I have plenty on hand but I would prefer not hand writing them out. I don't need GnuCash to print the checks but do need something that is usable from LibreOffice - ready made template? My research (Google) turns some up but everyone mentions being compatible with commercial accounting software. Probably so they can be printed from the software. Since I do not need that I would still like any thoughts or suggestions for a good brand. TIA, Rod -- ___ 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] Split Transactions: "wrong" Num fields show in reports
> > -- Forwarded message -- > From: Paul Kroitor > To: "gnucash-user@gnucash.org" > Cc: > Bcc: > Date: Sat, 23 Nov 2019 15:49:26 + > Subject: [GNC] Split Transactions: "wrong" Num fields show in reports > Hi, I've looked for this in the archives but nothing pops up. I have years > of experience with GnuCash cannot seem to resolve this. > > Simplified, we have a regular bank account which is used to reimburse > construction worker's out-of-pocket purchases. They provide a store > receipt, which gets a NUMber, and an e-transfer is made to their bank > account. Then we create a weekly transaction list, showing the all the > expenses. It (of course) needs to show the receipt number. > > This works fine for individual payments (each expense is listed with the > Num correctly shown). But if we repay the worker for two items, we enter it > as a split: a credit to the bank, and two debits, one for each receipt > (e.g. #27 Nails $5, #28 Paint $10). > > The problem is that the transaction report always shows the Num from the > main entry in the bank ledger, not the individual Nums for the split lines. > It does this even though the transaction report is selecting from the > Expense ledgers, not the bank. > > Entry into Bank shows as follows in Autosplit mode > Jan 1 #xxx John Smith C $15 >#27 ABC Hardware Nails D > $5 >#28 DEF Paints Paint > D $10 > (bank tracking code)Bank AccountC$15 > > But the transaction report for expenses shows > Jan 1 #xxx ABC Hardware Nails$5 > Jan 1 #xxx DEF PaintsPaint$10 > > Note the Num shown is from the top line of the entry, but the description > is from each split line. We need the Num from the split line to be shown. > > Is this a bug, or is it designed to work this way? And if so, why, and is > there a work-around? > > Thanks for any advice, info, pointers, etc > Paul Kroitor > > Paul, There is an option (File->Properties->Accounts Tab->Use Split Action Field for Number) that should do what you want; that is, if this option is selected, the 'num' field on registers and reports can vary by split within a transaction. If the report you are using doesn't respect your selection for this option, that would be a bug on the report. Also, please note that changing this option will not change historical data. It will change the behaviour going forward for new transactions entered. But, if there are only a few, you could go back and modify individual transactions through the register window after making the option change and rerun the report. Regards, Alex ___ 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] gnucash.org is UP
In case anyone was waiting, gnucash.org is available for your Internet browsing convenience. In case anyone remains concerned with the reliability of the site, details about you can help ensure reliability may be found here: https://www.gnucash.org/donate.phtml I'm very grateful for this software and all who make it happen. Kind regards, Greg Feneis (Pixel 3) ___ 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] Split Transactions: "wrong" Num fields show in reports
Hi, I've looked for this in the archives but nothing pops up. I have years of experience with GnuCash cannot seem to resolve this. Simplified, we have a regular bank account which is used to reimburse construction worker's out-of-pocket purchases. They provide a store receipt, which gets a NUMber, and an e-transfer is made to their bank account. Then we create a weekly transaction list, showing the all the expenses. It (of course) needs to show the receipt number. This works fine for individual payments (each expense is listed with the Num correctly shown). But if we repay the worker for two items, we enter it as a split: a credit to the bank, and two debits, one for each receipt (e.g. #27 Nails $5, #28 Paint $10). The problem is that the transaction report always shows the Num from the main entry in the bank ledger, not the individual Nums for the split lines. It does this even though the transaction report is selecting from the Expense ledgers, not the bank. Entry into Bank shows as follows in Autosplit mode Jan 1 #xxx John Smith C $15 #27 ABC Hardware Nails D $5 #28 DEF Paints PaintD $10 (bank tracking code)Bank AccountC$15 But the transaction report for expenses shows Jan 1 #xxx ABC Hardware Nails$5 Jan 1 #xxx DEF PaintsPaint$10 Note the Num shown is from the top line of the entry, but the description is from each split line. We need the Num from the split line to be shown. Is this a bug, or is it designed to work this way? And if so, why, and is there a work-around? Thanks for any advice, info, pointers, etc Paul Kroitor ___ 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] Finance::Quote morningstar uk (and europe?) have changed stuff
On 25/08/2019 00:06, Richard Ullger wrote: On 23/08/2019 14:26, Wm via gnucash-user wrote: heads up, folks morningtstar.co.uk (and possibly other European versions) have changed some stuff that mean some F::Q requests have stopped working. This isn't gnc's fault. If you use a quote source such as mstaruk expect it to fail until the F::Q folks catch up. Would people with appropriate access let us know if the German / French / Italian / Scandinavian / etc versions of morningstar are similarly affected. I'm using Morningstar, GB as it appears in the quote source dropdown list for a couple of funds and am not seeing any issues. Prices have successfully loaded up to Friday 23/08/19. Works using mstaruk in gnc-fq-dump too. Hmmmn. Apols for time passing, etc What do you (or anyone else interested) get for === gnc-fq-dump -v mstaruk GB00B4PQW151 === I get === Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock GB00B4PQW151 stock field value - - - GB00B4PQW151 errormsg: Error - failed to retrieve fund data MSTARUK_LOOK_UP http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB00B4PQW151 GB00B4PQW151 last: **missing** GB00B4PQW151nav: **missing** GB00B4PQW151 price: **missing** GB00B4PQW151success: 0 === Note: the extra detail in the "errormsg:" is because I worked out where mstaruk was breaking for me and I'm trying to work out what is wrong. The URL without the extra dot before the ISIN works, for clarity === http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=.GB00B4PQW151 = vs = http://www.morningstar.co.uk/uk/funds/SecuritySearchResults.aspx?search=GB00B4PQW151 === GB00B4PQW151 is Vanguard LifeStrategy 80% which I think more than one person here might own a bit of. -- 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.