Re: [GNC] Difficulty with online price retrieval (John Ralls)
Thank you for your response, John, and I am sorry for the long delay but I have had an avalanche of work to do. My problem is that when I go to post an invoice the "fetch rate" button is greyed out so I cannot use the online currency rate retrieval that I used to be able to before I upgraded my hardware. After installing the current version of gnucash on my new PC, I clicked on "Install Online Price Retrieval" from the Gnucash list in my start menu and I have entered the Alfa Vantage API key in my gnucash preferences. I have checked for the presence of the perl software using the Troubleshooting method you directed me to and received the response that I should install the Finance::Quote. The only way I have done this in the past is by clicking on "Install Online Price Retrieval" from the Gnucash list in my start menu and this is what I have done several times now. So I have done this again and after a run of code in the cmd window the final lines are: "C:\Strawberry\perl\bin\perl.exe" -MExtUtils::Command -e cp - - examples/dm_zdump blib\script\dm_zdump pl2bat.bat blib\script\dm_dump SBECK/Date-Manip-6.82.tar.gz C:\STRAWB~1\c\bin\gmake.exe - -OK When I look in the Windows list of apps installed it says I have installed Strawberry Perl on 3rd July (when I first tried installing it on my new PC). I am running the latest version of Gnucash and I find that in the help window it says "Version: 4.0 Build ID: 4.0+(2020-06-27) Finance::Quote: -" Please let me know what other information you need in order to be able to help me. I am stepping way out of my comfort zone when I enter the cmd window but willing to give it a go. Best regards Samantha On 16 July 2020 18:14 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha, Have you tried price retrieval from the command line as explained in [2]https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Does that work? You haven't actually told us exactly what doesn't work. Please elaborate. Note that trading accounts has nothing to do with it, nor do previously created prices. Note that while rates used for transactions are recorded in the pricedb to ensure that there's an entry to make reports work properly, each foreign currency split has its own exchange rate, the ratio between the amount in the foreign currency and the value in the home currency, so the only thing you'd affect by clearing the pricedb is reports on past dates, especially time series reports. You may also enter prices manually as a temporary measure until you get online quotes working properly. Regards, John Ralls On Jul 16, 2020, at 5:08 AM, Samantha Payn < [3]saman...@boorertranslations.com> wrote: Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation and cannot see where I am going wrong. In addition to having installed Online Price Retrieval and entered my API key, I have now also double checked that the "use trading accounts" option is checked which it is. In the price database window the currencies I use are listed. There is an option to delete all previous prices but I presume I don't want to do that as they record the currency exchange rates used for each of my past transactions. I am beginning to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. References 1. mailto:jra...@ceridwen.us 2. https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting 3. mailto:saman...@boorertranslations.com ___ 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] Difficulty with online price retrieval (John Ralls)
Samantha, Have you tried price retrieval from the command line as explained in https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting? Does that work? You haven't actually told us exactly what doesn't work. Please elaborate. Note that trading accounts has nothing to do with it, nor do previously created prices. Note that while rates used for transactions are recorded in the pricedb to ensure that there's an entry to make reports work properly, each foreign currency split has its own exchange rate, the ratio between the amount in the foreign currency and the value in the home currency, so the only thing you'd affect by clearing the pricedb is reports on past dates, especially time series reports. You may also enter prices manually as a temporary measure until you get online quotes working properly. Regards, John Ralls > On Jul 16, 2020, at 5:08 AM, Samantha Payn > wrote: > > Thanks for your comments John and Eric. > > I have again reviewed the gnucash help documentation and cannot see > where I am going wrong. In addition to having installed Online Price > Retrieval and entered my API key, I have now also double checked that > the "use trading accounts" option is checked which it is. > > In the price database window the currencies I use are listed. There is > an option to delete all previous prices but I presume I don't want to > do that as they record the currency exchange rates used for each of my > past transactions. > > I am beginning to think I must take a backward step and use manual > price entry ... where am I going wrong, when I used to be able to use > the automatic option and all seems to be set up as before? > > All help gratefully received. > ___ 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] Difficulty with online price retrieval (John Ralls)
Thanks for your comments John and Eric. I have again reviewed the gnucash help documentation and cannot see where I am going wrong. In addition to having installed Online Price Retrieval and entered my API key, I have now also double checked that the "use trading accounts" option is checked which it is. In the price database window the currencies I use are listed. There is an option to delete all previous prices but I presume I don't want to do that as they record the currency exchange rates used for each of my past transactions. I am beginning to think I must take a backward step and use manual price entry ... where am I going wrong, when I used to be able to use the automatic option and all seems to be set up as before? All help gratefully received. -- Samantha Payn On 16 July 2020 11:38 [1]gnucash-user-requ...@gnucash.org wrote: Send gnucash-user mailing list submissions to [2]gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to [4]gnucash-user-requ...@gnucash.org You can reach the person managing the list at [5]gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Difficulty with online price retrieval (Samantha Payn) 2. Re: Reconcile also opens Interest Payment box? (Jean Laroche) 3. Re: Difficulty with online price retrieval (Eric Coates) 4. GnuCash 4.0 printing on MacOS (Flyeta) 5. Re: Difficulty with online price retrieval (John Ralls) 6. Re: GnuCash 4.0 printing on MacOS (John Ralls) 7. Get Online Quotes (Ruaraidh Sackville Hamilton) 8. gnucash cannot see printer (Gio Bacareza) -- Message: 1 Date: Wed, 15 Jul 2020 17:24:49 +0100 (BST) From: Samantha Payn < [6]saman...@boorertranslations.com> To: " [7]gnucash-user@gnucash.org" < [8]gnucash-user@gnucash.org> Subject: [GNC] Difficulty with online price retrieval Message-ID: < [9]1218599278.968.1594830289...@privateemail.com> Content-Type: text/plain; charset="UTF-8" I did post this question before but am still having the same problem. I have successfully used Gnucash for a couple of years for multicurrency invoice processing using the Strawberry perl plug in (by clicking on Install online price retrieval in the Gnucash section of the start menu) and an #Alpha Vantage access key. I use Windows 10. Recently I had to upgrade my hardware and since installing gnucash on the new machine I've not been able to make the price retrieval work. I have tried installing gnucash, adding the API key, and then adding Strawberry perl; and I have tried uninstalling everything and then installing gnucash, adding Strawberry perl and then adding the API key. No joy. Where am I going wrong? All help gratefully received. Thanks. -- Message: 2 Date: Wed, 15 Jul 2020 09:39:43 -0700 From: Jean Laroche < [10]rip...@gmail.com> To: [11]gnucash-user@gnucash.org Subject: Re: [GNC] Reconcile also opens Interest Payment box? Message-ID: < [12]40aabd76-e146-8fab-b54a-56beeb731...@gmail.com> Content-Type: text/plain; charset=utf-8; format=flowed I'd like a preference somewhere to activate/inactivate the Interest Payment pop-up appearing automatically on an account by account basis. I'd like the "Enter Interest Payment ..." button to remain as I have used it a couple of times, but that when it has been used it won't then mean it appears automatically the next time, which would remove the need for the "No Automatic Interest Payment" button. Just my two penny worth. Alan A Holmes BTW, that's exactly what the current Pull Request implements: per account option, and the option isn't set silently if you decide to click "enter interest payment". [13]https://github.com/Gnucash/gnucash/pull/753 I think it's a reasonable compromise that keeps the feature around, but much better behaved. -- Message: 3 Date: Wed, 15 Jul 2020 17:44:33 +0100 From: Eric Coates < [14]twistedw...@talktalk.net> To: [15]gnucash-user@gnucash.org Subject: Re: [GNC] Difficulty with online price retrieval Message-ID: < [16]a9519fec-f78e-9ca9-83e0-4277468c6...@talktalk.net> Content-Type: text/plain; charset=utf-8; format=flowed A few days ago it was reported that AlphaVantage was no longer serving price information (something to do with them not having the appropriate licences apparently). The general advice seems to be use Yahoo as JSON? which works fine for me perhaps it would for you.