[GNC] Price retrieval failing

2023-03-28 Thread R. Warriner via gnucash-user
"c:\program files (x86)\gnucash\bin\gnucash-cli" --quotes get --namespace=ETF Household.gnucash returns: .ound Finance::Quote version 1.54 Price retrieval failed: GncQuotes::Fetch called with no commodities. Everything was working and downloading properly prior to updat

Re: [GNC] Online price retrieval

2021-10-14 Thread Fred Bone
On 13 October 2021 at 0:24, J Medina said: > Gentlemen/Ladies, > > I want to install Finance::Quote on Windows10 > > Could you please give me a bit more detailed explanation on how to do this > >>> Run Start → GnuCash → Install Online Price Retrieval. > > I

Re: [GNC] Online price retrieval

2021-10-14 Thread Kalpesh Patel
In the search box (the icon that looks like magnifying glass in the task bar) just type in "Install Online Price Retrieval for GnuCash" and press the "Enter" key to kick off the installation routine. You can follow the same process to upgrade now and then as well. If all goes

Re: [GNC] Online price retrieval

2021-10-13 Thread David H
ash folder and click on the "Install Online Price Retrieval for GnuCash" shortcut in the folder and let it do it's thing. This will also install Strawberry Perl for you as it needs that to run - can take 5 - 10 minutes so wait until it finishes. Cheers David H. On Thu, 14 Oct 2021 at 15:36,

[GNC] Online price retrieval

2021-10-13 Thread J Medina
Gentlemen/Ladies, I want to install Finance::Quote on Windows10 Could you please give me a bit more detailed explanation on how to do this >>> Run Start → GnuCash → Install Online Price Retrieval. I understand I need to do this from the command prompt ...I just need a more su

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Chris Good
Good Message: 9 Date: Wed, 5 May 2021 07:58:44 -0500 From: David Carlson To: Sudesh Chandar Cc: "gnucash-user@gnucash.org" , Geoff Subject: Re: [GNC] Trouble Installing Online Price Retrieval Tool Message-ID: Content-Type: text/plain; charset="UTF-8" Sudes

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread David Carlson
gt; screenshot if it is still hanging after 30 minutes. > > Thanks > > Geoff > = > > On 5/05/2021 5:09 pm, Sudesh Chandar via gnucash-user wrote: > > Hello Group, > > I am a new user of GNU cash and have recently downloaded and installed > Gnucash v

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Geoff
after 30 minutes. Thanks Geoff = On 5/05/2021 5:09 pm, Sudesh Chandar via gnucash-user wrote: > Hello  Group, > I am a new user of GNU cash and have recently downloaded and installed Gnucash ver 4.5 on a windows 10 64 bit machine. > I am trying to run the script for

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Sudesh Chandar via gnucash-user
I am a new user of GNU cash and have recently downloaded and installed > Gnucash ver 4.5 on a windows 10 64 bit machine. > I am trying to run the script for Installing online price retrieval and the > command line freezes after a while. > It installed the Strawberry perl just fine and the

