Re: Finance-Quote 1.42 released!

2017-11-06 Thread Bruce Schuck
> If you launch GnuCash using the launcher in a Finder window, add your > "export ALPHAVANTAGE_API_KEY=X" line to the file > "/Applications/Gnucash.app/Contents/MacOS/Gnucash". I added it just > below the last current export line. On a similar note, if you launch Gnucash from the

Re: [GNC] Alphavantage Problem

2018-06-15 Thread Bruce Schuck
> Date: Fri, 15 Jun 2018 16:06:46 -0500 > From: Les > For several months, I have been downloading stock and currency prices > using AlphaVantage.? For the last 2 days, I have not been able to > download any prices.? Is anyone else having this problem? I've noticed the same thing on my Mac

[GNC] AlphaVantage Quotes

2018-06-19 Thread Bruce Schuck
I believe I'm not the only one experiencing occasional issues getting quotes from AlphaVantage. While poking around I found a similar source, World Trading Data at https://www.worldtradingdata.com/. They use an API Key similar to AlphaVantage, along with a REST based API. While researching their

Re: [GNC] AlphaVantage Deal

2018-08-23 Thread Bruce Schuck
In my opinion, at $5.00 or more per month one might as well purchase Quicken (which is now a subscription based product I believe). For the F::Q developers, I've been working on module for World Trading Data. Free use is limited to 250 per day, and it's only US traded equities and funds. See pull

Re: [GNC] Finance-Quote 1.49 released!

2019-07-01 Thread Bruce Schuck
> This release would not have happened without Vincent Lucarelli and > Bruce P Schuck. Therefore I welcome your message which certainly > will help keep us all motivated :) > enjoy the new release! No applause necessary. Just send donuts. ;) Glad to have the opportunity to help. - Bruce S.

Re: [GNC] since Catalina, unable to open gnucash

2020-01-25 Thread Bruce Schuck
It seems that maybe the /opt directory tree is being restricted by what OSX called System Integrity Protection. Try following the steps to turn off SIP here: http://osxdaily.com/2015/10/05/disable-rootless-system-integrity-protection-mac-os-x/ If not, please open a terminal window and supply

Re: [GNC] gnucash-user Digest, Vol 202, Issue 66

2020-01-26 Thread Bruce Schuck
On 1/26/20 09:00, D wrote: > And yet, still unanswered is why a user would put their data files into /opt > in the first place... Because OSX is under the hood is very similar to *Nix and BSD systems. Those who are putting their data files under /opt are probably doing so to follow the Linux

[GNC] Finance-Quote 1.51 released!

2021-07-04 Thread Bruce Schuck
New version 1.51 of Finance-Quote is available with the following changes: * Fix bugs in t/fq-object-methods.t * Add code to hide warning in t/currency_lookup.t Authors: - Ben Hemming - Bradley Dean - Brent Neal - Bruce P Schuck - Caleb Begly - CleanShed

[GNC] Finance::Quote v1.50 Released

2021-06-26 Thread Bruce Schuck
Finance::Quote v1.50 has finally been released. This version made possible by many contributions by Vincent Lucarelli, Erik Colson, and others. - Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] Finance::Quote v1.50 Released

2021-06-28 Thread Bruce Schuck
On Tue, 29 Jun 2021 10:25 dull...@gmail.com wrote: Thanks for the update! I just installed this version on Windows, using Strawberry perl. Just to note the included "Cdnfundlibrary.pm" is still not working for some Canadian funds ... during "Get Quotes" I get this error popup "Unable to

Re: [GNC] Finance::Quote v1.50 Released

2021-06-27 Thread Bruce Schuck
On 6/27/21 02:55, Outlook wrote: > Just tried to install it for GNC V4.4 on an Intel Mac OS 11.4, but > failed and got the message as below. > 3 dependencies missing (Date::Range,Date::Simple,Test::Perl::Critic); > additionally test harness failed Install the missing Perl dependencies and

Re: [GNC] Finance::Quote v1.50 Released

