Re: [GNC] Next release of F::Q

[Eric Coates]

Hi

Apologies. It seems that my email system has developed a mind of its own 
and sent an early and incomplete version of this note.


I've been away for some time. Since returning I have not been able to 
find any information about an upgrade to Finance::Quote.


It seemed from the work done by Erik Colson and Chris Good that an 
update to version 1.47 (which I have installed) was within grasp. Is it 
expected to be released soon?


If not, is there a way that I (ignorant as I am) can in any way 
dupliacte Chris's work to get something working on my machine?


As always. many thanks to all who develop and support gnucash.

Eric

=

On 10/09/2018 10:33, Chris Good wrote:

Erik Colson
 eco
at ecocode.net wrote on gnucash-user Thu Aug 16 05:20:42 EDT 2018

  


Hello all,

  


I'm on some extended vacation and will be back home next week.  My

intent is to release F::Q from master at the end of this month.

  


The alphavantage module has undergone some modifications which should

make it more reliable since we can now tell the module at which speed it

can question the alphavantage API.

  


Before releasing F::Q, I would like as many feedback as possible on the

best working arguments.  You can therefor play with the following

variables in the Alphavantage.pm file:

  


my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries
per y seconds

  


Probably we should now set quantity to 5 and seconds to 61, but maybe

there are some better values?  The values above seem to work pretty well

on my automated home system.  Sometimes queries get rejected, but the

module is now smart enough to insert a delay if alphavantage API refuses

to answer queries.

  


The purpose of next release is to fix the problems with Alphavantage

speed control, so I won't add any other commits to other modules for

this release.  I've seen some messages on github concerning

Alphavantage.pm and will read those while enhancing the module.

  


best

--

erik colson

  

  


Hi Erik,

  


Thanks for working on this.

I have done some testing using the current github master Quote.pm &
AlphaVantage.pm.

  


Here are my results:

  


I have 16 stocks but only 1 currency.

  


Using the F::Q 1.47  code:

Only the first 5 stocks worked, the others failed.

  


Using your mods (& my variations in timing), there was never a failure to
return all the quotes requested. Yay!

  


Using your timing of no more than 20 queries per 65 seconds:

real3m0.735s

real2m20.476s

real2m19.217s

real2m17.692s

real2m19.923s

  


Using timing of no more than 5 queries per 60 seconds:

real3m2.503s

real3m2.320s

real2m9.449s

real2m32.282s

  


Using timing of no more than 5 queries per 59 seconds:

real2m59.858s

  


Using timing of no more than 20 queries per 50 seconds:

real3m1.121s

real2m38.678s

  


Looks like your 20 in 65 seconds is pretty good, which doesn't seem to agree
with

https://www.alphavantage.co/premium/ which says:

  


In certain high-frequency use cases that exceed our standard call-frequency
limit (5 requests per minute), we offer a dedicated, premium API key which
allows various tiers of API calls per minute.

  


Can you please release the new version asap?

  


Can you please also merge
https://github.com/finance-quote/finance-quote/pull/79

   (yahooJSON.pm returns date 00/00/2000 in Windows)

as this also fixes perl warnings which can cause GnuCash to hang when
multiple quotes (>15) are requested.

  


Regards, Chris Good

  


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


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

[GNC] int

[tom9...@earthlink.net]

   I have an interest bearing checking account that has paid interest
   every month until October (per their monthly statement). When I called
   them, they said it was calculated at $.008. I want to put a zero dollar
   transaction in GnuCash but whenever I try, I shows blanks instead of
   zeros. How do I get it to show zeros instead of blanks, so if look back
   at it in the future & see the absence of interest I won't have to call
   the back all over again to find out why.
___
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: [GNC] alpha advantage

[brad]

I switched to the quote source 'Yahoo as JSON'  & it works great.

On 10/28/18 11:50 PM, Steven Anter wrote:

version of gnucash = 3.0
OS = windows 10

Changes = none, other than adding a couple new securities

