[GNC] Installing or updating Finance::Quote
I've started this thread separately from "[GNC] getting price quotes" (from which I gained helpful advice last week), as it's a more specific problem I now face. Following the advice from David H and others last week, I eventually decided to upgrade from GC version 3.5 to 4.12, in the hope that it would automatically install the latest version of Finance::Quote and enable me to resume downloading stock prices again. I'm using Windows 10 and the previously installed version of F::Q was 1.47, which had worked without problems until the first week of November. The upgrade to GC v4.12 turned out to be more straightforward than I'd previously feared, but I then found that F::Q was still on 1.47, and attempts to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start menu have been unsuccessful, so I'm hoping someone can point me in the direction of a solution. I should add that, prior to the GC update, I installed the latest version of Strawberry Perl (v5.32.1), after first removing the previous version (v5.18.2). Regards,Alan ___ 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] Installing or updating Finance::Quote
Alan Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the version. if it is not 1.52, you may need to download and replace the file Saludos Cordiales Murugan From: gnucash-user on behalf of aeg via gnucash-user Sent: Friday, December 9, 2022 2:40 PM To: gnucash-user@gnucash.org Subject: [GNC] Installing or updating Finance::Quote I've started this thread separately from "[GNC] getting price quotes" (from which I gained helpful advice last week), as it's a more specific problem I now face. Following the advice from David H and others last week, I eventually decided to upgrade from GC version 3.5 to 4.12, in the hope that it would automatically install the latest version of Finance::Quote and enable me to resume downloading stock prices again. I'm using Windows 10 and the previously installed version of F::Q was 1.47, which had worked without problems until the first week of November. The upgrade to GC v4.12 turned out to be more straightforward than I'd previously feared, but I then found that F::Q was still on 1.47, and attempts to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start menu have been unsuccessful, so I'm hoping someone can point me in the direction of a solution. I should add that, prior to the GC update, I installed the latest version of Strawberry Perl (v5.32.1), after first removing the previous version (v5.18.2). Regards,Alan ___ 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] Installing or updating Finance::Quote
Murugan, Thank you for your suggestion.There is no folder named "Finance" at that location, but I searched for quote.pm within Strawberry and found it at each of these locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance (version 1.5301) C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301) C:\Strawberry\perl\vendor\lib\Sub (version 2.006006) C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270) I don't know whether that helps to clarify the problem. Regards,Alan On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam wrote: Alan Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the version. if it is not 1.52, you may need to download and replace the file Saludos Cordiales Murugan From: gnucash-user on behalf of aeg via gnucash-user Sent: Friday, December 9, 2022 2:40 PM To: gnucash-user@gnucash.org Subject: [GNC] Installing or updating Finance::Quote I've started this thread separately from "[GNC] getting price quotes" (from which I gained helpful advice last week), as it's a more specific problem I now face. Following the advice from David H and others last week, I eventually decided to upgrade from GC version 3.5 to 4.12, in the hope that it would automatically install the latest version of Finance::Quote and enable me to resume downloading stock prices again. I'm using Windows 10 and the previously installed version of F::Q was 1.47, which had worked without problems until the first week of November. The upgrade to GC v4.12 turned out to be more straightforward than I'd previously feared, but I then found that F::Q was still on 1.47, and attempts to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start menu have been unsuccessful, so I'm hoping someone can point me in the direction of a solution. I should add that, prior to the GC update, I installed the latest version of Strawberry Perl (v5.32.1), after first removing the previous version (v5.18.2). Regards,Alan ___ 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] Installing or updating Finance::Quote
Hi Alan It looks like the install has failed for some reason as the modules should be under: C:\Strawberry\perl\site\lib\Finance\ The entries under "perl\vendor" are not related to Finance::Quote and are irrelevant. I suggest that you try to install it again. The installation can be a bit fiddly as there are a number of dependencies, and some modules take a while. You can do this with the GnuCash installer. Open a command prompt as administrator and type:- perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update Or directly by downloading from here:- https://metacpan.org/pod/Finance::Quote Good luck! Regards Geoff = On 10/12/2022 6:01 am, aeg via gnucash-user wrote: Murugan, Thank you for your suggestion.There is no folder named "Finance" at that location, but I searched for quote.pm within Strawberry and found it at each of these locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance (version 1.5301) C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301) C:\Strawberry\perl\vendor\lib\Sub (version 2.006006) C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270) I don't know whether that helps to clarify the problem. Regards,Alan On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam wrote: Alan Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the version. if it is not 1.52, you may need to download and replace the file Saludos Cordiales Murugan From: gnucash-user on behalf of aeg via gnucash-user Sent: Friday, December 9, 2022 2:40 PM To: gnucash-user@gnucash.org Subject: [GNC] Installing or updating Finance::Quote I've started this thread separately from "[GNC] getting price quotes" (from which I gained helpful advice last week), as it's a more specific problem I now face. Following the advice from David H and others last week, I eventually decided to upgrade from GC version 3.5 to 4.12, in the hope that it would automatically install the latest version of Finance::Quote and enable me to resume downloading stock prices again. I'm using Windows 10 and the previously installed version of F::Q was 1.47, which had worked without problems until the first week of November. The upgrade to GC v4.12 turned out to be more straightforward than I'd previously feared, but I then found that F::Q was still on 1.47, and attempts to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start menu have been unsuccessful, so I'm hoping someone can point me in the direction of a solution. I should add that, prior to the GC update, I installed the latest version of Strawberry Perl (v5.32.1), after first removing the previous version (v5.18.2). Regards,Alan ___ 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.
Re: [GNC] Installing or updating Finance::Quote
Hi Geoff, Thank you for your input.Following advice from Murugan, I created a Finance folder at the correct location and put a copy of the latest version of quote.pm into it. When I now run perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update", this is what I see in cmd: C:\WINDOWS\system32>perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update"Database was generated on Sat, 10 Dec 2022 08:13:54 GMTTest2 is up to date (1.302191).Date::Manip is up to date (6.90).Finance::Quote is up to date (1.5301). C:\WINDOWS\system32> This looked promising, so I then ran "Install Online Price Retrieval for Gnucash" from the Start menu again, and this was the result: * Check Perl* Check Perl version* Install required perl modulesDatabase was generated on Sat, 10 Dec 2022 08:13:54 GMTTest2 is up to date (1.302191).Date::Manip is up to date (6.90).Finance::Quote is up to date (1.5301). * Check environment variable ALPHAVANTAGE_API_KEY *** *** You need an API key (from https://www.alphavantage.co) *** to run the Perl module Finance::Quote. *** *** Make it available to GnuCash by *** - setting the environment variable ALPHAVANTAGE_API_KEY or *** - starting GnuCash and adding the Alpha Vantage api key in *** Edit->Preferences->Online Quotes *** * Run 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 An error occurred, see above. It appears that these two are returning conflicting reports, so I'm now wondering whether I should uninstall Strawberry perl again and reinstall it, but I'm also wondering why it didn't fully install in the first place. Regards,Alan On Friday, 9 December 2022 at 23:26:12 GMT, Geoff wrote: Hi Alan It looks like the install has failed for some reason as the modules should be under: C:\Strawberry\perl\site\lib\Finance\ The entries under "perl\vendor" are not related to Finance::Quote and are irrelevant. I suggest that you try to install it again. The installation can be a bit fiddly as there are a number of dependencies, and some modules take a while. You can do this with the GnuCash installer. Open a command prompt as administrator and type:- perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update Or directly by downloading from here:- https://metacpan.org/pod/Finance::Quote Good luck! Regards Geoff = On 10/12/2022 6:01 am, aeg via gnucash-user wrote: > Murugan, > > Thank you for your suggestion.There is no folder named "Finance" at that > location, but I searched for quote.pm within Strawberry and found it at each > of these > locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance > (version 1.5301) > C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301) > C:\Strawberry\perl\vendor\lib\Sub (version 2.006006) > C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270) > > I don't know whether that helps to clarify the problem. > Regards,Alan > > On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam > wrote: > > Alan > Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the > version. if it is not 1.52, you may need to download and replace the file > Saludos Cordiales > Murugan > > From: gnucash-user > on behalf of > aeg via gnucash-user > Sent: Friday, December 9, 2022 2:40 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Installing or updating Finance::Quote I've started this thread > separately from "[GNC] getting price quotes" (from which I gained helpful > advice last week), as it's a more specific problem I now face. > Following the advice from David H and others last week, I eventually decided > to upgrade from GC version 3.5 to 4.12, in the hope that it would > automatically install the latest version of Finance::Quote and enable me to > resume downloading stock prices again. I'm using Windows 10 and the > previously installed version of F::Q was 1.47, which had worked without > problems until the first week of November. > The upgrade to GC v4.12 turned out to be more straightforward than I'd > previously feared, but I then found that F::Q was still on 1.47, and attempts > to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start > menu have been unsuccessful, so I'm hoping someone can point me in the > direction of a solution. > I should add that, prior to the GC update, I installed the latest version of > Strawberry Perl (v5.32.1), after first removing the previous version > (v5.18.2). > Regards,Alan > > > > __
Re: [GNC] Installing or updating Finance::Quote
hi Alan best way is what Geoff advised. Try re installing the finance quote. make sure you see the folder and sub folder called quotes under finance please check if the alphavantage key is updated. [cid:317807f5-d37d-4aa6-9461-a7a8a6c6fc13] Saludos Cordiales Murugan From: aeg Sent: Saturday, December 10, 2022 5:59 AM To: gnucash-user@gnucash.org ; Geoff Cc: Murugan Muruganandam Subject: Re: [GNC] Installing or updating Finance::Quote Hi Geoff, Thank you for your input. Following advice from Murugan, I created a Finance folder at the correct location and put a copy of the latest version of quote.pm into it. When I now run perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update", this is what I see in cmd: C:\WINDOWS\system32>perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-update" Database was generated on Sat, 10 Dec 2022 08:13:54 GMT Test2 is up to date (1.302191). Date::Manip is up to date (6.90). Finance::Quote is up to date (1.5301). C:\WINDOWS\system32> This looked promising, so I then ran "Install Online Price Retrieval for Gnucash" from the Start menu again, and this was the result: * Check Perl * Check Perl version * Install required perl modules Database was generated on Sat, 10 Dec 2022 08:13:54 GMT Test2 is up to date (1.302191). Date::Manip is up to date (6.90). Finance::Quote is up to date (1.5301). * Check environment variable ALPHAVANTAGE_API_KEY *** *** You need an API key (from https://www.alphavantage.co) *** to run the Perl module Finance::Quote. *** *** Make it available to GnuCash by ***- setting the environment variable ALPHAVANTAGE_API_KEY or ***- starting GnuCash and adding the Alpha Vantage api key in ***Edit->Preferences->Online Quotes *** * Run 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 An error occurred, see above. It appears that these two are returning conflicting reports, so I'm now wondering whether I should uninstall Strawberry perl again and reinstall it, but I'm also wondering why it didn't fully install in the first place. Regards, Alan On Friday, 9 December 2022 at 23:26:12 GMT, Geoff wrote: Hi Alan It looks like the install has failed for some reason as the modules should be under: C:\Strawberry\perl\site\lib\Finance\ The entries under "perl\vendor" are not related to Finance::Quote and are irrelevant. I suggest that you try to install it again. The installation can be a bit fiddly as there are a number of dependencies, and some modules take a while. You can do this with the GnuCash installer. Open a command prompt as administrator and type:- perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update Or directly by downloading from here:- https://metacpan.org/pod/Finance::Quote Good luck! Regards Geoff = On 10/12/2022 6:01 am, aeg via gnucash-user wrote: > Murugan, > > Thank you for your suggestion.There is no folder named "Finance" at that > location, but I searched for quote.pm within Strawberry and found it at each > of these > locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance > (version 1.5301) > C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301) > C:\Strawberry\perl\vendor\lib\Sub (version 2.006006) > C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270) > > I don't know whether that helps to clarify the problem. > Regards,Alan > > On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam > mailto:m.muruganan...@hotmail.com>> wrote: > > Alan > Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the > version. if it is not 1.52, you may need to download and replace the file > Saludos Cordiales > Murugan > > From: gnucash-user > mailto:hotmail@gnucash.org>> > on behalf of aeg via gnucash-user > mailto:gnucash-user@gnucash.org>> > Sent: Friday, December 9, 2022 2:40 PM > To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> > mailto:gnucash-user@gnucash.org>> > Subject: [GNC] Installing or updating Finance::Quote I've started this thread > separately from "[GNC] getting price quotes" (from which I gained helpful > advice last week), as it's a more specific problem I now face. > Following the advice from David H and others last week, I eventually decided > to upgrade from GC version 3.5 to 4.12, in the hope that it would > automatically install the latest version of Finance::Quote and enable me to > resume downloading stock prices again. I'm using Windows 10 and the > previously installed version of F::Q was 1.47, which had worked without &
Re: [GNC] Installing or updating Finance::Quote
UPDATE With thanks to those who advised me on this problem, I've finally managed to install the latest version of Finance::Quote and get it working. It wasn't as straightforward as I'd expected, and I ended up reinstalling Perl a couple of times in case that was the problem, but it turns out that the Start menu item “Install Online Price Retrieval for Gnucash” proved unreliable, as did the use of cmd command 'gnc-fq-update', and after several unsuccessful attempts, I searched the internet and found a very useful step-by-step guide that helped me achieve a successful outcome. In case anyone else faces similar problems with installing Finance::Quote, this is how I did it: Following additional guidance from https://learn.perl.org/installing/windows.html, I carried out the following steps: Uninstall old version of Strawberry PerlDownload and install the latest version of Strawberry Perl.Install App::cpanminus by typing 'cpan App::cpanminus' into cmd Install Finance::Quote by typing 'cpanm Finance::Quote' into cmd I rebooted the computer between each stage, just in case that helped, and GnuCash now shows the latest version of Finance::Quote and downloads stock prices as it used to. Regards,AlanG On Friday, 9 December 2022 at 23:26:12 GMT, Geoff wrote: Hi Alan It looks like the install has failed for some reason as the modules should be under: C:\Strawberry\perl\site\lib\Finance\ The entries under "perl\vendor" are not related to Finance::Quote and are irrelevant. I suggest that you try to install it again. The installation can be a bit fiddly as there are a number of dependencies, and some modules take a while. You can do this with the GnuCash installer. Open a command prompt as administrator and type:- perl C:\Program Files (x86)\gnucash\bin\gnc-fq-update Or directly by downloading from here:- https://metacpan.org/pod/Finance::Quote Good luck! Regards Geoff = On 10/12/2022 6:01 am, aeg via gnucash-user wrote: > Murugan, > > Thank you for your suggestion.There is no folder named "Finance" at that > location, but I searched for quote.pm within Strawberry and found it at each > of these > locations:C:\Strawberry\cpan\build\Finance-Quote-1.5301-0\lib\Finance > (version 1.5301) > C:\Strawberry\cpan\build\Finance-Quote-1.5301-1\lib\Finance (version 1.5301) > C:\Strawberry\perl\vendor\lib\Sub (version 2.006006) > C:\Strawberry\perl\vendor\lib\PPI\Token (version 1.270) > > I don't know whether that helps to clarify the problem. > Regards,Alan > > On Friday, 9 December 2022 at 17:51:50 GMT, Murugan Muruganandam > wrote: > > Alan > Check your quote.pm file in C:\Strawberry\perl\site\lib\Finance and check the > version. if it is not 1.52, you may need to download and replace the file > Saludos Cordiales > Murugan > > From: gnucash-user > on behalf of > aeg via gnucash-user > Sent: Friday, December 9, 2022 2:40 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Installing or updating Finance::Quote I've started this thread > separately from "[GNC] getting price quotes" (from which I gained helpful > advice last week), as it's a more specific problem I now face. > Following the advice from David H and others last week, I eventually decided > to upgrade from GC version 3.5 to 4.12, in the hope that it would > automatically install the latest version of Finance::Quote and enable me to > resume downloading stock prices again. I'm using Windows 10 and the > previously installed version of F::Q was 1.47, which had worked without > problems until the first week of November. > The upgrade to GC v4.12 turned out to be more straightforward than I'd > previously feared, but I then found that F::Q was still on 1.47, and attempts > to update or run "Install OnlinePrice Retrieval for Gnucash" from the Start > menu have been unsuccessful, so I'm hoping someone can point me in the > direction of a solution. > I should add that, prior to the GC update, I installed the latest version of > Strawberry Perl (v5.32.1), after first removing the previous version > (v5.18.2). > Regards,Alan > > > > ___ > 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/li