Re: [GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Geoff
ws 10 64 bit machine. I am trying to run the script for Installing online price retrieval and the command line freezes after a while. It installed the Strawberry perl just fine and the install check and version check passes ok and then it copies all the *.pm files just ok. Where it hangs is after the messa

[GNC] Trouble Installing Online Price Retrieval Tool

2021-05-05 Thread Sudesh Chandar via gnucash-user
Hello  Group, I am a new user of GNU cash and have recently downloaded and installed Gnucash ver 4.5 on a windows 10 64 bit machine. I am trying to run the script for Installing online price retrieval and the command line freezes after a while. It installed the Strawberry perl just fine

Re: [GNC] GnuCash 4.4 "Install Online Price Retrieval for GnuCash" fails

2021-02-02 Thread SgtWilko
Withdrawing this request. Found the solution in this article: https://www.geekworker.com/gnucash-install-online-price-retrieval-for-gnucash-results-in-access-is-denied-error/ <https://www.geekworker.com/gnucash-install-online-price-retrieval-for-gnucash-results-in-access-is-denied-er

Re: [GNC] Security price retrieval [again]

2021-01-09 Thread Fred Bone
On 09 January 2021 at 16:54, Frank H. Ellenberger said: > Am 07.01.21 um 18:01 schrieb Graham: > > Sorry - didn't realise that the images hadn't gone through. > > When I try to update prices, more than half do not update, and it [...] > > I have run gnc-fq-update and I get:  Date::Manip is up to

Re: [GNC] Security price retrieval [again]

2021-01-09 Thread Frank H. Ellenberger
Am 07.01.21 um 18:01 schrieb Graham: > Sorry - didn't realise that the images hadn't gone through. > When I try to update prices, more than half do not update, and it > prompts me to continue with the ones that have updated. I tried > converting the source from Morningstar GB to Yahoo-JSON but

Re: [GNC] Security price retrieval [again]

2021-01-09 Thread Graham
On 08/01/2021 10:16, Liz Dodd wrote: On Thu, 7 Jan 2021 17:01:42 + Graham wrote: Sorry - didn't realise that the images hadn't gone through. When I try to update prices, more than half do not update, and it prompts me to continue with the ones that have updated. I tried converting the

Re: [GNC] Security price retrieval [again]

2021-01-07 Thread Graham
On 07/01/2021 20:06, David H wrote: Not uncommon, perhaps you should list the ones that aren't working, other users might be able to point you in the right direction... Cheers David H. Thanks David, All LSE: DNE, SCF, EUDV, LGEN, GFRD, JCH, KETL, EPIC, PNN,AIRE,CTY , currency:eur,

Re: [GNC] Security price retrieval [again]

2021-01-07 Thread David H
Not uncommon, perhaps you should list the ones that aren't working, other users might be able to point you in the right direction... Cheers David H. On Fri, 8 Jan 2021 at 03:01, Graham wrote: > Sorry - didn't realise that the images hadn't gone through. > When I try to update prices, more

Re: [GNC] Security price retrieval [again]

2021-01-07 Thread Graham
Sorry - didn't realise that the images hadn't gone through. When I try to update prices, more than half do not update, and it prompts me to continue with the ones that have updated. I tried converting the source from Morningstar GB to Yahoo-JSON but that froze Gnucash. I have run

Re: [GNC] Security price retrieval [again]

2021-01-06 Thread dullege
by all the quote sources) -Original Message- From: gnucash-user On Behalf Of Graham Sent: Thursday, 7 January 2021 1:12 AM To: David H Cc: Gnucash Users Subject: Re: [GNC] Security price retrieval [again] On 04/01/2021 22:22, David H wrote: > Graham, > > My gnc-fq-xxx scr

Re: [GNC] Security price retrieval [again]

2021-01-06 Thread David H
Hi Graham, Well I'm not sure what your original issue was as this is all I saw - no image as you can't send images inline as part of your email. From memory you either need to add images to the end or attach them as a separate file. So what was your exact problem again :-) Cheers David H. I

Re: [GNC] Security price retrieval [again]

2021-01-06 Thread Graham
On 04/01/2021 22:22, David H wrote: Sorry - just read your reply to Michelle. Ran it and got: C:\Program Files (x86)\gnucash\bin>perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-check" ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx" "aufunds" "australia" "bamosz" "bet"

Re: [GNC] Security price retrieval [again]

2021-01-06 Thread Graham
On 04/01/2021 22:22, David H wrote: Graham, My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files (x86)\gnucash\bin. If they're not present have you run the "Install Online Price Retrieval for GnuCash" which installs/sets up everything for Online Price Retrieval to work

Re: [GNC] Security price retrieval [again]

2021-01-04 Thread David H
Graham, My gnc-fq-xxx scripts on Win10 Pro are in C:\Program Files (x86)\gnucash\bin. If they're not present have you run the "Install Online Price Retrieval for GnuCash" which installs/sets up everything for Online Price Retrieval to work? Cheers David H. On Mon, 4 Jan 2021 at 23:

Re: [GNC] Security price retrieval [again]

2021-01-04 Thread Graham
Thanks Frank, but I get ' Can't open perl script "gnc-fq-check": No such file or directory '. This is all i have in the start menu. I have used the install program to get the latest version, and I've d/l'd GNC4.4 Graham On 03/01/2021 20:06, Frank H. Ellenberger wrote: Hi Graham, Am

Re: [GNC] Security price retrieval [again]

2021-01-03 Thread Frank H. Ellenberger
Hi Graham, Am 03.01.21 um 18:45 schrieb Graham: > > I have uninstalled and installed 4.4, but it is still not there. When I > run the update prices, some stocks are updated, but after a good 4 > minutes, this appears : > > > Looking at the list, some were set to Morningstar GB whereas the >