A couple securities =  NYSE:AA
FUND:VTSAX
NASDAQ:VNQI

On Sun, Oct 28, 2018 at 10:39 PM David Carlson 
wrote:


You are very lucky if you were getting 50 prices from AlphaVantage as
recently as a week ago.  Since there have been several different causes of
impaired performance you really need to provide all the details I mentioned
in my first reply to you and even a couple of example securities and
exchange on which they are traded in order for others on this user list to
suggest solutions to your problem.

David C

On Mon, Oct 29, 2018 at 12:22 AM Steven Anter  wrote:


David,

I have about 50+ securities. Alpha has been working ok, albeit with a few
incorrect prices, until this weekend. What list are you talking about that
I should "search?"

On Sun, Oct 28, 2018 at 9:57 PM David Carlson <
david.carlson@gmail.com> wrote:


Steven,

AlphaVantage stopped working for those of us with more than a few
securities several months ago when they started throttling services.  Some
of us have also had issues after downloading release 3.3 or so of GnuCash.
Search this list for info that seems to match your particular problem or
provide more details about when it last worked for you, what version of
GnuCash you are using, your computer OS,  and what you have changed since
it last worked for suggestions about how to restore price retrieval.

David C

On Sun, Oct 28, 2018 at 3:44 PM Steven Anter  wrote:


I've been using alpha advantage to download quotes for some time now.
However, it fails with message:  "unable to retrieve quotes for these
items."  The list includes all my securities.  Is there a new
development
with alpha advantage that I should know about?
___
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.


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


___
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: [GNC] alpha advantage

[Les]

I did the same thing a few months ago and have had a great experience.  
The only problem I have now is having trouble obtaining currencies, 
which I believe are still part of Alpha Advantage.


Les

On 10/30/18 11:05 AM, brad wrote:

I switched to the quote source 'Yahoo as JSON'  & it works great.

On 10/28/18 11:50 PM, Steven Anter wrote:

version of gnucash = 3.0
OS = windows 10

Changes = none, other than adding a couple new securities

A couple securities =  NYSE:AA
    FUND:VTSAX
    NASDAQ:VNQI

On Sun, Oct 28, 2018 at 10:39 PM David Carlson 


wrote:


You are very lucky if you were getting 50 prices from AlphaVantage as
recently as a week ago.  Since there have been several different 
causes of
impaired performance you really need to provide all the details I 
mentioned

in my first reply to you and even a couple of example securities and
exchange on which they are traded in order for others on this user 
list to

suggest solutions to your problem.

David C

On Mon, Oct 29, 2018 at 12:22 AM Steven Anter  
wrote:



David,

I have about 50+ securities. Alpha has been working ok, albeit with 
a few
incorrect prices, until this weekend. What list are you talking 
about that

I should "search?"

On Sun, Oct 28, 2018 at 9:57 PM David Carlson <
david.carlson@gmail.com> wrote:


Steven,

AlphaVantage stopped working for those of us with more than a few
securities several months ago when they started throttling 
services.  Some
of us have also had issues after downloading release 3.3 or so of 
GnuCash.
Search this list for info that seems to match your particular 
problem or
provide more details about when it last worked for you, what 
version of
GnuCash you are using, your computer OS,  and what you have 
changed since

it last worked for suggestions about how to restore price retrieval.

David C

On Sun, Oct 28, 2018 at 3:44 PM Steven Anter  
wrote:


I've been using alpha advantage to download quotes for some time 
now.
However, it fails with message:  "unable to retrieve quotes for 
these

items."  The list includes all my securities.  Is there a new
development
with alpha advantage that I should know about?
___
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.


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


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

___
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: [GNC] GNC 3.3 CSV Importer Freezing on MacOS

[Wole Lawani]

I was unable to get the CSV import to work.