2021-06-27 Thread Bruce Schuck
On 6/27/21 6:58 PM, Outlook wrote: Thanks, just installed it by using cpanm Finance::Quote —force Finance::Quote v1.50 is working well with GNC v4.6 now……:) Understandable. The last two major releases of OSX (Catalina and Big Sur) have presented challenges when trying to compile Perl

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-19 Thread Bruce Schuck
Hello all, Chris G, 1.51 is not broken. We missed a bug in the F::Q 1.50 release that caused testing of at least one module to fail for some. 1.51 was pushed to CPAN a week later. F::Q v1.52 is likely at least a few months out. David R (and Geoff), The Windows system I used for testing

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-22 Thread Bruce Schuck
d Romano, UK Direct line: +44 (0) 23 9234 1647 UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call: David.J.Romano -Original Message- From: Bruce Schuck Sent: 21 July 2021 22:37 To: gnucash-user@gnucash.org Cc: david.rom...@davidjromano.com Subject: ***SPAM*** Re: [GNC

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-22 Thread Bruce Schuck
David, I've been testing installs of F::Q on different operating systems. An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool used to build the package for uploading to CPAN did not

Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data

2021-07-23 Thread Bruce Schuck
On 7/23/21 1:41 AM, david.rom...@davidjromano.com wrote: Hi Bruce, the headline news is that your suggestion fixed the issue - see gnu.png - very many thanks to you (and Chris and Geoff) for your help, expertise and patience. Not a problem, glad I could be of assistance. If you previously

Re: [GNC] Upgrade to GC 2.6.19 and Finance:Quote 1.51

2022-02-27 Thread Bruce Schuck
From: James Edmunds I have just upgraded from Ubuntu 16.04 to 18.04. FYI - Ubuntu 22.04LTS will be released in April. I then wished to install the latest version of FQ. The command ?gnc-fq-update ? is not included in Ubuntu 16.04 or 18.04. So I searched the internet for an alternative

Re: [GNC] Upgrade to GC 2.6.19 and Finance:Quote 1.51

2022-02-27 Thread Bruce Schuck
Typo: Add "export PERL5LIB=/home/perl5/lib/perl5" to your "~/.bashrc" file and "PERL5LIB=/home/perl5/lib/perl5" to /etc/gnucash/environment. Log out and back in that try gnc-fq-check. ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] AlphaVantage now restricting users to 25 quotes

2023-11-01 Thread Bruce Schuck
On 11/1/23 10:43 AM, Adrian Holbrook wrote: Thanks for that - I changed all mine to Yahoo as JSON and it works, as you say, for now. Wasn't long ago that I chenged them all from Yahhoo to Alphvantage! Bit of a chore with over 50 to do. Would be a very useful feature to be able to switch en

[GNC] Finance-Quote 1.52 released!

2022-07-03 Thread Bruce Schuck
New version 1.52 of Finance-Quote is available with the following changes: * Quote.pm - Fixed logic for FQ_LOAD_QUOTELET starting with "-defaults" reported in issue #197. PR #199. * AlphaVantage currency module: Don't recurse infinitely when exchange rate is

[GNC] Finance::Quote v1.52 Release Candidate 1 Available

2022-06-18 Thread Bruce Schuck
Hello all, Sorry it's been a while, but a pre-release release candidate of Finance::Quote v1.52 is available from Github. https://github.com/finance-quote/finance-quote/releases/tag/v1.52-rc.1 A Github discussion for this release can be found at

[GNC] Finance::Quote v1.53 RC1 Available for Download

2022-09-29 Thread Bruce Schuck
Greetings all, Sorry for the delay. There was an illness resulting in death in the family last month, followed by various executor and trustee related business. To top that off, currently an unknown status of a family house in Punta Gorda, FL where Hurricane Ian made landfall yesterday

[GNC] Finance::Quote v1.53 RC2 Available for Download

2022-10-04 Thread Bruce Schuck
Hello again, Quick fix of a dependency and a version number hard coded in Union.pm. https://github.com/finance-quote/finance-quote/releases/tag/v1.53-rc.2 or https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.52_02.tar.gz The official v1.53 will likely be pushed to CPAN

Re: [GNC] Price update not working

2022-10-10 Thread Bruce Schuck
On 10/10/22 Mon, 10 Oct 2022 09:50:07 -0400, john wrote: The alphavantage module in Finance::Quote throttles the requests to comply with AlphaVantage's limit. Most stocks and funds supported by AlphaVantage are also available from yahoo_json, but currency exchange rates are not. For non-US

[GNC] Finance-Quote 1.53 released!

2022-10-08 Thread Bruce Schuck
hors: - alex314159 - AndreJ - Ben Hemming - Bradley Dean - Brent Neal - Bruce Schuck - Caleb Begly - CleanShed <72849657+cleans...@users.noreply.github.com> - David Hampton - Diego Marcolungo - e-dorigatti - Eelco Dolstra - Emmanuel Di Pretoro - Erik Colson

Re: [GNC] Finance-Quote 1.53 released!

