Re: [GNC] Finance-Quote 1.62 released!

2024-05-16 Thread Bruce Schuck
On Thu May 16 22:22:53 EDT 2024, Adrien Monteleone wrote: Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! heh-heh. Sometimes it does seem like playing whack-a-mole. Thank you for the

[GNC] Finance-Quote 1.62 released!

2024-05-16 Thread Bruce Schuck
;last" to data being returned * BorsaItaliana.pm - New module for Borsa Italiana, Italian traded bonds using ISIN * YahooWeb.pm - Issue #377. Modified YahooWeb to account for changes from Yahoo. Authors: - Erik Colson - Paul Fenwick - Bruce Schuck - Vincent Lucarelli

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-03 Thread Bruce Schuck
On 5/3/24 11:36 AM, Kalpesh Patel wrote: I looked at Makefile.PL for 1.61 source at CPAN and it does NOT have CPAN listed in PREREQ_PM or in %FallbackPrereqs. Might be worth adding to it... Most GnuCash users can (and probably should...) likely ignore this post. Any further discussion should

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-03 Thread Bruce Schuck
On 5/3/24 9:58 AM, John Ralls wrote: It’s normal for Linux distros to package perl modules. Fedora’s is https://packages.fedoraproject.org/pkgs/perl-Finance-Quote/perl-Finance-Quote/ . Note that there are back

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-03 Thread Bruce Schuck
On May 2, 2024 at 23:44:53 EDT Kalpesh wrote: That is possible that there is no depend target in the make file. Just curious how you built/get the make file for it? Kalpesh, The old school method of installing Perl modules. The makefile is created by running "perl Makefile.PL". Then one

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-02 Thread Bruce Schuck
On Apr 30, 2024 at 22:59:34 EDT I wrote: A new module for US traded stocks, StockData.pm, with default method "stockdata". This requires an API token from https://www.stockdata.org/. If passed in as an environment variable, set "STOCKDATA_API_KEY" to your token. Once installed "perldoc

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-02 Thread Bruce Schuck
On 5/2/24 8:38 AM, Fred Tydeman wrote: perl -MCPAN -e shell gets Can't locate CPAN.pm This is Fedora Linux 40 (the most recent) I find it odd that your system *ever* had Finance::Quote installed, as the GnuCash utility to install the F::Q module depends on CPAN. Which also explains why

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Bruce Schuck
On 5/1/24 7:39 PM, Fred Tydeman wrote: On my Linux systems, after some searching, I found that I needed: dnf install perl-ExtUtils-MakeMake* to get me started. Running perl Makefile.PL got me several warnings of other missing perl files. After doing a bunch of dnf install perl-... for them,

Re: [GNC] Finance::Quote PreRelease 1.61_03

2024-05-01 Thread Bruce Schuck
On 5/1/24 7:25 AM PDT, Fred Tydeman wrote: Can I apply this update to my older 4.14 Gnucash system on Linux? Yes, recent and current releases of Finance::Quote are backwards compatible WRT to GnuCash. As a matter of fact I run GnuCash 4.8 on my primary Linux desktop at home and 4.8 on my

[GNC] Finance::Quote PreRelease 1.61_03

2024-04-30 Thread Bruce Schuck
A few more fixes and additions to Finance::Quote. For those who are comfortable with the interim releases, 1.61_03 has been uploaded to CPAN. https://www.cpan.org/modules/by-authors/id/B/BP/BPSCHUCK/Finance-Quote-1.61_03.tar.gz Or just "BPSCHUCK/Finance-Quote-1.61_03.tar.gz" when installing

Re: [GNC] Finance-Quote 1.61 released!

2024-04-28 Thread Bruce Schuck
On 4/28/24 06:28, Klaus Dahlke wrote: It took a while to figure out why yahoo_json didn't work. When trying to fetch the cookie from fc.yahoo.com the response was 'connection refused', also when trying to connect via browser. In the end it turned out that pihole blocked fc.yahoo.com. Once I

Re: [GNC] Finance::Quote on a Mac with a foreign perl

