Re: GNU Cash Transactions - Wiped Out

[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 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 will be highly APPRECIATED.
>
> Yours Sincerely
>
> Roy Molepo
> ___
> 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.

Configuring GnuCash to fetch stock prices from ASX

[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-dump asx bhp
Finance::Quote fields Gnucash uses:
symbol: bhp  <=== required
  date: ** missing **<=== recommended
  currency: AUD  <=== required
  last: 28.070   <=\
   * correct price *
   nav:  <=== one of these
 price: 28.070   <=/
  timezone:  <=== optional

** This quote will have today's date, which might be incorrect.
   GnuCash will use it, but you might prefer that it doesn't.


But, when I set the single quote source for this stock to "Australian Stock
Exchange, AU", GnuCash returns an error "Unable to retrieve quotes for
these items..."

Does anyone know why gnc-fq-dump works but GnuCash doesn't?

BTW I updated F::Q to version 1.45.


Cheers,
Justin.
___
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: Translation...

[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 sums up all the transactions of all
>accounts. Another example, the word "Transaction" is not used in
>this context, and have a different meaning (transaction is more
>like a "deal"). Examples are numerous. It is so confusing that I
>thought it could be useful to create my own .po file and recompile
>the whole thing.
>

It will be useful to have a native speaker explain concepts and use correct
words. Thank you for your contribution!


>
>  * But another problem appears : some columns have been inverted. For
>example,asset account register columns have weird title AND are
>reversed. So, it is difficult to understand the titles and the user
>cannot rely on "Debit" on left and "Credit" on right. How is that
>possible?
>
>
Are you relating to the register for a bank account? The register
debit/credit, for most individuals, is confusing, and does not match the
bank statement which presents the bank's (well, duh) statement of your
account, rather than your own statement. The following explains it all:

http://www.finweb.com/banking-credit/debit-reversed-in-banking-accounting.html#axzz4y1epdNbF
https://www.accountingcoach.com/debits-and-credits/explanation
https://en.wiktionary.org/wiki/debit

In formal accounting, for an asset account such as bank, debits will
*increase* it. But the usual bank statement received by the account holder
will state the opposite. Hence, to the layterm, to "debit an account"
usually means to try to empty it.

HTH
___
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: Translation...

[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 to make it easier to move between organisations) and (2) the market
is hollowed out by a recent law that prevents anyone who is subject to
VAT from using open source accounting software (which seems abusive and
is).  The last means there are fewer professionals using gnucash than
one might hope.

Jeff


On 10/11/17 12:16, Christopher Lam wrote:
> 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 sums up all the transactions of all
>>accounts. Another example, the word "Transaction" is not used in
>>this context, and have a different meaning (transaction is more
>>like a "deal"). Examples are numerous. It is so confusing that I
>>thought it could be useful to create my own .po file and recompile
>>the whole thing.
>>
> It will be useful to have a native speaker explain concepts and use correct
> words. Thank you for your contribution!
>
>
>>  * But another problem appears : some columns have been inverted. For
>>example,asset account register columns have weird title AND are
>>reversed. So, it is difficult to understand the titles and the user
>>cannot rely on "Debit" on left and "Credit" on right. How is that
>>possible?
>>
>>
> Are you relating to the register for a bank account? The register
> debit/credit, for most individuals, is confusing, and does not match the
> bank statement which presents the bank's (well, duh) statement of your
> account, rather than your own statement. The following explains it all:
>
> http://www.finweb.com/banking-credit/debit-reversed-in-banking-accounting.html#axzz4y1epdNbF
> https://www.accountingcoach.com/debits-and-credits/explanation
> https://en.wiktionary.org/wiki/debit
>
> In formal accounting, for an asset account such as bank, debits will
> *increase* it. But the usual bank statement received by the account holder
> will state the opposite. Hence, to the layterm, to "debit an account"
> usually means to try to empty it.
>
> HTH
> ___
> 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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
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: Finance-Quote 1.44 released!

[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.Vcurrency_set_by_fq' => 1,
  'CMI.Vvolume' => '5000',
  'CMI.Vmethod' => 'alphavantage',
  'CMI.Vhigh' => '1.1400',
  'CMI.Vlow' => '1.1000',
  'CMI.Vcurrency' => 'CAD',
  'CMI.Vsymbol' => 'CMI.V',
  'CMI.Vlast' => '1.1000',
  'CMI.Vsuccess' => 1,
  'CMI.Vdate' => '11/09/2017',
  'CMI.Visodate' => '2017-11-09'
};

The required fields for gnucash return correct data.  So F::Q does the
job.  There will probably be something misconfigured in your gnucash
setup..

best
--
erik colson
___
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: GNU Cash Transactions - Wiped Out

[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 will be highly APPRECIATED.

Yours Sincerely

Roy Molepo
Let's get clear about what you are and are not seeing. If I am wrong 
interpreting what you are trying to describe, say so.


I am taking what you describe when starting gnucash is that it opens a 
file where you DO see all of the accounts you expect to see, but when 
you ask it to open an account, you don't see the transactions you expect 
to see.


Things to check:
a) Is this the right file that was opened? You should see its name 
displayed. Remember, you data is NOT "in the program" but in data files 
(you can have several, one program (gnucash) being used to keep 
different books.


b) If it is the right file, check that there are no date range filters 
in effect. For example, if you were (accidentally) asking gnucash to 
show you just 2018 on you would not expect to see any transactions.


Michael D Novack
___
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: Finance-Quote 1.44 released!

[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, 2017, at 4:46 AM, Erik Colson  wrote:
>>> 
>>> 
>>> davel...@mac.com writes:
>>> 
 Thanks for all your work on this. A symbol I cannot get to work is QREARX 
 (a TIAA-CREF mutual fund).
 
 https://finance.yahoo.com/quote/QREARX?p=QREARX
 
 I don't know if it's something wrong with AlphaVantage or Finance::Quote.
>>> 
>>> This symbol isn't supported by the alphavantage API.  So we'll need to
>>> find another source for it. Anyone?
>>> 
>>> best
>>> --
>>> erik colson
>> 
>> Thanks. I emailed alphavantage through the support option on their website 
>> so we'll see what they say. It's strange that all the other TIAA-CREF funds 
>> I have work fine.
>> 
>> Dave
>> 
> 

___
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: Finance-Quote 1.44 released!

[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...@mac.com wrote:

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, 2017, at 4:46 AM, Erik Colson  wrote:


davel...@mac.com writes:


Thanks for all your work on this. A symbol I cannot get to work is QREARX (a 
TIAA-CREF mutual fund).

https://finance.yahoo.com/quote/QREARX?p=QREARX

I don't know if it's something wrong with AlphaVantage or Finance::Quote.

This symbol isn't supported by the alphavantage API.  So we'll need to
find another source for it. Anyone?

best
--
erik colson

Thanks. I emailed alphavantage through the support option on their website so 
we'll see what they say. It's strange that all the other TIAA-CREF funds I have 
work fine.

Dave


___
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.

API Key

[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
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

[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 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.

Re: API Key

[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.

Re: API Key

[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 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

[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.
> > 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: Finance-Quote 1.44 released!

[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.Vclose' => '1.1000',
   'CMI.Vcurrency_set_by_fq' => 1,
   'CMI.Vvolume' => '5000',
   'CMI.Vmethod' => 'alphavantage',
   'CMI.Vhigh' => '1.1400',
   'CMI.Vlow' => '1.1000',
   'CMI.Vcurrency' => 'CAD',
   'CMI.Vsymbol' => 'CMI.V',
   'CMI.Vlast' => '1.1000',
   'CMI.Vsuccess' => 1,
   'CMI.Vdate' => '11/09/2017',
   'CMI.Visodate' => '2017-11-09'
 };

The required fields for gnucash return correct data.  So F::Q does the
job.  There will probably be something misconfigured in your gnucash
setup..


I am suspecting as much. There is no alphavantage key error, so it is 
clearly present in the bash environment. For example:

gnc-fq-dump alphavantage ALV.V
Finance::Quote fields Gnucash uses:
    symbol: ALV.V    <=== required
  date: 11/10/2017   <=== recommended
  currency: CAD  <=== required
  last: 0.1950   <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

"nav" is not set, which may be the problem, or one of them.  I notice 
that it is blank when I test it with US stocks as well, so perhaps not.


Gnucash is throwing an error on something for which no or insufficient 
information is available.  I'll go look at bug reports.


Thank you very much for your time and effort

Cam

___
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: Finance-Quote 1.44 released!

[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

___
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]

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

[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=x

Cheers Dave H.

On 11 November 2017 at 06:09, Les  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: Finance-Quote 1.44 released!

[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 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, 2017, at 4:46 AM, Erik Colson  wrote:
 
 
 davel...@mac.com writes:
 
> Thanks for all your work on this. A symbol I cannot get to work is QREARX 
> (a TIAA-CREF mutual fund).
> 
> https://finance.yahoo.com/quote/QREARX?p=QREARX
> 
> I don't know if it's something wrong with AlphaVantage or Finance::Quote.
 
 This symbol isn't supported by the alphavantage API.  So we'll need to
 find another source for it. Anyone?
 
 best
 --
 erik colson
>>> 
>>> Thanks. I emailed alphavantage through the support option on their website 
>>> so we'll see what they say. It's strange that all the other TIAA-CREF funds 
>>> I have work fine.
>>> 
>>> Dave
>>> 
>> 
> 
> ___
> 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: Finance-Quote 1.44 released!

[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

___
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]

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 > 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.

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

[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 returned when directly accessing alphavantage for
a silver quote using https:

"https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_currency=XAG&to_currency=USD&apikey=(mykey)"

"Realtime Currency Exchange Rate": 
 "1. From_Currency Code": "XAG",
 "2. From_Currency Name": "Silver Ounce",
 "3. To_Currency Code": "USD",
 "4. To_Currency Name": "United States Dollar",
 "5. Exchange Rate": "16.89899689",
 "6. Last Refreshed": "2017-11-11 04:21:27",
 "7. Time Zone": "UTC"

Thanks.

Ralph
___
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

[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/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  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 > > 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.

___
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.

Alphavantage Not Showing Up In List Sources

[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: GOOGL    <=== required
  date: 11/10/2017   <=== required
  currency: USD  <=== required
  last: 1044.1500    <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional
===

However, when I try to set up quote retrieval in GnuCash, alphavantage is not listed as a quote source.  When I switch 
the type of quote source to 'Unknown' as described in the FAQ, the drop down list has only the following 9 entries:


adig

bet

fetch_live_currencies

fidelityfixed

hufund

hungary

hustock

known_currencies

yahoo_yql


Using gnc-fq-check, there are many more listed, including alphavantage:



jim@clifford ~ $ gnc-fq-check
("1.45" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia" "asx" "australia" "bamosz" "bet" 
"bmonesbittburns" "bourso" "brasil" "bse" "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch" 
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed" "financecanada" "finanzpartner" 
"finland" "fool" "france" "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece" "hex" "hu" 
"hufund" "hungary" "hustock" "indiamutual" "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp" 
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds" "sixfunds" "sixshares" "stockhousecanada_fund" 
"tdefunds" "tdwaterhouse" "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx" "uk_unit_trusts" 
"ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd" "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" 
"yahoo_europe" "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")



What did I miss?


___
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.

Error Connecting with MySql

[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_utf8_to_utf16: assertion 'str != NULL' failed
* 14:57:45  CRIT  [mysql_error_fn()] DBI error: 1292:
Incorrect datetime value: '1970010100' for column 'timespec_val' at row
1
* 14:57:45  CRIT  [conn_execute_nonselect_statement()]
Error executing SQL INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','3e30d2cd8728e886f5ae5a637019b8a4',0,1,NULL)
* 14:57:45  CRIT  [gnc_sql_do_db_operation()] SQL error:
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','3e30d2cd8728e886f5ae5a637019b8a4',0,1,NULL)
* 14:57:45  CRIT  save_slot: assertion 'pSlot_info->is_ok'
failed
* 14:57:45  CRIT  gnc_dbi_transaction_rollback: assertion
'sql_savepoint > 0' failed
* 15:00:53  CRIT  g_utf8_to_utf16: assertion 'str != NULL' failed
* 15:01:02  CRIT  [mysql_error_fn()] DBI error: 1292:
Incorrect datetime value: '1970010100' for column 'timespec_val' at row
1
* 15:01:02  CRIT  [conn_execute_nonselect_statement()]
Error executing SQL INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','88daf84aca9c8d3fda87f321c3564e62',0,1,NULL)
* 15:01:02  CRIT  [gnc_sql_do_db_operation()] SQL error:
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'1970010100','88daf84aca9c8d3fda87f321c3564e62',0,1,NULL)
* 15:01:02  CRIT  save_slot: assertion 'pSlot_info->is_ok'
failed
* 15:01:02  CRIT  gnc_dbi_transaction_rollback: assertion
'sql_savepoint > 0' failed

*What Can I do ?*

*Best Regards,*


*Mubasher Usman*

*Software Engineer (J2EE)*
​*NovaPex Tech. & *​
*T​​TR-Group ​DE​*
Tel:  +92 311 1379796 | Skype: mubasherusman




*​*
*Disclaimer:* This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify the
sender. If you are not the intended recipient of this e-mail, you are
prohibited from reading, printing, duplicating, disseminating or otherwise
using this information. Please note that any views or opinions presented in
this email are solely those of the author. Recipient should check this
email and any attachments for the presence of viruses.
___
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.

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

[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 when I return from being out of town.
The same .gnucash account file and Finance-Quote 1.38 ran fine on both 
machines until Yahoo did its thing on Nov. 1.


Yesterday I did the following on the Win 8.1 machine.

1) Got a free AlphaVantage API key
2) Set a new Environmental Variable for both User and System 
(ALPHAVANTAGE_API_KEY=)
3) Removed the previously installed version of Perl from the machine 
(including running a registry cleaner)
4) Installed Strawberry Perl  5.26.1.1 (downloaded 
strawberry-perl-5.26.1.1-64bit.msi from http://strawberryperl.com/)
5) Ran "Install Online Price Retrieval" from the Start Menu which 
successfully installed Finance-Quote 1.45
6) Opened GnuCash and used the Security Editor Tool to change the quote 
source to Unknown -> alphavantage on all stocks and funds
7) Used Price Editor Tool to successfully retrieve new quotes (long 
list, took 2+ minutes)


Today, I did the following on the Win 10.0 machine.

1) Used the previously acquired AlphaVantage API key to set a new 
Environmental Variable for both User and System 
(ALPHAVANTAGE_API_KEY=)
2) Removed the previously installed version of Perl from the machine 
(including running a registry cleaner)
3) Installed Strawberry Perl  5.26.1.1 (downloaded 
strawberry-perl-5.26.1.1-64bit.msi from http://strawberryperl.com/)
4) Ran "Install Online Price Retrieval" from the Start Menu which 
successfully installed Finance-Quote 1.45
5) Opened the .gnucash account file from the Win 8.1 machine that was 
saved on Dropbox yesterday
6) Used the Security Editor Tool to verify that the quote source was 
already set to Unknown -> alphavantage on all stocks and funds

7) Used Price Editor Tool to attempt to retrieve new quotes
8) Got the message ("An error occurred while trying to...") produced 
previously when trying to get quotes from Yahoo.
9) Got a new AlphaVantage API key and used it to change the 
Environmental Variables
10) Used Price Editor Tool to attempt to retrieve new quotes and got the 
same unsuccessful result


Any suggestions for a next step would be appreciated.

___
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.