2022-10-09 Thread Bruce Schuck
On Sun, 9 Oct 2022 09:30:23 +0100 Eric Coates writes: > There's a lot of people involved! Thanks to all of them The author list is created by grabbing every contributor to the GitHub repo with at least 2 commits. Some of those commits could be minor such as correcting a typo in documentation.

[GNC] F::Q Currency Issues

2022-08-15 Thread Bruce Schuck
Hello everyone, As I am now the F::Q team member with CPAN/Pause upload priv, please have patience. I had to unexpectedly travel out of state for a family matter. I am not sure how long I will be away, but it will be at least a few days before I have time to review and merge the pull request.

[GNC] Finance::Quote v1.54 Released

2022-12-26 Thread Bruce Schuck
Finance::Quote v1.54 has been released and uploaded to CPAN. https://metacpan.org/release/BPSCHUCK/Finance-Quote-1.54 https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54.tar.gz https://github.com/finance-quote/finance-quote Thank you. - Bruce S.

Re: [GNC] Finance::Quote v1.54 Released

2022-12-27 Thread Bruce Schuck
On 12/27/22 9:08 AM, R Losey wrote: I have version 1.52 installed on Ubuntu 22.04LTS... it came as a package. What do I need to do to install the update? Is there a script to run for updates? Do I need to build it myself? Dropped gnucash-devel from the Cc. The good folks on the GnuCash

[GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

2022-11-08 Thread Bruce Schuck
Go figure. It appears that AlphaVantage changed back access to the CURRENCY_EXCHANGE_RATE API. It is no longer considered premium. A feature I liked about the CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former data included Crypto and Precious Metals. Will revert back F::Q in

Re: [GNC] AlphaVantage Changed Access to the CURRENCY_EXCHANGE_RATE API

2022-11-08 Thread Bruce Schuck
Bruce S wrote: >> Go figure. It appears that AlphaVantage >> changed back access to the CURRENCY_EXCHANGE_RATE API. It is no >> longer considered premium. A feature I liked about the >> CURRENCY_EXCHANGE_RATE API over the FX_DAILY API is that the former >> data included Crypto and Precious

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-23 Thread Bruce Schuck
- autoload is function in Module::Load). On 3/23/23 1:42 PM, John Ralls wrote: Bruce, Not sufficient on macOS X 10.13/perl 5.18. It still heads off to la-la land in the autoload call. Regards, John Ralls On Mar 21, 2023, at 6:30 PM, Bruce Schuck wrote: Please trying installing Module::Load

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-23 Thread Bruce Schuck
On 3/23/23 3:28 PM, John Ralls wrote: Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in /Library/Perl/Updates/5.18.2. @INC includes both directories and neither PERLLIB nor PERL5LIB is set. No doubt something else is missing in 10.13. What's a good way to get perl to tell me?

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-23 Thread Bruce Schuck
On 03/23/23 9:21 PM, Bruce Schuck wrote: What versions of those modules are on the 10.13 OS you have access to? Can you update Module::Load and test again? Perl does have two modules, Devel::Trace and Devel::DumpTrace. I think the output of Devel::Trace may be more useful. "perl -d:

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-23 Thread Bruce Schuck
On 3/23/23 3:28 PM, John Ralls wrote: Yes, all but SelfLoader in /Library/Perl/5.18; SelfLoader is in /Library/Perl/Updates/5.18.2. @INC includes both directories and neither PERLLIB nor PERL5LIB is set. No doubt something else is missing in 10.13. What's a good way to get perl to tell me?

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-25 Thread Bruce Schuck
wd /Users/bschuck/tmp/finance-quote Bruces-Virtual-High-Sierra:finance-quote bschuck$ ./Examples/currency-lookup.pl EUR USD EUR->USD = 1.0763104 Thanks. - Bruce S. On 3/25/23 4:11 PM, Bruce Schuck wrote: Thanks John. Coincidentally I just managed to install a High Sierra VM under Vir

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-25 Thread Bruce Schuck
on. Regards, John Ralls On Mar 23, 2023, at 7:33 PM, Bruce Schuck wrote: On 03/23/23 9:21 PM, Bruce Schuck wrote: What versions of those modules are on the 10.13 OS you have access to? Can you update Module::Load and test again? Perl does have two modules, Devel::Trace and Devel::DumpTrace

[GNC] Chile Mutual Fund Quotes (was Price Quote IEXCloud)

2023-04-20 Thread Bruce Schuck
On Thu, 20 Apr 2023 Murugan Muruganandam writes: I have done a package to pull mutual funds price , you can check the following link for reference https://github.com/Murugan-CL/gnucash-chile-mutual-fund-quote Murugan, Do you think you could create a pull request against

