Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
On 22 Jan 2021, at 20:10, John Ralls wrote: To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from terminal. I've been sticking print statements into price-quotes.scm and gnc-fq-check and looking at the results. It seems that there's something about the final printf in gnc-fq-check that chokes the guile read. I haven't figured out what yet and I'm out of time for today. But you've confirmed my suspicion about having a non-Apple-supplied perl. That will never work with the bundle launched from Finder because your shell environment, which includes the path to the Homebrew-installed perl, isn't read when launching an app bundle from Finder. You may be able to get it to work from the terminal that way. Or you can change the #! line at the front of each of the gnc-fq-* files to point to the copy of Perl you want to use. A kludge, but it works, at least for me. I'm still running an older version of MacOS on an Intel Mac so I don't have the same issues you've seen. I do, however, use a non-stander installation of Perl. Mike ___ 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] Representing fund restructure in Gnucash
Thanks to all who've replied. I've followed Geoff's advice here and it's done exactly what I was trying to do. Robin, thanks for the note about the bogus price in the price database. I'd noticed the same in my earlier attempts to do this. I've cleaned up the bogus price, and the new stocks have a price freshly fetched from the ASX. D. (sunfish62), yes, you're correct, but I have the transaction linking back to the original stocks and the documentation about the restructure. Only one lot is involved, and the rules for capital gains tax (CGT) here in Australia are relatively simple: there's just a simple time threshold for how long an asset has been held that determines whether the full rate or a concessional rate of CGT applies. I think that I've got enough to keep a tax auditor happy. Christopher, I tried to use the stock split assistant, but I couldn't see how to tell it to transfer everything to a new stock account. That may well be user error. Thanks again to everyone who replied, Peter On 22/1/21 20:35, Geoff wrote: Hi Peter From what you have said, the new security will inherit the old security's cost base. So I would create a transaction to reduce the old one to zero and add the new quantity to the new one. Blank out the price and put in the cost base as the value - GnuCash will calculate the price. Screenshot #1 attached shows an example where "BHP" is the old security, and "CBA" is the new security. Hope this helps. Geoff = On 22/01/2021 6:08 pm, Peter Lamb via gnucash-user wrote: I own some Exchange Traded Fund stocks, and one of the stocks has been restructured: the stock I owned has been converted into another stock, so that 1 ABC share (the original stock) has been converted into N DEF shares. I have only been provided with the ratio of share values, not with prices. No money changed hands. How do I represent this in Gnucash? Peter -- Peter Lamb Canberra, ACT ___ 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] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Justin, To answer your earlier question, no, F::Q doesn't work for me either on my DTK. I hadn't actually even tried to install it. It took two passes through sudo gnc-fq-update to get a good install so that I could run gnc-fq-check successfully from terminal. I've been sticking print statements into price-quotes.scm and gnc-fq-check and looking at the results. It seems that there's something about the final printf in gnc-fq-check that chokes the guile read. I haven't figured out what yet and I'm out of time for today. But you've confirmed my suspicion about having a non-Apple-supplied perl. That will never work with the bundle launched from Finder because your shell environment, which includes the path to the Homebrew-installed perl, isn't read when launching an app bundle from Finder. You may be able to get it to work from the terminal that way. Regards, John Ralls > On Jan 22, 2021, at 4:48 PM, Justin via gnucash-user > wrote: > > So... it doesn't actually work quite yet, but GnuCash does recognize it. > Attempting to get quotes via the GnuCash-cli program results in a "unable to > retrieve quotes for these items" message, followed by all of my securities. > > The following will not work. It shows a bunch of missing dependency errors. > This is because I installed F::Q manually, and its dependencies were not > installed. > >> echo '(yahoo_json "FSKAX")' | perl -w gnc-fq-helper > > So I reinstalled perl (and wiped all of the modules). Then tried to install > F::Q via the Perl shell. If I do: > >> sudo perl -MCPAN -e shell >>> install Finance::Quote > > It will fail with the following error messages: > >> Result: PASS >> > >> ECOCODE/Finance-Quote-1.49.tar.gz >> > >> Tests succeeded but one dependency not OK (LWP::Protocol::https) >> > >> ECOCODE/Finance-Quote-1.49.tar.gz >> > >> [dependencies] -- NA >> > >> Failed during this command: >> > >> CHRISN/Net-SSLeay-1.90.tar.gz : make NO >> > >> SULLR/IO-Socket-SSL-2.068.tar.gz : make_test NO one dependency not OK >> (Net::SSLeay); additionally test harness failed >> > >> OALDERS/LWP-Protocol-https-6.10.tar.gz : make_test NO 2 dependencies >> missing (IO::Socket::SSL,IO::Socket::SSL::Utils); additionally test harness >> failed >> > >> ECOCODE/Finance-Quote-1.49.tar.gz : make_test NO one dependency not OK >> (LWP::Protocol::https) > > Net::SSLeay fails because it cannot find the "openssl/err.h" header. I've > installed openssl (with brew) and added the include directory to > $LIBRARY_PATH, but it still doesn't find it. This is the root of the problem. > I'm pretty sure if Net::SSLeay could be installed, everything else would fall > in place. If anyone knows how to get this working, please let me know. I'll > probably spend a little more time trying to figure it out tomorrow. > > Regards, > Justin > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 22nd, 2021 at 5:17 PM, Justin wrote: > >> Woo. I've made progress. So I manually installed the latest F::Q from there >> GitHub release (following their instructions): >> https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 >> > >> This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q >> v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by >> itself, it still prints F::Q v1.49. >> > >> Next, I tried running GnuCash from the ApplicationLauncher (or whatever it's >> called) but alas, F::Q didn't work. Then, I tried running GnuCash from the >> terminal. This **does** work! The GUI application shows F::Q v1.50. >> > >> I'm going to mess around with it a little more. I'm unsure why there's a >> discrepancy. >> > >> ‐‐‐ Original Message ‐‐‐ >> On Friday, January 22nd, 2021 at 5:07 PM, Justin wrote: >> > >>> Alright. I think I might have found part of the issue. >>> > >>> According to this line in GnuCash source, gnc-fq-check is run as an >>> argument to perl: >>> https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 >>> > >>> So I tried that out and it says F::Q is not installed. >>> > $ perl -w gnc-fq-check You need to install the following Perl modules: Finance::Quote Use your system's package manager to install them, or run 'gnc-fq-update' as root. missing-lib >>> > >>> So I re-run what it says, but it doesn't make a difference: >>> > $ sudo ./gnc-fq-update Password: Reading '/Users/jtraglia/.cpan/Metadata' Database was generated on Fri, 22 Jan 2021 00:41:03 GMT Date::Manip is up to date (6.83). Finance::Quote is up to date (1.49). >>> > >>> Lemme try installing F::Q another way. >>> > >>> ‐‐‐ Original Message ‐‐‐ >>> On Friday, January 22nd, 2021 at 4:41 PM, Justin wrote: >>> > John, sorry I forgot to check if launching GnuCash from the terminal makes a difference. F::Q does not work if I run GnuCash from the terminal. Good idea though.
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
So... it doesn't actually work quite yet, but GnuCash does recognize it. Attempting to get quotes via the GnuCash-cli program results in a "unable to retrieve quotes for these items" message, followed by all of my securities. The following will not work. It shows a bunch of missing dependency errors. This is because I installed F::Q manually, and its dependencies were not installed. > echo '(yahoo_json "FSKAX")' | perl -w gnc-fq-helper So I reinstalled perl (and wiped all of the modules). Then tried to install F::Q via the Perl shell. If I do: > sudo perl -MCPAN -e shell > > install Finance::Quote It will fail with the following error messages: > Result: PASS > > ECOCODE/Finance-Quote-1.49.tar.gz > > Tests succeeded but one dependency not OK (LWP::Protocol::https) > > ECOCODE/Finance-Quote-1.49.tar.gz > > [dependencies] -- NA > > Failed during this command: > > CHRISN/Net-SSLeay-1.90.tar.gz : make NO > > SULLR/IO-Socket-SSL-2.068.tar.gz : make_test NO one dependency not OK > (Net::SSLeay); additionally test harness failed > > OALDERS/LWP-Protocol-https-6.10.tar.gz : make_test NO 2 dependencies missing > (IO::Socket::SSL,IO::Socket::SSL::Utils); additionally test harness failed > > ECOCODE/Finance-Quote-1.49.tar.gz : make_test NO one dependency not OK > (LWP::Protocol::https) Net::SSLeay fails because it cannot find the "openssl/err.h" header. I've installed openssl (with brew) and added the include directory to $LIBRARY_PATH, but it still doesn't find it. This is the root of the problem. I'm pretty sure if Net::SSLeay could be installed, everything else would fall in place. If anyone knows how to get this working, please let me know. I'll probably spend a little more time trying to figure it out tomorrow. Regards, Justin ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 5:17 PM, Justin wrote: > Woo. I've made progress. So I manually installed the latest F::Q from there > GitHub release (following their instructions): > https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 > > This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q > v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by > itself, it still prints F::Q v1.49. > > Next, I tried running GnuCash from the ApplicationLauncher (or whatever it's > called) but alas, F::Q didn't work. Then, I tried running GnuCash from the > terminal. This **does** work! The GUI application shows F::Q v1.50. > > I'm going to mess around with it a little more. I'm unsure why there's a > discrepancy. > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 22nd, 2021 at 5:07 PM, Justin wrote: > > > Alright. I think I might have found part of the issue. > > > > According to this line in GnuCash source, gnc-fq-check is run as an > > argument to perl: > > https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 > > > > So I tried that out and it says F::Q is not installed. > > > > > $ perl -w gnc-fq-check > > > You need to install the following Perl modules: > > > Finance::Quote > > > Use your system's package manager to install them, > > > or run 'gnc-fq-update' as root. > > > missing-lib > > > > So I re-run what it says, but it doesn't make a difference: > > > > > $ sudo ./gnc-fq-update > > > Password: > > > Reading '/Users/jtraglia/.cpan/Metadata' > > > Database was generated on Fri, 22 Jan 2021 00:41:03 GMT > > > Date::Manip is up to date (6.83). > > > Finance::Quote is up to date (1.49). > > > > Lemme try installing F::Q another way. > > > > ‐‐‐ Original Message ‐‐‐ > > On Friday, January 22nd, 2021 at 4:41 PM, Justin wrote: > > > > > John, sorry I forgot to check if launching GnuCash from the terminal > > > makes a difference. F::Q does not work if I run GnuCash from the > > > terminal. Good idea though. > > > > > > ‐‐‐ Original Message ‐‐‐ > > > On Friday, January 22nd, 2021 at 4:38 PM, David H > > > wrote: > > > > > > > I think that's what John meant in the second message he posted in this > > > > thread re running under Rosetta2 . > > > > > > > > >> BigSur absolutely is supported. What's not yet available yet is a > > > > >> native build for Apple Silicon, but I've found so far that the Intel > > > > >> build of GnuCash works fine with Rosetta2. > > > > > > > > >> The BigSur upgrade seems to have messed up perl; I had to reinstall > > > > >> F::Q to get it working after I upgraded, but one could also set > > > > >> $PERL5LIB in the environment to include > > > > >> the old /Library/perl/5.18 as a workaround. If you did that in a > > > > >>shell rc file it would make gnc-fq-helper work from terminal but not > > > > >>from GnuCash when run from LaunchServices. > > > > > > > > >> Does F::Q work when starting GnuCash from the terminal? > > > > > > > > >> Regards, > > > > >> John Ralls > > > > > > > > Cheers David H. > > > > > > > > > > > > On
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Woo. I've made progress. So I manually installed the latest F::Q from there GitHub release (following their instructions): https://github.com/finance-quote/finance-quote/releases/tag/v1.50-rc.1 This fixes the issue with running "perl -w gnc-fq-check" (and prints F::Q v1.50) that I mentioned in the last email. But if I run "gnc-fq-check" by itself, it still prints F::Q v1.49. Next, I tried running GnuCash from the ApplicationLauncher (or whatever it's called) but alas, F::Q didn't work. Then, I tried running GnuCash from the terminal. This **does** work! The GUI application shows F::Q v1.50. I'm going to mess around with it a little more. I'm unsure why there's a discrepancy. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 5:07 PM, Justin wrote: > Alright. I think I might have found part of the issue. > > According to this line in GnuCash source, gnc-fq-check is run as an argument > to perl: > https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 > > So I tried that out and it says F::Q is not installed. > > > $ perl -w gnc-fq-check > > You need to install the following Perl modules: > > Finance::Quote > > Use your system's package manager to install them, > > or run 'gnc-fq-update' as root. > > missing-lib > > So I re-run what it says, but it doesn't make a difference: > > > $ sudo ./gnc-fq-update > > Password: > > Reading '/Users/jtraglia/.cpan/Metadata' > > Database was generated on Fri, 22 Jan 2021 00:41:03 GMT > > Date::Manip is up to date (6.83). > > Finance::Quote is up to date (1.49). > > Lemme try installing F::Q another way. > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 22nd, 2021 at 4:41 PM, Justin wrote: > > > John, sorry I forgot to check if launching GnuCash from the terminal makes > > a difference. F::Q does not work if I run GnuCash from the terminal. Good > > idea though. > > > > ‐‐‐ Original Message ‐‐‐ > > On Friday, January 22nd, 2021 at 4:38 PM, David H wrote: > > > > > I think that's what John meant in the second message he posted in this > > > thread re running under Rosetta2 . > > > > > > >> BigSur absolutely is supported. What's not yet available yet is a > > > >> native build for Apple Silicon, but I've found so far that the Intel > > > >> build of GnuCash works fine with Rosetta2. > > > > > > >> The BigSur upgrade seems to have messed up perl; I had to reinstall > > > >> F::Q to get it working after I upgraded, but one could also set > > > >> $PERL5LIB in the environment to include > > > >> the old /Library/perl/5.18 as a workaround. If you did that in a > > > >>shell rc file it would make gnc-fq-helper work from terminal but not > > > >>from GnuCash when run from LaunchServices. > > > > > > >> Does F::Q work when starting GnuCash from the terminal? > > > > > > >> Regards, > > > >> John Ralls > > > > > > Cheers David H. > > > > > > > > > On Sat, 23 Jan 2021 at 07:54, Chris Graves wrote: > > > > > > > John Ralls, have you had success running F::Q on an M1 Mac (I seem to > > > > recall that you had a dev kit)? > > > > > > > > > On Jan 22, 2021, at 1:11 PM, Justin wrote: > > > > > > > > > > Chris, this did not fix my issue. > > > > > > > > > > ‐‐‐ Original Message ‐‐‐ > > > > > > > > > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves > > > > > wrote: > > > > > > > > > >> I reinstalled (on my Intel Mac) by running: > > > > >> > > > > > > > > > >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > > > >> > > > > > > > > > >>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > > > > >>> > > > > > > > > > >>> Hello all, thank you for replying. I'm new to this email list. > > > > >>> > > > > > > > > > >>> Dave, I do have an M1 Mac. Maybe that's part of the problem. > > > > >>> > > > > > > > > > >>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" > > > > >>> doesn't have an uninstall option. I did manually upgrade F::Q > > > > >>> though, no change. Gnucash-cli still thinks it's installed > > > > >>> improperly. > > > > >>> > > > > > > > > > >>> Thanks, > > > > >>> > > > > > > > > > >>> Justin > > > > >>> > > > > > > > > > >>> ‐‐‐ Original Message ‐‐‐ > > > > >>> > > > > > > > > > >>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote: > > > > >>> > > > > > > > > > Chris, do you have an M1 or Intel Mac? > > > > >>> > > > > > > > > > > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com > > > > > wrote: > > > > >>> > > > > > > > > > > Just another point of information, I had the same issue, but it > > > > > was resolved after reinstalling F::Q as John mentions below. > > > > >>> > > > > > > > > > >> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > > > > >> gnucash-user@gnucash.org wrote: > > > > >>> > > > > > > > > > >>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us > > > > >>> wrote: > > > > >>> >
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Alright. I think I might have found part of the issue. According to this line in GnuCash source, gnc-fq-check is run as an argument to perl: https://github.com/Gnucash/gnucash/blob/maint/gnucash/price-quotes.scm#L47 So I tried that out and it says F::Q is not installed. > $ perl -w gnc-fq-check > You need to install the following Perl modules: > Finance::Quote > Use your system's package manager to install them, > or run 'gnc-fq-update' as root. > missing-lib So I re-run what it says, but it doesn't make a difference: > $ sudo ./gnc-fq-update > Password: > Reading '/Users/jtraglia/.cpan/Metadata' > Database was generated on Fri, 22 Jan 2021 00:41:03 GMT > Date::Manip is up to date (6.83). > Finance::Quote is up to date (1.49). Lemme try installing F::Q another way. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 4:41 PM, Justin wrote: > John, sorry I forgot to check if launching GnuCash from the terminal makes a > difference. F::Q does not work if I run GnuCash from the terminal. Good idea > though. > > ‐‐‐ Original Message ‐‐‐ > On Friday, January 22nd, 2021 at 4:38 PM, David H wrote: > > > I think that's what John meant in the second message he posted in this > > thread re running under Rosetta2 . > > > > >> BigSur absolutely is supported. What's not yet available yet is a native > > >> build for Apple Silicon, but I've found so far that the Intel build of > > >> GnuCash works fine with Rosetta2. > > > > >> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q > > >> to get it working after I upgraded, but one could also set $PERL5LIB in > > >> the environment to include > > >> the old /Library/perl/5.18 as a workaround. If you did that in a shell > > >>rc file it would make gnc-fq-helper work from terminal but not from > > >>GnuCash when run from LaunchServices. > > > > >> Does F::Q work when starting GnuCash from the terminal? > > > > >> Regards, > > >> John Ralls > > > > Cheers David H. > > > > > > On Sat, 23 Jan 2021 at 07:54, Chris Graves wrote: > > > > > John Ralls, have you had success running F::Q on an M1 Mac (I seem to > > > recall that you had a dev kit)? > > > > > > > On Jan 22, 2021, at 1:11 PM, Justin wrote: > > > > > > > > Chris, this did not fix my issue. > > > > > > > > ‐‐‐ Original Message ‐‐‐ > > > > > > > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves > > > > wrote: > > > > > > > >> I reinstalled (on my Intel Mac) by running: > > > >> > > > > > > > >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > > >> > > > > > > > >>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > > > >>> > > > > > > > >>> Hello all, thank you for replying. I'm new to this email list. > > > >>> > > > > > > > >>> Dave, I do have an M1 Mac. Maybe that's part of the problem. > > > >>> > > > > > > > >>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't > > > >>> have an uninstall option. I did manually upgrade F::Q though, no > > > >>> change. Gnucash-cli still thinks it's installed improperly. > > > >>> > > > > > > > >>> Thanks, > > > >>> > > > > > > > >>> Justin > > > >>> > > > > > > > >>> ‐‐‐ Original Message ‐‐‐ > > > >>> > > > > > > > >>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote: > > > >>> > > > > > > > Chris, do you have an M1 or Intel Mac? > > > >>> > > > > > > > > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com > > > > wrote: > > > >>> > > > > > > > > Just another point of information, I had the same issue, but it was > > > > resolved after reinstalling F::Q as John mentions below. > > > >>> > > > > > > > >> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > > > >> gnucash-user@gnucash.org wrote: > > > >>> > > > > > > > >>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote: > > > >>> > > > > > > > On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user > > > gnucash-user@gnucash.org wrote: > > > >>> > > > > > > > Hello everyone, > > > >>> > > > > > > > I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on > > > macOS Big Sur (11.0). Despite not being officially supported, > > > GnuCash itself works great, with the exception of > > > Finance::Quote. The "get quotes" button in the Price Database is > > > grayed out and the Security Editor has the warning > > > "Finance::Quote isn't installed properly." When running > > > Gnucash-cli, there is a similar error: > > > >>> > > > > > > > > $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes > > > > get > > > > /Users/username/Documents/Finances/Tracking/finances.gnucash > > > > --debug > > > >>> > > > > > > > > Application Path > > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > > > >>> > > > > > > > >
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
John, sorry I forgot to check if launching GnuCash from the terminal makes a difference. F::Q does not work if I run GnuCash from the terminal. Good idea though. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 4:38 PM, David H wrote: > I think that's what John meant in the second message he posted in this thread > re running under Rosetta2 . > > >> BigSur absolutely is supported. What's not yet available yet is a native > >> build for Apple Silicon, but I've found so far that the Intel build of > >> GnuCash works fine with Rosetta2. > > >> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q > >> to get it working after I upgraded, but one could also set $PERL5LIB in > >> the environment to include > >> the old /Library/perl/5.18 as a workaround. If you did that in a shell rc > >>file it would make gnc-fq-helper work from terminal but not from GnuCash > >>when run from LaunchServices. > > >> Does F::Q work when starting GnuCash from the terminal? > > >> Regards, > >> John Ralls > > Cheers David H. > > > On Sat, 23 Jan 2021 at 07:54, Chris Graves wrote: > > > John Ralls, have you had success running F::Q on an M1 Mac (I seem to > > recall that you had a dev kit)? > > > > > On Jan 22, 2021, at 1:11 PM, Justin wrote: > > > > > > Chris, this did not fix my issue. > > > > > > ‐‐‐ Original Message ‐‐‐ > > > > > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves > > > wrote: > > > > > >> I reinstalled (on my Intel Mac) by running: > > >> > > > > > >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > >> > > > > > >>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > > >>> > > > > > >>> Hello all, thank you for replying. I'm new to this email list. > > >>> > > > > > >>> Dave, I do have an M1 Mac. Maybe that's part of the problem. > > >>> > > > > > >>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't > > >>> have an uninstall option. I did manually upgrade F::Q though, no > > >>> change. Gnucash-cli still thinks it's installed improperly. > > >>> > > > > > >>> Thanks, > > >>> > > > > > >>> Justin > > >>> > > > > > >>> ‐‐‐ Original Message ‐‐‐ > > >>> > > > > > >>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote: > > >>> > > > > > Chris, do you have an M1 or Intel Mac? > > >>> > > > > > > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com wrote: > > >>> > > > > > > Just another point of information, I had the same issue, but it was > > > resolved after reinstalling F::Q as John mentions below. > > >>> > > > > > >> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > > >> gnucash-user@gnucash.org wrote: > > >>> > > > > > >>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote: > > >>> > > > > > On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user > > gnucash-user@gnucash.org wrote: > > >>> > > > > > Hello everyone, > > >>> > > > > > I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on > > macOS Big Sur (11.0). Despite not being officially supported, > > GnuCash itself works great, with the exception of Finance::Quote. > > The "get quotes" button in the Price Database is grayed out and > > the Security Editor has the warning "Finance::Quote isn't > > installed properly." When running Gnucash-cli, there is a similar > > error: > > >>> > > > > > > $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes > > > get /Users/username/Documents/Finances/Tracking/finances.gnucash > > > --debug > > >>> > > > > > > Application Path > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > > >>> > > > > > > (process:2277): gnc.gui-WARNING **: 22:01:17.540: > > > [mac_set_languages()] Language list: en:en_US:C > > >>> > > > > > > - 22:01:17 INFO [gnc_module_init_backend_dbi] > > > 3 DBD drivers found > > > - 22:01:17 INFO [gnc_module_init_backend_dbi] > > > Driver: pgsql > > > - 22:01:17 INFO [gnc_module_init_backend_dbi] > > > Driver: sqlite3 > > > - 22:01:17 INFO [gnc_module_init_backend_dbi] > > > Driver: mysql > > > - 22:01:17 INFO [Gnucash::CoreApp::start] System > > > locale returned (null) > > > - 22:01:17 INFO [Gnucash::CoreApp::start] Effective > > > locale set to en_US.UTF-8. > > > - 22:01:17 INFO > > > [gnc_gsettings_register_cb] schema: general, key: retain-days, > > > settings_ptr: 0x7fde7e839430, handler_id: 1 > > > - 22:01:17 INFO > > > [gnc_gsettings_register_cb] schema: general, key: > > > retain-type-never, settings_ptr: 0x7fde7e839430, handler_id: 2 > > > - 22:01:17 INFO > > > [gnc_gsettings_register_cb] schema:
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
I think that's what John meant in the second message he posted in this thread re running under Rosetta2 . >> BigSur absolutely is supported. What's not yet available yet is a native build for Apple Silicon, but I've found so far that the Intel build of GnuCash works fine with Rosetta2. >> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q to get it working after I upgraded, but one could also set $PERL5LIB in the environment to include >> the old /Library/perl/5.18 as a workaround. If you did that in a shell rc file it would make gnc-fq-helper work from terminal but not from GnuCash when run from LaunchServices. >> Does F::Q work when starting GnuCash from the terminal? >> Regards, >> John Ralls Cheers David H. On Sat, 23 Jan 2021 at 07:54, Chris Graves wrote: > John Ralls, have you had success running F::Q on an M1 Mac (I seem to > recall that you had a dev kit)? > > > On Jan 22, 2021, at 1:11 PM, Justin wrote: > > > > Chris, this did not fix my issue. > > > > ‐‐‐ Original Message ‐‐‐ > > > > On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves < > mohaveba...@gmail.com> wrote: > > > >> I reinstalled (on my Intel Mac) by running: > >> > > > >> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > >> > > > >>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > >>> > > > >>> Hello all, thank you for replying. I'm new to this email list. > >>> > > > >>> Dave, I do have an M1 Mac. Maybe that's part of the problem. > >>> > > > >>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't > have an uninstall option. I did manually upgrade F::Q though, no change. > Gnucash-cli still thinks it's installed improperly. > >>> > > > >>> Thanks, > >>> > > > >>> Justin > >>> > > > >>> ‐‐‐ Original Message ‐‐‐ > >>> > > > >>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote: > >>> > > > Chris, do you have an M1 or Intel Mac? > >>> > > > > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com > wrote: > >>> > > > > Just another point of information, I had the same issue, but it was > resolved after reinstalling F::Q as John mentions below. > >>> > > > >> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > gnucash-user@gnucash.org wrote: > >>> > > > >>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote: > >>> > > > On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user > gnucash-user@gnucash.org wrote: > >>> > > > Hello everyone, > >>> > > > I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on > macOS Big Sur (11.0). Despite not being officially supported, GnuCash > itself works great, with the exception of Finance::Quote. The "get quotes" > button in the Price Database is grayed out and the Security Editor has the > warning "Finance::Quote isn't installed properly." When running > Gnucash-cli, there is a similar error: > >>> > > > > $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes > get /Users/username/Documents/Finances/Tracking/finances.gnucash --debug > >>> > > > > Application Path > /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > >>> > > > > (process:2277): gnc.gui-WARNING **: 22:01:17.540: > [mac_set_languages()] Language list: en:en_US:C > >>> > > > > - 22:01:17 INFO > [gnc_module_init_backend_dbi] 3 DBD drivers found > > - 22:01:17 INFO > [gnc_module_init_backend_dbi] Driver: pgsql > > - 22:01:17 INFO > [gnc_module_init_backend_dbi] Driver: sqlite3 > > - 22:01:17 INFO > [gnc_module_init_backend_dbi] Driver: mysql > > - 22:01:17 INFO [Gnucash::CoreApp::start] System > locale returned (null) > > - 22:01:17 INFO [Gnucash::CoreApp::start] Effective > locale set to en_US.UTF-8. > > - 22:01:17 INFO > [gnc_gsettings_register_cb] schema: general, key: retain-days, > settings_ptr: 0x7fde7e839430, handler_id: 1 > > - 22:01:17 INFO > [gnc_gsettings_register_cb] schema: general, key: retain-type-never, > settings_ptr: 0x7fde7e839430, handler_id: 2 > > - 22:01:17 INFO > [gnc_gsettings_register_cb] schema: general, key: retain-type-days, > settings_ptr: 0x7fde7e839430, handler_id: 3 > > - 22:01:17 INFO > [gnc_gsettings_register_cb] schema: general, key: retain-type-forever, > settings_ptr: 0x7fde7e839430, handler_id: 4 > > - 22:01:17 INFO > [gnc_gsettings_register_cb] schema: general, key: file-compression, > settings_ptr: 0x7fde7e839430, handler_id: 5 > >>> > > > > No quotes retrieved. Finance::Quote isn't installed properly. > > > > > > - 22:01:17 INFO [gnc_hook_lookup] no hook lists > >>> > > > The error message above isn't particularly useful. It gets > printed here: > >>> > > > > https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91 > >>> > > > I'm
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
John Ralls, have you had success running F::Q on an M1 Mac (I seem to recall
that you had a dev kit)?
> On Jan 22, 2021, at 1:11 PM, Justin wrote:
>
> Chris, this did not fix my issue.
>
> ‐‐‐ Original Message ‐‐‐
>
> On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves
> wrote:
>
>> I reinstalled (on my Intel Mac) by running:
>>
>
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
>>
>
>>> On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote:
>>>
>
>>> Hello all, thank you for replying. I'm new to this email list.
>>>
>
>>> Dave, I do have an M1 Mac. Maybe that's part of the problem.
>>>
>
>>> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't have
>>> an uninstall option. I did manually upgrade F::Q though, no change.
>>> Gnucash-cli still thinks it's installed improperly.
>>>
>
>>> Thanks,
>>>
>
>>> Justin
>>>
>
>>> ‐‐‐ Original Message ‐‐‐
>>>
>
>>> On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote:
>>>
>
Chris, do you have an M1 or Intel Mac?
>>>
>
> On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com wrote:
>>>
>
> Just another point of information, I had the same issue, but it was
> resolved after reinstalling F::Q as John mentions below.
>>>
>
>> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user
>> gnucash-user@gnucash.org wrote:
>>>
>
>>> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote:
>>>
>
On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user
gnucash-user@gnucash.org wrote:
>>>
>
Hello everyone,
>>>
>
I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS
Big Sur (11.0). Despite not being officially supported, GnuCash itself
works great, with the exception of Finance::Quote. The "get quotes"
button in the Price Database is grayed out and the Security Editor has
the warning "Finance::Quote isn't installed properly." When running
Gnucash-cli, there is a similar error:
>>>
>
> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get
> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>>>
>
> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>>>
>
> (process:2277): gnc.gui-WARNING **: 22:01:17.540:
> [mac_set_languages()] Language list: en:en_US:C
>>>
>
> - 22:01:17 INFO [gnc_module_init_backend_dbi] 3
> DBD drivers found
> - 22:01:17 INFO [gnc_module_init_backend_dbi]
> Driver: pgsql
> - 22:01:17 INFO [gnc_module_init_backend_dbi]
> Driver: sqlite3
> - 22:01:17 INFO [gnc_module_init_backend_dbi]
> Driver: mysql
> - 22:01:17 INFO [Gnucash::CoreApp::start] System locale
> returned (null)
> - 22:01:17 INFO [Gnucash::CoreApp::start] Effective
> locale set to en_US.UTF-8.
> - 22:01:17 INFO
> [gnc_gsettings_register_cb] schema: general, key: retain-days,
> settings_ptr: 0x7fde7e839430, handler_id: 1
> - 22:01:17 INFO
> [gnc_gsettings_register_cb] schema: general, key: retain-type-never,
> settings_ptr: 0x7fde7e839430, handler_id: 2
> - 22:01:17 INFO
> [gnc_gsettings_register_cb] schema: general, key: retain-type-days,
> settings_ptr: 0x7fde7e839430, handler_id: 3
> - 22:01:17 INFO
> [gnc_gsettings_register_cb] schema: general, key:
> retain-type-forever, settings_ptr: 0x7fde7e839430, handler_id: 4
> - 22:01:17 INFO
> [gnc_gsettings_register_cb] schema: general, key: file-compression,
> settings_ptr: 0x7fde7e839430, handler_id: 5
>>>
>
> No quotes retrieved. Finance::Quote isn't installed properly.
>
>
> - 22:01:17 INFO [gnc_hook_lookup] no hook lists
>>>
>
The error message above isn't particularly useful. It gets printed
here:
>>>
>
https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>>>
>
I'm pretty sure that Finance::Quote itself is installed properly. I'm
not really sure why GnuCash does not recognize it.
>>>
>
> $ sudo gnc-fq-update
>>>
>
> Reading '/Users/username/.cpan/Metadata'
>>>
>
> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>>>
>
> Date::Manip is up to date (6.83).
>>>
>
> Finance::Quote is up to date (1.49).
>>>
>
A basic query shows that it does work:
>>>
>
> $ echo '(yahoo_json "CSCO")' |
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>>>
>
> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00")
> (last . #e45.19) (currency . "USD")))
>>>
>
>>> BigSur
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Chris, this did not fix my issue. ‐‐‐ Original Message ‐‐‐ On Friday, January 22nd, 2021 at 9:17 AM, Chris Graves wrote: > I reinstalled (on my Intel Mac) by running: > > /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update > > > On Jan 21, 2021, at 5:43 PM, Justin jtrag...@pm.me wrote: > > > > Hello all, thank you for replying. I'm new to this email list. > > > > Dave, I do have an M1 Mac. Maybe that's part of the problem. > > > > Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't have > > an uninstall option. I did manually upgrade F::Q though, no change. > > Gnucash-cli still thinks it's installed improperly. > > > > Thanks, > > > > Justin > > > > ‐‐‐ Original Message ‐‐‐ > > > > On Thursday, January 21st, 2021 at 7:05 PM, davel...@mac.com wrote: > > > > > Chris, do you have an M1 or Intel Mac? > > > > > > On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com wrote: > > > > > > Just another point of information, I had the same issue, but it was > > > > resolved after reinstalling F::Q as John mentions below. > > > > > > > On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user > > > > > gnucash-user@gnucash.org wrote: > > > > > > > > On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote: > > > > > > > > > On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user > > > > > > > gnucash-user@gnucash.org wrote: > > > > > > > > > Hello everyone, > > > > > > > > > I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on > > > > > > > macOS Big Sur (11.0). Despite not being officially supported, > > > > > > > GnuCash itself works great, with the exception of Finance::Quote. > > > > > > > The "get quotes" button in the Price Database is grayed out and > > > > > > > the Security Editor has the warning "Finance::Quote isn't > > > > > > > installed properly." When running Gnucash-cli, there is a similar > > > > > > > error: > > > > > > > > > > $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes > > > > > > > > get > > > > > > > > /Users/username/Documents/Finances/Tracking/finances.gnucash > > > > > > > > --debug > > > > > > > > > > Application Path > > > > > > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli > > > > > > > > > > (process:2277): gnc.gui-WARNING **: 22:01:17.540: > > > > > > > > [mac_set_languages()] Language list: en:en_US:C > > > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_module_init_backend_dbi] 3 DBD drivers found > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_module_init_backend_dbi] Driver: pgsql > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_module_init_backend_dbi] Driver: sqlite3 > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_module_init_backend_dbi] Driver: mysql > > > > > > > > - 22:01:17 INFO [Gnucash::CoreApp::start] System > > > > > > > > locale returned (null) > > > > > > > > - 22:01:17 INFO [Gnucash::CoreApp::start] Effective > > > > > > > > locale set to en_US.UTF-8. > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_gsettings_register_cb] schema: general, key: retain-days, > > > > > > > > settings_ptr: 0x7fde7e839430, handler_id: 1 > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_gsettings_register_cb] schema: general, key: > > > > > > > > retain-type-never, settings_ptr: 0x7fde7e839430, handler_id: 2 > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_gsettings_register_cb] schema: general, key: > > > > > > > > retain-type-days, settings_ptr: 0x7fde7e839430, handler_id: 3 > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_gsettings_register_cb] schema: general, key: > > > > > > > > retain-type-forever, settings_ptr: 0x7fde7e839430, handler_id: 4 > > > > > > > > - 22:01:17 INFO > > > > > > > > [gnc_gsettings_register_cb] schema: general, key: > > > > > > > > file-compression, settings_ptr: 0x7fde7e839430, handler_id: 5 > > > > > > > > > > No quotes retrieved. Finance::Quote isn't installed properly. > > > > > > > > > > > > > > > > - 22:01:17 INFO [gnc_hook_lookup] no hook lists > > > > > > > > > The error message above isn't particularly useful. It gets > > > > > > > printed here: > > > > > > > > > https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91 > > > > > > > > > I'm pretty sure that Finance::Quote itself is installed properly. > > > > > > > I'm not really sure why GnuCash does not recognize it. > > > > > > > > > > $ sudo gnc-fq-update > > > > > > > > > > Reading '/Users/username/.cpan/Metadata' > > > > > > > > > > Database was generated on Wed, 20 Jan 2021 02:29:03 GMT > > > > > > > > > > Date::Manip is up to date (6.83). > > > > > > > > > > Finance::Quote is up to date (1.49). > > > > > > > > > A basic query shows that it does work: > > > > > > > > > > $ echo '(yahoo_json "CSCO")' | > > > > > > > >
Re: [GNC] Import CSV: save settings doesn't save
>>> the next time you run the csv import assistant the name you typed in should be present... That's the problem: the name I typed in doesn't show up. That's what I mean by "nothing happens". -marcus On Fri, Jan 22, 2021 at 8:19 AM John Ralls wrote: > > > > On Jan 22, 2021, at 7:26 AM, Marcus Winston < > mar...@thechocolatehouse.net> wrote: > > > > Hello, > > > > I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit > "faster". I see the "Save Settings" ( > https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save). > Unfortunately for me, saving settings doesn't work. I type in a name, click > the "Save" button, and nothing happens. I've tried looking at the > gnucash.trace file, with both --debug, and --debug --extra as command-line > options, but didn't find anything useful. Any suggestions or hints are > appreciated. > > What do you expect to happen? > > What should happen is that the next time you run the csv import assistant > the name you typed in should be present in the list for you to select and > if you select it your saved column types and other parameters--encoding, > date format, etc.--are reflected in the dialog. > > 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] Import CSV: save settings doesn't save
Hello, I'm using GnuCash 3.6 on Linux. Trying to get CSV import working a bit "faster". I see the "Save Settings" (https://www.gnucash.org/docs/v4/C/gnucash-guide/importing-from-files.html#importing-csv-save). Unfortunately for me, saving settings doesn't work. I type in a name, click the "Save" button, and nothing happens. I've tried looking at the gnucash.trace file, with both --debug, and --debug --extra as command-line options, but didn't find anything useful. Any suggestions or hints are appreciated. Thanks. -marcus ___ 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] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
I reinstalled (on my Intel Mac) by running:
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
> On Jan 21, 2021, at 5:43 PM, Justin wrote:
>
> Hello all, thank you for replying. I'm new to this email list.
>
> Dave, I do have an M1 Mac. Maybe that's part of the problem.
>
> Chris, how do you reinstall F::Q? The "perl -MCPAN -e shell" doesn't have an
> uninstall option. I did manually upgrade F::Q though, no change. Gnucash-cli
> still thinks it's installed improperly.
>
> Thanks,
> Justin
>
> ‐‐‐ Original Message ‐‐‐
>
> On Thursday, January 21st, 2021 at 7:05 PM, wrote:
>
>> Chris, do you have an M1 or Intel Mac?
>>
>
>>> On Jan 21, 2021, at 6:02 PM, Chris Graves mohaveba...@gmail.com wrote:
>>>
>
>>> Just another point of information, I had the same issue, but it was
>>> resolved after reinstalling F::Q as John mentions below.
>>>
>
On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user
gnucash-user@gnucash.org wrote:
>
> On Jan 21, 2021, at 12:12 PM, John Ralls jra...@ceridwen.us wrote:
>
>
>> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user
>> gnucash-user@gnucash.org wrote:
>>
>
>> Hello everyone,
>>
>
>> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS
>> Big Sur (11.0). Despite not being officially supported, GnuCash itself
>> works great, with the exception of Finance::Quote. The "get quotes"
>> button in the Price Database is grayed out and the Security Editor has
>> the warning "Finance::Quote isn't installed properly." When running
>> Gnucash-cli, there is a similar error:
>>
>
>>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get
>>> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>>>
>
>>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>>
>
>>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()]
>>> Language list: en:en_US:C
>>>
>
>>> - 22:01:17 INFO [gnc_module_init_backend_dbi] 3 DBD
>>> drivers found
>>> - 22:01:17 INFO [gnc_module_init_backend_dbi]
>>> Driver: pgsql
>>> - 22:01:17 INFO [gnc_module_init_backend_dbi]
>>> Driver: sqlite3
>>> - 22:01:17 INFO [gnc_module_init_backend_dbi]
>>> Driver: mysql
>>> - 22:01:17 INFO [Gnucash::CoreApp::start] System locale
>>> returned (null)
>>> - 22:01:17 INFO [Gnucash::CoreApp::start] Effective locale
>>> set to en_US.UTF-8.
>>> - 22:01:17 INFO [gnc_gsettings_register_cb]
>>> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430,
>>> handler_id: 1
>>> - 22:01:17 INFO [gnc_gsettings_register_cb]
>>> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430,
>>> handler_id: 2
>>> - 22:01:17 INFO [gnc_gsettings_register_cb]
>>> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430,
>>> handler_id: 3
>>> - 22:01:17 INFO [gnc_gsettings_register_cb]
>>> schema: general, key: retain-type-forever, settings_ptr:
>>> 0x7fde7e839430, handler_id: 4
>>> - 22:01:17 INFO [gnc_gsettings_register_cb]
>>> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430,
>>> handler_id: 5
>>>
>
>>>No quotes retrieved. Finance::Quote isn't installed properly.
>>> - 22:01:17 INFO [gnc_hook_lookup] no hook lists
>>
>
>> The error message above isn't particularly useful. It gets printed here:
>>
>
>> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>>
>
>> I'm pretty sure that Finance::Quote itself is installed properly. I'm
>> not really sure why GnuCash does not recognize it.
>>
>
>>> $ sudo gnc-fq-update
>>>
>
>>> Reading '/Users/username/.cpan/Metadata'
>>>
>
>>> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>>>
>
>>> Date::Manip is up to date (6.83).
>>>
>
>>> Finance::Quote is up to date (1.49).
>>
>
>> A basic query shows that it does work:
>>
>
>>> $ echo '(yahoo_json "CSCO")' |
>>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>>>
>
>>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00")
>>> (last . #e45.19) (currency . "USD")))
>
>
> BigSur absolutely is supported. What's not yet available yet is a native
> build for Apple Silicon, but I've found so far that the Intel build of
> GnuCash works fine with Rosetta2.
>
>
> The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q
> to get it working after I upgraded, but one could also set $PERL5LIB in
> the environment to include the old /Library/perl/5.18 as a workaround. If
> you did that in a shell rc file it would make gnc-fq-helper
Re: [GNC] GnuCash on macOS Big Sur "Finance::Quote isn't installed properly"
Intel
> On Jan 21, 2021, at 5:05 PM, davel...@mac.com wrote:
>
> Chris, do you have an M1 or Intel Mac?
>
>> On Jan 21, 2021, at 6:02 PM, Chris Graves wrote:
>>
>> Just another point of information, I had the same issue, but it was resolved
>> after reinstalling F::Q as John mentions below.
>>
>>> On Jan 21, 2021, at 2:38 PM, davelist--- via gnucash-user
>>> wrote:
>>>
>>>
>>>
On Jan 21, 2021, at 12:12 PM, John Ralls wrote:
> On Jan 19, 2021, at 8:32 PM, Justin via gnucash-user
> wrote:
>
> Hello everyone,
>
> I have an issue with GnuCash (4.4) and Finance::Quote (1.49) on macOS Big
> Sur (11.0). Despite not being officially supported, GnuCash itself works
> great, with the exception of Finance::Quote. The "get quotes" button in
> the Price Database is grayed out and the Security Editor has the warning
> "Finance::Quote isn't installed properly." When running Gnucash-cli,
> there is a similar error:
>
>> $ /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli --quotes get
>> /Users/username/Documents/Finances/Tracking/finances.gnucash --debug
>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash-cli
>>
>
>> (process:2277): gnc.gui-WARNING **: 22:01:17.540: [mac_set_languages()]
>> Language list: en:en_US:C
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] 3 DBD
>> drivers found
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> pgsql
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> sqlite3
>> * 22:01:17 INFO [gnc_module_init_backend_dbi] Driver:
>> mysql
>> * 22:01:17 INFO [Gnucash::CoreApp::start] System locale
>> returned (null)
>> * 22:01:17 INFO [Gnucash::CoreApp::start] Effective locale
>> set to en_US.UTF-8.
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-days, settings_ptr: 0x7fde7e839430,
>> handler_id: 1
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-never, settings_ptr: 0x7fde7e839430,
>> handler_id: 2
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-days, settings_ptr: 0x7fde7e839430,
>> handler_id: 3
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: retain-type-forever, settings_ptr: 0x7fde7e839430,
>> handler_id: 4
>> * 22:01:17 INFO [gnc_gsettings_register_cb]
>> schema: general, key: file-compression, settings_ptr: 0x7fde7e839430,
>> handler_id: 5
>> No quotes retrieved. Finance::Quote isn't installed properly.
>> * 22:01:17 INFO [gnc_hook_lookup] no hook lists
>
> The error message above isn't particularly useful. It gets printed here:
> https://github.com/Gnucash/gnucash/blob/1e7433daf3307fb3e6ff6d479aacb22d42941fda/gnucash/gnucash-commands.cpp#L91
>
> I'm pretty sure that Finance::Quote itself is installed properly. I'm not
> really sure why GnuCash does not recognize it.
>
>> $ sudo gnc-fq-update
>> Reading '/Users/username/.cpan/Metadata'
>> Database was generated on Wed, 20 Jan 2021 02:29:03 GMT
>> Date::Manip is up to date (6.83).
>> Finance::Quote is up to date (1.49).
>
> A basic query shows that it does work:
>
>> $ echo '(yahoo_json "CSCO")' |
>> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-helper
>> (("CSCO" (symbol . "CSCO") (gnc:time-no-zone . "2021-01-19 12:00:00")
>> (last . #e45.19) (currency . "USD")))
>
BigSur absolutely is supported. What's not yet available yet is a native
build for Apple Silicon, but I've found so far that the Intel build of
GnuCash works fine with Rosetta2.
The BigSur upgrade seems to have messed up perl; I had to reinstall F::Q
to get it working after I upgraded, but one could also set $PERL5LIB in
the environment to include the old /Library/perl/5.18 as a workaround. If
you did that in a shell rc file it would make gnc-fq-helper work from
terminal but not from GnuCash when run from LaunchServices.
Does F::Q work when starting GnuCash from the terminal?
Regards,
John Ralls
>>>
>>>
>>> I can confirm the same issue - quotes work from the command line (after
>>> re-installing finance quote) but in gnucash, the "get quotes" button is
>>> disabled. I am running this on an M1 Mac (so obviously Big Sur). My old Mac
>>> (where quotes work) is running Catalina (and the M1 Mac was set up from a
>>> Time Machine backup of the old Maco) so I don't know if it's a M1 issue or
>>> a Big Sur issue.
>>>
>>> Justin, are you using an M1 Mac?
>>>
>>> Thanks,
>>> Dave
>>>
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
Re: [GNC] Representing fund restructure in Gnucash
For what it's worth, users should also know that this method establishes a new date of acquisition for the shares, which may affect short term versus long term capital gains calculations if the user isn't careful. Original Message From: Robin Chattopadhyay Sent: Fri Jan 22 08:32:45 EST 2021 To: Peter Lamb Cc: Gnucash Users Subject: Re: [GNC] Representing fund restructure in Gnucash Hi Peter- This is also how I have done similar transactions (and in-kind transfers to a new broker). One thing to note is that this method will also create a new price record in the price database. So I also go into the price editor and remove that extra, invalid price. On Fri, Jan 22, 2021 at 3:35 AM Geoff wrote: > Hi Peter > > From what you have said, the new security will inherit the old > security's cost base. So I would create a transaction to reduce the old > one to zero and add the new quantity to the new one. Blank out the > price and put in the cost base as the value - GnuCash will calculate the > price. > > Screenshot #1 attached shows an example where "BHP" is the old security, > and "CBA" is the new security. > > Hope this helps. > > Geoff > = > > On 22/01/2021 6:08 pm, Peter Lamb via gnucash-user wrote: > > I own some Exchange Traded Fund stocks, and one of the stocks has been > > restructured: the stock I owned has been converted into another stock, > > so that 1 ABC share (the original stock) has been converted into N DEF > > shares. I have only been provided with the ratio of share values, not > > with prices. No money changed hands. > > > > How do I represent this in Gnucash? > > > > Peter > > > ___ > 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. > -- --- Typed with my thumbs and sent from my iPad. ___ 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] Switching to trading accounts in existing database
Hi Mike, Lukas, I am using trading accounts since multiple years and can confirm that the UI can be pretty cumbersome. I got used to it. Besides the regular problems in getting the transactions straight it works pretty well Cheers, Christoph > Am 22.01.2021 um 06:13 schrieb Mike Alexander : > > When I implemented trading accounts several years ago they were a bit > controversial. Some people thought they were more trouble than they were > worth and argued that they should be an opt-in choice. One of the initial > design goals was that if you didn't turn them on nothing would change in the > way GnuCash behaved. The initial implementation had some rough edges too, > which didn't help. It's been a while since any significant problems have > come up with them (although a new bug was filed on them today) so maybe this > question should be revisited. > > It's also the case that the user interface leaves a bit to be desired. It is > harder than it should be to enter multi-currency transactions with trading > accounts turned on. At the time I implemented them there was an effort > underway to rewrite the code that supports the register UI and the new > implementation would have improved this. Unfortunately that effort was later > abandoned and we're left with the old UI code. I have ideas for how to > improve it, but my time and ability to do much coding is limited these days > so I probably won't get to it soon. See > https://bugs.gnucash.org/show_bug.cgi?id=797913 for more information about > this. > > I know what you mean about multiple currencies. I haven't moved around as > often as you have, but I've lived in a couple of countries and spend a lot of > time traveling in various others. I think I have accounts in nearly 30 > currencies over a 30 year period. I used to have income and expense accounts > in multiple currencies, but this turned out to not work well so I now use > only one currency for all of them and convert transactions in other > currencies into USD. This works for me since it is still my home currency > although I am under increasing pressure to move to Canada. > > Mike > > On 21 Jan 2021, at 21:06, Lukas Haase wrote: > >> Hi Christopher, >> >> This is very sad. Sad for various reasons. >> >> I went over these documents previously (but did not read them thoroughly). >> >> My takeaway is: >> * Storing the conversion rate per transaction makes the accounting equation >> as a function of time inconsistent (but it is consistent for each snaphot in >> time). >> * Trading account accounts for these inaccuracies. >> >> My question was more why the trading accounts (which seem to me the cleaner, >> superior and better way) are not enabled by default. >> >> Also, can you comment a bit more why precicely this would be a major >> minefield? (If you know it, of course). >> >> Multiple databases are just extremely hard for some people (like me). >> >> Consider living for a couple of months to a year in a different place. There >> is just no way to separate this in a clean way without replicating all the >> transactions in different databases. BTDT. >> >> Also I moved multiple times. Even then, there is no clear cut: Initially I >> would use credit cards, ATM etc. from previous country. Even the first or >> second rent may be partially paid with funds from the previous location. It >> takes a few months until I could consider the books between two countries >> sufficiently separate. The only ways are a) Massive transaction Replication >> b) booking everything I pay with funds from old country into old database. >> But with my rent example, it gets very inconsistent how much I paid rent at >> the new place. >> >> Lastly, simple portfolio accounting (e.g. crypto currencies) if they are >> bought in different countries. >> >> I am curious what the potential mines are so I can try to avoid them. >> >> Lukas >> >> >> >> On 2021-01-21 20:20, Christopher Lam wrote: >>> Multicurrency is a major minefield. >>> Start from https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html >>> and finish with >>> https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the >>> background on trading accounts. >>> From discussion with accountant, it would seem that the safest approach is >>> to have 1 book per home currency. When you move countries you'd be better >>> off with a new book with a new home currency. Taking temporary trips abroad >>> gets the currencies translated to home currency. AFAIU. IANAA YMMV. >>> https://techcrunch.com/2010/08/14/internet-must-be-true/ >>> >>> On Fri, 22 Jan 2021 at 00:59, Lukas Haase wrote: >>> Hi Mike, On 2021-01-21 02:24, Mike Alexander wrote: > On 19 Jan 2021, at 20:08, Lukas Haase wrote: > >> So I got recommended using trading accounts. But suddenly all my >> previous multi-currency transactions get a small grey box with a cross >> (hinting the transaction is
Re: [GNC] Representing fund restructure in Gnucash
Hi Peter- This is also how I have done similar transactions (and in-kind transfers to a new broker). One thing to note is that this method will also create a new price record in the price database. So I also go into the price editor and remove that extra, invalid price. On Fri, Jan 22, 2021 at 3:35 AM Geoff wrote: > Hi Peter > > From what you have said, the new security will inherit the old > security's cost base. So I would create a transaction to reduce the old > one to zero and add the new quantity to the new one. Blank out the > price and put in the cost base as the value - GnuCash will calculate the > price. > > Screenshot #1 attached shows an example where "BHP" is the old security, > and "CBA" is the new security. > > Hope this helps. > > Geoff > = > > On 22/01/2021 6:08 pm, Peter Lamb via gnucash-user wrote: > > I own some Exchange Traded Fund stocks, and one of the stocks has been > > restructured: the stock I owned has been converted into another stock, > > so that 1 ABC share (the original stock) has been converted into N DEF > > shares. I have only been provided with the ratio of share values, not > > with prices. No money changed hands. > > > > How do I represent this in Gnucash? > > > > Peter > > > ___ > 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. > -- --- Typed with my thumbs and sent from my iPad. ___ 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] Switching to trading accounts in existing database
Personally I'd stick with 1 book = 1 currency, and record all transactions in their home currency only. I'd only record the same transaction in both books if they're a formal currency transfer. A simple issue is balance sheet: if you hold stocks eg TSLA in your USD account, and ANA from your Japan account... the overall balance sheet in USD will convert ANA->JPY->USD. This has a chance of being accurate if you have *daily* USD/JPY prices. Most users don't. On Fri, 22 Jan 2021 at 02:06, Lukas Haase wrote: > Hi Christopher, > > This is very sad. Sad for various reasons. > > I went over these documents previously (but did not read them thoroughly). > > My takeaway is: > * Storing the conversion rate per transaction makes the accounting > equation as a function of time inconsistent (but it is consistent for > each snaphot in time). > * Trading account accounts for these inaccuracies. > > My question was more why the trading accounts (which seem to me the > cleaner, superior and better way) are not enabled by default. > > Also, can you comment a bit more why precicely this would be a major > minefield? (If you know it, of course). > > Multiple databases are just extremely hard for some people (like me). > > Consider living for a couple of months to a year in a different place. > There is just no way to separate this in a clean way without replicating > all the transactions in different databases. BTDT. > > Also I moved multiple times. Even then, there is no clear cut: Initially > I would use credit cards, ATM etc. from previous country. Even the first > or second rent may be partially paid with funds from the previous > location. It takes a few months until I could consider the books between > two countries sufficiently separate. The only ways are a) Massive > transaction Replication b) booking everything I pay with funds from old > country into old database. But with my rent example, it gets very > inconsistent how much I paid rent at the new place. > > Lastly, simple portfolio accounting (e.g. crypto currencies) if they are > bought in different countries. > > I am curious what the potential mines are so I can try to avoid them. > > Lukas > > > > On 2021-01-21 20:20, Christopher Lam wrote: > > Multicurrency is a major minefield. > > Start from > https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html > > and finish with > > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the > > background on trading accounts. > > From discussion with accountant, it would seem that the safest approach > is > > to have 1 book per home currency. When you move countries you'd be better > > off with a new book with a new home currency. Taking temporary trips > abroad > > gets the currencies translated to home currency. AFAIU. IANAA YMMV. > > https://techcrunch.com/2010/08/14/internet-must-be-true/ > > > > On Fri, 22 Jan 2021 at 00:59, Lukas Haase wrote: > > > >> Hi Mike, > >> > >> On 2021-01-21 02:24, Mike Alexander wrote: > >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote: > >>> > So I got recommended using trading accounts. But suddenly all my > previous multi-currency transactions get a small grey box with a cross > (hinting the transaction is inconsistent). > > How do I best deal with this? > Is it possible to keep my old multi currency transactions as-is and > use trading accounts only for securities/stocks? > > If not, how do I migrate while ensuring my ten years worth of data > does not suddenly get inconsistent? > >>> > >>> You should be able to use the "Check & Repair" commands in the Actions > >>> menu to add the trading account splits to existing transactions. I > >>> would certainly save a copy of my data before doing this, and try it on > >>> a few transactions first. Your situation is complex enough that it is > >>> not unlikely that this won't do exactly what you want, but it's worth a > >>> try assuming you have good backup. > >> > >> Thank you, I think that worked indeed. > >> > >> I still need to cross-check everything (at the first glance things look > >> OK). > >> > >> So then I'd have a general question on the multi currency feature: > >> > >> 1.) Are "Trading Accounts" just an *alternative* way to handle multi > >> currencies (and as such have nothing to do with "trading")? > >> > >> 2.) Trading Account seem to be way more powerful than storing the > >> exchange rate in each transaction > >> > >> 3.) Why exactly aren't they enabled by default if they are so superior? > >> Why let people my default use the way that makes things less consistent > >> and error-prone? > >> > >> Thanks, > >> Lukas > >> > >> > >> > >> > >> ___ > >> 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 > >>
Re: [GNC] Switching to trading accounts in existing database
The issue is when currency fluctuates, you have capital gains or losses, depending on whatever you consider to be your home currency. These gains/losses are unrecorded (but not unrealised). C On Fri, 22 Jan 2021 at 04:36, w...@theprescotts.com wrote: > I am probably missing something here. > > I have bank accounts in two countries and regularly transfer money between > them. Whenever I move money, I record the transaction and the amount for > each side of the transaction. Gnucash automatically makes an entry in the > Price Database recording the conversion rate. > > It seems much cleaner than treating one currency or the other as a > commodity that is bought or sold at some rate. One thing that is a little > strange is that the Price Database has separate tables for each direction. > I suppose it depends on which side of the transaction I use to record the > transfer. But I almost never look at the Price Database so it doesn't > bother me much. > > Will > > On 2021 Jan 21, at 01-21 20:06:04, Lukas Haase wrote: > > Hi Christopher, > > This is very sad. Sad for various reasons. > > I went over these documents previously (but did not read them thoroughly). > > My takeaway is: > * Storing the conversion rate per transaction makes the accounting > equation as a function of time inconsistent (but it is consistent for each > snaphot in time). > * Trading account accounts for these inaccuracies. > > My question was more why the trading accounts (which seem to me the > cleaner, superior and better way) are not enabled by default. > > Also, can you comment a bit more why precicely this would be a major > minefield? (If you know it, of course). > > Multiple databases are just extremely hard for some people (like me). > > Consider living for a couple of months to a year in a different place. > There is just no way to separate this in a clean way without replicating > all the transactions in different databases. BTDT. > > Also I moved multiple times. Even then, there is no clear cut: Initially I > would use credit cards, ATM etc. from previous country. Even the first or > second rent may be partially paid with funds from the previous location. It > takes a few months until I could consider the books between two countries > sufficiently separate. The only ways are a) Massive transaction Replication > b) booking everything I pay with funds from old country into old database. > But with my rent example, it gets very inconsistent how much I paid rent at > the new place. > > Lastly, simple portfolio accounting (e.g. crypto currencies) if they are > bought in different countries. > > I am curious what the potential mines are so I can try to avoid them. > > Lukas > > > > On 2021-01-21 20:20, Christopher Lam wrote: > > Multicurrency is a major minefield. > > Start from > https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html > > and finish with > > https://www.mathstat.dal.ca/~selinger/accounting/gnucash.html for the > > background on trading accounts. > > From discussion with accountant, it would seem that the safest approach > is > > to have 1 book per home currency. When you move countries you'd be better > > off with a new book with a new home currency. Taking temporary trips > abroad > > gets the currencies translated to home currency. AFAIU. IANAA YMMV. > > https://techcrunch.com/2010/08/14/internet-must-be-true/ > > On Fri, 22 Jan 2021 at 00:59, Lukas Haase wrote: > >> Hi Mike, > >> > >> On 2021-01-21 02:24, Mike Alexander wrote: > >>> On 19 Jan 2021, at 20:08, Lukas Haase wrote: > >>> > So I got recommended using trading accounts. But suddenly all my > previous multi-currency transactions get a small grey box with a cross > (hinting the transaction is inconsistent). > > How do I best deal with this? > Is it possible to keep my old multi currency transactions as-is and > use trading accounts only for securities/stocks? > > If not, how do I migrate while ensuring my ten years worth of data > does not suddenly get inconsistent? > >>> > >>> You should be able to use the "Check & Repair" commands in the Actions > >>> menu to add the trading account splits to existing transactions. I > >>> would certainly save a copy of my data before doing this, and try it on > >>> a few transactions first. Your situation is complex enough that it is > >>> not unlikely that this won't do exactly what you want, but it's worth a > >>> try assuming you have good backup. > >> > >> Thank you, I think that worked indeed. > >> > >> I still need to cross-check everything (at the first glance things look > >> OK). > >> > >> So then I'd have a general question on the multi currency feature: > >> > >> 1.) Are "Trading Accounts" just an *alternative* way to handle multi > >> currencies (and as such have nothing to do with "trading")? > >> > >> 2.) Trading Account seem to be way more powerful than storing the > >> exchange rate in each transaction > >> > >> 3.) Why exactly aren't they
Re: [GNC] Representing fund restructure in Gnucash
You could use the stock split assistant to record the stock split (cannot record stock split using the register only), then use the security editor to rename the stock. Someone else may have better ideas. On Fri, 22 Jan 2021, 3:59 pm Peter Lamb via gnucash-user, < gnucash-user@gnucash.org> wrote: > I own some Exchange Traded Fund stocks, and one of the stocks has been > restructured: the stock I owned has been converted into another stock, > so that 1 ABC share (the original stock) has been converted into N DEF > shares. I have only been provided with the ratio of share values, not > with prices. No money changed hands. > > How do I represent this in Gnucash? > > Peter > > -- > > Peter Lamb > > Canberra, ACT > > ___ > 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] Representing fund restructure in Gnucash
Hi Peter From what you have said, the new security will inherit the old security's cost base. So I would create a transaction to reduce the old one to zero and add the new quantity to the new one. Blank out the price and put in the cost base as the value - GnuCash will calculate the price. Screenshot #1 attached shows an example where "BHP" is the old security, and "CBA" is the new security. Hope this helps. Geoff = On 22/01/2021 6:08 pm, Peter Lamb via gnucash-user wrote: I own some Exchange Traded Fund stocks, and one of the stocks has been restructured: the stock I owned has been converted into another stock, so that 1 ABC share (the original stock) has been converted into N DEF shares. I have only been provided with the ratio of share values, not with prices. No money changed hands. How do I represent this in Gnucash? Peter ___ 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] Representing fund restructure in Gnucash
I own some Exchange Traded Fund stocks, and one of the stocks has been restructured: the stock I owned has been converted into another stock, so that 1 ABC share (the original stock) has been converted into N DEF shares. I have only been provided with the ratio of share values, not with prices. No money changed hands. How do I represent this in Gnucash? Peter -- Peter Lamb Canberra, ACT ___ 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.