2024-04-27 Thread Bruce Schuck
On Sat Apr 27, 2024 at 21:13:22 Mr. Ralls wrote: I just remembered a third case that's probably the same problem: https://bugs.gnucash.org/show_bug.cgi?id=799195 complained that it took 15 minutes to install the F::Q dependencies and the attempt ultimately failed because SSLeay failed its

Re: [GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN

2024-04-27 Thread Bruce Schuck
Earlier, I wrote: Another option for retrieving US quotes is MarketWatch. No API key needed. And... scratch that. They must have recently made changes as I successfully tested this method 2 or 3 days ago. 1 gets fixed, 2 no longer work. Aggravating as all hell.

[GNC] Finance::Quote Pre-Release 1.61_02 Uploaded to CPAN

2024-04-27 Thread Bruce Schuck
Greetings, Finance::Quote v1.61_02 has been uploaded to CPAN. Changes since 1.61 * Modified yahooJSON.pm module in order handle EU consent redirects better. * TwelveData.pm - Added "last" to data being returned. The method "twelvedata" was returning a value for "close". GnuCash expects

Re: [GNC] Finance::Quote on a Mac with a foreign perl

2024-04-27 Thread Bruce Schuck
On Fri Apr 26, 2024, at 12:07:04 EDT Mr Ralls wrote: Here's an example of a failed session with Homebrew interference: https://paste.jvnv.net/view/CcsOd This comes from an IRC discussion at https://code.gnucash.org/logs/2024/04/16.html#T06:46:33. There was an earlier exchange with another

[GNC] Finance::Quote 1.61_01 - YahooWeb

2024-04-21 Thread Bruce Schuck
For those who were using the 'yahooweb' quote source, I rewrote the module to parse the new format being returned by Yahoo. And I hope to avoid the "header too large" error. A trial release has been uploaded to CPAN. It can be installed with: cpan BPSCHUCK/Finance-Quote-1.61_01.tar.gz or

Re: [GNC] Finance-Quote 1.61 released!

2024-04-19 Thread Bruce Schuck
On 4/19/24 9:52 AM, Murugan Muruganandam wrote: Bruce and team, thanks for the build It was Kalpesh that spent time looking for different Yahoo URIs and standing up AWS instances in other regions for testing. Me, I just did the administrative work to get the new package pushed to CPAN. I

Re: [GNC] Finance-Quote 1.61 released!

2024-04-19 Thread Bruce Schuck
Adam Griffis also noted that it is working from Germany. I suspect that you set PERL5LIB to use $HOME/.cpan/build/Finance-Quote-1.60-0/ instead of 1.61? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or

[GNC] Finance-Quote 1.61 released!

2024-04-18 Thread Bruce Schuck
. Issue #373 Authors: - Erik Colson - Paul Fenwick - Bruce Schuck - Vincent Lucarelli - David Hampton - jvolkening - Pawel Konieczny - Mike Alexander - AndreJ - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2

Re: [GNC] GNC] Finance-Quote 1.60 released!

2024-04-18 Thread Bruce Schuck
On Thu, 18 Apr 2024 16:13:34 +0200, Klaus writes: I am located in Germany and only one cookie is returned. Here is the top of the output of 'curl --include https://login.yahoo.com': Klaus, Thank you for posting that. It helps confirm this is a geo related issue. Thank you to David Crowe for

Re: [GNC] Finance-Quote 1.60 released!

2024-04-18 Thread Bruce Schuck
On 4/18/24 06:55, Kalpesh Patel wrote: Any ways it definitely appears to be tied to geo location. Another gentleman out of Germany is NOT getting those cookies either. Confirmed by the user in Spain I have been working with off-list. The same user receives the necessary cookies when using a

Re: [GNC] Finance-Quote 1.60 released!

2024-04-17 Thread Bruce Schuck
On 4/17/24 11:57 AM, Kalpesh Patel wrote: You can also save cookies to a file named cookies.txt as follows: #curl -c cookies.txt https://login.yahoo.com -I Some info: The user having issues with YahooJSON that I've been having a discussion with tried the simple curl command. Just *one*

