Currency Quotes

2017-11-05 Thread Plutocrat
gnucash-user-requ...@gnucash.org wrote on Monday, 06 November, 2017 05:14 AM: > Please note that while AlphaVantage does appear to offer quite a bunch > of quotes, it doesn't seem to support funds nor currencies. > > I hope someone will come up with one or more sites offering those info > so I can

Re: GnuCash skips lines with identical dollar amounts during bank statement import

2017-11-05 Thread David Reiser
> On Nov 5, 2017, at 6:23 PM, John Ralls wrote: > > > >> On Nov 5, 2017, at 1:59 PM, Todd Dailey wrote: >> >> During a QFX bank statement import, GnuCash skips lines with identical >> dollar amounts. >> >> Example: my mortgage payment is bi-weekly and is withdrawn as the same >> amount 2X

Re: GnuCash skips lines with identical dollar amounts during bank statement import

2017-11-05 Thread David Carlson
Todd, The OFX/QFX import requires a lot of TLC during the import to get everything right. During the verification step it is critical to examine each transaction carefully to be sure that if it is new it gets added, if it matches an existing transaction in your data it is matched to the correct e

Re: GnuCash skips lines with identical dollar amounts during bank statement import

2017-11-05 Thread John Ralls
> On Nov 5, 2017, at 1:59 PM, Todd Dailey wrote: > > During a QFX bank statement import, GnuCash skips lines with identical dollar > amounts. > > Example: my mortgage payment is bi-weekly and is withdrawn as the same amount > 2X or 3X per statement. GnuCash will only import the first occurre

GnuCash skips lines with identical dollar amounts during bank statement import

2017-11-05 Thread Todd Dailey
During a QFX bank statement import, GnuCash skips lines with identical dollar amounts. Example: my mortgage payment is bi-weekly and is withdrawn as the same amount 2X or 3X per statement. GnuCash will only import the first occurrence. GnuCash 2.6.16 _

Re: Copying fields in a filtered account sheet

2017-11-05 Thread John Ralls
Cliff, Glad you’ve got what you need. No magic required: Mailing lists are just servers that accept incoming emails and resend them to everyone who’s subscribed. Regards, John Ralls > On Nov 5, 2017, at 9:59 AM, Cliff Williams wrote: > > John Ralls, > > Brilliant, you have solved my probl

Re: F::Q 1.40 uploaded

2017-11-05 Thread Maf. King
On Sunday, 5 November 2017 19:44:54 GMT Erik Colson wrote: > > I hope someone will come up with one or more sites offering those info > so I can work on that part too. However, my freetime is sparse and I > already took some time I should have put on real world work. So more > coding might take

Re: F::Q 1.40 uploaded

2017-11-05 Thread Fross, Michael
Hello, I'm just trying this out now, but for windows, setting an environment variable is easy. In control panel, select "SYSTEM" then "Advanced System Settings" on the left. There is an environment variables button (poke that). Simply add a new environment variable as Erik mentions in the User

Re: Stock price fetch from ASX broken?

2017-11-05 Thread Chris Good
Hi John, I actually just used the reply option in the nabble webpage. It seems to have done what I wanted which was to send an email to GnuCash User with a link to the nabble thread which contains the instructions for installing the fix. I don't have access to my PC at the moment or much free t

Re: F::Q 1.40 uploaded

2017-11-05 Thread Erik Colson
David T. writes: > Moreover, if I export the variable at a terminal prompt, it seems to go > away upon exit. I imagine I am not the only Mac user challenged by these > points, and I don’t know what Windows users have to do at all. Some > guidance would be greatly helpful! On mac I think it is t

Re: F::Q 1.40 uploaded

2017-11-05 Thread Erik Colson
David T. writes: > As a general question to the GnuCash-users list: How do various GnuCash users > upgrade their F::Q to use this newest version, and how should the environment > variable be set? On my Mac, for example, trying to “upgrade Finance::Quote” > from a CPAN shell tells me that F::Q

Re: F::Q 1.40 uploaded

2017-11-05 Thread David T. via gnucash-user
Erik, Thank you for working on a fix to the Yahoo! Finance problem. I am sure it has been a challenge. As a general question to the GnuCash-users list: How do various GnuCash users upgrade their F::Q to use this newest version, and how should the environment variable be set? On my Mac, for exa

F::Q 1.40 uploaded

2017-11-05 Thread Erik Colson
Hello, F::Q 1.40 adds support for the symbol field for AlphaVantage. This seems to be required for Gnucash users. best -- erik colson ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - P

Re: Online Quote Problem - Mac

2017-11-05 Thread Joshua Morris
Thanks for the speedy response! > On Nov 5, 2017, at 1:05 PM, David T. wrote: > > It’s a known issue. Yahoo has blocked quotes. Everyone hopes for a fix… > > >> On Nov 5, 2017, at 11:43 PM, Joshua Morris wrote: >> >> I’m a very big fan of GnuCash - I use it religiously. Recently, >> out-of

Re: Online Quote Problem - Mac

2017-11-05 Thread David T. via gnucash-user
It’s a known issue. Yahoo has blocked quotes. Everyone hopes for a fix… > On Nov 5, 2017, at 11:43 PM, Joshua Morris wrote: > > I’m a very big fan of GnuCash - I use it religiously. Recently, > out-of-the-blue, I have been having trouble retrieving online quotes. I’ve > updated to the latest

F::Q 1.39 with support for AlphaVantage released to CPAN

2017-11-05 Thread Erik Colson
Hello, F::Q 1.39 with support for the AlphaVantage API has been uploaded to CPAN. You will need to get your own API KEY and add it as an environment variable on your system. You can get it through the website https://www.alphavantage.co/. On linux systems this can an be done by adding this line

Online Quote Problem - Mac

2017-11-05 Thread Joshua Morris
I’m a very big fan of GnuCash - I use it religiously. Recently, out-of-the-blue, I have been having trouble retrieving online quotes. I’ve updated to the latest stable version and done everything I’ve read to fix the issue but it’s still telling me that there is an unknown error. I’m not the be

Fwd: Re: Copying fields in a filtered account sheet

2017-11-05 Thread Cliff Williams
John Ralls, Brilliant, you have solved my problem, thank you very much. As for using the 'list' I just did not understand what you meant. I thought you were referring to keeping or the emails together in a list...Hopefully this email has now been sent correctly to the right place. I'm als

Re: Copying fields in a filtered account sheet

2017-11-05 Thread John Ralls
> On Nov 5, 2017, at 5:32 AM, Cliff Williams wrote: > > Hi John > > Me again..thanks for the prompt reply. > > I am aware of the transaction report facility and the fact that I can > download part of an account (that word again, sorry) but this is very > cumbersome way of obtai

Re: stock price retrieval not working

2017-11-05 Thread John Ralls
> On Nov 5, 2017, at 4:31 AM, Dino Carubia via gnucash-user > wrote: > > Installed latest version of gnucash (2.6.18).Ran "Install online price > retrieval..." > When I try to update stock prices I get the following:"There was an unknown > error while retrieving the price quotes." > I have t

Re: Stock price fetch from ASX broken?

2017-11-05 Thread John Ralls
> On Nov 5, 2017, at 4:03 AM, ChrisGood wrote: > > Now that yahoo is no longer allowing users to use their API, users can still > get stock quotes for Australian stocks from the ASX by using my fix to > ASX.pm as per instructions in the nabble post I am replying to now. > Hopefully the Finance:

Re: Price Editor

2017-11-05 Thread Jim Muchow
Thanks for the info, Colin. On Sun, Nov 5, 2017 at 9:37 AM, Colin Law wrote: > On 5 November 2017 at 15:09, Jim Muchow wrote: > > Helpfully, the Bugzilla system threw up the following when > > I was setting up to create a new bug. > > > > https://bugzilla.gnome.org/show_bug.cgi?id=766028 > > >

Re: Price Editor

2017-11-05 Thread Colin Law
On 5 November 2017 at 15:09, Jim Muchow wrote: > Helpfully, the Bugzilla system threw up the following when > I was setting up to create a new bug. > > https://bugzilla.gnome.org/show_bug.cgi?id=766028 > > It's not only been seen, but also fixed. Just need to wait > for a newer version. You likel

Re: Price Editor

2017-11-05 Thread Jim Muchow
Helpfully, the Bugzilla system threw up the following when I was setting up to create a new bug. https://bugzilla.gnome.org/show_bug.cgi?id=766028 It's not only been seen, but also fixed. Just need to wait for a newer version. Thanks again, John On Sun, Nov 5, 2017 at 6:37 AM, Jim Muchow wrot

Re: stock price retrieval not working

2017-11-05 Thread D via gnucash-user
Dino, This is known. Apparently, Yahoo has disabled quote retrieval for many users, and this is true for the tool that Gnucash uses to retrieve quotes. We will all have to see what happens I this. David On November 5, 2017, at 5:37 PM, Dino Carubia via gnucash-user wrote: Installed latest v

Re: F::Q not working... any ideas for workaround ?

2017-11-05 Thread Michael Fross
There is a Google finance module for Python, but I've not looked into it and have no idea how to integrate it with GC. Michael On Sat, Nov 4, 2017 at 11:31 PM D via gnucash-user wrote: > Brad, GB, > > This is an approach that would be difficult to do on a Mac, since users > have to specially co

Re: Price Editor

2017-11-05 Thread Jim Muchow
Thanks for the info, John. I will reproduce and do/send the items requested. On Sat, Nov 4, 2017 at 11:48 PM, John Ralls wrote: > > > On Nov 4, 2017, at 3:10 PM, Jim Muchow wrote: > > On Sat, Nov 4, 2017 at 4:39 PM, Colin Law wrote: > > On 4 November 2017 at 21:12, Jim Muchow wrote: > > I kno

stock price retrieval not working

2017-11-05 Thread Dino Carubia via gnucash-user
Installed latest version of gnucash (2.6.18).Ran "Install online price retrieval..." When I try to update stock prices I get the following:"There was an unknown error while retrieving the price quotes." I have tried to use the "multiple sources" option, but I still cannot get any prices. If I tr

RE: Stock price fetch from ASX broken?

2017-11-05 Thread ChrisGood
Now that yahoo is no longer allowing users to use their API, users can still get stock quotes for Australian stocks from the ASX by using my fix to ASX.pm as per instructions in the nabble post I am replying to now. Hopefully the Finance::Quote maintainers will be able to make a new release that in