Re: [GNC] Security price retrieval [again]

2021-01-03 Thread Graham
Hi team, After unsuccessful aatempts to get price retrieval to work on Windows, Gnucash 3.8, i went back to the manual, only to find that I was missing gnc-fq-dump in the start menu. I have uninstalled and installed 4.4, but it is still not there. When I run the update prices, some stocks

Re: [GNC] Price retrieval

2020-11-12 Thread Kalpesh Patel
Looking at the picture of the menu shows that it has been customized. Next best step would be to download the official full Windows package and try to install it. That should create and populate that group properly. I don't believe reinstalling it will harm in anyway as I have reinstalled

Re: [GNC] Price retrieval

2020-11-12 Thread randix
Geert... just to put a cap on this thread (it has a good ending)... 1. The Dell XPS 13 that was involved is not a 2-1 version (which Dell does offer), it has a standard Windows 10 Professional install with no optional tablet version as far as I'm aware. I have no idea why the Start menu does not

Re: [GNC] Price retrieval

2020-11-12 Thread Geert Janssens
Hi, You seem to have a different Windows menu on your Windows 10 than I do. Perhaps that's the tablet mode and I'm in desktop mode. On my Windows menu there are both a GnuCash application and a GnuCash folder. Inside the folder I do see the Online price retrieval installer. Having said all

Re: [GNC] Price retrieval

2020-11-12 Thread randix
I sincerely appreciate your response, however, as reflected in the attached piks: 1. I do NOT have a GnuCash group in the Start menu, only the exe file appears, as reflected in the attached screenshot, so I can't access the "Install Online Price Retrieval" from there; 2. If I d

Re: [GNC] Price retrieval

2020-11-11 Thread randix
Ok, so after my last post, I figured I better read the user manual as it's been a long time since I've installed GnuCash.  Appears to me that I need to "install" the Finance::Quote module.  However, despite the documentation, I cannot find the "Gnucash Start Group"-- all it includes is the exe

Re: [GNC] Price retrieval

2020-11-09 Thread Geoff
av: <=== one of these price: <=/ timezone: <=== optional C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump australia BHP Finance::Quote fields Gnucash uses: symbol: BHP <=== required date: 11/

[GNC] Price retrieval

2020-11-09 Thread randix
I'm using GnuCash 4.2 on Windows 10 Pro. On a separate laptop, I installed GnuCash, and copied over from my regular laptop where I normally use GnuCash, the files that I thought contained the customization needed for the new install. Everything works great, except for one component, price

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Geoff
Woo hoo! I couldn't have resolved this without John's groundwork. Enjoy your day. Regards Geoff = On 26/08/2020 8:49 pm, Samantha Payn wrote: HURRAH! Thank you so much Geoff and John for your patience while I struggled with this. Geoff seems to have found the solution and I am

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Samantha Payn
HURRAH! Thank you so much Geoff and John for your patience while I struggled with this. Geoff seems to have found the solution and I am enormously grateful to him, and to John Ralls who supported me in the earlier phases of this mystery. I hope not to trouble you again for a

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Samantha Payn
Thanks very much for your quick response. I am totally out of my depth in the CMD window! On 26 August 2020 11:24 Geoff < [1]cleanoutmys...@gmail.com> wrote: Hi Samantha I see nothing wrong there - the SET command does not return any output. Please try the 3rd command - it

Re: [GNC] Difficulty with online price retrieval

