2017-11-13 GnuCash IRC logs
00:51:13 <CDB-Man> 8[20:38:15] @jralls: CDB-Away: IIRC there's a hard-coded currency source in F::Q. I think that's what Erik is messing with in 1.47. If you're feeling lucky you can try it out. <-- going to try this out right now
00:53:36 <CDB-Man> jralls: confirmed it works, at least for US dollar noon rates on my gnucash that's base CAD currency
01:02:26 *** Mechtilde has joined #gnucash
01:19:36 *** fell has quit IRC
01:20:44 *** fell has joined #gnucash
01:30:25 *** lucky has quit IRC
01:34:58 *** bertbob has quit IRC
01:37:39 *** bertbob has joined #gnucash
01:40:43 *** bertbob has quit IRC
01:51:10 *** Mechtilde has quit IRC
01:56:49 *** bertbob has joined #gnucash
03:27:23 *** fabior has joined #gnucash
03:31:42 *** gjanssens has joined #gnucash
03:31:42 *** ChanServ sets mode: +o gjanssens
03:42:49 *** fabior has quit IRC
03:51:30 *** Mechtilde has joined #gnucash
04:01:57 *** pilotauto has quit IRC
04:30:25 *** Mechtilde has quit IRC
04:36:31 *** Mechtilde has joined #gnucash
04:50:21 *** fabior has joined #gnucash
05:30:58 *** Mechtilde has quit IRC
05:43:37 *** fabior has quit IRC
05:45:04 *** fabior has joined #gnucash
06:18:23 *** fabior has quit IRC
06:41:56 *** Mechtilde has joined #gnucash
06:44:47 *** fabior has joined #gnucash
06:45:17 *** Jimraehl1 has joined #gnucash
06:55:55 *** analysis has joined #gnucash
06:58:50 *** fabior has quit IRC
07:17:27 *** Jimraehl1 has left #gnucash
07:28:28 *** chris has joined #gnucash
08:07:16 *** meb has joined #gnucash
08:10:38 *** analysis has quit IRC
08:12:30 *** fabior has joined #gnucash
08:12:54 <lmat> chris: Ah, I see your other post, "actually i figured it out". I see that branch; exactly what I was talking about.
08:16:43 *** phebus has quit IRC
08:17:42 *** fabior has quit IRC
08:17:56 *** phebus has joined #gnucash
08:23:30 *** jotrago has quit IRC
08:24:22 *** jotrago has joined #gnucash
08:33:31 <warlord> .
08:59:56 *** storyjesse has joined #gnucash
09:01:27 *** User has joined #gnucash
09:07:10 *** storyjesse1 has joined #gnucash
10:08:53 *** Mechtilde has quit IRC
10:12:12 *** kael has joined #gnucash
10:22:54 *** storyjesse1 has quit IRC
10:28:46 *** storyjesse has quit IRC
10:32:50 *** kael has quit IRC
10:38:27 *** meb has quit IRC
10:40:35 *** meb has joined #gnucash
10:44:01 *** ArtGravity has joined #gnucash
10:52:21 *** lmat has quit IRC
10:55:22 *** lmat has joined #gnucash
11:22:18 *** Mechtilde has joined #gnucash
11:32:41 *** Mechtilde has quit IRC
11:42:43 *** meb has quit IRC
11:51:31 *** bertbob has quit IRC
12:34:28 *** Mechtilde has joined #gnucash
12:52:43 *** gncbot sets mode: +o fell
13:03:56 *** bertbob has joined #gnucash
13:07:00 *** bertbob has quit IRC
13:13:17 *** User has quit IRC
13:23:06 *** bertbob has joined #gnucash
13:47:45 *** bertbob has quit IRC
13:56:23 *** bertbob has joined #gnucash
14:11:19 *** fbruetting has joined #gnucash
14:13:20 *** chf has quit IRC
14:16:59 *** chf has joined #gnucash
14:17:00 *** bunk3m has joined #gnucash
14:25:34 *** jchonig has quit IRC
14:33:06 *** carwynnelson has joined #gnucash
14:34:29 *** fekepp has joined #gnucash
14:36:09 *** frakturfreak has joined #gnucash
14:42:13 *** frakturfreak has quit IRC
14:45:38 *** Mechtilde has quit IRC
14:46:01 *** carwynnelson has quit IRC
14:48:26 *** frakturfreak has joined #gnucash
14:57:34 *** O01eg has quit IRC
14:59:15 *** jchonig has joined #gnucash
15:00:30 *** O01eg has joined #gnucash
15:01:30 *** bertbob has quit IRC
15:03:43 *** bertbob has joined #gnucash
15:06:54 *** bertbob has quit IRC
15:11:32 *** User has joined #gnucash
15:18:26 *** fabior has joined #gnucash
15:22:51 *** bertbob has joined #gnucash
15:28:11 *** kael has joined #gnucash
15:34:17 *** fabior has quit IRC
15:37:05 *** kael has quit IRC
15:50:18 *** User has quit IRC
15:53:08 *** fabior has joined #gnucash
16:16:47 *** frakturfreak has quit IRC
16:19:17 *** bertbob has quit IRC
16:21:55 *** fabior has quit IRC
16:25:42 *** meb has joined #gnucash
16:26:19 *** bertbob has joined #gnucash
16:28:44 *** meb has quit IRC
16:29:28 *** bertbob has quit IRC
16:34:01 *** meb has joined #gnucash
16:35:55 *** fabior has joined #gnucash
16:37:31 *** chf has quit IRC
16:37:48 *** noah has joined #gnucash
16:37:59 *** chf has joined #gnucash
16:38:27 *** pilotauto has joined #gnucash
16:45:32 *** bertbob has joined #gnucash
16:48:37 *** carwynnelson has joined #gnucash
16:48:37 *** bertbob has quit IRC
16:48:47 *** noah has quit IRC
16:52:09 *** meb has quit IRC
16:53:55 *** noah has joined #gnucash
16:53:58 *** fabior has quit IRC
16:55:33 *** gjanssens has quit IRC
16:55:56 *** meb has joined #gnucash
16:56:11 *** luc14n0 has joined #gnucash
16:59:00 *** meb has quit IRC
17:03:23 <luc14n0> jralls: Since you mentioned that the perl packages are not runtime dep and slib is not needed, my manual installation should've worked. I'm doing the compilation again to see if it hiccups again.
17:04:42 *** bertbob has joined #gnucash
17:06:35 *** Unhammer has quit IRC
17:11:49 *** meb has joined #gnucash
17:12:00 *** Unhammer has joined #gnucash
17:22:35 *** noah has quit IRC
17:27:09 *** carwynnelson has quit IRC
17:27:12 *** carwynnelson has joined #gnucash
17:32:13 <luc14n0> jralls: that's odd, now the app launched without errors. If you want the dumped core of the first try, let me know.
17:35:43 <jralls> luc14n0: Depends on the reason for the crash. What was the error? Have you looked at the stack trace?
17:36:21 *** tref95 has joined #gnucash
17:38:21 <luc14n0> jralls: the error was caused by the lack of running ldconfig, after I ran it the error got away but the app didn't launched, it showed a crash message I think and dumped a core.
17:38:39 <luc14n0> *launch
17:42:23 <luc14n0> I'll see if I trace something.
17:42:56 <luc14n0> *traced
17:47:36 <luc14n0> Such a pity, I thought I did but didn't. The core dump wont be of great help.
17:54:51 *** tref95 has quit IRC
18:00:34 *** carwynnelson has quit IRC
18:09:04 <jralls> luc14n0: Too bad.
18:14:03 <luc14n0> jralls: yeah, now I'll compile with cmake to see the error that I'm getting. If I recall correctly is a different one. We talk another day.
18:14:23 <jralls> OK.
18:16:02 *** luc14n0 has quit IRC
18:22:23 <chris> date-utilities.scm is confusing -- while timepair refers to seconds + nanoseconds, gnc:date occasionally refers to a datevec, and othertimes refers to the time64 integer :-(
18:22:23 <gncbot> chris: Sent 1 day, 21 hours, and 40 minutes ago: <lmat> I added time64CanonicalDayTime and another function: https://github.com/limitedatonement/gnucash/tree/time64-ftw
18:31:51 <chris> I may need to global search-and-replace, e.g. gnc:date-get-week to time64-get-week in all .scm files to make the function names more consistent
18:32:08 *** PaulG has joined #gnucash
18:33:32 *** PaulG has quit IRC
18:34:01 *** PaulG has joined #gnucash
18:34:48 <PaulG> Has anyone noticed any problems with the p5-Finance-Quote after Yahoo!'s recent changes (they removed .csv file downloads of quote data)
18:35:40 <PaulG> (using gnucash 2.6.18 and p5-Finance-Quote 1.44, on a NetBSD-8 system)
18:56:58 <fell> PaulG: https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
18:58:42 <fell> and the latest announcement of FQ, which I see, is 1.47
19:01:53 *** fbruetting has quit IRC
19:11:02 <PaulG> yeah, looks like I need to upgrade - which unfortunately means waiting for the NetBSD pkgsrc folks to update the packaging.
19:11:08 <PaulG> Thanks for the reply.
19:12:11 <fell> or use sudo gnc-fq-update or 'cpan upgrade ...'
19:13:21 <PaulG> AFAIK neither of those are available for NetBSD pkgsrc systems. :(
19:24:45 <PaulG> well, I did my own update, and it doesn't help. PriceEditor->GetQuotes results in a dialog box that says "There was an unknown error while retrieving the price quotes."
19:25:52 <fell> did you change the source for your commodities?
19:27:01 <PaulG> not sure what you mean
19:27:37 <PaulG> they're all set to "Yahoo USA" just like they've always been
19:28:43 <fell> you have to change them to alphavantage in group unknown
19:29:26 <PaulG> every security? I have a couple hundred of them! And there doesn't seem to be any "change all" option, just one at a time.
19:29:41 <PaulG> (similarly, there's no way to "get one quote" only "Get All Quotes")
19:31:12 <PaulG> and the pop-up menu that lists quote sources doesn't seem to mention alphavantage anywhere
19:31:30 <PaulG> treat me like an idiot - where do I find the thing that needs to be changed? :)
19:34:44 <PaulG> oh, ok, I think I found it. I changed one security, and instead of the error messasge I got a list of all the _other_ securities that said it was unable to find them.
19:34:55 <PaulG> So here I go, one security at a time!
19:34:59 <PaulG> Thanks again!
19:35:17 <fell> if you start gnucash in a terminal, do you see 'Found Finance::Quote version 1.47'?
19:35:54 <fell> OK, good luck with changing. ;-)
19:37:04 <fell> (Unsupported option: save a copy as uncompressed xml and use your text editor.)
19:43:14 <PaulG> I'm running 1.46 cuz the list archives sasid "consider 1.47 untested"
19:43:35 <PaulG> but it still isn't working. It just lists all the securities in the "can't get quotes" list
19:44:51 <PaulG> it works for all the Mutual funds but not for stocks.
19:45:12 <PaulG> (The mutual funds are NOT included in the "can't get quotes" list)
19:46:59 <fell> Affected should be yahoo* (with exception of json), canada, usa, nyse, nasdaq, vanguard which are aliases.
19:48:19 <PaulG> let me see if the json thing works
19:49:53 *** bunk3m has quit IRC
19:50:11 <fell> But I fear they might close it later, too.
19:56:25 <PaulG> for now at least, "Yahoo as JSON" is working for both Mutual Funds and (NYSE/NASDAQ) Securities
19:56:33 <PaulG> thanks again for the pointers
19:56:45 <fell> Welcome
20:13:00 *** ArtGravity has quit IRC
20:15:56 <PaulG> oh, one last question: what do I use for currencies? "Yahoo as JSON" is not available, and "known currencies" (in the Unknown group) doesn't work
20:28:22 *** User has joined #gnucash
20:29:21 <fell> PaulG, search https://lists.gnucash.org/pipermail/gnucash-user/2017-November/thread.html
20:29:39 <PaulG> will do - thanks again
20:30:38 <fell> https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072969.html
20:39:21 <PaulG> ok, message from Mark dated 2017-11-13 17:00:31 seems to indicate that currencies should work in 1.47, so I updated to 1.47. Alas, it still complains about Currency PHP. (interestingly, it does NOT complain about USD!)
20:40:02 <PaulG> er it was actually message from Erik dated 2017-11-12 16:27:21
20:41:45 <PaulG> oh, wait, it seems I also need to change the lookup method to Other->alphavantage - retesting
20:42:26 <PaulG> nope, doesn't help. still get error for CURRENCY:PHP
20:43:33 *** chris has quit IRC
20:45:54 <PaulG> the security editor allows me to select Other->alphavantage, but it doesn't "stick". If I "OK" that dialog and then try to edit again, it's back to Single:Currency
20:46:15 *** chris has joined #gnucash
20:46:18 *** chris_ has quit IRC
20:46:27 *** pilotauto has quit IRC
20:46:33 *** pilotauto has joined #gnucash
20:47:41 *** chris_ has joined #gnucash
20:56:50 *** meb has quit IRC
21:01:22 *** meb has joined #gnucash
21:06:12 *** bunk3m has joined #gnucash
21:14:22 <fell> PaulG: I had no time to test it. If nobody else here knows the answer ask on that mailing list.
21:14:47 <PaulG> will do
21:15:58 *** meb has quit IRC
21:16:09 <fell> but from my understanding, Erik should have adjusted currency in a way, that it point to alphavantage instead of yahoo.
21:17:07 *** bunk3m has quit IRC
21:18:42 *** meb has joined #gnucash
21:22:02 *** meb has quit IRC
21:23:33 *** meb has joined #gnucash
21:36:50 <CDB-Away> Alpha vantage on 1.47 works for USD for me, PaulG
21:36:54 *** meb has quit IRC
21:37:17 <PaulG> yeah, but I need PHP!
21:37:30 <PaulG> USD works for me, too.
21:41:21 <CDB-Away> Eh, didn't run into php issues
21:41:30 <CDB-Away> Are you on Windows or Linux?
21:41:43 *** meb has joined #gnucash
21:44:20 <PaulG> PHP == Philippine peso
21:44:41 <PaulG> I am on NetBSD
21:45:03 <PaulG> close enough to linux that I can "translate"
21:45:04 <CDB-Away> Ah, I was thinking PHP the language... Which wouldn't make sense for a non webpage, hence the confusion
21:45:19 <PaulG> yeah, I realized that after your comment - sorry for the confusion
21:45:36 *** lucky has joined #gnucash
21:45:54 <CDB-Away> In that case, no idea
21:46:56 *** meb has quit IRC
22:00:07 *** bertbob has quit IRC
22:00:27 *** bertbob has joined #gnucash
22:01:24 *** bertbob has quit IRC
22:01:34 *** bertbob has joined #gnucash
22:02:48 *** bebo has joined #gnucash
22:03:27 *** bebo has quit IRC
22:04:33 *** bebo has joined #gnucash
22:04:42 *** bertbob has quit IRC
22:05:17 *** User has quit IRC
22:07:42 *** bebo has quit IRC
22:18:30 *** kael has joined #gnucash
22:23:42 *** bebo has joined #gnucash
22:39:01 *** lucky has quit IRC
22:40:08 *** meb has joined #gnucash
22:48:24 *** kusfedora has joined #gnucash
22:48:32 <kusfedora> how is it going guys?
22:54:51 <PaulG> its going - but thanks to yahoo, not exactly perfectly!
22:55:16 <PaulG> "issues" with p5-Finance-Quote :)
22:56:01 <PaulG> mostly worked around (by setting "Yahoo as JSON" as the quote retrieval mechanism), but still issues with currency stuff.
22:56:39 <PaulG> I have bth USD and PHP (Philippine peso) in my accounts, but currency quote works only for USD, not for PHP
22:57:36 <PaulG> (also, the Yahoo-as-JSON occassionally gets an error for one or two out of 100+ symbols)
22:57:47 <kusfedora> ah...
22:58:17 <PaulG> anyone ever consider an option to retrieve a single quote? It seems that you can manually enter one quote, but no way to _retrieve_ just one!
22:58:27 <kusfedora> I would argue you should slowly (or fast) stop relying on Yahoo
22:58:44 <kusfedora> I don't trust Verizon
22:59:00 <PaulG> got any better options?
22:59:21 <kusfedora> no sadly
22:59:49 <PaulG> I'm not happy with Yahoo either, but don't have a viable alternative.
23:00:02 <CDB-Away> Program drops unfindable quotes
23:00:21 <CDB-Away> Alpha vantage works fine for (North America) equity
23:00:24 <PaulG> Unless there's some supported/standard way to import from a .csv file
23:00:49 <PaulG> (I've got over 100 securities, so not about to manually enter them all the time!)
23:00:51 *** kusfedora has quit IRC
23:01:30 <PaulG> I tried alphavantage but it didn't seem to work. maybe they don't work if your location is non-US.
23:01:43 <PaulG> (I live in the Philippines, even though all my investments are in US)
23:04:05 <PaulG> the Yahoo-as-JSON method is so slow - I swear it looks like it transfers several hundred kb of data for each quote
23:04:27 <PaulG> takes like 3+ minutes to run through all of my securities
23:19:07 *** meb has quit IRC
23:25:49 <CDB-Away> I'm in Canada
23:25:49 <CDB-Away> Alpha vantage is fine
23:25:59 <CDB-Away> Did you create the API key?
23:39:04 <PaulG> what api key?
23:40:03 <PaulG> and I would expect that any geographical restriction would be "north america" rather than US-specific
23:40:30 <PaulG> You'd be surprised how many videos referred to on Yahoo finance are unavailable to me!
23:41:17 <PaulG> anyway, I am ok for now, I guess. I can live with having to manually enter one price for PHP (which would be the inverse of the USD price)
23:44:14 <PaulG> I still don't understand why the retrieved price/quote for USD shows the conversion rate to PHP, yet it cannot calculate the inverse.
23:44:54 *** PaulG has quit IRC
23:47:58 *** meb has joined #gnucash
23:51:02 <CDB-Away> @tell paulg read the gnucash FAQ, you need to create an API key for alpha vantage and edit your GNUcash configuration file with the API key
23:51:02 <gncbot> CDB-Away: The operation succeeded.
23:53:21 *** meb has quit IRC