Re: [GNC] Finance-Quote 1.60 released!

2024-04-17 Thread Bruce Schuck
On 4/17/24 11:57 AM, Kalpesh Patel wrote: You can also save cookies to a file named cookies.txt as follows: #curl -c cookies.txt https://login.yahoo.com -I and then following to display 11 characters crumb by using cookies saved in previous command: #curl -H "user-agent: Mozilla/5.0

Re: [GNC] Finance-Quote 1.60 released!

2024-04-17 Thread Bruce Schuck
Wed Apr 17 11:58:37 EDT 2024, Kalpesh Patel writes: Is this happening on Windows 10 with Strawberry perl? There is one other user is having problem getting secure cookies on Windows 10 which is what this appears to be as well. It is related to some Perl's SSL package being broken or not

Re: [GNC] How to get mutual fund quotes with Finance::Quote::GoogleWeb.pm

2024-04-15 Thread Bruce Schuck
On Mon Apr 15, 2024 22:02 EDT, Ken Farley wrote: Once I sent the last message and had a bit of time to think about it, I realized I could try something, and it worked. There's a line in the module that uses a few exchange names to find the correct data on the HTML page: What version of F::Q

[GNC] Finance-Quote 1.60 released!

2024-04-15 Thread Bruce Schuck
the future. * Bloomberg.pm - Changed module to extract data from JSON structure embedded within the HTML - Issue #360 * NSEIndia.pm - Eliminated need to use temp folders by storing file data from URL into a variable. Authors: - Erik Colson - Paul Fenwick - Br

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Bruce Schuck
On 4/14/24 3:02 PM, David Reiser wrote: yahoo_json not YahooJSON Yeah... I've made that mistake myself many times. The original author of the YahooJSON module chose to name the method (aka subroutine with the name used in the Security Editor and on the command line) "yahoo_json". Most

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-14 Thread Bruce Schuck
On 4/13/24 20:08:20 -0700, Bruce S wrote: There is some miscellaneous housekeeping and cleanup that needs to be done before pushing a final release to CPAN. Plus I had some other changes that I was planning for v1.60 but haven't done yet. Instead of v1.60, I may upload v1.59_01 tomorrow so

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-13 Thread Bruce Schuck
Just a quick status. Just an FYI, I have worked on getting a PR ready using kalpesh Patel's changes. I tried applying the same logic to the CurrencyRates/YahooJSON.pm currency module with no luck. In that case I quickly modified the currency module to utilize the "v8" API. I admit, I suck at

Re: [GNC] Finance::quote YahooJSON

2024-04-11 Thread Bruce Schuck
On 4/11/24 17:29:59 +, Greg wrote: I'm sure the Dev's are working on it, but do we have any idea what happened? My log shows 401 type errors (Unauthorized) so I thought I'd add some diagnostics in case it helps anyone. Hoping for some good news (and I'm sure I'm not alone on that).

Re: [GNC] Finance::quote YahooJSON

2024-04-10 Thread Bruce Schuck
Wed Apr 10 16:12:21 EDT 2024 Jacob Larsen wrote: Did something happen to the YahooJSON module in Finance::Quote? Or perhaps more likely the Yahoo API? I get this now, using Finance::Quote version 1.59: Unfortunately Yahoo once again made some changes with respect to the API URLs. F::Q team

[GNC] gnucash-devel list down?

2024-04-07 Thread Bruce Schuck
Odd, after sending a message to the gnucash-devel list early this morning, I received an email saying my message was in a queue because I'm not subscribed. Odd, I've been subscribed for at least a handful of years. I also notice that it does not show up in the list of lists at

[GNC] Finance::Quote::Fool