Eventually I converted the CSV to a QIF file and that worked.
On Sun, Oct 28, 2018 at 10:34 PM Wole Lawani  wrote:
>
> Thanks John.
> I had tested with a small (c. 100 transactions) segment of the larger
> file but it still freezes.
>
> On Sun, Oct 28, 2018 at 10:28 PM John Ralls  wrote:
> >
> > If you made a large CSV it might be 
> > https://bugs.gnucash.org/show_bug.cgi?id=795383.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Oct 28, 2018, at 2:19 PM, klawani  wrote:
> > >
> > > Hi.
> > > A few days ago I was able to do my first successful CSV import on my GNC 
> > > 3.3
> > > installation (MacOS 10.12.6 - Sierra).
> > > I then spent a week preparing a much larger import. The CSV file is
> > > basically the same structure as was used for the earlier successful run - 
> > > in
> > > fact I'm using the settings I saved at the time.
> > >
> > > But now the CSV import doesn't work. When I click "next" on the 
> > > "transaction
> > > information" window everything stops...it freezes. I've done this several
> > > times and left it to run for hours at one point so I'm quite sure it's not
> > > just being slow.
> > >
> > > Any ideas would be appreciated. Because I'm having to forcefully terminate
> > > the application, each time I restart it it fails to obtain the file lock 
> > > and
> > > I select the "open anyway" option - could this be relevant?
> > >
> > > Thanks in advance.
> > >
> > >
> > >
> > > --
> > > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > > ___
> > > 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.
> >
___
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: [GNC] Online Banking Upgrade hosed Name and Memo field

[Alan Marsh]

The "new and improved" online banking allows me to export to .csv, .ofx,
.qfx, and .qbo
I am using the File > Import > Import OFX/QFX menu option.

Even in the CSV format, the Description and Memo fields show the same as
 and  in both .ofx and .qfx
I'm thinking I'll have to pre-process the file as John mentions.

I'm very out of date on programming stuff and only dabbled with Python
once... stuck in a corporate Microsoft world.
Any suggestions on what to use and maybe a sample script from someone
else forced to do this sort of thing. Last time this happened, I changed
credit unions. Besides this one problem, I'm pretty happy at this one.
Thanks!

On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote:
> What do you mean by online banking.?  Are you actually using the
> OFX import?> 
> If so, just do not use the option to update the transaction when
> matching.  Then Gnucash leaves the description unchanged.> 
> David C
> 
> On Mon, Oct 29, 2018, 7:49 PM John Ralls  wrote:
>> 
>> 
>> > On Oct 29, 2018, at 5:38 PM, Alan Marsh  wrote:
>>  > 
>>  > NAME and MEMO were identical in old xml (either ofx or qfx)
>>  > POS PURCH - KROGER FUEL CTR  554
>>  > POS PURCH - KROGER FUEL CTR  5542   IL DECATUR
>>  > 4615 E. US ROUTE 36US
>>  > After online banking upgrade it now gives me
>>  > 
>>  > POS PURCH
>>  > KROGER FUEL CTR  5542   IL DECATUR 4615
>>  > E. US>>  > ROUTE 36US
>>  > Which means all transactions in gnucash say just POS PURCH for the>>  > 
>> Description and you have to expand each one to see the actual memo
>>  > entry>>  > to know who was paid.
>>  > Any idea how to fix this?
>> 
>>  Does your bank offer QIF export? Maybe they didn't bork that.
>>  Otherwise you're stuck with pre-processing the file with the
>>  scripting language of your choice.>> 
>>  Regards,
>>  John Ralls
>>  ___
>>  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.

___
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: [GNC] Online Banking Upgrade hosed Name and Memo field

[David Carlson]

Before you go down that path see if any others on this maillist have had
the same problem with release 3.3.  I am still on 2.6.15 or 17, so I have
not seen the revised importers.

David C

On Tue, Oct 30, 2018 at 7:31 PM Alan Marsh  wrote:

> The "new and improved" online banking allows me to export to .csv, .ofx,
> .qfx, and .qbo
>
> I am using the File > Import > Import OFX/QFX menu option.
>
> Even in the CSV format, the Description and Memo fields show the same as
>  and  in both .ofx and .qfx
>
> I'm thinking I'll have to pre-process the file as John mentions.
>
> I'm very out of date on programming stuff and only dabbled with Python
> once... stuck in a corporate Microsoft world.
>
> Any suggestions on what to use and maybe a sample script from someone else
> forced to do this sort of thing. Last time this happened, I changed credit
> unions. Besides this one problem, I'm pretty happy at this one.
>
> Thanks!
>
> On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote:
>
> What do you mean by online banking.?  Are you actually using the OFX
> import?
>
> If so, just do not use the option to update the transaction when
> matching.  Then Gnucash leaves the description unchanged.
>
> David C
>
> On Mon, Oct 29, 2018, 7:49 PM John Ralls  wrote:
>
>
>
> > On Oct 29, 2018, at 5:38 PM, Alan Marsh  wrote:
> >
> > NAME and MEMO were identical in old xml (either ofx or qfx)
> > POS PURCH - KROGER FUEL CTR  554
> > POS PURCH - KROGER FUEL CTR  5542   IL DECATUR
> > 4615 E. US ROUTE 36US
> > After online banking upgrade it now gives me
> >
> > POS PURCH
> > KROGER FUEL CTR  5542   IL DECATUR 4615 E. US
> > ROUTE 36US
> > Which means all transactions in gnucash say just POS PURCH for the
> > Description and you have to expand each one to see the actual memo entry
> > to know who was paid.
> > Any idea how to fix this?
>
> Does your bank offer QIF export? Maybe they didn't bork that. Otherwise
> you're stuck with pre-processing the file with the scripting language of
> your choice.
>
> Regards,
> John Ralls
> ___
> 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.
>
>
>
___
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.

[GNC] Backup

[Bob Hammons]

I have been using Gnucash since the first of the year.  The data files are in a 
directory named gnucash and it save a lot of backups. I am using Windows 10. I 
open filer and control c the days files, sometimes as high as 20,  and paste 
them to a thumb drive for backup.  Is this all I need to backup or is there 
other files ?  Can I take the thumb drive to a different computer, to my 
accountant,  with gnucash installed and have the info he needs?


 thanks Bob
___
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: [GNC] Backup

[D via gnucash-user]

Check out https://wiki.gnucash.org/wiki/Backup

HTH,
David

On October 31, 2018, at 6:23 AM, Bob Hammons  wrote:

I have been using Gnucash since the first of the year.  The data files are in a 
directory named gnucash and it save a lot of backups. I am using Windows 10. I 
open filer and control c the days files, sometimes as high as 20,  and paste 
them to a thumb drive for backup.  Is this all I need to backup or is there 
other files ?  Can I take the thumb drive to a different computer, to my 
accountant,  with gnucash installed and have the info he needs?


 thanks Bob
___
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.
___
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: [GNC] Backup

[David Cousens]

Bob,

There will be the main data file, x.gnucash, log files and backup files in 
your gnucash directory. The logfiles and
backup files will have the same basename as your mainfile, but will have a 
timestamp as part of the filename, i.e
x..log  and x..gnucash. If you have a datafile 
problem at some point, you can load a
backup file  known to be good and then load the log files up to the time of 
failure to restore your data file. How many
of these you keep can be defined in the user preferences. This is not however 
an adequate backup strategy overall as it
will not protect you from computer hardware failures etc See 
https://wiki.gnucash.org/wiki/Backup for more information.

David Cousens

On Wed, 2018-10-31 at 00:52 +, Bob Hammons wrote:
> I have been using Gnucash since the first of the year.  The data files are in 
> a directory named gnucash and it save a
> lot of backups. I am using Windows 10. I open filer and control c the days 
> files, sometimes as high as 20,  and paste
> them to a thumb drive for backup.  Is this all I need to backup or is there 
> other files ?  Can I take the thumb drive
> to a different computer, to my accountant,  with gnucash installed and have 
> the info he needs?
> 
> 
>  thanks Bob
> ___
> 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.

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