On Sun, 12 Nov 2017 21:27:47 -0600
listreader wrote:
> > >> me "0.0200". Should I NOT be using alphavantage for the currency
> > >> quotes in gc?
> > >
> > > I have no idea. I don't know how gnucash actually gets the quote
> > > for currencies from F::Q. It might
This is a perl module. To update in a terminal window follow these steps
from a recent post:
sudo perl -MCPAN -e shell
Then in the perl shell:
reload index
upgrade Finance::Quote
Dale
On 11/12/2017 08:02 PM, David Carlson wrote:
> I cannot find Finance::Quote on my Ubuntu 16.04 computer that
I added the alphavantage key to my environment, and now gnc-fq-dump work fine
from the command line. However, when I run Gnucash, it still fails. I did add
the key to /etc/gnucash/environment. Any ideas?
(1.45 on Ubuntu)
On Sun, Nov 12, 2017 at 05:32:24PM +0100, Erik Colson wrote:
>
> Brian
On 11/12/17 18:02, David Carlson wrote:
I cannot find Finance::Quote on my Ubuntu 16.04 computer that has GnuCash
6.12 installed. How can I update it? I have tried using Synaptic and even
searching with files.
David C
snip
Try GetDeb to update -
> >> me "0.0200". Should I NOT be using alphavantage for the currency
> >> quotes in gc?
> >
> > I have no idea. I don't know how gnucash actually gets the quote
> > for currencies from F::Q. It might i.e. use another method...
> > Maybe a developper from GnuCash can help here?
>
> We
>No tests should fail if you set following environment variable:
>>export ONLINE_TEST=0
>>By default ONLINE_TEST should not be defined, which is basically the
>same. I guess you might have this variable set somewhere?
>best
>--
>erik colson
I set that in both the GNC and system environment per
Yeah it's not a key problem for me, it's in my environment file and I
source it in the shell. Without the key, I get a different specific error
about the key being absent.
Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred
> On Nov 12, 2017, at 5:51 PM, David Carlson
> wrote:
>
> I thought I saw instructions somewhere on how to update the Finance-Quote
> module, but now I cannot find it. The instructions in the GnuCash FAQ are
> not sufficiently complete for dummies like me. I get
AlphaVantage.
Be sure to get the key in the right places. There are two, one for the app, one
for command line. See the FAQ.
David
On November 13, 2017, at 6:50 AM, Greg Etling wrote:
David, using alphavantage, or yahoo_json? The latter still works for me with
1.47.
> On Nov 12, 2017, at 4:27 PM, Christine via gnucash-user
> wrote:
>
> Hello
> All my files are on the desktop where I saved them. So I put them in a
> folder and now when I try to open one of the pages, it asks me to save it,
> if I click on save it wants a new path,
I thought I saw instructions somewhere on how to update the Finance-Quote
module, but now I cannot find it. The instructions in the GnuCash FAQ are
not sufficiently complete for dummies like me. I get an error
gnc-fq-update command not found then I do not know what to do next.
David C
For what it's worth, my Mac is using 5.18 without problem with F::Q 1.45.
David
On November 13, 2017, at 3:15 AM, Erik Colson wrote:
Greg Etling writes:
> I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
> all possible as I've
Thanks, Erik.
Peter
On 13/11/2017 10:27, Erik Colson wrote:
prl writes:
my $suffix = uc($1);
yes, I've already committed it for the next version.
best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
Hello
All my files are on the desktop where I saved them. So I put them in a
folder and now when I try to open one of the pages, it asks me to save it,
if I click on save it wants a new path, how can I work from a main folder
pls?
Christine
-Original Message-
From: gnucash-user
Cam Ellison writes:
> On 12/11/17 08:27 AM, Erik Colson wrote:
>> New version 1.47 of Finance-Quote is available with the following changes:
>>
>> * Use AlphaVantage for currency quotes instead of Yahoo (Mike
>> Alexander)
>>
>>
> FYI: USD->CAD now works, but not
On 12/11/17 08:27 AM, Erik Colson wrote:
New version 1.47 of Finance-Quote is available with the following changes:
* Use AlphaVantage for currency quotes instead of Yahoo (Mike
Alexander)
FYI: USD->CAD now works, but not GBP->CAD.
Cheers
Cam
listreader writes:
> I had to find the source of currency-lookup.pl via google but did and
> "perl -Ilib currency-lookup.pl XAG USD" works: "XAG->USD = 16.87475774"
> (price varying from yours because the market is now open for the day)
> but "gnc-fq-dump alphavantage
> > 1.47 - No errors but returns the wrong price data, i.e. for gold:
> >
> > :~> gnc-fq-dump alphavantage XAU
> >
> > Finance::Quote fields Gnucash uses:
> > symbol: XAU <=== required
> > date: 11/10/2017 <=== recommended
> > currency: USD
Hi,
Em sex, 2017-11-10 às 18:50 +0100, Erik Colson escreveu:
> rmcas...@gmail.com writes:
>
> > Hi,
> >
> > I changed the YahooJSON module to use the new API variables and the
> > new
> > URL. It is attached for anyone who wants to test. It's not a very
> > clean
> > code, it's just an
On 11/12/2017 05:25 PM, John Ralls wrote:
On Nov 12, 2017, at 2:13 PM, Chris Szilagyi wrote:
On 11/12/2017 04:02 PM, John Ralls wrote:
On Nov 12, 2017, at 10:36 AM, Chris Szilagyi wrote:
On 11/12/2017 11:01 AM, John Ralls wrote:
On Nov 12,
prl writes:
> my $suffix = uc($1);
yes, I've already committed it for the next version.
best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Keith Myers writes:
> I've had nothing but failed builds ever since I think 1.45. Most of
> the test builds fail with errors. But at least the alphavantage test
> successfully completes. What I do now is to use the --force and
> --notest options when I upgrade the F:Q
Keith Myers writes:
> Thanks for the reply Erik. I kept missing that source way down at the
> bottom of the list a couple of times. Changed to yahoo_json and was able
> to get the FT Portfolios symbols to pull. But didn't you say that that
> source is questionable for the
Gentlemen:
I'm running Linux Mint 18.1.
I've installed Finance::Quote 1.45 and acquired an ALPHAVANTAGE key.
I've tested 1.45 by using this string "export
ALPHAVANTAGE_API_KEY=" in terminal (using my new key, of
course). 1.45 returns the proper quote information. I found
> Lots of output follows, most tests failed:
hmmm... I'm out of ideas for now. Your Perl is pretty old. Although it
should be working AFAIK, would you mind upgrading to a recent version ?
best
--
erik colson
I've had nothing but failed builds ever since I think 1.45. Most of the test
builds
Keith Myers writes:
> I used to be able to pull quotes for FT Portfolios symbols FOEMJX and
> FDNWFX from Yahoo. I have not been able to get F:Q to pull these
> symbols from either alphavantage, ftportfolios or
> ftportfolios_direct. These are the only securities that I
> On Nov 12, 2017, at 1:57 PM, Liz wrote:
>
> I've put a small piece on the FAQ about this, with the intention that
> the information gets picked up by the search engines.
> I don't actually use F::Q, so could someone with wiki edit privileges
> who understands what has and
> On Nov 12, 2017, at 2:13 PM, Chris Szilagyi wrote:
>
> On 11/12/2017 04:02 PM, John Ralls wrote:
>>> On Nov 12, 2017, at 10:36 AM, Chris Szilagyi
>>> wrote:
>>>
>>> On 11/12/2017 11:01 AM, John Ralls wrote:
> On Nov 12, 2017, at 4:38
Greg Etling writes:
> I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
> all possible as I've already had to blow away one profile over the years
> due to too much tinkering with perl. I'll take it under consideration, but
> for now I'll just have to
On 11/12/2017 04:02 PM, John Ralls wrote:
On Nov 12, 2017, at 10:36 AM, Chris Szilagyi wrote:
On 11/12/2017 11:01 AM, John Ralls wrote:
On Nov 12, 2017, at 4:38 AM, Chris Szilagyi wrote:
Hello:
Recently our Discover credit card online
I'm on OSX Sierra, and I'd prefer not to try to overlay a new perl if at
all possible as I've already had to blow away one profile over the years
due to too much tinkering with perl. I'll take it under consideration, but
for now I'll just have to leave this broken. Thanks anyway.
Greg
Greg Etling writes:
> Lots of output follows, most tests failed:
hmmm... I'm out of ideas for now. Your Perl is pretty old. Although it
should be working AFAIK, would you mind upgrading to a recent version ?
best
--
erik colson
I've put a small piece on the FAQ about this, with the intention that
the information gets picked up by the search engines.
I don't actually use F::Q, so could someone with wiki edit privileges
who understands what has and is happening enlarge on this - perhaps a
wiki page linked to the FAQ.
If
> On Nov 12, 2017, at 10:57 AM, Ettore Scalese
> wrote:
>
> Dear Sirs,
>
> I am getting an error message from GnuCash, when I am trying to update online
> shares' prices in my porfolio.
>
>
> The message I get is in Italian (I use GnuCash in that language
you need to get yourself an api key on alphavantage.co, set it as an
environment variable and then change the datasource in gnucash to
'alphavantage'. That seems to be documented somewhere on gnucash
website, check the mailing list archive for the link.
Also upgrade to F::Q v1.46.
best
--
erik
listreader writes:
> On Sun, 12 Nov 2017 17:37:50 +0100
> Erik Colson wrote:
>
>> listreader writes:
>>
>> > 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
Greg Etling writes:
>> perl -MFinance::Quote -e 'print $Finance::Quote::VERSION'
>>
>
> 1.47
>
>
>> and
>>
>> perl -v
>>
>
> This is perl 5, version 18, subversion 2 (v5.18.2) built for
> darwin-thread-multi-2level
> (with 2 registered patches, see perl -V for more
Dear Sirs,
I am getting an error message from GnuCash, when I am trying to update online
shares' prices in my porfolio.
The message I get is in Italian (I use GnuCash in that language version), and
the translation in English would be as follows:
* An unknown error happened while
On Sun, Nov 12, 2017 at 4:05 PM, Erik Colson wrote:
>
> Greg Etling writes:
>
> > Same result when I cd into that directory and run as either:
> > perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> > alphavantage SCHB
> > or
> >
Greg Etling writes:
> Same result when I cd into that directory and run as either:
> perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> alphavantage SCHB
> or
> perl -Ilib Examples/stockdump.pl alphavantage SCHB
Well, that is weird...
Can you send
> On Nov 12, 2017, at 10:36 AM, Chris Szilagyi wrote:
>
> On 11/12/2017 11:01 AM, John Ralls wrote:
>>
>>> On Nov 12, 2017, at 4:38 AM, Chris Szilagyi wrote:
>>>
>>> Hello:
>>>
>>> Recently our Discover credit card online banking stopped
On Sun, 12 Nov 2017 17:37:50 +0100
Erik Colson wrote:
> listreader writes:
>
> > 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
prl writes:
> Hi, Eric.
>
> Thanks for getting back to me.
>
> I reported in my original email that using tls.ax shows no currency:
you need to uppercase at least the suffix.
best
--
erik colson
___
gnucash-user mailing list
After the release of F:Q 1.47, I was able to update to in on my LInux
Mint 18.2 and now I am able to update stocks and currencies via Price
Editor's Get Quotes!
Now waiting for F:Q 1.47 to migrate to my Mac where running the script I
get FQ is up to date at 1.45.
Three chears for Eric!
On
Hi, Eric.
Thanks for getting back to me.
I reported in my original email that using tls.ax shows no currency:
gnc-fq-dump -valphavantage tls.ax
Finance::Quote fields Gnucash uses:
symbol: tls.ax <=== required
date: 11/09/2017 <=== recommended
*currency: **
Did you add the line containing your key to /etc/gnucash/environment as
described in the wiki
and restart gnucash?
If so is gnucash actually using the new Finance::Quote package?
I am running linux mint 18.2 and just followed the directions in the wiki.
Alphavantage showed up on the list.
Dale
On Sun, Nov 12, 2017 at 1:58 PM, Erik Colson wrote:
>
> Greg Etling writes:
>
> > #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.
> pl
> > alphavantage SCHB
>
> you need to run this command from the directory
>
Keith Myers writes:
> I used to be able to pull quotes for FT Portfolios symbols FOEMJX and
> FDNWFX from Yahoo. I have not been able to get F:Q to pull these
> symbols from either alphavantage, ftportfolios or
> ftportfolios_direct. These are the only securities that I
I used to be able to pull quotes for FT Portfolios symbols FOEMJX and FDNWFX
from Yahoo. I have not been able to get F:Q to pull these symbols from either
alphavantage, ftportfolios or ftportfolios_direct. These are the only
securities that I have not been able to get the reworked F:Q
On 11/12/2017 01:37 PM, gnucash-user-requ...@gnucash.org wrote:
On Nov 12, 2017, at 4:38 AM, Chris Szilagyi
wrote:
Hello:
Recently our Discover credit card online banking stopped working.
I have tried setting the dates to as far back as 6 months, and up to the
past
Greg Etling writes:
> #perl -Ilib ~/.cpan/build/Finance-Quote-1.47-IUv7sO/Examples/stockdump.pl
> alphavantage SCHB
you need to run this command from the directory
~/.cpan/build/Finance-Quote-1.47-IUv7sO
otherwise the -Ilib won't use the correct library
best
--
erik
On 11/12/2017 11:01 AM, John Ralls wrote:
On Nov 12, 2017, at 4:38 AM, Chris Szilagyi wrote:
Hello:
Recently our Discover credit card online banking stopped working. It seems to be caused
by our credit card number being changed, I think, as the time it stopped was
Same issue here... Any ideas?
thanks :-)
Am 11.11.2017 um 00:46 schrieb 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:
>
>
>
>
Erik,
Thanks for the quick reply. The error message is gone with 1.47, although
I'm still unsuccessful in retrieving any quotes from what looks like an
issue on the AlphaVantage site:
#perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump
alphavantage SCHB
Finance::Quote fields
Greg Etling writes:
> Commands:
> export ALPHAVANTAGE_API_KEY=XXX...
> perl /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump -v
> alphavantage SCHB.US
>
> Note: same exact behavior happens with 'SCHB' and 'US:SCHB' formulations
> and other ticker symbols.
>
>
Like many others, I'm trying to get AlphaVantage up and running, but
running into an error I haven't seen discussed yet. I followed the FAQ
instructions (
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F) to
add an ALPHAVANTAGE_API_KEY to
Like many others, I'm trying to get AlphaVantage up and running, but
running into an error I haven't seen discussed yet. I followed the FAQ
instructions (https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_
online_quoting_work.3F) to add an ALPHAVANTAGE_API_KEY to /
Ok. In terminal, have you set ALPHAVANTAGE_API_KEY using an export command?
That must be set *in the terminal session* in order to retrieve quotes in
terminal.
David
On November 12, 2017, at 10:10 PM, Les wrote:
>Yes, that is the path I used. In the terminal, I changed
Ok, that works. Thanks!!
On 11/12/2017 08:43 AM, David Reiser wrote:
If gnucash is even letting you punch the “Get Quotes” button, it
thinks both perl and finance-quote are installed correctly.
If the environment file you edited is
Yes, that is the path I used. In the terminal, I changed to the path
you indicated and now that part works but does not return any useful
data (No price quote, date or currency).
But progress just the same. Thanks David.
On 11/12/2017 08:33 AM, David T. wrote:
I’ll assume that you mean
listreader writes:
> 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
Brian M. Sutin writes:
> $ gnc-fq-dump -v vanguard VTSAX
> No results found for stock VTSAX.
>
> $ gnc-fq-dump -v nasdaq ibm
> No results found for stock ibm.
>
> $ gnc-fq-dump -v nyse ATGE
> No results found for stock ATGE.
These won't work ass vanguard,
New version 1.47 of Finance-Quote is available with the following changes:
* Use AlphaVantage for currency quotes instead of Yahoo (Mike Alexander)
Authors:
- Dj Padzensky , PadzNet, Inc.
- Linas Vepstas
- Yannick LE NY
-
Hello users,
I released versions 1.46 and 1.47 to cpan.
Version 1.46 is to be considered with increased stability and a modified
yahoo_json module which apparently seems to have moved to a new URL.
The module might stop working soon depending on Yahoo's decision.
Version 1.47 is considered
New version 1.46 of Finance-Quote is available with the following changes:
* Drop long-obsolete debian directory (Florian Schlichting)
* AlphaVantage:
- added support for .IL => USD currency and division (Adriano Baldi)
- graceful error catchup (Mike Alexander)
Your /etc/gnucash/environment file does not affect your shell which is why
gnc-fq-dump isn't working for alphavantage.
-derek
Sent using my mobile device. Please excuse any typos.
On November 12, 2017 10:20:10 AM "Brian M. Sutin" wrote:
I am unable to get gnc-fq-dump
I am unable to get gnc-fq-dump to work on almost everything. I am running
v1.45 on Ubuntu. I did get a hit off of TIAA-CREF, so it works in general.
$ gnc-fq-dump -v vanguard VTSAX
No results found for stock VTSAX.
$ gnc-fq-dump -v nasdaq ibm
No results found for stock ibm.
$
Hi Erik
Some example symbol for the suffix .IL
https://finance.yahoo.com/quote/OGZD.IL?p=OGZD.IL
https://finance.yahoo.com/quote/LKOD.IL?p=LKOD.IL
https://finance.yahoo.com/quote/MNOD.IL?p=MNOD.IL
https://finance.yahoo.com/quote/VTBR.IL?p=VTBR.IL
Thanks again.
Best regards
Adriano
If gnucash is even letting you punch the “Get Quotes” button, it thinks both
perl and finance-quote are installed correctly.
If the environment file you edited is
/Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment
then it looks to me like you only need the
I’ll assume that you mean
/Applications/Gnucash.app/Contents/Resources/environment (note the lower case
‘e’; case matters in MacOS). If not, then that will be the problem.
To run gnc-fq-dump, you need to be in
/Applications/Gnucash.app/Contents/Resources/bin
David
> On Nov 12, 2017, at 7:10
Adriano writes:
> Hello Erik
>
> Sorry for my English, I am Italian.
>
> As always you did a great job!
> And with a speed that does not allow me to compete ;-).
thx!
> I'm following stock markets in the USA, Canada TSX and TSXV, Milan, London,
> Oslo, Copenhagen and
prl writes:
> F::Q 1.45 seems to be returning the wrong currency (or none) for
> Australian Stock Exchange (ASX) stocks.
>
> For example, for Telstra (ASX:TLS), if I run:
> gnc-fq-dump alphavantage asx:tls
>
> I get:
> currency: USD
Currencies are deduced based on suffix.
I added Alphavantage API key to the end of
/Applications/Gnucash.app/Contents/Resources/Environment, which is where
I was informed it needed to be. Is this no correct?
As for command line, I have tried running changing directories to
/Applications/Gnucash.app .
On 11/12/2017 07:30 AM,
Cam Ellison writes:
> 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.
Hello:
Recently our Discover credit card online banking stopped working. It
seems to be caused by our credit card number being changed, I think, as
the time it stopped was around the time they changed it. Originally I
went in to the AQBanking setup and just changed the account # there, and
I have had GC installed on my Mac for a very long time, and until Yahoo
pulled the plug everything worked great! So, I would have to believe
that Perl is already in the path. The only changes I have made were to
add the Alphavantage key to the end of the environment file and updating
GC to
I did an export and tried running F:Q in the terminal with the -v and
still get "no such file or directory".
On 11/12/2017 05:08 AM, Dave H wrote:
Hi Les,
Have you tried running it with the -v (verbose) option to get a bit
more information back ?
Running F:Q directly in Terminal works OK
One thing to check is that perl is in the path so GNC can find the
executable.
Michael
On Sun, Nov 12, 2017 at 6:09 AM Dave H wrote:
> Hi Les,
>
> Have you tried running it with the -v (verbose) option to get a bit more
> information back ?
>
> Running F:Q directly in
Hi Les,
Have you tried running it with the -v (verbose) option to get a bit more
information back ?
Running F:Q directly in Terminal works OK on MacOS 10.13 here but only
after I first issue a "export ALPHAVANTAGE_AKI_KEY="
command so you might find that's what is needed when
When I run the same command from my Linux Mint 18.2 I get
Finance::Quote fields Gnucash uses:
symbol: NYSE:TGT (deduced) <=== required
date: ** missing ** <=== recommended
currency: ** missing ** <=== required
last: <=\
nav:
80 matches
Mail list logo