Re: [GNC] Finance::quote YahooJSON
I might be concluding wrong on this one. Libre Office Calc will accept them, and I just saved them again. But I think there might be more variables. It is detected as UTF16 by Libre Office Calc, so it might be a character set issue. Also, I do need to get my Gnucash upgraded, I am on 4.5 at the moment, so it might just be old. Would like to try out the Flatpak, but I can see that I need to do this the long way around. /Jacob On 2024-04-13 07:21, sunfis...@yahoo.com wrote: Gnucash most definitely *will* accept tab delimited files. You just have to tell it to use that separator in the importer. David T. On Apr 13, 2024, at 12:54 AM, ja...@larsen.net wrote: I was playing around with this a bit, unfortunately a large part of my investments are ETFs listed on Xetra in Germany, which is not available through the Google Finance services. The searching I did on it looked like this was a "Won't fix" issue. But it turns out that I am able to download CSV files with historical data from my broker, so I am back in business. The files have basically the full history of single instruments, so I can just download when I get to it, and it will fill all the holes. Only challenge is that it seems GnuCash will not accept the files directly as they are tab-separated, but I can convert them to semi-colon separated files through LibreOffice Calc, and then it works. /Jacob On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can then be quickly imported into GnuCash for even hundreds of commodities. David T. On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff wrote: Is there a way to import data to the price database? I could create a > CSV or the like and just update the numbers from day to day until this > gets resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I could create a CSV or the like and just update the numbers from day to day until this gets resolved. Thanks all, -g -Original Message- From: fromven...@outtacyte.com Sent: Thursday, April 11, 2024 1:27 AM To: GnuCash User eMail List Subject: RE: [GNC] Finance::quote YahooJSON OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON 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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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. - - 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/g
Re: [GNC] Finance::quote YahooJSON
I am currently using modified YahooJSON.pm module for my needs and seems to be working from the States. It is pulling data so far. Head over to https://github.com/ka-patel/dl_quotes/blob/main/FinanceQuote/YahooJSON.pm if you are interested in its early release before Bruce can do his vetting and get it into the main line release of F::Q. Of course I am also interested in its feedback. Keep in mind that this will introduce dependency on HTTP::CookieJar::LWP module (https://metacpan.org/pod/HTTP::CookieJar::LWP) which you can install from CPAN using your normal methods of module installation. Transcript of install below... Microsoft Windows [Version 10.0.22631.3447] (c) Microsoft Corporation. All rights reserved. C:\Users\kalpesh>perl -MCPAN -e shell Unable to get Terminal Size. The Win32 GetConsoleScreenBufferInfo call didn't work. The COLUMNS and LINES environment variables didn't work. at C:\Strawberry\perl\vendor\lib/Term/ReadLine/readline.pm line 410. cpan shell -- CPAN exploration and modules installation (v2.28) Enter 'h' for help. cpan> install HTTP::CookieJar::LWP Fetching with LWP: http://cpan.strawberryperl.com/authors/01mailrc.txt.gz Fetching with LWP: http://cpan.strawberryperl.com/modules/02packages.details.txt.gz Fetching with LWP: http://cpan.strawberryperl.com/modules/03modlist.data.gz Database was generated on Fri, 12 Apr 2024 11:19:08 GMT Updating database file ... Done! HTTP::CookieJar::LWP is up to date (0.014). cpan> upgrade HTTP::CookieJar::LWP All modules are up to date for HTTP::CookieJar::LWP cpan> exit Lockfile removed. C:\Users\kalpesh> -Original Message- From: Bruce Schuck Sent: Thursday, April 11, 2024 10:39 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Finance::quote YahooJSON 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). > I really appreciate this great working mail list and thanks for those > who devlop/fix/maintain the program. It's important to note that these APIs are likely not meant for direct access. Which is why the previous APIs that the YahooJSON.pm all became unusable at some point. This would be why you cannot find official documentation for the APIs online like you can for APIs like the AlphaVantage which limits what you can retrieve for free. I've had less time to work on F::Q the last few months, so I'm not sure when I'll be able to either rework the module to use the v8 API or test and implement Kalpesh Patel's changes. Hopefully in the next week or so, but if someone else wants to step up and create a pull request at https://github.com/finance-quote/finance-quote that would be a great help. On 4/11/24 12:48:09 -0600 (MDT), Terrence Branscombe wrote: > I've just noticed that my last stock price update occurred on March > 28. * 11:11:36 ERROR [parse_quotesource_error()] > Unrecognized Finance::Quote Error Wide character in subroutine entry > at C:/Strawberry/perl/site/lib/Finance/Quote/Cdnfundlibrary.pm line > 80. It appears the format of page Cdnfundlibrary.pm uses to scrape the data from fundlibrary.com has had major changes. The Fundata.pm module (idata.fundata.com) has also stopped working for the same reason. See Issue https://github.com/finance-quote/finance-quote/issues/366 and discussion https://github.com/finance-quote/finance-quote/discussions/364. Unfortunately both modules are likely going to be disabled and then removed from Finance::Quote. The Fool.pm module has also recently stopped working and it will also be disabled in the next release of F::Q. 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] Finance::quote YahooJSON
Gnucash most definitely *will* accept tab delimited files. You just have to tell it to use that separator in the importer. David T. On Apr 13, 2024, 12:54 AM, at 12:54 AM, ja...@larsen.net wrote: >I was playing around with this a bit, unfortunately a large part of my >investments are ETFs listed on Xetra in Germany, which is not available > >through the Google Finance services. The searching I did on it looked >like this was a "Won't fix" issue. > >But it turns out that I am able to download CSV files with historical >data from my broker, so I am back in business. The files have basically > >the full history of single instruments, so I can just download when I >get to it, and it will fill all the holes. Only challenge is that it >seems GnuCash will not accept the files directly as they are >tab-separated, but I can convert them to semi-colon separated files >through LibreOffice Calc, and then it works. > >/Jacob > >On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: > >> In the past, I have used a Google sheet that captured all my stock >> prices in one fell swoop, using Google's financial functions and a >> pasted copy of the Advanced Portfolio report. I put the AP in one >tab, >> and retrieve all quotes using references in a second tab. Save the >> sheet as CSV, which can then be quickly imported into GnuCash for >even >> hundreds of commodities. >> >> David T. >> >> On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff > >> wrote: Is there a way to import data to the price database? I could >> create a > CSV or the like and just update the numbers from day to >day >> until >> this > gets resolved. >> >> Yes, you can:- >> >> File / Import / Import Prices from a CSV file ... >> >> You only need 5 columns:- >> (1) Namespace >> (2) Symbol >> (3) Date >> (4) Price >> (5) Currency >> >> See attached. >> >> Regards >> >> Geoff >> = >> >> On 11/04/2024 4:41 pm, fromvendor wrote: I've tried Advantech, >Motley, >> and Rowe. All failed (different, but fails for all of them). >> I put in manual entries for now. Is there a way to import data to >the >> price database? I could create a CSV or the like and just update >> the numbers from day to day until this gets resolved. >> Thanks all, >> -g >> >> -Original Message- >> From: fromven...@outtacyte.com >> Sent: Thursday, April 11, 2024 1:27 AM >> To: GnuCash User eMail List >> Subject: RE: [GNC] Finance::quote YahooJSON >> >> OK, I just noticed in my log that I got bit by this. What other >source >> do you recommend for the nonce? I only have 3 to get updated. -greg >> >> For help with any of our services, please reach out to our Helpdesk: >> helpd...@outtacyte.com >> OuttaCyTE / Greg's Helpdesk >> E-Mail: helpd...@outtacyte.com >> Phone: 830-672-9068, Dial ext. 852 to reach a staff person during >> office hours >> -Original Message- >> From: gnucash-user >> [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On >> Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM >> To: GnuCash User eMail List >> Subject: Re: [GNC] Finance::quote YahooJSON >> >> 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 is aware and an issue has been opened, but so far no >> determination if it can be corrected or when. For now the best >> suggestion is to select a different source. >> >> Regards, >> >> 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 Re
Re: [GNC] Finance::quote YahooJSON
I was playing around with this a bit, unfortunately a large part of my investments are ETFs listed on Xetra in Germany, which is not available through the Google Finance services. The searching I did on it looked like this was a "Won't fix" issue. But it turns out that I am able to download CSV files with historical data from my broker, so I am back in business. The files have basically the full history of single instruments, so I can just download when I get to it, and it will fill all the holes. Only challenge is that it seems GnuCash will not accept the files directly as they are tab-separated, but I can convert them to semi-colon separated files through LibreOffice Calc, and then it works. /Jacob On 2024-04-11 17:16, sunfish62--- via gnucash-user wrote: In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can then be quickly imported into GnuCash for even hundreds of commodities. David T. On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff wrote: Is there a way to import data to the price database? I could create a > CSV or the like and just update the numbers from day to day until this > gets resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I could create a CSV or the like and just update the numbers from day to day until this gets resolved. Thanks all, -g -Original Message- From: fromven...@outtacyte.com Sent: Thursday, April 11, 2024 1:27 AM To: GnuCash User eMail List Subject: RE: [GNC] Finance::quote YahooJSON OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON 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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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. ___ 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. ___ 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] Finance::quote YahooJSON
Bruce, thank you for that excellent reply. Hoping the best for all the Devs. -greg -Original Message- From: Bruce Schuck [mailto:bsch...@asgard-systems.com] Sent: Thursday, April 11, 2024 9:39 PM To: gnucash-user@gnucash.org Cc: From: Terrence Branscombe; fromvendor Subject: Re: [GNC] Finance::quote YahooJSON 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). > I really appreciate this great working mail list and thanks for those > who devlop/fix/maintain the program. It's important to note that these APIs are likely not meant for direct access. Which is why the previous APIs that the YahooJSON.pm all became unusable at some point. This would be why you cannot find official documentation for the APIs online like you can for APIs like the AlphaVantage which limits what you can retrieve for free. I've had less time to work on F::Q the last few months, so I'm not sure when I'll be able to either rework the module to use the v8 API or test and implement Kalpesh Patel's changes. Hopefully in the next week or so, but if someone else wants to step up and create a pull request at https://github.com/finance-quote/finance-quote that would be a great help. On 4/11/24 12:48:09 -0600 (MDT), Terrence Branscombe wrote: > I've just noticed that my last stock price update occurred on March > 28. * 11:11:36 ERROR [parse_quotesource_error()] > Unrecognized Finance::Quote Error Wide character in subroutine entry > at C:/Strawberry/perl/site/lib/Finance/Quote/Cdnfundlibrary.pm line > 80. It appears the format of page Cdnfundlibrary.pm uses to scrape the data from fundlibrary.com has had major changes. The Fundata.pm module (idata.fundata.com) has also stopped working for the same reason. See Issue https://github.com/finance-quote/finance-quote/issues/366 and discussion https://github.com/finance-quote/finance-quote/discussions/364. Unfortunately both modules are likely going to be disabled and then removed from Finance::Quote. The Fool.pm module has also recently stopped working and it will also be disabled in the next release of F::Q. 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] Finance::quote YahooJSON
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). I really appreciate this great working mail list and thanks for those who devlop/fix/maintain the program. It's important to note that these APIs are likely not meant for direct access. Which is why the previous APIs that the YahooJSON.pm all became unusable at some point. This would be why you cannot find official documentation for the APIs online like you can for APIs like the AlphaVantage which limits what you can retrieve for free. I've had less time to work on F::Q the last few months, so I'm not sure when I'll be able to either rework the module to use the v8 API or test and implement Kalpesh Patel's changes. Hopefully in the next week or so, but if someone else wants to step up and create a pull request at https://github.com/finance-quote/finance-quote that would be a great help. On 4/11/24 12:48:09 -0600 (MDT), Terrence Branscombe wrote: I've just noticed that my last stock price update occurred on March 28. * 11:11:36 ERROR [parse_quotesource_error()] Unrecognized Finance::Quote Error Wide character in subroutine entry at C:/Strawberry/perl/site/lib/Finance/Quote/Cdnfundlibrary.pm line 80. It appears the format of page Cdnfundlibrary.pm uses to scrape the data from fundlibrary.com has had major changes. The Fundata.pm module (idata.fundata.com) has also stopped working for the same reason. See Issue https://github.com/finance-quote/finance-quote/issues/366 and discussion https://github.com/finance-quote/finance-quote/discussions/364. Unfortunately both modules are likely going to be disabled and then removed from Finance::Quote. The Fool.pm module has also recently stopped working and it will also be disabled in the next release of F::Q. 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] Finance::quote YahooJSON
Yes, off the rails again: Found Finance::Quote version 1.59. * 23:45:21 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:VZ - Finance::Quote returned fetch failure.Reason Error retrieving quote for VZ. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=VZ&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) * 23:45:21 WARN [GncQuotesImpl::parse_one_quote()] Skipped NYSE:WBD - Finance::Quote returned fetch failure.Reason Error retrieving quote for WBD. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=WBD&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) ___ 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] Finance::quote YahooJSON
Kalpesh - Thank you for the link. I took a quick gander and it seems pretty nice. Have you used it since the Yahoo thing went south and did it work? Are you using the query api or scraping the window? All, 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. Here is a set of lines from the log I keep (security redacted): Found Finance::Quote version 1.59. * 15:30:02 WARN [GncQuotesImpl::parse_one_quote()] Skipped NASDAQ:X - Finance::Quote returned fetch failure. Reason Error retrieving quote for X. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=X&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) If I try the above URL, I get what appears to be a JSON reply: {"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Crumb"}}} Dooing a bit of Google-fu, I find a 1 day old comment on reddit r/GnuCash saying it's broke and a reply saying it's been turned off (no longer free) but I have not found any comment from yahoo on the subject. Hoping for some good news (and I'm sure I'm not alone on that). I really appreciate this great working mail list and thanks for those who devlop/fix/maintain the program. -greg -Original Message- From: Kalpesh Patel [mailto:kalpesh.pa...@usa.net] Sent: Thursday, April 11, 2024 7:44 AM To: 'Geoff'; fromvendor; 'GnuCash User eMail List' Subject: RE: [GNC] Finance::quote YahooJSON You may want to review my personal project at https://github.com/ka-patel/dl_quotes ... -Original Message----- From: Geoff Sent: Thursday, April 11, 2024 7:57 AM To: fromvendor ; 'GnuCash User eMail List' Subject: Re: [GNC] Finance::quote YahooJSON > Is there a way to import data to the price database? I could create a > CSV > or the like and just update the numbers from day to day until this > gets > resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: > I've tried Advantech, Motley, and Rowe. All failed (different, but fails for > all of them). > > I put in manual entries for now. Is there a way to import data to the price > database? I could create a CSV or the like and just update the numbers from > day to day until this gets resolved. > > Thanks all, > -g > > -Original Message- > From: fromven...@outtacyte.com > Sent: Thursday, April 11, 2024 1:27 AM > To: GnuCash User eMail List > Subject: RE: [GNC] Finance::quote YahooJSON > > OK, I just noticed in my log that I got bit by this. What other source do > you recommend for the nonce? I only have 3 to get updated. > -greg > > For help with any of our services, please reach out to our Helpdesk: > helpd...@outtacyte.com > > OuttaCyTE / Greg's Helpdesk > E-Mail: helpd...@outtacyte.com > Phone: 830-672-9068, Dial ext. 852 to reach a staff person during > office hours > > -----Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On > Behalf Of Bruce Schuck > Sent: Wednesday, April 10, 2024 4:26 PM > To: GnuCash User eMail List > Subject: Re: [GNC] Finance::quote YahooJSON > > 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 is aware and an issue has been opened, but so far > no determination if it can be corrected or when. For now the best > suggestion is to select a different source. > > Regards, > > 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. &g
Re: [GNC] Finance::quote YahooJSON
YohooWeb is a page-scraping alternative to Yahoo-json. The web URLs are a lot more stable than the REST API ones. Page format changes will break it, but one can hope that web breakage and REST breakage will happen at different times. There's one caveat, Yahoo! uses a script element for the quote date-time on the web page and the page-scraper can't get the result so it has to use the current time instead. Regards, John Ralls > On Apr 10, 2024, at 23:26, fromvendor wrote: > > OK, I just noticed in my log that I got bit by this. What other source do > you recommend for the nonce? I only have 3 to get updated. > -greg > > For help with any of our services, please reach out to our Helpdesk: > helpd...@outtacyte.com > > OuttaCyTE / Greg's Helpdesk > E-Mail: helpd...@outtacyte.com > Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf > Of Bruce Schuck > Sent: Wednesday, April 10, 2024 4:26 PM > To: GnuCash User eMail List > Subject: Re: [GNC] Finance::quote YahooJSON > > 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 is aware and an issue has been opened, but so far no > determination if it can be corrected or when. For now the best > suggestion is to select a different source. > > Regards, > > 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. ___ 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] Finance::quote YahooJSON
In the past, I have used a Google sheet that captured all my stock prices in one fell swoop, using Google's financial functions and a pasted copy of the Advanced Portfolio report. I put the AP in one tab, and retrieve all quotes using references in a second tab. Save the sheet as CSV, which can then be quickly imported into GnuCash for even hundreds of commodities. David T. On Apr 11, 2024, 2:59 PM, at 2:59 PM, Geoff wrote: >> Is there a way to import data to the price database? I could create >a > CSV or the like and just update the numbers from day to day until >this > gets resolved. > >Yes, you can:- > >File / Import / Import Prices from a CSV file ... > >You only need 5 columns:- >(1) Namespace >(2) Symbol >(3) Date >(4) Price >(5) Currency > >See attached. > >Regards > >Geoff >= > >On 11/04/2024 4:41 pm, fromvendor wrote: >> I've tried Advantech, Motley, and Rowe. All failed (different, but >fails for all of them). >> >> I put in manual entries for now. Is there a way to import data to >the price database? I could create a CSV or the like and just update >the numbers from day to day until this gets resolved. >> >> Thanks all, >> -g >> >> -Original Message- >> From: fromven...@outtacyte.com >> Sent: Thursday, April 11, 2024 1:27 AM >> To: GnuCash User eMail List >> Subject: RE: [GNC] Finance::quote YahooJSON >> >> OK, I just noticed in my log that I got bit by this. What other >source do you recommend for the nonce? I only have 3 to get updated. >> -greg >> >> For help with any of our services, please reach out to our Helpdesk: >helpd...@outtacyte.com >> >> OuttaCyTE / Greg's Helpdesk >> E-Mail: helpd...@outtacyte.com >> Phone: 830-672-9068, Dial ext. 852 to reach a staff person during >office hours >> >> -Original Message- >> From: gnucash-user >[mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On >Behalf Of Bruce Schuck >> Sent: Wednesday, April 10, 2024 4:26 PM >> To: GnuCash User eMail List >> Subject: Re: [GNC] Finance::quote YahooJSON >> >> 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 is aware and an issue has been opened, but so far no >> determination if it can be corrected or when. For now the best >> suggestion is to select a different source. >> >> Regards, >> >> 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. > > > >___ >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] Finance::quote YahooJSON
You may want to review my personal project at https://github.com/ka-patel/dl_quotes ... -Original Message- From: Geoff Sent: Thursday, April 11, 2024 7:57 AM To: fromvendor ; 'GnuCash User eMail List' Subject: Re: [GNC] Finance::quote YahooJSON > Is there a way to import data to the price database? I could create a > CSV > or the like and just update the numbers from day to day until this > gets > resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: > I've tried Advantech, Motley, and Rowe. All failed (different, but fails for > all of them). > > I put in manual entries for now. Is there a way to import data to the price > database? I could create a CSV or the like and just update the numbers from > day to day until this gets resolved. > > Thanks all, > -g > > -Original Message- > From: fromven...@outtacyte.com > Sent: Thursday, April 11, 2024 1:27 AM > To: GnuCash User eMail List > Subject: RE: [GNC] Finance::quote YahooJSON > > OK, I just noticed in my log that I got bit by this. What other source do > you recommend for the nonce? I only have 3 to get updated. > -greg > > For help with any of our services, please reach out to our Helpdesk: > helpd...@outtacyte.com > > OuttaCyTE / Greg's Helpdesk > E-Mail: helpd...@outtacyte.com > Phone: 830-672-9068, Dial ext. 852 to reach a staff person during > office hours > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On > Behalf Of Bruce Schuck > Sent: Wednesday, April 10, 2024 4:26 PM > To: GnuCash User eMail List > Subject: Re: [GNC] Finance::quote YahooJSON > > 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 is aware and an issue has been opened, but so far > no determination if it can be corrected or when. For now the best > suggestion is to select a different source. > > Regards, > > 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. ___ 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] Finance::quote YahooJSON
> Is there a way to import data to the price database? I could create a > CSV or the like and just update the numbers from day to day until this > gets resolved. Yes, you can:- File / Import / Import Prices from a CSV file ... You only need 5 columns:- (1) Namespace (2) Symbol (3) Date (4) Price (5) Currency See attached. Regards Geoff = On 11/04/2024 4:41 pm, fromvendor wrote: I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I could create a CSV or the like and just update the numbers from day to day until this gets resolved. Thanks all, -g -Original Message- From: fromven...@outtacyte.com Sent: Thursday, April 11, 2024 1:27 AM To: GnuCash User eMail List Subject: RE: [GNC] Finance::quote YahooJSON OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON 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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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.___ 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] Finance::quote YahooJSON
I've tried Advantech, Motley, and Rowe. All failed (different, but fails for all of them). I put in manual entries for now. Is there a way to import data to the price database? I could create a CSV or the like and just update the numbers from day to day until this gets resolved. Thanks all, -g -Original Message- From: fromven...@outtacyte.com Sent: Thursday, April 11, 2024 1:27 AM To: GnuCash User eMail List Subject: RE: [GNC] Finance::quote YahooJSON OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON 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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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] Finance::quote YahooJSON
OK, I just noticed in my log that I got bit by this. What other source do you recommend for the nonce? I only have 3 to get updated. -greg For help with any of our services, please reach out to our Helpdesk: helpd...@outtacyte.com OuttaCyTE / Greg's Helpdesk E-Mail: helpd...@outtacyte.com Phone: 830-672-9068, Dial ext. 852 to reach a staff person during office hours -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+fromvendor=outtacyte@gnucash.org] On Behalf Of Bruce Schuck Sent: Wednesday, April 10, 2024 4:26 PM To: GnuCash User eMail List Subject: Re: [GNC] Finance::quote YahooJSON 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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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] Finance::quote YahooJSON
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 is aware and an issue has been opened, but so far no determination if it can be corrected or when. For now the best suggestion is to select a different source. Regards, 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.
[GNC] Finance::quote YahooJSON
Hi 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: $ gnc-fq-dump -v yahoo_json EUNL.DE Finance::Quote fields Gnucash uses: symbol: EUNL.DE <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock EUNL.DE stock field value - - - EUNL.DE errormsg: Error retrieving quote for EUNL.DE. Attempt to fetch the URL https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=EUNL.DE&modules=price,summaryDetail,defaultKeyStatistics resulted in HTTP response 401 (Unauthorized) EUNL.DE last: **missing** EUNL.DE nav: **missing** EUNL.DE price: **missing** EUNL.DE success: 0 EUNL.DEsymbol: EUNL.DE Opening the link in a browser gets me this: {"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid Crumb"}}} There are 14 securities on the list that I am trying to update from this source. Same operation worked yesterday. /Jacob ___ 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.