2018-08-11 GnuCash IRC logs
00:19:23 *** rlosey has quit IRC
00:19:43 *** rlosey has joined #gnucash
00:23:32 <rlosey> ok, thanks
00:42:37 *** talexb has quit IRC
00:42:39 *** elkalamar has joined #gnucash
00:42:52 *** jwheare has joined #gnucash
00:44:55 *** jwheare10 has joined #gnucash
00:46:09 *** jwheare has quit IRC
00:46:09 *** jwheare10 has quit IRC
00:46:09 *** elkalamar has quit IRC
00:47:31 *** Napsterbater has joined #gnucash
00:51:11 *** Napsterbater has quit IRC
00:53:00 *** swordsmanz has joined #gnucash
00:56:09 *** swordsmanz has quit IRC
00:57:40 *** Chew has joined #gnucash
01:00:10 *** Mechtilde has joined #gnucash
01:01:09 *** Chew has quit IRC
01:24:23 *** fell has joined #gnucash
01:24:24 *** gncbot sets mode: +o fell
01:30:43 *** fell_laptop has joined #gnucash
01:32:41 *** fell has quit IRC
01:43:30 *** pilotauto has joined #gnucash
02:08:16 *** fell_laptop has quit IRC
02:16:36 *** gjanssens has joined #gnucash
02:16:36 *** ChanServ sets mode: +o gjanssens
02:41:49 *** pilotauto has quit IRC
03:03:34 *** Church has quit IRC
03:25:53 *** gour has joined #gnucash
03:37:18 *** boldstripe has joined #gnucash
03:49:09 *** jotrago has quit IRC
04:12:29 *** jotrago has joined #gnucash
04:43:23 <Simon> I think I'm hitting some sort of rate limit for alphavantage; at least that's the only thing I can think of because the traffic is HTTPS and gnc-fq-helper has no debug whatsoever
04:44:05 <Simon> EUR GBP is the last currency lookup it makes and that keeps failing every time, but it's ok if I do a single lookup manually
04:44:44 <Simon> I really need GnuCash to stop querying prices for things it already has so that I can get it to successfully obtain prices for everything
04:45:50 <Simon> the problem is I have no idea how to modify the Scheme code to only operate on those commodities that don't already have a price
04:48:50 <Simon> even if I use --namespace=ISO4217, it's still failing
05:04:57 <gjanssens> Yes, it's likely a rate limiting issue.
05:05:37 <gjanssens> From what I've read there's a patch for this ready for Finance:Quote, but it isn't released yet (this is outside of gnucash control)
05:05:38 <Simon> Finance::Quote doesn't appear to have any delays, despite the Alpha Vantage API implying a 1 second delay should be used
05:06:04 <Simon> yes but what is within gnucash's control is to stop querying for things I already have a price for
05:06:16 <gjanssens> What version if Finance::Quote do you have ? I *thought* version 1.47 already had some rate limiting
05:06:26 <Simon> 1.47
05:06:39 <Simon> I have now added a large delay before each query
05:07:36 <Simon> ... and it's still failing to get a result
05:07:45 <gjanssens> "what gnucash already has" is a relative term of course.
05:08:08 <gjanssens> But anyway I'm unfortunately not the person to advise you here as I don't query quotes myself
05:08:14 <gjanssens> So I have no experience to share :(
05:09:35 *** gour_ has joined #gnucash
05:09:39 <Simon> I think I'm hitting some hard limit because it happens to query 2 other stocks with AV immediately before the 3 currencies
05:10:47 *** fabior has joined #gnucash
05:11:52 *** gour has quit IRC
05:14:43 *** storyjesse has quit IRC
05:32:07 *** gour_ is now known as gour
05:41:07 *** Mechtilde has quit IRC
05:44:17 *** chris has quit IRC
06:07:04 *** chris has joined #gnucash
06:08:43 *** chris has quit IRC
06:51:00 *** chris has joined #gnucash
06:58:20 *** Jimraehl1 has joined #gnucash
06:58:56 *** Jimraehl1 has left #gnucash
07:00:48 *** gour has quit IRC
07:03:23 *** oozer has joined #gnucash
07:05:37 *** gour has joined #gnucash
07:08:01 *** Mechtilde has joined #gnucash
07:16:06 *** oozer has quit IRC
07:20:41 *** boldstripe has quit IRC
07:28:11 *** fabior has quit IRC
07:46:34 *** fell_laptop has joined #gnucash
07:55:33 *** jotrago has quit IRC
08:00:13 *** storyjesse has joined #gnucash
08:03:16 *** jotrago has joined #gnucash
08:36:29 *** oozer has joined #gnucash
08:53:30 *** jralls has quit IRC
08:56:02 *** jralls has joined #gnucash
08:56:02 *** ChanServ sets mode: +o jralls
08:59:50 *** harshitaneja has joined #gnucash
09:12:02 *** boldstripe has joined #gnucash
09:12:59 *** finster has joined #gnucash
09:26:45 *** chf has quit IRC
09:27:42 *** chf has joined #gnucash
09:32:24 *** windboy has joined #gnucash
10:16:17 *** User has joined #gnucash
10:40:10 *** storyjesse has quit IRC
10:55:01 *** bahner has joined #gnucash
11:08:53 *** fekepp has quit IRC
11:08:56 *** fekepp has joined #gnucash
11:14:55 * chris getting balsheet fatigue
11:34:39 *** boldstripe has quit IRC
11:35:36 <chris> looks like there's no other option than to calculate LEFT = total(assets) = RIGHT = total(equity) + total(liabilities) + unrealized-gains(i.e. trading accts) + total(income)-total(expenses)
11:53:07 *** User has quit IRC
11:57:34 *** Mechtilde has quit IRC
11:59:17 *** bahner has quit IRC
13:10:15 <jralls> rlosey: https://bugs.gnucash.org/show_bug.cgi?id=796734
13:12:59 <jralls> Simon: Alphavantage did indeed change their query rate limit, down to 1 per 20 seconds. It's fixed in https://github.com/finance-quote/finance-quote but not released.
13:15:42 <jralls> chris: That's the way the current Balance Sheet works. I'm in favor of marking un-booked realized gains (as one might find from trading accounts) separately from truly unrealized gains, the result of a price difference between basis and whatever price the report comes up with for assets not in the report currency.
13:30:16 *** kus has joined #gnucash
13:49:54 *** fiddlerwoaroof has quit IRC
13:53:11 *** fiddlerwoaroof has joined #gnucash
14:06:28 *** chf has quit IRC
14:06:39 <rlosey> jralls - Thank you!
14:06:54 *** chf has joined #gnucash
14:12:31 <rlosey> The workaround in the bug report worked for me, also.
14:12:38 *** rlosey has quit IRC
14:13:15 *** frakturfreak has joined #gnucash
15:07:56 *** finster has left #gnucash
15:08:58 <gjanssens> jralls: fyi I'll be afk until Thursday
15:15:43 *** kus has quit IRC
15:23:38 *** gncbot sets mode: +o fell_laptop
15:36:40 *** fabior has joined #gnucash
15:44:55 <jralls> gjanssens: Since you haven't left yet (I hope!) here's my plan for the altered function signaturess: I'll change them (back) to foo_t64 and put the timespec ones in a new engine-deprecated.[ch] visible only to swig. Calling them from a binding will issue a deprecation warning.
15:45:28 *** fell_laptop is now known as fell
15:45:34 <jralls> gjanssens: The implementation will just wrap foo_t64.
15:49:40 <gjanssens> jralls: ok. So for 3.x the time64 based functions won't change name, do I get that right ?
15:49:50 <jralls> Yes.
15:50:29 <gjanssens> And then for 4.x we rename them to foo without _t64 and mark the _t64 ones deprecated ?
15:51:05 <jralls> I suppose so.
15:51:08 <gjanssens> Ok
15:51:19 <gjanssens> That sounds fine
15:51:54 <jralls> Though I hope for 4.x most of them will be C++ member functions instead of renamed C functions.
15:52:06 <gjanssens> Of course :)
15:53:00 <jralls> Separate subject: It seems you're pretty busy this month. Do you think you'll have time to dig in to the input method mess?
15:54:47 <gjanssens> I still intend to yes
15:56:27 <gjanssens> Today I first worked on the CVE bug.
15:56:43 <jralls> The stupid one about putting files in /tmp?
15:56:54 <gjanssens> My idea was to drop strfmon completely and redo the little bit we use of it in C++
15:56:59 <gjanssens> No the strfmon one
15:57:27 <gjanssens> https://bugs.gnucash.org/show_bug.cgi?id=796777
15:57:58 <gjanssens> I have it mostly working, but I'm running into an encoding issue again :(
15:58:24 <jralls> Ah. Yes, it's unlikely that strfmon is going to do the right thing in GnuCash.
16:00:09 <gjanssens> Well, I haven't dug through the full code. I have only sought to replace the strfmon call at this point
16:00:16 <gjanssens> A full rewrite is for later.
16:00:30 <gjanssens> If you're curious https://github.com/gjanssens/gnucash/tree/CVE-2008-1391 is what I have so far
16:00:53 *** fabior has quit IRC
16:01:43 <jralls> What's the encoding problem? It's in the loan assistant. I'd think you could just drop in the same monetary display code we use everywhere else.
16:01:51 <gjanssens> It fails with LC_MONETARY set to ru_RU, but works fine for en_US and nl_BE
16:02:18 <gjanssens> It looks like the Russian thousands separator is not utf8.
16:02:26 <gjanssens> I'll have to study it some more later.
16:03:14 <jralls> Gah! Don't use gfloats, they have only 6 digits of accuracy. That's *all* digits, not just the fractional part.
16:04:11 *** harshitaneja has quit IRC
16:04:30 <gjanssens> I worked with what was there... But I can go for gdouble as well though that may make the change more invasive
16:04:54 *** harshitaneja has joined #gnucash
16:05:58 <jralls> Best would be to use GncNumeric or GncRational, though I guess for interest calculations we'd need exponent functions.
16:06:23 <gjanssens> Yep, and that's 4.x land at best.
16:06:28 <jralls> Or maybe operator**() like in FORTRAN. ;)
16:07:20 <gjanssens> As I said this is meant as a fix for the CVE and I wanted to get rid of some borrowed code in the process if possible.
16:07:24 <jralls> Not necessarily (/me pulls out Knuth V2...)
16:08:22 <jralls> OK. So how are you getting the ru_RU thousands separator? From the C++ locale facet?
16:09:14 <gjanssens> Indirectly yes. put_money uses that local facet.
16:10:02 <gjanssens> locale* facet
16:10:39 <jralls> Did you set the locale to ru_RU.UTF-8? The default might be some ISO-8859-5.
16:11:59 <gjanssens> Ah, it works if I set LC_ALL=ru_RU.utf-8, but it fails if I only set LC_MONETARY
16:12:35 <gjanssens> That's progress.
16:12:55 <gjanssens> The rest is for later. I have to continue packing my suitcase...
16:13:10 <jralls> OK. Where are you off to this time?
16:13:15 <gjanssens> Venice
16:13:39 <gjanssens> TTYL :)
16:14:11 *** gjanssens has quit IRC
16:22:27 *** fell has quit IRC
16:24:47 <Simon> "Note that AlphaVantage now says they only allow 5 requests per minute unless you pay for a Premium API key" :|
16:27:41 *** fell has joined #gnucash
16:28:30 *** gncbot sets mode: +o fell
16:30:59 <warlord> .
16:39:25 *** schneid3306 has joined #gnucash
16:41:42 <schneid3306> Is there a way to have reports display the date that they were run? I have been looking and cannot seem to find it. Thank you.
16:42:30 <fell> That might depend on the report.
16:43:25 *** gjanssens has joined #gnucash
16:43:25 *** ChanServ sets mode: +o gjanssens
16:45:44 <schneid3306> Okay. I was looking at the Reconciliation Report. It has the dates for to/from, but no "Aug 11 2018" in the corner for example. I don't see it in the settings. If one of the reports has that option, I may just create a custom report with the sub reports I need and then put it at the "top" of each page.
16:55:22 <fell> If I run it line 2 reads "From 01/01/17 to 08/11/18"
16:56:12 *** gjanssens has quit IRC
16:58:33 <fell> You could copy it in excel or another calc sheet and mark the line as part of the repeated page header
16:58:53 <schneid3306> Yeah. I just need to have the date that it ran. I think that is what I will do. Thanks!
16:59:38 <fell> welcome!
17:20:55 *** boldstripe has joined #gnucash
17:32:17 *** fell has quit IRC
17:36:04 *** fell has joined #gnucash
17:36:05 *** gncbot sets mode: +o fell
17:46:53 *** fell has quit IRC
17:58:19 *** fell has joined #gnucash
17:58:21 *** gncbot sets mode: +o fell
17:59:56 *** sixwheeledbeast has quit IRC
18:00:54 *** sixwheeledbeast has joined #gnucash
18:22:45 *** boldstripe has quit IRC
18:23:11 *** boldstripe has joined #gnucash
18:39:15 *** boldstripe has quit IRC
19:59:33 *** fiddlerwoaroof has quit IRC
20:04:25 *** fiddlerwoaroof has joined #gnucash
20:09:22 *** User has joined #gnucash
20:12:29 *** User has quit IRC
20:22:15 <chris> jralls - if we're replicating current balance-sheet behaviour.... it currently takes income and expense accounts from the accounts selection - this means, if the income/expense accounts are unselected, the balancesheet won't balance
20:22:25 <chris> is it desirable to replicate this?
20:22:48 <chris> imho the 'correct' way would be to disallow accounts-selection and just report on every account
20:23:14 *** gour has quit IRC
20:23:55 <chris> i.e. removing income+expense or trading accounts from balance-sheet accounts selector means the 'Retained Earnings' line disappears, leading to unbalanced balance-sheet
21:14:18 *** frakturfreak has quit IRC
21:15:44 *** frakturfreak has joined #gnucash
21:53:01 <fell> chris: income & expense are usually not part of the balance.
21:54:16 <fell> balance is state at a point of time, income & expense success over a time range.
21:57:04 <fell> There is "only" the problem of inbalance, if the wrong price methode is choosen.
22:00:46 <fell> I could imagine a situation, where a user wants to break down the balance for one branch of his business. But then I do not see how to assign the passiva to the assets..
22:01:18 *** oozer has quit IRC
22:01:48 <fell> So it might be a question for the mailing list: Are there use cases for account selection.