Re: GNU Cash Transactions - Wiped Out

2017-11-10 Thread David Carlson
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: > Greetings > > I have

Configuring GnuCash to fetch stock prices from ASX

2017-11-10 Thread Justin Smith
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: $ gnc-fq-dum

Re: Translation...

2017-11-10 Thread Christopher Lam
Hi Thomas >Two major problems: > * The accounting vocabulary has been mixed up and add difficulties to >the simple work of understanding accounting concepts. An example: >the name given to the registers is, in fact, the name accountants >give to the main book that

Re: Translation...

2017-11-10 Thread Jeff Abrahamson
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 seem

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Erik Colson
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', 'CMI.Vcurrenc

Re: GNU Cash Transactions - Wiped Out

2017-11-10 Thread Mike or Penny Novack
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 w

Re: Finance-Quote 1.44 released!

2017-11-10 Thread davelist
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: >> >> >>> On Nov 9, 20

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Les
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, davel...@ma

API Key

2017-11-10 Thread Les
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

Re: API Key

2017-11-10 Thread Maf. King
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

Re: API Key

2017-11-10 Thread 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. _

Re: API Key

2017-11-10 Thread Dale Alspach
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 added bit about adding t

Re: API Key

2017-11-10 Thread Geert Janssens
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: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
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', 'CMI

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
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: API Key

2017-11-10 Thread Les
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

Re: API Key

2017-11-10 Thread Dave H
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=xx

Re: Finance-Quote 1.44 released!

2017-11-10 Thread davelist
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 swit

Re: Finance-Quote 1.44 released!

2017-11-10 Thread Cam Ellison
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, Cam

Re: API Key

2017-11-10 Thread Les
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,

Currency/metals quotes with new f::q 1.45?

2017-11-10 Thread listreader
I am using GnuCash 2.6.16 and Finance-Quote 1.45 (linux). US stock quotes work fine for me but I am not getting how to get precious metals quotes to work through the gnucash frontend. I think I've tried every possible combo of settings in gnucash. Is this available yet? FWIW, here's the data re

Re: API Key

2017-11-10 Thread David T. via gnucash-user
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

Alphavantage Not Showing Up In List Sources

2017-11-10 Thread Jim Sculley
I'm using Linux Mint 18.2, GnuCash 2.6.12 and Finance::Quote 1.45.  I have my API key in place and when testing via gnc-fq-dump everything seems to be working: jim@clifford ~ $ gnc-fq-dump alphavantage GOOGL Finance::Quote fields Gnucash uses:     symbol: GO

Error Connecting with MySql

2017-11-10 Thread Mubasher Usman
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 g_

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

2017-11-10 Thread samsurd2
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 wh