So you now at least have the F::Q module for Perl installed that works from GNC and that mean you have some ability to download prices.
Now comes the tricky and rinse-repeat part—you will have to ascertain by experiment which F::Q source provides price for the security of interest. For this, go into security definition (via ‘Tools‘ à ‘Security Editor’; get to security by clicking the arrow in front of list entry in the ‘Namespace’ column which will unfurl all securities defined underneath that name space; double click on the one that is of interest to bring up the finer grain definition of the security) and at the bottom portion of that security definition you will see ‘Quote Source Information’ section. This section defines source from where to get the price for that security from. You will now here need to experiment to see which source provides prices by selecting different one, then run through getting prices process (from ‘Tools’ à ‘Price Database’ à ‘Get Quotes’ button) and review whether the price was retrieved or not. If not then change the source to different one and run through getting prices process – rinse-&-repeat for all security of the interest in this fashion. You can speed up this if you are able to navigate around with scripts. See https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface (as Geert and others have pointed out). Scroll down to ‘gnucash-cli --quotes dump’ section slightly further down to utilize that to quickly get to the source that has price for the security that interest you. Then you can update the security definition in GNC to get prices from that ascertained source going forward. I deal with US domiciled equities so yahoo_json had (has?!) been great source until recently and that is the only one I have dealt with. Each source has its own nuances and restriction so of course you will have to learn to stay within those bounds and they change over time. For example Alphavantage limits how many you can retrieve in one shot using the free method. Given that all these sources in F::Q from what I can tell is free ones so your mileage is likely to very and change over time. I hope this puts you on to the right path… From: David Carlson <david.carlson....@gmail.com> Sent: Saturday, May 13, 2023 7:32 AM To: Graham <graham.ba...@gmail.com> Cc: Kalpesh Patel <kalpesh.pa...@usa.net>; gnucash-user <gnucash-user@gnucash.org> Subject: Re: [GNC] Finance:Quote again [sorry] You are not providing enough information. For those stocks, when you set them up, which price source did you select? What do you mean by selecting a stock? On Sat, May 13, 2023 at 6:19 AM Graham <graham.ba...@gmail.com <mailto:graham.ba...@gmail.com> > wrote: On 12/05/2023 17:23, Kalpesh Patel wrote: Thanks Kalpesh - my replies in-line > That is all tell-tale sign of barfed up path for the env... > > Additional steps to debug: > > 1 - Launch normal Command Prompt > > 2 - Type in following to know which perl binary you are actually executing: > > where perl > > --> this should display 'C:\Strawberry\perl\bin\perl.exe' It did. > > 3 - type following at the command prompt (let's validate if the env is setup > correctly or not): > > perl --version > > --> this step should display perl 5, version 28 (your might very in the > version but should be around '28') version 32 > 4 - type following at the command prompt (let's validate if the F::Q is > setup and working correctly): > > perl -MFinance::Quote -e "print $Finance::Quote::VERSION .\"\n\";" > > --> this step should display 1.54 (your might be different version) After turning off antivirus and re-running the installer, it did display 1.54. However,on re-starting GNC, and clicking 'get quotes' when i had selected AAL.L, it did return yesterday's closing price for AAL, but not for anything else. I tried selecting 'LSE' and running 'get quotes' but that did nothing. I then tried selecting another single stock and running it, but that did nothing either. Any thoughts? [Many thanks to everyone who has replied] -- -- Cheerio, Graham _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org <mailto: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. -- David Carlson _______________________________________________ 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.
