Re: [GNC] Finance::Quote on a Mac with a foreign perl
On Sat Apr 27, 2024 at 21:13:22 Mr. Ralls wrote: I just remembered a third case that's probably the same problem: https://bugs.gnucash.org/show_bug.cgi?id=799195 complained that it took 15 minutes to install the F::Q dependencies and the attempt ultimately failed because SSLeay failed its unit tests. I concur. I also have some agreement with Mr. Williams who opened that bug. While I understand doing the quote retrieval natively in GnuCash would be problematic for how much they need to be changed (especially recently), I am at least slightly surprised there hasn't been an effort to replace F::Q with something written in Python or another language. macOS is macOS. They don't change anything for the hardware, not even the build: Everything in the OS is universal binaries with x86_64 snd arm64. It's possible that Xcode/command-line tools adds stuff to /System/Library/Perl/Extras, but the user said he has both installed. I've asked him about what year MBA and what version of macOS. Perhaps there's a clue there. I get the macOS is macOS thing. But I've ended up down too many rabbit holes because of assumptions that turned out wrong. I would find it odd that XCode would know to add stuff for Perl, but again, I don't want to assume it doesn't. As for XCode command line tools being installed, I would think if they were, then wouldn't the libssl header files that the user's cpan output indicated were missing *not* be missing? It's been a while since I installed Xcode and the extra XCode bits on either of the Macs in my possession. Take care sir. I think it's time for my scotch nightcap. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 Pre-Release 1.61_02 Uploaded to CPAN
Earlier, I wrote: Another option for retrieving US quotes is MarketWatch. No API key needed. And... scratch that. They must have recently made changes as I successfully tested this method 2 or 3 days ago. 1 gets fixed, 2 no longer work. Aggravating as all hell. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] loading a CPAN something from Windows
On Windows there's a perl terminal under Strawberry Perl in the Start menu. Fire that up and then say `cpan -i BPSCHUCK/Finance-Quote-1.61_02.tar.gz" Regards, John Ralls > On Apr 27, 2024, at 6:32 PM, fromvendor wrote: > > Hi, regarding the below I'm trying to figure out how to run the update from > Widows. > > Where do I go to fire off cpan/cpanm? Or is it wrapped in something else on > windows? > > What happens if I simply run the original stuffs that I used to install F::Q > in the first place? > > -greg > > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf > Of Bruce Schuck > Sent: Saturday, April 27, 2024 6:35 PM > To: GnuCash User > Subject: [GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN > > Greetings, > > Finance::Quote v1.61_02 has been uploaded to CPAN. > > Changes since 1.61 > > * Modified yahooJSON.pm module in order handle EU consent redirects better. > > * TwelveData.pm - Added "last" to data being returned. The method > "twelvedata" was returning a value for "close". GnuCash expects "last" > or "price" in order to utilize the quote data. > > * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds > using ISIN > > * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes > from Yahoo. > > Using cpan or cpanm, install "BPSCHUCK/Finance-Quote-1.61_02.tar.gz". > > TwelveData has data for US and foreign exchanges. It does require an API > key from https://twelvedata.com/. > > Another option for retrieving US quotes is MarketWatch. No API key needed. > > I'm still trying to resurrect the Fool module. But hit another wall when > getting "too many requests" after only a half dozen requests. Even when > spaced out at 20 seconds per request. > > Thank you. > > Bruce S. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] loading a CPAN something from Windows
Hi, regarding the below I'm trying to figure out how to run the update from Widows. Where do I go to fire off cpan/cpanm? Or is it wrapped in something else on windows? What happens if I simply run the original stuffs that I used to install F::Q in the first place? -greg -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Saturday, April 27, 2024 6:35 PM To: GnuCash User Subject: [GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN Greetings, Finance::Quote v1.61_02 has been uploaded to CPAN. Changes since 1.61 * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned. The method "twelvedata" was returning a value for "close". GnuCash expects "last" or "price" in order to utilize the quote data. * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Using cpan or cpanm, install "BPSCHUCK/Finance-Quote-1.61_02.tar.gz". TwelveData has data for US and foreign exchanges. It does require an API key from https://twelvedata.com/. Another option for retrieving US quotes is MarketWatch. No API key needed. I'm still trying to resurrect the Fool module. But hit another wall when getting "too many requests" after only a half dozen requests. Even when spaced out at 20 seconds per request. Thank you. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 on a Mac with a foreign perl
> On Apr 27, 2024, at 2:32 PM, Bruce Schuck wrote: > > On Fri Apr 26, 2024, at 12:07:04 EDT Mr Ralls wrote: > >> Here's an example of a failed session with Homebrew interference: >> https://paste.jvnv.net/view/CcsOd This comes from an IRC discussion at >> https://code.gnucash.org/logs/2024/04/16.html#T06:46:33. There >> was an earlier exchange with another longer dump that implicated >> Homebrew in which I told the user to clean it out but gncbot was >> apparently offline when that occurred and I don't have a link to it. >> In the dump you can see that the user is invoking gnc-fq-update and >> that it's running /usr/bin/perl. Later at line 97 you can see that >> /System/Library/Perl/Extras/5.34 is missing from @INC. That's where the >> pre-built networking modules are. > > John, > > That is indeed odd. I have two Macbook Pros. One Intel based running OSX > Catalina (It's a 2016 model), and a fairly new M1 running OSX Ventura. Both > have HomeBrew's Perl installed along side the Apple bundled Perl. "Perl -V" > does include "/System/Library/Perl/Extras/5.XX" on both (Catalina is 5.18, > Ventura is 5.30). "@INC" in Perl is compiled. Installation of the HomeBrew > Perl should in no way affect the value of @INC in the OSX bundled Perl. Most > people wanting to modify @INC do so by a number of ways. Setting PERL5LIB, > adding "-I" when executing Perl, or adding something like "use lib > '/home/foobar/code';" to the Perl code are some examples. > > As Vince showed, the HomeBrew Perl typically installs its modules under the > $HOME/perl5 path, or as I see on my Ventura Mac, /opt/homebrew/Cellar/. > > From the command line prompt in the session, it appears the user having the > issue is on a MacBook Air. I wonder if the included version of Perl is not > the same as what gets installed on a MacBook? > > I'd be curious to see the output of this find command from that user's Mac. > > find /Library/Perl /System/Library/Perl -path '*/Net/*' -type f -name > 'SSLeay.pm' > > Or more simply, does /System/Library/Perl/Extras exist on the user's MacBook > Air? > > That path may not be in the system Perl's @INC, because it's not part of the > Apple Perl package. Bruce, The user who made the log file is on IRC, handle englishman. I just pinged him about it. I have no info at all about the fellow who added the instruction to point openssl requests at Homebrew's libopenssl. I just remembered a third case that's probably the same problem: https://bugs.gnucash.org/show_bug.cgi?id=799195 complained that it took 15 minutes to install the F::Q dependencies and the attempt ultimately failed because SSLeay failed its unit tests. macOS is macOS. They don't change anything for the hardware, not even the build: Everything in the OS is universal binaries with x86_64 snd arm64. It's possible that Xcode/command-line tools adds stuff to /System/Library/Perl/Extras, but the user said he has both installed. I've asked him about what year MBA and what version of macOS. Perhaps there's a clue there. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Nothing Wrong
Piling on here. Compared to most software I use that's actively maintained, GnuCash is satisfyingly stable and functional. Seldom needs attention to anything other than my own bookkeeping errors. Thanks! And thanks also for this newsgroup! I've learned a few things about basic bookkeeping and accounting issues that are helpful, and go beyond what was in the books used in the basic classes back in the last century (real paper textbooks! early days of "pocket" calculators (I got a Commodore PR-100 while in the first semester; still have it, and it still works)!). In my case, I came to GnuCash from a spreadsheet-based home bookkeeping setup that had become just too complicated and unmaintainable. Spent more time fighting with formatting and broken formulae/links (it was multiple pages per multiple files all cross-linked with each other ... yeah, right) than with actually keeping the records. Spreadsheets were great for my limited needs in the '80s (Visicalc 1.0 on TRS-80) and '90s (Quattro Pro then Star/LibreOffice), but by 2020 I needed something real. Again, thanks! We don't say that often enough. Mike Brady From my ancient taglines file> bookkeepers prepare the ingredients, accountants do the cooking, auditors figure out the recipe. On 4/25/2024 5:05 AM, gnucash-user-requ...@gnucash.org wrote: Message: 1 Date: Wed, 24 Apr 2024 12:19:20 -0500 From: R Losey To: Jim Muchow Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Nothing Wrong Message-ID: Content-Type: text/plain; charset="UTF-8" On Tue, Apr 23, 2024 at 4:00?PM Jim Muchow wrote: I want you maintainers and developers to know that I run GnuCash just fine and don't have problems. I very much appreciate such a great free product. Thanks. I kinda wanted to make this an annual thing but I have not been consistent about this and for that I apologize. Also this is not response to any one or more of the problem reports. Just a note of thanks. I'll add my voice to the growing chorus. I switched from Quicken in 2016 and am very, very happy with GnuCash itself, and for the additional things I've learned following this newsgroup. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN
Greetings, Finance::Quote v1.61_02 has been uploaded to CPAN. Changes since 1.61 * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned. The method "twelvedata" was returning a value for "close". GnuCash expects "last" or "price" in order to utilize the quote data. * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Using cpan or cpanm, install "BPSCHUCK/Finance-Quote-1.61_02.tar.gz". TwelveData has data for US and foreign exchanges. It does require an API key from https://twelvedata.com/. Another option for retrieving US quotes is MarketWatch. No API key needed. I'm still trying to resurrect the Fool module. But hit another wall when getting "too many requests" after only a half dozen requests. Even when spaced out at 20 seconds per request. Thank you. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 on a Mac with a foreign perl
On Fri Apr 26, 2024, at 12:07:04 EDT Mr Ralls wrote: Here's an example of a failed session with Homebrew interference: https://paste.jvnv.net/view/CcsOd This comes from an IRC discussion at https://code.gnucash.org/logs/2024/04/16.html#T06:46:33. There was an earlier exchange with another longer dump that implicated Homebrew in which I told the user to clean it out but gncbot was apparently offline when that occurred and I don't have a link to it. In the dump you can see that the user is invoking gnc-fq-update and that it's running /usr/bin/perl. Later at line 97 you can see that /System/Library/Perl/Extras/5.34 is missing from @INC. That's where the pre-built networking modules are. John, That is indeed odd. I have two Macbook Pros. One Intel based running OSX Catalina (It's a 2016 model), and a fairly new M1 running OSX Ventura. Both have HomeBrew's Perl installed along side the Apple bundled Perl. "Perl -V" does include "/System/Library/Perl/Extras/5.XX" on both (Catalina is 5.18, Ventura is 5.30). "@INC" in Perl is compiled. Installation of the HomeBrew Perl should in no way affect the value of @INC in the OSX bundled Perl. Most people wanting to modify @INC do so by a number of ways. Setting PERL5LIB, adding "-I" when executing Perl, or adding something like "use lib '/home/foobar/code';" to the Perl code are some examples. As Vince showed, the HomeBrew Perl typically installs its modules under the $HOME/perl5 path, or as I see on my Ventura Mac, /opt/homebrew/Cellar/. From the command line prompt in the session, it appears the user having the issue is on a MacBook Air. I wonder if the included version of Perl is not the same as what gets installed on a MacBook? I'd be curious to see the output of this find command from that user's Mac. find /Library/Perl /System/Library/Perl -path '*/Net/*' -type f -name 'SSLeay.pm' Or more simply, does /System/Library/Perl/Extras exist on the user's MacBook Air? That path may not be in the system Perl's @INC, because it's not part of the Apple Perl package. Bruce S P.S. My older Intel based Mac actually has 3 separate Perls installed. The third being one built from source where the paths in @INC are all under /usr/local/bpsperl/. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up gnucash / stocks
> On Apr 27, 2024, at 7:28 AM, Wolfgang Paul Rauchholz > wrote: > > Hello community! > > I am running the latest gnucash under Fedorca Core. > Finance::Quote is installed and I get quotes for Funds and Stocks. > > EUR is the System Currency. The Stock Quotes are in USD > > Did I set up the initial balance correctly for Stocks (please see > attached screenshot)? I used the Stock Assistant whose transactional > currency is in EUR, but the stock quotes are in USD. Does this work? > > > The reporting of the values in EUR does not seem to be correct. How do I set > up currency correctly? In my setup, is USD or EUR the Security? > > > Thanks for your help. > You need to create a USD-denominated account of type Assets and make it the parent of the Danaher account. 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up gnucash / stocks
On Sat, Apr 27, 2024 at 9:29 AM Wolfgang Paul Rauchholz < wp.rauchh...@gmail.com> wrote: > Hello community! > > I am running the latest gnucash under Fedorca Core. > Finance::Quote is installed and I get quotes for Funds and Stocks. > > EUR is the System Currency. The Stock Quotes are in USD > > Did I set up the initial balance correctly for Stocks (please see > attached screenshot)? I used the Stock Assistant whose transactional > currency is in EUR, but the stock quotes are in USD. Does this work? > > > The reporting of the values in EUR does not seem to be correct. How do I > set > up currency correctly? In my setup, is USD or EUR the Security? > > > Thanks for your help. > > Welcome! Very interesting problem. Perhaps it is the source you are using for the Quotes that is reporting is USD?? When I look at my 5.6 Security setup, there is nothing about the stocks that say that they should be evaluated in USD. Nor is there anything in their related account in the investment account. Can you attempt to use different sources for the Finance::Quote? Another thought: Do you get the quotes from within GnuCash, or are you running the quotes manually (as with 'cron')? It may be that you have EUR set as the system currency in GnuCash, but the quote program isn't aware of the setting? -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Setting up gnucash / stocks
Hello community! I am running the latest gnucash under Fedorca Core. Finance::Quote is installed and I get quotes for Funds and Stocks. EUR is the System Currency. The Stock Quotes are in USD Did I set up the initial balance correctly for Stocks (please see attached screenshot)? I used the Stock Assistant whose transactional currency is in EUR, but the stock quotes are in USD. Does this work? The reporting of the values in EUR does not seem to be correct. How do I set up currency correctly? In my setup, is USD or EUR the Security? Thanks for your help. Wolfgang Rauchholz +34 627 994 977 https://www.linkedin.com/in/wolfgangrauchholz/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF imports fails in 5.6
Hello Nodje Please read this: https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111431.html Regards Geoff = On 27/04/2024 3:21 pm, coolnodje wrote: Hi, QIF imports is failing in 5.6. I had to revert to 5.5 to be able to be able ro import as usual. The error message is "Missing QIF investment action for transaction dated 02.04.2024." Let me know how can I help, I'm unsure where to find more meaningful logs. /nodje ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF imports fails in 5.6
That's a known issue that is being worked on. David T. On Apr 27, 2024, 8:23 AM, at 8:23 AM, coolnodje wrote: >Hi, > >QIF imports is failing in 5.6. >I had to revert to 5.5 to be able to be able ro import as usual. > >The error message is "Missing QIF investment action for transaction >dated 02.04.2024." > >Let me know how can I help, I'm unsure where to find more meaningful >logs. > >/nodje > >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.