2023-05-06 GnuCash IRC logs
01:16:50 *** fell has quit IRC
01:18:10 *** fell has joined #gnucash
01:18:10 *** ChanServ sets mode: +o fell
02:33:30 *** ettore has quit IRC
02:44:31 *** gjanssens has joined #gnucash
02:44:31 *** ChanServ sets mode: +o gjanssens
02:59:40 *** gandalf has joined #gnucash
03:22:14 *** bertbob has quit IRC
03:24:29 *** bertbob has joined #gnucash
03:24:29 *** ChanServ sets mode: +v bertbob
06:24:11 *** gandalf has quit IRC
06:26:38 *** gandalf has joined #gnucash
08:41:21 *** miklcct has quit IRC
08:45:51 *** miklcct has joined #gnucash
08:45:51 *** ChanServ sets mode: +v miklcct
09:20:21 *** jervin has joined #gnucash
13:44:33 *** palerider has joined #gnucash
13:49:28 *** palerider has left #gnucash
15:10:01 <CDB-Man> is it just me, or is finance::quote not able to pull prices right now?
15:14:29 <CDB-Man> https://github.com/finance-quote/finance-quote/issues/264#issuecomment-1535612829
15:14:37 <CDB-Man> looks like I'm not the only one
15:18:10 <CDB-Man> [2023.04.09 04:20:00] <Simon> I think the prices are normally inserted as 12:00:00 --> https://github.com/Gnucash/gnucash/pull/1493#issuecomment-1375187680
15:19:33 <Simon> no-one has been using Yahoo for a long time
15:19:45 <Simon> you should be using Alphavantage
15:20:34 <Simon> I have my own modified version that always returns closing prices for the most recently available day instead of live data: https://git.uuid.uk/simon/perl-lib/tree/Finance/Quote.pm#n238
15:24:06 *** dtux[m] has left #gnucash
15:24:14 *** gandalf1 has joined #gnucash
15:24:42 *** gandalf has quit IRC
15:24:42 *** gandalf1 is now known as gandalf
15:32:36 <CDB-Man> well, it its not available in the deffault build, i dont have the abilty to build it myself. does alpha do crypto?
15:36:58 <CDB-Man> can it also lookup mutual funds on FUNDSERV?
15:37:43 <CDB-Man> also secondary non-US exchanges...
15:41:10 <CDB-Man> i rmember back in the past, I used alphavantage as a source, but because i lokup over 100 tickers... alphavantage could not handle that many
15:41:15 <CDB-Man> and its why i switched to Yahoo JSON
15:41:33 <CDB-Man> its also much slower than yahoo JSON
15:42:06 <Simon> are you doing this using gnucash directly?
15:42:22 <CDB-Man> yes
15:42:51 <CDB-Man> my pricedb and securities editor is massive
15:42:53 <jralls> Simon, not true. yahoo_json worked quite well until a month ago and it doesn't have a 5-quotes-per-minute limit like Alphavantage.
15:43:23 <Simon> does gnucash still lookup everything in one go even if it already has quotes for the current date?
15:43:48 <jralls> CDB-Man, The Alphavantage FQ module now can handle your 100 symbols, it will just take a while because of their throttling.
15:43:48 <Simon> I have a script to avoid doing that but I haven't updated it for the v5 finance-quote-wrapper https://github.com/nomis/gnucash-prices
15:43:52 <CDB-Man> i dont know, but based on the behaviour i would assume so
15:44:20 <CDB-Man> jralls: well, for fun i switched 10 tickers to AV, and that already took 60 seconds due to the throttling
15:44:28 <CDB-Man> i cant imagine the delay for 100+...
15:44:39 <jralls> 10x that?
15:44:50 <Simon> about an hour
15:44:52 <CDB-Man> is it linear or exponential throttling?
15:44:57 <Simon> if you want to query it faster you can of course pay them
15:45:02 <jralls> It's linear.
15:45:07 <CDB-Man> or I can use Yahoo! :)
15:45:14 <Simon> you don't pay Yahoo either
15:45:16 <jralls> Not today.
15:46:11 <Simon> you probably want to look at using my script if you're doing that many lookups
15:46:47 <CDB-Man> how would I run that on windows?
15:47:21 <jralls> Simon why would your script be any faster than GnuCash?
15:48:55 <CDB-Man> unless your script can get around the throttling, i cant see how its faster
15:49:15 <Simon> if you needed to do retries because something failed, it would avoid lookups when there's already a price for today
15:49:35 <Simon> CDB-Man: you'd run it with Python
15:49:57 <CDB-Man> that's beyond my capabilities if there's not a point and click solution
15:50:12 <Simon> then no, you can't use it
15:50:20 <Simon> it may also fail when it can't use syslog
15:50:27 <Simon> (which doesn't exist on Windows)
15:52:30 <jralls> CDB-Man, Bruce Schuck the FQ maintainer just posted a suggestion on gnucash-user: Find YahooJSON.pm and edit the $YIND_URL_HEAD to change "v7" to "v6".
15:53:48 <jralls> You can use Notepad. The path should be c:/Strawberry/perl/site/lib/Finance/Quote/YahooJSON.pm
15:54:15 <Simon> I'll try and remember to update the script so it works on Windows
15:57:00 <CDB-Man> jralls: OK, will try this now
15:58:14 <CDB-Man> OLD
15:58:14 <CDB-Man> my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v7/finance/quote?symbols=';
15:58:14 <CDB-Man> NEW
15:58:14 <CDB-Man> my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v6/finance/quote?symbols=';
15:58:18 <CDB-Man> let's see
16:00:56 <CDB-Man> jralls: do i need to relaunch gnucash for it to pickup the chagne?
16:01:12 <jralls> No. I take it that didn't work?
16:02:48 <CDB-Man> no, i just hadnt tried yet -- took a while to mess with default permissions in the perl folder
16:03:09 <CDB-Man> it worked -- his solution did the trick
16:03:18 <CDB-Man> all stocks found
16:03:35 <jralls> Yay. At least for now.
16:04:44 <CDB-Man> if I run the "install online price retrieval" script, will that detect my chagne and then attempt to overwrite with the server version? ie overwrit it back to v7
16:13:04 *** gandalf has quit IRC
16:21:29 <jralls> Assuming you're up to date, only when Bruce puts a new version of FQ on cpan. That new version should have a more stable work-around so the edit wouldn't be necessary.
16:22:47 <CDB-Man> i run the update script every saturday, before i run gnucash to update my financials, so yes I should always be up to date
18:12:20 *** gjanssens has quit IRC
18:27:58 *** jervin has quit IRC
20:07:33 <CDB-Man> @tell chris I forget where we had landed on https://bugs.gnucash.org/show_bug.cgi?id=798004#c83 this topic, or if we didnt get anywhere
20:07:33 <gncbot> CDB-Man: The operation succeeded.
23:12:08 *** mxdyeah has joined #gnucash
23:12:08 *** ChanServ sets mode: +v mxdyeah
23:22:51 *** mxdyeah has quit IRC
23:22:58 *** mxdfirst has joined #gnucash
23:22:58 *** ChanServ sets mode: +v mxdfirst
23:23:05 *** mxdfirst has quit IRC