Re: [GNC] Yahoo JSON - throwing unauthorized error

2023-04-19 Thread Bruce Schuck
On Wed, 19 Apr 2023 20:37:09 Murugan Muruganandam wrote: Today when i ran get quote got the following error message Finance::Quote reported a failure for symbol acn: Error retrieving quote for acn. Attempt to fetch the URLhttps://query1.finance.yahoo.com/v7/finance/quote?symbols=acn resulted

[GNC] Finance::Quote Yahoo JSON Module Issues

2023-04-19 Thread Bruce Schuck
Sometime in the last 24 hours Yahoo turned off the faucet for the REST API that Finance::Quote::YahooJSON was using for getting quote and exchange data. A query such as: curl 'https://query1.finance.yahoo.com/v7/finance/quote?symbols=F' Will return:

Re: [GNC] Command line quotes still not fixed

2023-04-10 Thread Bruce Schuck
On 10 Apr 2023 09:22:04 -0500R Losey wrote: You could always get a key (they are free) and have it set. Sh, don't tell anyone but I stumbled on a bug with the authentication of the AlphaVantage API Key. Make one up! Using "NOTAREALAPIKEY" as the key, I found that lookups work. I hit on

Re: [GNC] Command line quotes still not fixed

2023-04-11 Thread Bruce Schuck
On 4/11/23 6:51 PM, David G. Pickett wrote: Maybe patch the code to load a junk string in there "Enter_your_key_here" and suppress the warning? I have been thinking about that. I haven't tested if bogus API keys are subject to the same limitations as the free keys, but I think it would lead

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-21 Thread Bruce Schuck
, Are you using "stock" perl? Regards, John Ralls On Mar 21, 2023, at 4:31 PM, Bruce Schuck wrote: I hate to say this, but it works fine on my Mac OSX 10.15.7 (Catalina). bruce.schuck@Bruces-MacBook-Pro-2 F5 % sw_vers ProductName:Mac OS X ProductVersion: 10.15.7 BuildVersion:

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-21 Thread Bruce Schuck
I hate to say this, but it works fine on my Mac OSX 10.15.7 (Catalina). bruce.schuck@Bruces-MacBook-Pro-2 F5 % sw_vers ProductName:Mac OS X ProductVersion: 10.15.7 BuildVersion: 19H2026 bruce.schuck@Bruces-MacBook-Pro-2 ~ % gnc-fq-check ("1.54" "aex" ... bruce.schuck@Bruces-MacBook-Pro-2

Re: [GNC] Finance Quote problem MacOS High Sierra.

2023-03-21 Thread Bruce Schuck
Please trying installing Module::Load::Conditional from CPAN. It will also install Module::Load. If that still does not work, also install modules SelfLoader and AutoLoader. I will need to these to the package dependencies. - Bruce S. On 3/21/23 4:05 PM, John Ralls wrote: It works for me on

[GNC] Finance::Quote PreRelease

2023-06-07 Thread Bruce Schuck
Hello all, We've been trying to stay ahead of yet another possible disruption of the URL F::Q uses to fetch data in JSON format from Yahoo. Work is underway to extract data from the HTML of a standard Yahoo Finance page such as https://finance.yahoo.com/quote/AAPL?p=AAPL. In the meantime,

Re: [GNC] Finance-Quote 1.57 released!

2023-07-03 Thread Bruce Schuck
On 7/1/23 at 16:09 EDT, Bruce S wrote: For this release I added a quick way to count F::Q usage. It is just a simple web fetch of a URL containing the method (yahoo_json, fool, alphavantage, etc). Just 48 hours after pushing F::Q v1.57 to CPAN, these are the current counts. Assuming with a

[GNC] Yahoo Closed the Door on Finance API

2023-07-13 Thread Bruce Schuck
Some of us suspected this would come, getting reports of the Yahoo URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics and

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread Bruce Schuck
On 7/17/23 10:02 AM, john wrote: It's not all non-US securities. In AlphaVantage it appears to be only LSE stocks; JSE stocks aren't supported and Tel Aviv stocks support only ILS. The Yahoo JSON module adjusts prices for Zac (South Africa) and ILA (Israel) as well as GBX, but Yahoo JSON

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-18 Thread Bruce Schuck
On 7/17/23 9:06 PM, john wrote: Well, a user wouldn't want to set GBX as their default currency, just to create an account in their tree denominated in it to be a parent for stock accounts that are priced in GBX. But you're right that it's not something that a user can do now because GBX isn't

[GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-16 Thread Bruce Schuck
Hello again, At some point I am going to take a break from F::Q, I thought this weekend I was going to escape. ### For the question, skip to the next ### Anyway, some time ago the issue was raised about prices from AlphaVantage for LSE traded stocks (see

[GNC] Finance::Quote 1.57_02 - YahooWeb gets correct trading date and fixed pricing for single char symbols

2023-07-16 Thread Bruce Schuck
Greetings, Another beta pre-release for F::Q v1.58 has been uploaded to CPAN. The URL used by YahooWeb (yahooweb) has been changed to the date is pulled from web page. The issue with some single-character symbols getting bad pricing has also been fixed, and labels 'open', 'high', 'low', and

Re: [GNC] Yahoo Closed the Door on Finance API

2023-07-14 Thread Bruce Schuck
At 07/14/2023 at 1958 EDT, WR D wrote: Thanks for this - the yahooweb source worked for retrieving crypto-AUD exchange rates too. At 07/14/2023 at 08:50:29 EDT, Bart A.J. Seesing wrote: The latest release of F::Q (1.57) contains a new YahooWeb module that still works, at least for my

[GNC] Finance::Quote 1.57_01 - YahooJSON Quick Fix

2023-07-14 Thread Bruce Schuck
Greetings, A beta pre-release for F::Q v1.58 has been uploaded to CPAN. It has the quick fix I noted in the earlier "Yahoo Closed the Door on Finance API" thread. Not a production indexed release, you can install it using CPAN. $ cpan BPSCHUCK/Finance-Quote-1.57_01.tar.gz or $ cpanm

Re: [GNC] Yahoo Closed the Door on Finance API

2023-07-14 Thread Bruce Schuck
On 07/14/23 at 00:14 EDT, Bruce S wrote: Some of us suspected this would come, getting reports of the Yahoo URLs > https://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics and >

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-17 Thread Bruce Schuck
On 7/17/23 03:48 PDT AM, Brad Morrison wrote: Does it also make sense to post this situation & question to the other 6 GnuCash Mailman 2 mailing lists that are not in English? https://wiki.gnucash.org/wiki/Mailing_Lists & https://lists.gnucash.org/mailman/listinfo If someone cares to

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

2023-07-19 Thread Bruce Schuck
On 7/18/23 10:34 AM, John Ralls wrote: YahooJSON and now YahooWeb are already doing the GBX->GBP conversion (not my doing). Easy because both of those sources have the pricing currency in the data returned. I hope you are not suggesting that the conversion is removed from both of those modules?

Re: [GNC] Finance-Quote 1.57 released!

2023-07-03 Thread Bruce Schuck
On 7/2/23 18:27 EDT, Bruce S wrote: I should have taken a closer look at the data before posting. For this release I added a quick way to count F::Q usage. It is just a simple web fetch of a URL containing the method (yahoo_json, fool, alphavantage, etc). Just 48 hours after pushing F::Q

Re: [GNC] Finance-Quote 1.57 released!

2023-07-05 Thread Bruce Schuck
On 7/4/23 23:22:09 +, Richard Ullger wrote: When prices are updated after midnight, the yahooweb price source is returning the current date instead of the price date. See below... On 7/4/23 22:35 -0400, Ken Farley replied: My understanding of the new Yahooweb module is that it uses the

Re: [GNC] Unable to get TIAA-CREF price quotes

2023-07-05 Thread Bruce Schuck
On 7/5/23 19:23 UTC, Doug Brown wrote: Linux Mint v. 20.?GNUCASH v. 4.2Finance::Quote v. 1.56 When I update the price Data Base it fails to retrieve TIAA-CREF quotes. The Security Editor is set up as follows: Running?gnc-fq-dump gives the following result: doug@sager:~/src/gnucash-5.1$

Re: [GNC] Finance::Quote 1.57_01 - YahooJSON Quick Fix

2023-07-15 Thread Bruce Schuck
On 07/15/2023 04:52 EDT, Richard Ullger wrote: On 07/15/2023 03:28, Bruce Schuck wrote: A beta pre-release for F::Q v1.58 has been uploaded to CPAN. It has the quick fix I noted in the earlier "Yahoo Closed the Door on Finance API" thread. I've already updated Friday's prices

[GNC] Finance::Quote Quote Throttling

2023-05-28 Thread Bruce Schuck
I was wondering if any GnuCash users pay for a premium key from a data source like AlphaVantage? Or would some of you be more inclined to purchase premium keys from the vendors if Finance::Quote was able to optionally by-pass its throttling mechanisms? I am gauging if the interest is enough

Re: [GNC] Finance-Quote 1.56 released!

2023-05-29 Thread Bruce Schuck
On 5/29/23 15:13, WR D wrote: Can I confirm ... does this take time to propagate? Depending on what CPAN mirrors are configured on your system, yes. So I am not clear if this install method will update eventually and then look for 1.56? Unless there is some other issue with your CPAN or

[GNC] Finance-Quote 1.56 released!

2023-05-29 Thread Bruce Schuck
* Bourso.pm - Squash anything but numbers and period in quote values. * Renamed MStarUK.pm to MorningstarUK.pm * Added get_features method - PR #260 Authors: - Erik Colson - Paul Fenwick - Vincent Lucarelli - David Hampton - Bruce Schuck - jvolkening - Pawel Konieczny

Re: [GNC] Revisiting Quotes

2023-05-29 Thread Bruce Schuck
On Thu May 25, 2023 at 14:59:14 EDT R Losey wrote: From the discussion here, one would get the idea that the only two options for quotes are Alphavantage and Yahoo/JSON... don't the other options work? I seem to remember seeing a very long list of options. Most of the other modules retrieve

Re: [GNC] Revisiting Quotes (Bruce Schuck)

2023-05-29 Thread Bruce Schuck
On 5/29/23 7:41 PM, Colin Arndt wrote: Thanks for all your work to keep up this past month. The latest 1.56 update fixes price retrieval within GnuCash. This means modules will need to be rewritten to parse the HTML. Doable, but not as simple as parsing JSON. There is an excellent python

Re: [GNC] Revisiting Quotes (Bruce Schuck)

2023-05-29 Thread Bruce Schuck
While I would confirm if the Python source is grabbing the normal webpage or the API calls we use(d) in F::Q, this did give me the idea to search CPAN. I found the module Yahoo::Finance which may also be a good start and possibly does the heavy lifting already. Colin, The Yahoo::Finance Perl

Re: [GNC] [Finance-quote-news] Finance-Quote 1.56 released!

2023-05-30 Thread Bruce Schuck
On 5/30/23 7:59 AM, Fross, Michael wrote: Running directly via the rest api works: https://api.twelvedata.com/quote?symbol=acn=xx (I've hidden the actual key) But when I run: C:\Program Files

Re: [GNC] Yahoo v6 and Gnucash 5.1 Online Quotes Changed again and not working

2023-05-24 Thread Bruce Schuck
Starting sometime this afternoon failures of the "https://query2.finance.yahoo.com/v6/finance/quote?...; API/URL have been failing consistently. There is already an F::Q issue opened, https://github.com/finance-quote/finance-quote/issues/282. No need to add "me too" messages to the comments.

Re: [GNC] Finance::Quote Status

2023-05-27 Thread Bruce Schuck
rates yet and needs an API key) in addition to the Yahoo fix. On Sat, May 27, 2023 at 1:47 PM Bruce Schuck <mailto:bsch...@asgard-systems.com>> wrote: The F::Q team hopes to push v1.56 to CPAN before the end of the U.S. holiday weekend.

Re: [GNC] Finance::Quote Status

2023-05-27 Thread Bruce Schuck
On 5/27/23 6:04 PM, Fross, Michael wrote: I installed 1.55_01 and switched my securities back to Yahoo_JSON. I didn't receive any errors after retrieving and it looked like all of the securities had an updated date of Friday 5/26/2023. Whoo hoo. The totals also compared correctly to my

[GNC] Finance::Quote Status

2023-05-27 Thread Bruce Schuck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The F::Q team hopes to push v1.56 to CPAN before the end of the U.S. holiday weekend. The Yahoo fix will be included, let's hope that Yahoo does not pull the plug on it for a while. Thank you to Paolo Maero for quickly contributing fixes for

Re: [GNC] [Finance-quote-news] Finance-Quote 1.56 released!

2023-05-30 Thread Bruce Schuck
On 5/30/23 12:59 PM, Vincent Lucarelli wrote: You can verify that by setting the environment variable DEBUG=1 and repeating the gnucash-cli command. You should see the AlphaVantage key error. I don’t think we’ve clearly documented this requirement anywhere and maybe we should change the

[GNC] New Finance-Quote-User email List at SourceForge

2023-06-03 Thread Bruce Schuck
Greetings all, Just an FYI. I created a new finance-quote-u...@lists.sourceforge.net email list. This will augment any ongoing discussions on https://github.com/finance-quote/finance-quote/discussions. Have a good weekend. Bruce S. ___

Re: [GNC] Finance::Quote Quote Throttling

2023-06-03 Thread Bruce Schuck
On 6/3/23 13:40, Mike Alexander wrote: I would pay a few dollars a month for a key to avoid throttling. I looked into buying a key from IEXCloud, but the cheapest one that seems to do the trick is $1500 a month. :-) In other words, your answer is no. Obviously we are aware of the cost of

