F::Q on Windows 8.1 works ok, Windows 10.0 no joy

For background, I've been using GnuCash 2.6.16 on an HP desktop running Win 8.1 and an HP laptop running Win 10.0 Home version. I usually update quotes on the Win 8.1 machine, store the .gnucash account file on Dropbox and then download/run that file to the Win 10.0 machine. I do the reverse

Error Connecting with MySql

Hi, Gnucash ver 2.6.18 windows. MySQL 5.7.20 latest one just downloaded today. i am trying to save my accounts (by save as) into mysql database with root user having full permissions. But I always get the eror and upon searching the error in tace files I found the following. * 14:57:36 CRIT

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

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

Re: Finance-Quote 1.44 released!

For anyone who has been following this thread, and especially for Erik: The problem turned out to be a couple of stocks that I no longer hold but are still in the table for historical reasons, whose quote assignments were incorrect. All good now. Thank you again, Erik, for your patience,

Re: Finance-Quote 1.44 released!

Sorry, I had left the other TIAA funds using the TIAA source but had accidentally set QREARX to use AlphVantage. Switching it to using TIAA as the source works again. Dave > On Nov 10, 2017, at 9:31 AM, davel...@mac.com wrote: > > I'm not sure. I'll check that tonight and let you know. I

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

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

Re: Finance-Quote 1.44 released!

Having re-read the FAQ, I think it may just be a time-out problem. I may have to change the cron job to the middle of the night - at least until there's a change in gnucash that will recognize this and allow for the extra time. Thank you, once again, Cam

Re: Finance-Quote 1.44 released!

On 10/11/17 05:21 AM, Erik Colson wrote: Cam, I don't know about gnucash itself since I don't use it. F::Q handels the symbols correctly as shown below for CMI.V: ~/.../finance-quote/Examples >>> perl stockdump.pl alphavantage CMI.V $VAR1 = { 'CMI.Vopen' => '1.1400',

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.

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" wrote: > Hi Les, > > have a read of the FAQ - there is a recently

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.

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

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

Re: Finance-Quote 1.44 released!

I have just obtained the API key from ALPHAVANTAGE, but I do not have a clue how to add it to my LinuxMint or MacOs.  (I am not technical) :-[ Could someone please walk me through this process, so I can begin updating stock and currency prices? Thanks, Les On 11/10/2017 08:31 AM,

Re: Finance-Quote 1.44 released!

I'm not sure. I'll check that tonight and let you know. I switched everything to AlphaVantage the other day. Dave > On Nov 9, 2017, at 11:46 AM, David T. wrote: > > Does the TIAA-CREF module not work? > > David > >> On Nov 9, 2017, at 7:31 PM, davel...@mac.com wrote: >>

Re: GNU Cash Transactions - Wiped Out

On 11/9/2017 3:39 PM, Roy Molepo wrote: Greetings I have been using GNU Cash and processed transactions for 12 months. Today when I opened the Program all my processed transactions have been wiped out / disappeared. All balances are now ZEROS. How can I recover my processed transactions? Help

Re: Finance-Quote 1.44 released!

Cam, I don't know about gnucash itself since I don't use it. F::Q handels the symbols correctly as shown below for CMI.V: ~/.../finance-quote/Examples >>> perl stockdump.pl alphavantage CMI.V $VAR1 = { 'CMI.Vopen' => '1.1400', 'CMI.Vclose' => '1.1000',

Re: Translation...

Thanks for your efforts, Thomas. FYI, there's a somewhat dormant gnucash-fr list that might also be helpful.  (I suspect you know, but just in case.) For others:  France is a particularly weird case, because (1) we have nationally legislated account numbers (which seems invasive, but it does

Configuring GnuCash to fetch stock prices from ASX

Hi All, I had configured GnuCash to fetch stock prices with a single quote source set to "Yahoo Australia". Like many others on this list, this stopped working recently when Yahoo discontinued their service. After trying a few things, I noticed that the following works: $

Re: GNU Cash Transactions - Wiped Out

Roy, What is the name of your data file and where do you have it stored? If all the accounts are devoid of transactions, are they all present? Did you look for the backups that are mentioned in the online FAQs? David C On Thu, Nov 9, 2017 at 2:39 PM, Roy Molepo wrote: