Re: [GNC] Finance-Quote 1.49 released!
Geert Janssens writes: > Well the thanks extends to this release as well :) Hi Geert, This release would not have happened without Vincent Lucarelli and Bruce P Schuck. Therefor I welcome your message which certainly will help keep us all motivated :) enjoy the new release! -- erik colson ___ 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] Finance-Quote 1.49 released!
New version 1.49 of Finance-Quote is available with the following changes: * Alphavantage: Removed Time::HiRes dependency due to mswin32 not supporting clock_gettime calls. Authors: - Dj Padzensky , PadzNet, Inc. - Linas Vepstas - Yannick LE NY - Paul Fenwick - Brent Neal - Volker Stuerzl - Keith Refson - Rob Sessink - Leigh Wedding - Tobias Vancura - James Treacy - Bradley Dean - Erik Colson ___ 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] Finance-Quote 1.48 released!
New version 1.48 of Finance-Quote is available with the following changes: * Alphavantage: Add a waiting mechanism to comply to alphavantage use terms * Alphavantage: Added several stock exchange support and currency * Updated modules: Union, Deka, Indiamutual, ASX, Yahoojson, TSP, AEX, Fool * New modules: IEXTrading, MorningstarAU, MorningstarCH, IEXCloud * Yahoo: removed modules referring to yahoo API, which yahoo stopped * BUGFIX: 'use of uninitialized value' returned by perl could make gnucash fail when more than 15 quotes where requested * BUGFIX: MS Windows does not support %T in strftime call * Added new documentation files: Release.txt, Hackers-Guide, Modules-README.yml * We started moving known failing tests into TODO blocks * This release is the result of hard work by Bruce Schuck, Vincent Lucarelli, Pieter-Jan Vandormael, Manuel Friedli, Jalon Avens, Chris Good, Mark J. Cox, Eelco Dolstra, Henrik Ahlgren, Vinay Shastry, Mike Alexander, Erik Colson. * Special thanks go to Bruce Schuck and Vincent Lucarelli which joined the maintainers team! Authors: - Dj Padzensky , PadzNet, Inc. - Linas Vepstas - Yannick LE NY - Paul Fenwick - Brent Neal - Volker Stuerzl - Keith Refson - Rob Sessink - Leigh Wedding - Tobias Vancura - James Treacy - Bradley Dean - Erik Colson ___ 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] Cannot retrieve quotes for some securities
David T. via gnucash-user writes: > Alphavantage implemented limits on the number of quotes that can be retrieved > at a time. This was discussed some months back, with suggestions on different > remedies. > > Changing the source to "Yahoo as json" is one of those solutions. Editing the > perl in Finance::Quote to add a time delay was another. YMMV. Or using Finance::Quote from the master branch on github where Alphavantage module has been updated to follow limits imposed by the site. -- erik colson ___ 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] Certain Quotes not fetching (NASDAQ, OTCMKTS)
tref95 writes: > Hello, > > Ever since August 1, my NASDAQ and OTCMKTS quotes have not been fetching. > However, my funds and NYSE are still fetching. I am currently using > AlphaVantage, but when I switched one to YahooJSON, I still received the > error for it. > > Did something change in August? Is this related to waiting for the new > version of F::Q? Can be. Would you mind posting a list of stock symbols (as queried by F::Q) which did work and do not work anymore? best -- erik colson ___ 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] Next release of F::Q
brad writes: > My version of AlphaVantage.pm in > /usr/local/share/perl/5.26.1/Finance/Quote/AlphaVantage.pm has no > maxQueries variable. I just ran gnc-fq-update. Do we need to get the > latest from github? Hello Brad, You need to get the whole F::Q from github master branch. F::Q is developed using Dist::Zilla. So you need to install Dist::Zilla first, get F::Q either with "git clone" or download the zip-file at https://github.com/finance-quote/finance-quote/archive/master.zip. Then run "dzil install" from the command line to actually install F::Q. Dzil will probably ask you to install some dependencies, just follow the instructions given. You will then have a version F::Q 1.48 installed. It is however a pre-release version and therefor you will have to force install F::Q 1.48 once finally released. If you are not familiar with command-line and git, or if you hardly understand what this does, I wouldn't recommend to install F::Q from github at all. best -- erik colson ___ 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] Next release of F::Q
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 ___ 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: Finance::Quote still not working with alphavantage
John Ralls <jra...@ceridwen.us> writes: > Looks to me like Alphavantage's server has a problem. Not for me.. ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/stockdump.pl alphavantage T $VAR1 = { 'Tisodate' => '2017-11-17', 'Tcurrency' => 'USD', 'Thigh' => '34.8800', 'Tlast' => '34.5100', 'Tsuccess' => 1, 'Tlow' => '34.3500', 'Tclose' => '34.5100', 'Topen' => '34.4300', 'Tdate' => '11/17/2017', 'Tvolume' => '36883419', 'Tcurrency_set_by_fq' => 1, 'Tsymbol' => 'T', 'Tmethod' => 'alphavantage' }; -- 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: Update stock quotes not working
Peter Gröbner <peter_groeb...@web.de> writes: >Here are some examples of what I did: > - gnc-fq-dump yahoo AMZN > - gnc-fq-dump yahoo_europe AMZN > - gnc-fq-dump unionfunds AMZN<-- German quote source > - gnc-fq-dump unionfunds AMZ.F<-- Traded in Frankfurt > - gnc-fq-dump unionfunds 906866 <-- Type: German WKN >And all this with a lot more sources and types > >Can anyone tell me what Iam doing wrong? I have read a lot of forum >discussions but I could not fix the problem. >Thanks in advance! Please try with alphavantage (after you get an API key) - look at the wiki. Or try with yahoo_json. 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: Finance-Quote 1.47 released!
Cam Ellison <c...@ellisonet.ca> 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 GBP->CAD. it does here: ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl GBP CAD GBP->CAD = 1.66540274 ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl CAD GBP CAD->GBP = 0.60045536 -- 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: Currency/metals quotes with new f::q 1.45?
listreader <susel...@cableone.net> 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 XAG" still gives 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? 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: Finance-Quote 1.45 released!
prl <p...@ozemail.com.au> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: gnucash-user Digest, Vol 176, Issue 30
Keith Myers <keith.my...@att.net> 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 module. At least then it > successfully builds the latest 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 ___ 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: Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?
Keith Myers <keith.my...@att.net> 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 future? Yes, but as the symbols doesn't seem to be supported through alphavantage, I can't offer you another alternative. 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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 leave this broken. Thanks anyway. It is indeed a wrong idea to mess with system Perl. You should however install your own Perl with brew or another tool like that. Meantime, I'll try F::Q with perl v5.18 on a test system to see if I can figure this out. 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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 ___ 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: Request of help
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 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: Currency/metals quotes with new f::q 1.45?
listreader <susel...@cableone.net> writes: > On Sun, 12 Nov 2017 17:37:50 +0100 > Erik Colson <e...@ecocode.net> wrote: > >> listreader <susel...@cableone.net> 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 gnucash. Is this >> > available yet? >> >> please check F::Q version 1.47 (untested). > > Hello Erik. > > 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 <=== required > last: 6.5100 <=\ >From the F::Q Examples I get following data: ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl XAU USD XAU->USD = 1275.81939501 and for XAG ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/currency-lookup.pl XAG USD XAG->USD = 16.89097601 Can you check those on your system ? > On another note: on my system (openSUSE Leap 42.3) AlphaVantage.pm got > installed with eXecute permissions while all the other .pm have only > Read permissions. Was that intended? nope... Have to check that, but that won't hurt. 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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 detail) That should be OK. Can you test following lines? also from the same directory. and post the returned info. export ONLINE_TEST=1 prove -lvof t/alphavantage.t 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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 the response to following command ? perl -MFinance::Quote -e 'print $Finance::Quote::VERSION' and perl -v 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: Finance-Quote 1.45 released!
prl <p...@ozemail.com.au> 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 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: Has anyone been able to get F:Q to pull quotes for FT Portfolios symbols?
Keith Myers <keith.my...@att.net> 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 have not > been able to get the reworked F:Q releases to pull quotes. Has anyone > else been successful? both symbols work with yahoo_json on F::Q v1.47. 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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 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: F::Q 1.45 AlphaVantage quote failure
Greg Etling <g...@gregetling.com> 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. > > Output: > malformed JSON string, neither array, object, number, string or atom, at > character offset 0 (before "Can't connect to www...") at > /Library/Perl/5.18/Finance/Quote/AlphaVantage.pm line 138. > > For reference, line 138: > my $json_data = JSON::decode_json $body; The page returned by alphavantage is sometimes empty. On my system the SCHB works correctly from F::Q. ~/DEVELOPMENT/finance-quote >>> perl -Ilib Examples/stockdump.pl alphavantage SCHB ±[master] $VAR1 = { 'SCHBopen' => '62.2500', 'SCHBcurrency_set_by_fq' => 1, 'SCHBisodate' => '2017-11-10', 'SCHBdate' => '11/10/2017', 'SCHBvolume' => '234359', 'SCHBcurrency' => 'USD', 'SCHBlow' => '62.1800', 'SCHBsuccess' => 1, 'SCHBclose' => '62.3200', 'SCHBhigh' => '62.3700', 'SCHBsymbol' => 'SCHB', 'SCHBmethod' => 'alphavantage', 'SCHBlast' => '62.3200' }; This is with version 1.47. Please try with at least 1.46. 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: Currency/metals quotes with new f::q 1.45?
listreader <susel...@cableone.net> 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 gnucash. Is this available yet? please check F::Q version 1.47 (untested). 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: gnc-fq-dump doesn't work for most sources
Brian M. Sutin <gnuca...@skewray.com> 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, nasdaq and nyse are not supported in the alphavantage module. They should however be added in a future release.. Use alphavantage instead. 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.
Finance-Quote 1.47 released!
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 <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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 releases 1.46 and 1.47
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 untested. It adds support for currency lookup through AlphaVantage and passes the currency.t test and maybe it won't break other stuff. If you need currency conversions and feel confident enough, please use 1.47 and report issues to F::Q mailing list or through github issues. Otherwise use 1.46 and wait for currency issues to be solved. 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.
Finance-Quote 1.46 released!
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) * Yahoojson: - module adapted to new URL and returned json (Rafael Casali) Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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.45 released!
Adriano <adriano.ba...@gmail.com> 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 I can confirm that version 1.45 works very fine, even > for London with the division for 100. > For me I miss the (.IL) market in London, quoted in USD / 100. > So I made a dirty edit to your work and for me it works fine. Can you provide an example symbol for the suffix .IL ? [..] > > I think changing Currencies.pm for using AlphaVantage can be solve the > problem. > By accident, are you already working on this? > I asking you because you always beat me in speed and quality ;-)). There is already a pull-request on github which I have to check out. Hopefully I can work on this very soon :) 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: Finance-Quote 1.45 released!
prl <p...@ozemail.com.au> 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. So, try TLS.AX instead of ASX:TLS. Please report if this solves your issue. 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: Finance-Quote 1.44 released!
Cam Ellison <c...@ellisonet.ca> 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. > > Thank you again, Erik, for your patience, Hi Cam, thx for reporting! 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: Finance-Quote 1.44 released!
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: Currency Quotes
Alun Champion <l...@achampion.net> writes: > Alphavantage supports currencies, e.g.: > > $ export ALPHAVANTAGE_API_KEY=XXX > $ gnc-fq-dump alphavantage GBPUSD=X > Finance::Quote fields Gnucash uses: > symbol: GBPUSD=X <=== required > date: 11/09/2017 <=== recommended > currency: USD <=== required > last: 1.3139 <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > Haven't quite figured out how to get Gnucash to use this yet. F::Q has a different API for currencies. The source has to be moved to alphavantage which will probably be done next weekend. Till then, GnuCash will probably not have currency rates anymore.. 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: Asian Stocks and Multiple Currencies Not Updated
Chen Thomas <jctc...@outlook.com> writes: > Hi Erik, > > Thank you. > > I just tried F::Q v1.45 with AlphaVantage source. > > Everything but currency is working good. great! > But it's very high possibility to get system error message while getting > quotes. I have to try many times. Yep. I've sent a mail to alphavantage to figure this out... 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: Finance-Quote 1.44 released!
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 ___ 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!
? ?? <jctc...@outlook.com> writes: > Hi Erik, > > Below are some symbols for Asian stocks: > Hong Kong: 0700.HK > China: 000636.SZ > Taiwan: 5880.TW, 6638.TWO Hi They all work with F::Q v1.45 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: Finance-Quote 1.44 released!
Cam Ellison <c...@ellisonet.ca> writes: > On 08/11/17 12:40 PM, Erik Colson wrote: > >> Please list some symbols you tried. >> >> > Here you go: > > CMI.V > MBA.TO > QST.V > FCEL (on NASDAQ) Hi Cam, Please try again with F::Q v1.45. It does work on my system. 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: Finance-Quote 1.44 released!
Cam Ellison <c...@ellisonet.ca> writes: > While you're at it - and thank you very much for all your time and > effort on this - I can't seem to get any TSXV (TSX Venture) stocks > through alphavantage. gnc-fq-dump shows currency missing for the ones > I've tried. Running gnucash --add-price-quotes with debugging (extra) > enabled shows that the attempt is made to load all the quotes, but > nothing is recorded and there is no error message. > > If you can give me some direction as to additional analysis I can do, > I'm willing to try it. Please list some symbols you tried. 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.
Finance-Quote 1.45 released!
New version 1.45 of Finance-Quote is available with the following changes: * alphavantage * more suffix - currency pairs added * GBP and GBX divided by 100 Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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: Asian Stocks and Multiple Currencies Not Updated
? ?? <jctc...@outlook.com> writes: > Hi, > > We all know there are lots of efforts since Yahoo! stopped service on Nov. > 1st. Thank you all. > > I've got F::Q updated to 1.44, and set everything OK with AlphaVantage > source, it only works for my US stock. > > But it is not working for my Asian stocks, such as Hong Kong stock (.HK), > China stock (xx.SZ, xx.SS), and Taiwan stock (.TW, .TWO). Please check those again with F::Q v1.45 > Even the currencies (USD, CNY, HKD, TWD, EUR) cannot be updated. Shall I > change the update source to AlphaVantage for currencies? currencies are not yet supported but will come probably next weekend 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: alpha vantage with non-US exchanges
Bye <byem...@telus.net> writes: > First off, thanks to those involved in getting things working again with > F::Q. > > > > I'm using v1.43 successfully with US stocks, but not for Canadian stocks. I > see alpha vantage should work for stocks on the TSX as the following > successfully returns stock prices: You need v1.44 for .TO symbols. -- 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: Finance-Quote 1.43 released!
Richard Ullger <rull...@gmail.com> writes: > On 06/11/17 22:43, Erik Colson wrote: >> New version 1.43 of Finance-Quote is available with the following changes: > > All prices from AlphaVantage are being returned 100 times too big as > pence rather than pounds. For example, a price of £7.329 is being > returned as £732.90. This is making stock values 100 times too big in > gnucash. Probably F::Q should return GBp instead of GBP as currency. However I can force division by 100 for .L quotes in alpavantage, maybe gnucash can handle GBp to GBP conversion? Can GnuCash developers tell which option would be appropriate? 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.
Finance-Quote 1.44 released!
New version 1.44 of Finance-Quote is available with the following changes: * Added currencies for .SA (Brazil) and .TO (Canada/Toronto) markets * Setup a pause of .7s between queries in AlphaVantage.pm to limit queries Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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.42 released!
? ?? <jctc...@outlook.com> writes: > Thank you for all of your contribution. > > I have F-Q 1.40 installed in my Windows 10. But when I tried to upgrade to > 1.42 from 1.40, system told me that 1.40 is up-to-date. > Did I miss some step? Probably not. There is a lag between me uploading F::Q and the CPAN server indexing it and making it available. Also, your system might be configured to use a cpan mirror which will add another lag. 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: Finance-Quote 1.42 released!
? ?? <jctc...@outlook.com> writes: > Error reading 'C:\strawberry\cpan\FTPstats.yml': Alert: While trying to > 'parse' YAML file > 'C:\strawberry\cpan\FTPstats.yml' > .. > Stashing away as 'C:\strawberry\cpan\FTPstats.yml.1510022664' to prevent > further interruptions. You may want to remove that file later. > Could not rename: Permission denied I'm by no means a Windows expert, but I would try manually removeing FTPstats.yml and restart the installation. 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.
Finance-Quote 1.43 released!
New version 1.43 of Finance-Quote is available with the following changes: * Added currency for .DE market * BUGFIX in currency determination regex Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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.
Finance-Quote 1.42 released!
New version 1.42 of Finance-Quote is available with the following changes: * more tests in alphavantage.t * BUG resolved: removed time from $last_refresh when markets are open Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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.
Finance-Quote 1.41 released!
New version 1.41 of Finance-Quote is available with the following changes: * return symbol for AlphaVantage data * added AlphaVantage module (Matthew Patterson) * some other module changes: yahoojson, Morningstar, Bourso, TSX (not working) Authors: - Dj Padzensky <djp...@padz.net>, PadzNet, Inc. - Linas Vepstas <li...@linas.org> - Yannick LE NY <y-le...@ifrance.com> - Paul Fenwick <p...@cpan.org> - Brent Neal <bre...@users.sourceforge.net> - Volker Stuerzl <volker.stue...@gmx.de> - Keith Refson <Keith.Refson#earth.ox.ac.uk> - Rob Sessink <rob_...@users.sourceforge.net> - Leigh Wedding <leigh.wedd...@telstra.com> - Tobias Vancura <tvanc...@altavista.net> - James Treacy <tre...@debian.org> - Bradley Dean <bjd...@bjdean.id.au> - Erik Colson <e...@ecocode.net> ___ 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-devel] F::Q 1.40 uploaded
Raviraj Murdeshwar <raviraj.murdesh...@gmail.com> writes: > HI Erik > > I downloaded 'Finance-Quote-1.40.tar.gz' and tried simple example as > follows and it's not returning the data. I have setup the API key as per > your instructions. > > #!/usr/bin/perl > > use lib '../lib'; > > # import module > use Finance::Quote; > > # create object > my $q = Finance::Quote->new(); > > # retrieve stock quote > my %data = $q->fetch('nyse', 'IBM'); > > # print price > print "The current price of IBM on the NYSE is " . $data{'IBM', 'price'}; Hi Raviraj, You are correct. That doesn't work and I didn't have time to change the example code. You need to change 'nyse' to 'alphavantage' to use the new module. I didn't test that, no time now, but the tests in t/alphavantage.t do pass. So take a look at that file if you want to script yourself. 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.