2020-08-26 Thread Geoff
Hi Samantha I see nothing wrong there - the SET command does not return any output. Please try the 3rd command - it should show you your key: echo %ALPHAVANTAGE_API_KEY% Thanks Geoff = On 26/08/2020 8:10 pm, Samantha Payn wrote: Hi Geoff Thank you for this. For some reason I encounter

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
Thanks John, I'll try and get Samantha's perl installation sorted out, then we will see if she still has a problem with exchange rates. Geoff = On 26/08/2020 2:33 am, John Ralls wrote: On Aug 25, 2020, at 1:42 AM, Geoff wrote: <<< Please excuse me for jumping in late on this thread >>>

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread John Ralls
> > On Aug 25, 2020, at 1:42 AM, Geoff wrote: > > <<< Please excuse me for jumping in late on this thread >>> > > Samantha reported: ""when I click it I get an error window that says: "There > was a system error while retrieving the price quotes"."" > > Samantha's debug output shows the

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
nd' specified. >> >>> >> >>> It does occur to me the US markets are closed at 10:15 BST, but I >> >>> suppose that you also checked with gnc-fq-dump around the same time >> >>> and that worked OK. >> >>>

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
rogram Files >>> (x86)\gnucash\bin\gnc-fq-helper >>> Should produce something like >>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") >>> (last . #e0.7658) (currency . "GBP"))) >>> >>> Regards,

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
>>> (x86)\gnucash\bin\gnc-fq-helper >>> Should produce something like >>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2020-08-24 14:56:25") >>> (last . #e0.7658) (currency . "GBP"))) >>> &g

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
om a week ago must have fallen through the net? >> Any assistance gratefully received >> Samantha Payn >>> -- Original Message -- >>> From: Samantha Payn < saman...@boorertranslations.com <mailto:saman...@boorertranslations.com>> >

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
ny assistance gratefully received >> Samantha Payn >>> -- Original Message -- >>> From: Samantha Payn < [3]saman...@boorertranslations.com> >>> To: John Ralls < [4]jra...@ceridwen.us> >>> CC: Gnucash Users < [5]gnucash-user@

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Samantha Payn
John Ralls < [4]jra...@ceridwen.us> CC: Gnucash Users < [5]gnucash-user@gnucash.org> Date: 17 August 2020 10:19 Subject: Re: [GNC] Difficulty with online price retrieval John, thank you for your continued patience! This is what I got: * 10:13:32 DEBUG rpt-subdir=gn

Re: [GNC] Difficulty with online price retrieval

2020-08-25 Thread Geoff
nd list I think this response of mine from a week ago must have fallen through the net? Any assistance gratefully received Samantha Payn -- Original Message -- From: Samantha Payn To: John Ralls CC: Gnucash Users Date: 17 August 2020 10:19 Subject: Re: [GNC] Difficulty wit

Re: [GNC] Difficulty with online price retrieval

2020-08-24 Thread John Ralls
> Dear John and list > I think this response of mine from a week ago must have fallen through the > net? > Any assistance gratefully received > Samantha Payn >> -- Original Message -- >> From: Samantha Payn >> To: John Ralls >> C

[GNC] Fwd: Re: Difficulty with online price retrieval

2020-08-24 Thread Samantha Payn
2020 10:19 Subject: Re: [GNC] Difficulty with online price retrieval John, thank you for your continued patience! This is what I got: * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash

Re: [GNC] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user
nucash.org Subject: Re: [GNC] Get quote - online price retrieval One would think so David, but my experience was otherwise. When running Get Quotes on a brand new default database with no securities defined, and then after adding just one security for this mutual fund, in both cases I wa

Re: [GNC] Get quote - online price retrieval

2020-08-17 Thread D. via gnucash-user
: [GNC] Get quote - online price retrieval Ashok, I have tried to replicate your issue on a new Windows 10 installation. You said:- "Did the cpan Date::Manip, but that freezes at the point of the below stage. Have to "Ctrl"+C, ugly exit." You need to be more patient, it wasn't

Re: [GNC] Difficulty with online price retrieval