2024-04-07 Thread Bruce Schuck
Just an FYI. It appears that the Fool module (quote method/source "fool") has stopped working in the last week or so. I've spent some time investigating if it would be an easy fix, but no luck. Sorry. Bruce S. ___ gnucash-user mailing list

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-05 Thread Bruce Schuck
On 4/5/24 8:50 AM, David G. Pickett wrote: The quotes were fetched despite these usual errors, so it is only a cosmetic error. > 2024-04-03 23:45:06 Removed any lck, adding price quotes > flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes get -- >

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-04 Thread Bruce Schuck
On 4/4/24 4:02 PM, David G. Pickett wrote: Ran OK for me last night, 28 seconds, but running too often seems to create errors: 2024-04-03 23:45:01 Start GnuCash_price_cron /home/dgp/GnuCash/ubuntu-DGPickett.gnucash 2024-04-03 23:45:01 Killing gnucash

Re: [GNC] Finance Quotes Yahoo off the rails again?

2024-04-03 Thread Bruce Schuck
Wed Apr 3 13:40:48 EDT 2024 David G. Pickett wrote: Looks good, (only error because I need to switch DIA back to yahoo) and slow but much better. A later run under cron got lots of errors. Do they ration by IP address? If it is by frequency, maybe we should purposely send requests only every

Re: [GNC] Finance::Quote Default Currency Module

2024-04-01 Thread Bruce Schuck
On 3/31/24 16:46:44 -0700, Jim DeLaHunt wrote: I'm getting ready to release Finance::Quote v1.60 to CPAN. It appears that AlphaVantage has again changed how they deal with throttling for requests using the free API keys/tokens. This has affected some users that may have data that requires doing

[GNC] Finance::Quote Fidelity Module

2024-03-30 Thread Bruce Schuck
Fidelity has reworked their web pages sometime last year, breaking the Fidelity.pm module (fidelity method). I've done some digging using the Chrome/Firefox developer console and I'm not an expert but I think much of data now displayed comes through JavaScript calls. Unfortunately, it is

[GNC] Finance::Quote Default Currency Module

2024-03-30 Thread Bruce Schuck
Hello all, I'm getting ready to release Finance::Quote v1.60 to CPAN. It appears that AlphaVantage has again changed how they deal with throttling for requests using the free API keys/tokens. This has affected some users that may have data that requires doing more than a handful of currency

Re: [GNC] Finance Quotes Yahho of the rails again?

2024-03-23 Thread Bruce Schuck
On Fri, 22 Mar 2024 16:07:40 + (UTC) David G. Pickett wrote: Found Finance::Quote version 1.58.* 00:49:23? WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:VZ - Finance::Quote returned fetch failure.Reason Error retrieving quote for VZ. Attempt to fetch the

[GNC] Finance-Quote 1.59 released!

2023-12-31 Thread Bruce Schuck
rik Colson - Paul Fenwick - Vincent Lucarelli - Bruce Schuck - David Hampton - jvolkening - Pawel Konieczny - Mike Alexander - AndreJ - Vinay S Shastry - Bradley Dean - Brent Neal - Jacinta Richardson - e-dorigatti - goodvibes2 - Sam Morris - Lin

[GNC] Finance::Quote v1.59 Tentative Release Date

2023-12-30 Thread Bruce Schuck
Happy Holidays everyone. It's short notice, but I intend to push Finance::Quote v1.59 to CPAN tomorrow, December 31, 2023. The changes from v1.58 to v1.59 are: * Fixed XETRA, Tradegate and SInvestor after webpage was restructured - Issue #350 * Fidelity.pm temporarily disabled - Issue

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

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.

[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-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

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 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] 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] 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] 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] 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 - 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

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

[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] 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 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
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

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 >

[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] 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 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] 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-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

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,

[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

[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_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

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

[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-23 Thread Bruce Schuck
On 6/22/23 18:47 -0700, Bruce Schuck wrote: 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. If there is no Finance-Quote-1.56_02-? directory in C:\Strawberry\cpan\build (-? could be -0

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_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

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

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

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

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

2023-06-15 Thread Bruce Schuck
Greetings all, 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'. Anticipating that Yahoo may block access to

[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 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

[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-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

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] 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] 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] 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

[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 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

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.

[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] 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.

  1   2   >