Re: [GNC] Alpha Vantage API key not working properly.
Sure, I run Gnucash Build ID: 4.13+(2022-12-17), Finance::Quote: 1.54 under Fedora Core 37. Saludos cordiales desde Barcelona :) Wolfgang On 22.03.23 13:38, Murugan Muruganandam wrote: Wolfgang can you please detail the install version and Operating system. Saludos Cordiales Murugan *From:* gnucash-user on behalf of Wolfgang P Rauchholz *Sent:* Wednesday, March 22, 2023 9:08 AM *To:* gnucash-u...@lists.gnucash.org *Subject:* [GNC] Alpha Vantage API key not working properly. Hello gnucash community! I started using gnucash for my personal finances. I do have some questions, but the most pressing one is that there is something not working with the Alpha Vantage API key. I validated that I have a valid API key and I entered it in the correspondent field of Gnucash Preferences. In the price editor I don't get quotes for currencies, although I do get quotes for funds, stocks, etc.. When I ran on CLI this command "gnc-fq-dump -v currency EUR USD" I get the message that the key is missing. After that I set the key (on CLI) with export ALPHAVANTAGE_API_KEY=## and ran again "gnc-fq-dump -v currency EUR USD". Now this time I got a quote; 1 EUR = 1.0802636 USD What am I missing? Thanks for your help. and insight. Wolfgang ___ 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] Alpha Vantage API key not working properly.
Wolfgang can you please detail the install version and Operating system. Saludos Cordiales Murugan From: gnucash-user on behalf of Wolfgang P Rauchholz Sent: Wednesday, March 22, 2023 9:08 AM To: gnucash-u...@lists.gnucash.org Subject: [GNC] Alpha Vantage API key not working properly. Hello gnucash community! I started using gnucash for my personal finances. I do have some questions, but the most pressing one is that there is something not working with the Alpha Vantage API key. I validated that I have a valid API key and I entered it in the correspondent field of Gnucash Preferences. In the price editor I don't get quotes for currencies, although I do get quotes for funds, stocks, etc.. When I ran on CLI this command "gnc-fq-dump -v currency EUR USD" I get the message that the key is missing. After that I set the key (on CLI) with export ALPHAVANTAGE_API_KEY=## and ran again "gnc-fq-dump -v currency EUR USD". Now this time I got a quote; 1 EUR = 1.0802636 USD What am I missing? Thanks for your help. and insight. Wolfgang ___ 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] Alpha Vantage API key not working properly.
Hello gnucash community! I started using gnucash for my personal finances. I do have some questions, but the most pressing one is that there is something not working with the Alpha Vantage API key. I validated that I have a valid API key and I entered it in the correspondent field of Gnucash Preferences. In the price editor I don't get quotes for currencies, although I do get quotes for funds, stocks, etc.. When I ran on CLI this command "gnc-fq-dump -v currency EUR USD" I get the message that the key is missing. After that I set the key (on CLI) with export ALPHAVANTAGE_API_KEY=## and ran again "gnc-fq-dump -v currency EUR USD". Now this time I got a quote; 1 EUR = 1.0802636 USD What am I missing? Thanks for your help. and insight. Wolfgang ___ 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.
Future change in handling the Alpha Vantage API key
Just a heads up that starting with gnucash 2.6.20 and 2.7.4 (beta release to become 3.0) it will no longer be necessary to edit the gnucash environment file to get Finance::Quote working with the Alpha Vantage quote source. Instead there will be a new option under Edit->Preferences->Online Quotes where you can set the key from within gnucash. This has two advantages: 1. (most obvious) this should be easier 2. you only have to set the key once. It won't be overwritten during a gnucash application update. I have updated the gnucash FAQ [1] accordingly. The only remaining issue is that gnc-fq-update will not retrieve the key from the gnucash settings. So if you run gnc-fq-update you will still need to add it to the environment as described in the FAQ. On a related note, as of the same future gnucash releases you will also find the version of Finance::Quote that gnucash discovered on the system in the Gnucash About dialog. Regards, Geert [1] https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F ___ 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: API Key
Les, Dave, Thanks for airing this out a little more. I had not succeeded in getting this to work, mostly because I didn’t understand the FAQ, which tells us to add the environment key to "/etc/gnucash/environment where prefix is:” in one spot, and then says "/Applications/Gnucash.app/Contents/Resources on MacOS." Apparently my memory has become so abbreviated that by the time I got to the second part, I had forgotten about the first part, and added the variable to a new environment file in “/Applications/Gnucash.app/Contents/Resources”, rather than adding the value to the functional (and already existing) environment file in /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment. I have modified the FAQ so that this ambiguity is removed. You might call it idiot-proofing. I’ll own that. David > On Nov 11, 2017, at 4:03 AM, Les <lellio...@gmail.com> wrote: > > Thanks, that worked. Now I'm good to go on both systems. > > Thanks to all. > > Les > > > On 11/10/2017 03:13 PM, Dave H wrote: >> Les, >> >> Just right click on the environment file name in finder and choose "Open >> With" / "TextEdit.app". Scroll down and add it to the bottom of the file >> and then save the file, exit text editor and you're away >> >> i.e. >> >> # Setup ALPHAVANTAGE_API_KEY for Finance:Quote >> ALPHAVANTAGE_API_KEY=x >> >> Cheers Dave H. >> >> On 11 November 2017 at 06:09, Les <lellio...@gmail.com >> <mailto:lellio...@gmail.com>> wrote: >> >>I successfully added the API to Linux MInt 18.2. (I used sudo xed >>to add the key. After, I used Security Editor to change my stocks >>to Alphavantage.) Thanks for the pointers. >> >>How do I make the entry on MacOS 10.13? I am rather new to Mac so >>I don't know how to do edits. I know what and where I need to >>make the entry. >> >>Thanks, >> >> >> >>On 11/10/2017 10:24 AM, Maf. King wrote: >> >>Hi Les, >> >>have a read of the FAQ - there is a recently added bit about >>adding the API >>key. >> >> >> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F >> >> <https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F> >> >>HTH, >>Maf. >> >> >>On Friday, 10 November 2017 16:07:52 GMT Les wrote: >> >>I just obtained an API key from AlphaVantage, but I do not >>have a clue >>as to how to add the key to my LInux Mint or Mac OS systems. >> >>Could someone please walk me through the process? >> >> >>Thanks, >> >>Les >> >>___ >>gnucash-user mailing list >>gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >>https://lists.gnucash.org/mailman/listinfo/gnucash-user >><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 <mailto:gnucash-user@gnucash.org> >>https://lists.gnucash.org/mailman/listinfo/gnucash-user >><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 > 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 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: API Key
Thanks, that worked. Now I'm good to go on both systems. Thanks to all. Les On 11/10/2017 03:13 PM, Dave H wrote: Les, Just right click on the environment file name in finder and choose "Open With" / "TextEdit.app". Scroll down and add it to the bottom of the file and then save the file, exit text editor and you're away i.e. # Setup ALPHAVANTAGE_API_KEY for Finance:Quote ALPHAVANTAGE_API_KEY=x Cheers Dave H. On 11 November 2017 at 06:09, Les <lellio...@gmail.com <mailto:lellio...@gmail.com>> wrote: I successfully added the API to Linux MInt 18.2. (I used sudo xed to add the key. After, I used Security Editor to change my stocks to Alphavantage.) Thanks for the pointers. How do I make the entry on MacOS 10.13? I am rather new to Mac so I don't know how to do edits. I know what and where I need to make the entry. Thanks, On 11/10/2017 10:24 AM, Maf. King wrote: Hi Les, have a read of the FAQ - there is a recently added bit about adding the API key. https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F <https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F> HTH, Maf. On Friday, 10 November 2017 16:07:52 GMT Les wrote: I just obtained an API key from AlphaVantage, but I do not have a clue as to how to add the key to my LInux Mint or Mac OS systems. Could someone please walk me through the process? Thanks, Les ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> https://lists.gnucash.org/mailman/listinfo/gnucash-user <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 <mailto:gnucash-user@gnucash.org> https://lists.gnucash.org/mailman/listinfo/gnucash-user <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 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: API Key
Les, Just right click on the environment file name in finder and choose "Open With" / "TextEdit.app". Scroll down and add it to the bottom of the file and then save the file, exit text editor and you're away i.e. # Setup ALPHAVANTAGE_API_KEY for Finance:Quote ALPHAVANTAGE_API_KEY=x Cheers Dave H. On 11 November 2017 at 06:09, Les <lellio...@gmail.com> wrote: > I successfully added the API to Linux MInt 18.2. (I used sudo xed to add > the key. After, I used Security Editor to change my stocks to > Alphavantage.) Thanks for the pointers. > > How do I make the entry on MacOS 10.13? I am rather new to Mac so I don't > know how to do edits. I know what and where I need to make the entry. > > Thanks, > > > > On 11/10/2017 10:24 AM, Maf. King wrote: > >> Hi Les, >> >> have a read of the FAQ - there is a recently added bit about adding the >> API >> key. >> >> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F >> >> HTH, >> Maf. >> >> >> On Friday, 10 November 2017 16:07:52 GMT Les wrote: >> >>> I just obtained an API key from AlphaVantage, but I do not have a clue >>> as to how to add the key to my LInux Mint or Mac OS systems. >>> >>> Could someone please walk me through the process? >>> >>> >>> Thanks, >>> >>> Les >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> 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 > 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 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: API Key
I successfully added the API to Linux MInt 18.2. (I used sudo xed to add the key. After, I used Security Editor to change my stocks to Alphavantage.) Thanks for the pointers. How do I make the entry on MacOS 10.13? I am rather new to Mac so I don't know how to do edits. I know what and where I need to make the entry. Thanks, On 11/10/2017 10:24 AM, Maf. King wrote: Hi Les, have a read of the FAQ - there is a recently added bit about adding the API key. https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F HTH, Maf. On Friday, 10 November 2017 16:07:52 GMT Les wrote: I just obtained an API key from AlphaVantage, but I do not have a clue as to how to add the key to my LInux Mint or Mac OS systems. Could someone please walk me through the process? Thanks, Les ___ gnucash-user mailing list gnucash-user@gnucash.org 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 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: API Key
Op vrijdag 10 november 2017 18:03:59 CET schreef Maf. King: > On Friday, 10 November 2017 17:02:21 GMT Dale Alspach wrote: > > On linuxmint 18.2 (likely most linux distributions) the prefix /usr listed > > in wiki is not correct. It should be empty, i.e., /etc/gnucash/environment > > is the file. > > Dale > > Also true on OpenSuSE leap 42.3 > > Maf. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. As is on most cases where the gnucash package was installed via the linux system's own package manager. I have corrected the faq. Thanks for pointing this out. Geert ___ gnucash-user mailing list gnucash-user@gnucash.org 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: API Key
On linuxmint 18.2 (likely most linux distributions) the prefix /usr listed in wiki is not correct. It should be empty, i.e., /etc/gnucash/environment is the file. Dale On Nov 10, 2017 10:28 AM, "Maf. King" <m...@chilwell.net> wrote: > Hi Les, > > have a read of the FAQ - there is a recently added bit about adding the API > key. > > https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F > > HTH, > Maf. > > > On Friday, 10 November 2017 16:07:52 GMT Les wrote: > > I just obtained an API key from AlphaVantage, but I do not have a clue > > as to how to add the key to my LInux Mint or Mac OS systems. > > > > Could someone please walk me through the process? > > > > > > Thanks, > > > > Les > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > 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. > > > -- > Maf. King > PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 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: API Key
On Friday, 10 November 2017 17:02:21 GMT Dale Alspach wrote: > On linuxmint 18.2 (likely most linux distributions) the prefix /usr listed > in wiki is not correct. It should be empty, i.e., /etc/gnucash/environment > is the file. > Dale > Also true on OpenSuSE leap 42.3 Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org 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: API Key
Hi Les, have a read of the FAQ - there is a recently added bit about adding the API key. https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F HTH, Maf. On Friday, 10 November 2017 16:07:52 GMT Les wrote: > I just obtained an API key from AlphaVantage, but I do not have a clue > as to how to add the key to my LInux Mint or Mac OS systems. > > Could someone please walk me through the process? > > > Thanks, > > Les > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > 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. -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org 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.
API Key
I just obtained an API key from AlphaVantage, but I do not have a clue as to how to add the key to my LInux Mint or Mac OS systems. Could someone please walk me through the process? Thanks, Les ___ gnucash-user mailing list gnucash-user@gnucash.org 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.