2020-08-17 Thread Samantha Payn
John, thank you for your continued patience! This is what I got: * 10:13:32 DEBUG rpt-subdir=gnucash/reports/standard * 10:13:32 DEBUG mod-dir=C:\Program Files (x86)\gnucash\share/guile/site/2.2\gnucash/reports/standard * 10:13:32 DEBUG dir-files=(view-column trial-balance

Re: [GNC] Get quote - online price retrieval

2020-08-16 Thread Geoff
Ashok, I have tried to replicate your issue on a new Windows 10 installation. You said:- "Did the cpan Date::Manip, but that freezes at the point of the below stage. Have to "Ctrl"+C, ugly exit." You need to be more patient, it wasn't frozen, just having a rest! The complete installation

Re: [GNC] Difficulty with online price retrieval

2020-08-15 Thread John Ralls
Samantha, Run GnuCash from Powershell as you did before: & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug (The last time the command was & 'C:\Program Files (x86)\gnucash\bin\gnucash.exe' --log gnc.scm=debug --nofile but that last command, --nofile, tells GnuCash to not

Re: [GNC] Difficulty with online price retrieval

2020-08-15 Thread Samantha Payn
I am sorry John, do what? I am afraid I just do not understand "Please run from the PowerShell command line with the --log gnc.scm=debug option as before, try both a Fetch Rate and a Get Quotes and paste in the contents of the resulting log file." I am such a beginner with the

Re: [GNC] Difficulty with online price retrieval

2020-08-12 Thread John Ralls
Samantha, OK. Please do it when running GnuCash from Powershell with the --log gnc.scm=debug option and paste in the resulting gnucash.trace.XX.log. Regards, John Ralls > On Aug 12, 2020, at 6:54 AM, Samantha Payn > wrote: > > John, I am so sorry, I have slightly misled you. It is the

Re: [GNC] Difficulty with online price retrieval

2020-08-12 Thread Samantha Payn
John, I am so sorry, I have slightly misled you. It is the "Fetch Rate" button which returns the error message. I only use Gnucash for my business accounts and have no need of the "Get Quotes" button. On 11 August 2020 18:54 John Ralls < [1]jra...@ceridwen.us> wrote: Samantha,

Re: [GNC] Difficulty with online price retrieval

2020-08-11 Thread John Ralls
Samantha, Sorry, I lost that in the ensuing conversation about how to work Powershell and got hung up on the previous no Get Rate button issue. The Fetch Rate and Get Quotes buttons work a bit differently from each other: The first looks only at the currencies involved in the transaction

Re: [GNC] Difficulty with online price retrieval

2020-08-11 Thread Samantha Payn
I'm afraid the problem has not been solved. The Get Quotes button does light up (as I mentioned in an email to the list just after I first reported the problem), but when I click it I get an error window that says: "There was a system error while retrieving the price quotes".

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread John Ralls
Good. It succeeded in finding Finance::Quote from the command line. That should be sufficient to enable the Fetch Rate button. Was it enabled? Regards, John Ralls > On Aug 10, 2020, at 12:06 PM, Samantha Payn > wrote: > > Hi John > I did what you suggest and this is what I got: > > PS

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread Samantha Payn
Hi John I did what you suggest and this is what I got: PS C:\Users\User> Get-Content $Env:USERPROFILE\AppData\Local\Temp\gnucash.trace.VEQEP0.log * 11:46:06 DEBUG rpt-subdir=gnucash/reports/standard * 11:46:06 DEBUG mod-dir=C:\Program Files

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread John Ralls
> On Aug 10, 2020, at 6:16 AM, Frank H. Ellenberger > wrote: > > Samanta, > > Am 10.08.20 um 12:53 schrieb Samantha Payn: >> But you lost me at the next bit. >> >> PS C:\Users\User> Get-ChildItem -Path >> $Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* | >> Sort-Object

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread D. via gnucash-user
Odd that the list isn't properly sorted... Original Message From: "Frank H. Ellenberger" Sent: Mon Aug 10 09:16:42 EDT 2020 To: Samantha Payn Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Difficulty with online price retrieval Samanta, Am 10.08.20 um 12:

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread Frank H. Ellenberger
Samanta, Am 10.08.20 um 12:53 schrieb Samantha Payn: > But you lost me at the next bit. > >PS C:\Users\User> Get-ChildItem -Path >$Env:USERPROFILE\AppData\Local\Temp -filter gnucash.trace.* | >Sort-Object -Property Date >Directory: C:\Users\User\AppData\Local\Temp >Mode

Re: [GNC] Difficulty with online price retrieval

2020-08-10 Thread Samantha Payn
set your ALPHAVANTAGE_API_KEY in the environment: CMD set ALPHAVANTAGE_API_KEY xxx... Poweshell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If t

Re: [GNC] Difficulty with online price retrieval

2020-08-08 Thread John Ralls
t;>>>>>>> + FullyQualifiedErrorId : CommandNotFoundException >>>>>>>>> >>>>>>>>> (In the text above I have switched out my 16 digit API key for the >>>>>>>>> words "[my API ke

Re: [GNC] Difficulty with online price retrieval

2020-08-08 Thread Samantha Payn
ou can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system er

Re: [GNC] Difficulty with online price retrieval

2020-08-07 Thread John Ralls
our device". You don't need it for this test, plain Powershell is >>>>>>>> fine. Yes, Powershell. I don't think that there is a Poweshell, please >>>>>>>> excuse my hasty typing. >>>>>>>> >>>>&g

Re: [GNC] Difficulty with online price retrieval

2020-08-07 Thread Samantha Payn
oweshell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned

Re: [GNC] Difficulty with online price retrieval

2020-08-06 Thread John Ralls
t;>>>>>> saman...@boorertranslations.com> wrote: >>>>>>> >>>>>>> John, thank you for your continued support. >>>>>>> Before I try this can I just clarify two points: >>>>>>> I have a choice of W

Re: [GNC] Difficulty with online price retrieval

2020-08-05 Thread Samantha Payn
ell $Env:ALPHAVANTAGE_API_KEY = xxx... Now test that you can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned o

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread John Ralls
Best wishes >>>>> Samantha >>>>>> On 25 July 2020 17:12 John Ralls < jra...@ceridwen.us> wrote: >>>>>> >>>>>> >>>>>> Samantha, >>>>>> >>>>>>

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread Samantha Payn
6)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error message from online price retrieval is trying to get a stock price from one of

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread John Ralls
86)\gnucash\bin. >>>> >>>> First you'll need to set your ALPHAVANTAGE_API_KEY in the environment: >>>> CMD >>>> set ALPHAVANTAGE_API_KEY xxx... >>>> Poweshell >>>> $Env:ALPHAVANTAGE_API_KEY = xxx... >>>&

Re: [GNC] Difficulty with online price retrieval

2020-07-27 Thread Samantha Payn
can retrieve an arbitrary currency pair: perl 'c:\Program Files (x86)\gnucash\bin\gnc-fq-dump currency USD GBP If that works then Finance::Quote is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error me

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread John Ralls
ing installation info to C:\strawberry\perl\lib/perllocal.pod >>> ECOCODE/Finance-Quote-1.49.tar.gz >>> C:\STRAWB\c\bin\gmake.exe install UNINST=1 -- OK >>> Can you please give me guidance on what to do now? >>> Very many thanks! >>> Samantha >>> >>&g

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread Samantha Payn
ror message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book? If you're unsure use Tools>Security Editor to show a list of them. Regards, John Ralls On Jul 25, 2020, at 5:2

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread John Ralls
is working correctly and something else is going on. So far you've mentioned only currency rates, but the usual reason for a system error message from online price retrieval is trying to get a stock price from one of the dicontinued Yahoo! price sources. Do you have any securities in your book

Re: [GNC] Difficulty with online price retrieval

2020-07-25 Thread Samantha Payn
anual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently computer literate to correct this. My problem is that when I go to post an

Re: [GNC] Difficulty with online price retrieval

2020-07-24 Thread John Ralls
> On Jul 24, 2020, at 4:33 AM, Samantha Payn > wrote: > > Sorry to repeat myself but can anyone help me or shall I have to rely > on manual input of foreign exchange rates for the foreseeable future? I > think that Windows has put the online price retrieval somewhere

Re: [GNC] Difficulty with online price retrieval

2020-07-24 Thread Samantha Payn
Sorry to repeat myself but can anyone help me or shall I have to rely on manual input of foreign exchange rates for the foreseeable future? I think that Windows has put the online price retrieval somewhere where Gnucash cannot "see" it and I am not sufficiently compute

Re: [GNC] Difficulty with online price retrieval (John Ralls)

2020-07-21 Thread Samantha Payn
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 chec

Re: [GNC] Difficulty with online price retrieval (John Ralls)

2020-07-16 Thread 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

[GNC] Difficulty with online price retrieval (John Ralls)

2020-07-16 Thread Samantha Payn
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&qu

Re: [GNC] Difficulty with online price retrieval

2020-07-15 Thread John Ralls
le 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 up

Re: [GNC] Difficulty with online price retrieval

2020-07-15 Thread Eric Coates via gnucash-user
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

[GNC] Difficulty with online price retrieval

2020-07-15 Thread Samantha Payn
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

Re: [GNC] Automatic Price Retrieval

2020-04-29 Thread John Ralls
s the "Get Quotes" feature as "automatic", but I >> still have to remember to open the Price Editor and click "Get Quotes". >> >> Is there a way to make price retrieval fully automatic? > > Use a cron job/scheduled task to run GnuCash with the --a

Re: [GNC] Automatic Price Retrieval

2020-04-29 Thread John Ralls
r to open the Price Editor and click "Get Quotes". > > Is there a way to make price retrieval fully automatic? Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE argument, FILE being the path to your gnucash data file. Regards, John Ralls

[GNC] Automatic Price Retrieval

2020-04-29 Thread rsbrux via gnucash-user
I would like GnuCah to retrieve prices automatically each time I open it. The documentation describes the "Get Quotes" feature as "automatic", but I still have to remember to open the Price Editor and click "Get Quotes". Is there a way to make p

Re: [GNC] Online price retrieval

2019-07-21 Thread Fross, Michael
Did you confirm that the following are in your path? I had a few issues until both were there. perl/bin is probably added during installation, but the c\bin entry was not for me. C:\Strawberry\c\bin C:\Strawberry\perl\bin If you are not certain what that means, go to Control Panel, System,

Re: [GNC] Online price retrieval

2019-07-19 Thread John Ralls
; > > -- Original Message -- > From: John Ralls > To: "duru...@netzero.net" > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Online price retrieval > Date: Mon, 15 Jul 2019 13:28:07 -0700 > > > > > On Jul 14, 2019, at 6:06 PM, duru...

Re: [GNC] Online price retrieval

2019-07-16 Thread Fross, Michael
p1 line > 57. > > dmake.exe: Error code 153, while making "test_dynamic' > > EESTABR00/Crypt-HCE_SHA-0.75.tar.gz > > > > So it appearss that something is missing. > > > > Joe D. > > > > > > > > -- Original Message --

Re: [GNC] Online price retrieval

2019-07-15 Thread John Ralls
xe: Error code 153, while making "test_dynamic' > EESTABR00/Crypt-HCE_SHA-0.75.tar.gz > > So it appearss that something is missing. > > Joe D. > > > > -- Original Message -- > From: John Ralls > To: "duru...@netzero.n

Re: [GNC] Online price retrieval

2019-07-15 Thread John Ralls
> On Jul 14, 2019, at 6:06 PM, duru...@netzero.net wrote: > > Does anyone know (or think he/she knows) whether online price retrieval is > supposed towork with windows version 6.1.7601? I ran the install procedure, > but it seems to havefailed. It didn't leave a log fi

[GNC] Online price retrieval

2019-07-15 Thread duru...@netzero.net
Does anyone know (or think he/she knows) whether online price retrieval is supposed towork with windows version 6.1.7601? I ran the install procedure, but it seems to havefailed. It didn't leave a log file that I could identify, so I don't really know what to look at. Joe D. duru

[GNC] Stock price retrieval (again, sorry!)

2019-05-19 Thread Steve
Every since Yahoo shut down their service, I have not been able to get any stock quotes. I had been running a very old version 2.6.15, I think, so I did not try to resolve the issue but now I have updated to 3.4 and I still have the same problem. I have checked that I have the necessary version

[GNC] Help me out with the online currencies price retrieval

2019-04-14 Thread Petrus Arief
Dear Gnucash User & Development Team, My name is Petrus. I have a problem with my online price retrieval. I installed the newest version of strawberry perl & gnucash and installed the Online Price Retrieval for Gnucash, but I'm facing this error (attached). [image: i

Re: [GNC] Online Price Retrieval Fails

2018-09-15 Thread John Ralls
gt;>>> >>>>> On Sep 5, 2018, at 12:26 PM, nvsoar >>>> <mailto:nvs...@charter.net>> wrote: >>>>> >>>>> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) >>>>> reports DateManip could not be found;

Re: [GNC] Online Price Retrieval Fails

2018-09-15 Thread nvsoar
On 09/06/18 07:12, John Ralls wrote: On Sep 5, 2018, at 8:49 PM, nvsoar <mailto:nvs...@charter.net>> wrote: On 09/05/18 17:27, John Ralls wrote: On Sep 5, 2018, at 12:26 PM, nvsoar <mailto:nvs...@charter.net>> wrote: Running Win 10 - Install online price retrieva

Re: [GNC] Online Price Retrieval Fails

2018-09-06 Thread John Ralls
> On Sep 5, 2018, at 8:49 PM, nvsoar wrote: > > On 09/05/18 17:27, John Ralls wrote: >> >>> On Sep 5, 2018, at 12:26 PM, nvsoar wrote: >>> >>> Running Win 10 - Install online price retrieval (GnuCash version 2.6.21) >>> reports DateManip c

  1   2   >