Re: [GNC] Yahoo Closed the Door on Finance API
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 selection of European ETFs. Install that release if you haven't done so already, go to Tools > Security Editor, edit your security, change 'Type of source quote' to 'Unknown', and select 'yahooweb' from the dropdown list. Just note there is currently a caveat for the YahooWeb module. The trade date is not available (at least not without JavaScript). The date returned is the date the data is retrieved unless it's a weekend, in which case it will be set to the previous Friday. A recent web based URL with the trade date has been identified, but the module has not yet been modified to use it. Other modules that work without requiring an API key (at least for US exchanges) are Fool (fool), GoogleWeb (googleweb), and MarketWatch (marketwatch). Thank you. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
Thanks for this - the yahooweb source worked for retrieving crypto-AUD exchange rates too. Regards, Bill -Original Message- From: gnucash-user On Behalf Of Bart A.J. Seesing via gnucash-user Sent: Friday, 14 July 2023 10:50 PM To: rsb...@yahoo.com Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Yahoo Closed the Door on Finance API The latest release of F::Q (1.57) contains a new YahooWeb module that still works, at least for my selection of European ETFs. Install that release if you haven't done so already, go to Tools > Security Editor, edit your security, change 'Type of source quote' to 'Unknown', and select 'yahooweb' from the dropdown list. Sincerely, B -- Date: Fri, 14 Jul 2023 10:49:27 +0200 From: "rsbrux" To: Subject: [GNC] Yahoo Closed the Door on Finance API Message-ID: Content-Type: text/plain; charset="UTF-8" Any suggestions as to what would be the next best currently available source in F::Q for a broad spectrum of securities, especially European stocks? -- Some of us suspected this would come, getting reports of the Yahoo URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo'shttps://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub,https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. Bruce S. -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
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 > https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). For those comfortable with locating and editing the YahooJSON.pm module manually I have a quick fix. If you have F::Q v1.57 change the lines defining $YIND_URL_HEAD and $YIND_URL_TAIL (lines 38 and 39) to: my $YIND_URL_HEAD = 'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol='; my $YIND_URL_TAIL = '&modules=price,summaryDetail,defaultKeyStatistics'; Or you can wait for new release to be pushed to CPAN. On 07/14/13:43 EDT, Tom T replied: > The YahooWeb module mostly works for me except for some reason it > gives a ridiculously high value for AT&T (call sign T). Interesting. It also returns a bad value for Genpact Limited (G), but not Hyatt Hotels (H). Will need to open an issue and hopefully Vincent (who originally wrote the YahooWeb module) will take a look. Thanks all. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
The YahooWeb module mostly works for me except for some reason it gives a ridiculously high value for AT&T (call sign T). I switched that to "Motley Fool" which is a different screen scraping source under 'Type of source quote' 'Single'. On 7/14/23 8:50 AM, Bart A.J. Seesing via gnucash-user wrote: The latest release of F::Q (1.57) contains a new YahooWeb module that still works, at least for my selection of European ETFs. Install that release if you haven't done so already, go to Tools > Security Editor, edit your security, change 'Type of source quote' to 'Unknown', and select 'yahooweb' from the dropdown list. Sincerely, B ------ Date: Fri, 14 Jul 2023 10:49:27 +0200 From: "rsbrux" To: Subject: [GNC] Yahoo Closed the Door on Finance API Message-ID: Content-Type: text/plain; charset="UTF-8" Any suggestions as to what would be the next best currently available source in F::Q for a broad spectrum of securities, especially European stocks? -- Some of us suspected this would come, getting reports of the Yahoo URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo'shttps://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub,https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. Bruce S. -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
The latest release of F::Q (1.57) contains a new YahooWeb module that still works, at least for my selection of European ETFs. Install that release if you haven't done so already, go to Tools > Security Editor, edit your security, change 'Type of source quote' to 'Unknown', and select 'yahooweb' from the dropdown list. Sincerely, B -- Date: Fri, 14 Jul 2023 10:49:27 +0200 From: "rsbrux" To: Subject: [GNC] Yahoo Closed the Door on Finance API Message-ID: Content-Type: text/plain; charset="UTF-8" Any suggestions as to what would be the next best currently available source in F::Q for a broad spectrum of securities, especially European stocks? -- Some of us suspected this would come, getting reports of the Yahoo URLhttps://query2.finance.yahoo.com/v11/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics andhttps://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo'shttps://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub,https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. Bruce S. -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
You are correct Paul, but Yahoo-json has still been working. On Fri, Jul 14, 2023 at 3:40 AM Paul Feakins wrote: > On 14/07/2023 05:14, Bruce Schuck wrote: > > 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 > > > https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics > > now returning a 404 (v11) or "Unauthorized" (v10). > > > > Sorry to say this, but more than likely the YahooJSON module (aka > > yahoo_json) is going to be removed from Finance::Quote in the next > > release. This is not to say that if someone can figure out a way to > > successfully access Yahoo's https://query2.finance.yahoo.com/v?... > > APIs, please pass on that info or better yet, have a go at reworking > > the current module. > > > > There is already an issue raised on F::Q's GitHub, > > https://github.com/finance-quote/finance-quote/issues/318. Please > > refrain from "me too" comments. Unfortunately as I said in the > > previous paragraph, this issue will likely be resolved by removing the > > module. > > > As far as I know, and I may be wrong, this was shut down many years ago? > > Paul Feakins. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Yahoo Closed the Door on Finance API
Any suggestions as to what would be the next best currently available source in F::Q for a broad spectrum of securities, especially European stocks? >> 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 https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo's https://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub, https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. Bruce S. << ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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] Yahoo Closed the Door on Finance API
On 14/07/2023 05:14, Bruce Schuck wrote: 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 https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo's https://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub, https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. As far as I know, and I may be wrong, this was shut down many years ago? Paul Feakins. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Yahoo Closed the Door on Finance API
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 https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=price,summaryDetail,defaultKeyStatistics now returning a 404 (v11) or "Unauthorized" (v10). Sorry to say this, but more than likely the YahooJSON module (aka yahoo_json) is going to be removed from Finance::Quote in the next release. This is not to say that if someone can figure out a way to successfully access Yahoo's https://query2.finance.yahoo.com/v?... APIs, please pass on that info or better yet, have a go at reworking the current module. There is already an issue raised on F::Q's GitHub, https://github.com/finance-quote/finance-quote/issues/318. Please refrain from "me too" comments. Unfortunately as I said in the previous paragraph, this issue will likely be resolved by removing the module. Bruce S. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