Re: [GNC] Issue with Finance::Quote

2023-07-28 Thread Bruce Schuck
On 7/28/23 8:45 AM, bern...@deprez.biz wrote: Just ran it in a fresh window: C:\Users\Bernard>perl -MFinance::Quote -e "print qq{{$Finance::Quote::VERSION\n}}" {1.57 } Bernard, One last command. curl. Replace "YOURAPIKEY" with, of course, your ALphaVantage API key.

Re: [GNC] Issue with Finance::Quote

2023-07-28 Thread Bruce Schuck
On 7/28/23 12:31 PM, bern...@deprez.biz wrote: {     "Information": "Thank you for using Alpha Vantage! You have reached the 100 requests/day limit for your free API key. Please subscribe to any of the premium plans at https://www.alphavantage.co/premium/ to instantly remove all daily rate

[GNC] Finance::Quote Usage

2023-07-29 Thread Bruce Schuck
Hello all, Just an FYI. Getting a simple count of the Finance::Quote sources used. At least for those with v1.57 installed. I'd like to keep the counter in place for maybe another release, but will be removed by release v1.59. As noted in the discussion post, the ukfunds number is

Re: [GNC] Issue with Finance::Quote

2023-07-29 Thread Bruce Schuck
On 7/29/23 05:06, bern...@deprez.biz wrote: I wasn't aware of the IP tracking and that may be the explanation - without my knowledge, somebody else in my household was playing around with a Node-RED flow that was pulling a request from Alphavantage each minute with a third API key :-) We've

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread Bruce Schuck
On 7/27/23 10:37:17 -0400, Bernard wrote: Thanks for that suggestion - did that on 2 different Windows systems, both still fail the same way... C:\Program Files (x86)\gnucash\bin>gnucash-cli -Q dump alphavantage QQQ * 10:21:02 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote

Re: [GNC] Issue with Finance::Quote

2023-07-27 Thread Bruce Schuck
On 7/27/23 10:46 AM, bern...@deprez.biz wrote: Just gave that a shot: C:\Strawberry\cpan\build\Finance-Quote-1.57-0>perl Examples\stockdump.pl alphavantage QQQ Can't use an undefined value as a HASH reference at C:/Strawberry/perl/site/lib/Finance/Quote/AlphaVantage.pm line 234. You left

Re: [GNC] Finance::Quote - AlphaVantage Trade

2023-07-22 Thread Bruce Schuck
On 07/21/2023 at 18:34 EDT Kaligula wrote: In general the suffix idea looks like a nice workaround – but I'd like to throw in my two cents. So maybe a general solution in case of AV module pricing errors – a ".???" suffix (to any ticker, not only LSE ones) where the "???" is the currency

Re: [GNC] Strange prices update issue (possibly with TSP)

2023-08-11 Thread Bruce Schuck
On Aug 10, 2023, at 12:13, Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote: The difficult part in debugging this is that when I do query three times from the command line, it succeeds without any issue for me as well, but when I update prices from GNC, it fails two times and then succeeds

[GNC] Finance-Quote 1.58 released!

2023-08-12 Thread Bruce Schuck
and changed URL to get trade date - Issues #314 #319 * Another fix to the URL in YahooJSON and CurrencyRates/YahooJSON - Issue #318 Authors: - Erik Colson - Paul Fenwick - Vincent Lucarelli - Bruce Schuck - David Hampton - jvolkening - Pawel Konieczny - And

Re: [GNC] finance quote not working

2023-08-05 Thread Bruce Schuck
On 2023-08-04 at 20:16 EDT, Jim DeLaHunt wrote: Paras: On 2023-08-04 06:23, Paras Desai wrote: So far, Mutual fund is concerned, following is an example of the fund 1. Axis Special Situation Fund , symbol for fetching price is INF846K01Y05 Excellent. That is helpful information.

Re: [GNC] Issue with Finance::Quote

2023-07-28 Thread Bruce Schuck
On 7/28/23 3:21 AM, bern...@deprez.biz wrote: The version was in the C: path so didn't run the version command ;-) but ran it anyway, and I'm on {1.57} Bernard, Was that before of after you set PERL5LIB? It makes a difference. Please run the command in a new console window. Thank you.

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-17 Thread Bruce Schuck
On June 16, 2023 at 15:11 EDT, John Ralls wrote: On 06/15/2023 12:23 -0700, Bruce S wrote: Non-production release 1.56_02 is available for evaluation/testing. It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. The YahooWeb module currently requires the

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-17 Thread Bruce Schuck
On June 17, 2023 at 18:43 EDT wrote: > I'm doing preliminary testing using gnc-fq-dump with the yahoo_json > and yahooweb sources. > I'm getting different price formats between the two sources for > LSE securities with yahoo_json being the correct format. gnc-fq-dump yahoo_json SUK2.L

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-22 Thread Bruce Schuck
On 6/22/23 9:16 -0400, Kalpesh Patel" wrote: I was using this release in a prod like env (on my own real live files in an non-business use case) and seem to be getting unknown error in calls from GNC since last night. What is the best way to go about debugging this? Precise (un-helpful) error

[GNC] Finance::Quote 1.56_03 Available for Evaluation

2023-06-24 Thread Bruce Schuck
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greetings all, Non-production release 1.56_03 is available for evaluation/testing. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_03.tar.gz It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_03.tar.gz'.

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-22 Thread Bruce Schuck
Kalpesh Assuming the F::Q 1.56_02 build files still exist in your C:\Strawberry\cpan\build directory, trying the stockdump.pl example script as I did would help. GnuCash 4.x uses the old gnc-fq-check gnc-fq-dump scripts for checking F::Q. Please show the output from trying these. cd

Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation

2023-06-24 Thread Bruce Schuck
Oooops! Make that 1.56_04. I forgot to merge one pull request. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_04.tar.gz It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_04.tar.gz'. Bruce S. ___

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-18 Thread Bruce Schuck
On 6/18/23 10:34, john wrote: I'm at a loss. Although at the current moment, YahooWeb isn't required as long other viable quote sources exist. I like the Date::Business module, I just wish its install honored the PERL_USE_MM_DEFAULTS environment variable. It would be trivial to create different

[GNC] Finance-Quote 1.57 released!

2023-07-01 Thread Bruce Schuck
* removed Data::Dumper that caused another test to fail from TreasuryDirect.pm #290 * Fixed Fool.pm and fool.t - PR #289 Authors: - Erik Colson - Paul Fenwick - Vincent Lucarelli - Bruce Schuck - David Hampton - jvolkening - Pawel Konieczny - AndreJ - Mike

Re: [GNC] Finance-Quote 1.57 released!

2023-07-01 Thread Bruce Schuck
On 7/1/23 12:37, Bruce S wrote: New version 1.57 of Finance-Quote is available with the following changes: I'd also like to add the following disclosure. For this release I added a quick way to count F::Q usage. It is just a simple web fetch of a URL containing the method (yahoo_json, fool,

Re: [GNC] Finance::Quote 1.56_03 Available for Evaluation

2023-06-26 Thread Bruce Schuck
On 6/26/23 22:42 +, Richard Ullger wrote: Thanks for the 1.56_04 update. The price format for LSE securities using the yahooweb price source is fixed but I'm getting a difference in precision on crypto between yahoo_json and yahooweb. Unfortunately that is because the precision

[GNC] Finance Quote 1.56 - Crashing Gnucash / Error for Gnucash v5+ (Issue #309)

2023-06-27 Thread Bruce Schuck
On 6/27/23 4:12 PM, Trentan Healey wrote: Having an issue with retrieve quotes latest version (in conjunction with Gnucash get quotes and using cli). When attempting get quotes through gnucash, looks like it starts up cmd prompt, then get wheel of death and Gnucash crashes, no quotes

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-16 Thread Bruce Schuck
On 06/15/2023 12:23 -0700, Bruce S wrote: Non-production release 1.56_02 is available for evaluation/testing. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.56_02.tar.gz > It can be installed via cpan/cpanm as 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'. The YahooWeb

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-16 Thread Bruce Schuck
On 6/16/23 10:12 AM, Murugan Muruganandam wrote: i checked YahooWeb module with different combinations including symbols with .extensions , all the quotes were fetched correctly. Awesome, thank you for the response. Bruce S. ___ gnucash-user

Re: [GNC] Finance::Quote 1.56_02 Available for Evaluation

2023-06-16 Thread Bruce Schuck
On 6/16/23 12:11 PM, John Ralls wrote: Maybe you could use Date::Manip::Date_PrevWorkDay instead? But either way it's pretty US-centric because of the holidays enumeration. What about the Monday-Friday trading days assumption? Is that valid for all of the stock markets that Yahoo can get

  1   2   >