2017-11-14 GnuCash IRC logs
00:31:08 *** meb has joined #gnucash
00:38:52 *** bebo has quit IRC
00:42:09 *** kael has quit IRC
00:49:29 *** bertbob has joined #gnucash
00:51:15 *** Mechtilde has joined #gnucash
01:18:25 *** fell has quit IRC
01:19:31 *** fell has joined #gnucash
01:25:04 *** Mechtilde has quit IRC
01:33:31 *** Mechtilde has joined #gnucash
01:44:09 *** gjanssens has joined #gnucash
01:44:09 *** ChanServ sets mode: +o gjanssens
01:53:43 <gjanssens> .
01:56:38 *** Mechtilde has quit IRC
02:18:14 *** jotrago has quit IRC
02:38:07 *** fekepp has quit IRC
03:15:39 *** fabior has joined #gnucash
04:09:12 *** pilotauto has quit IRC
04:18:20 *** fabior has quit IRC
04:25:09 *** noah has joined #gnucash
05:03:58 *** noah has quit IRC
05:12:10 *** fabior has joined #gnucash
05:20:50 *** storyjesse has joined #gnucash
05:23:47 *** fabior has quit IRC
05:53:34 *** bertbob has quit IRC
06:14:59 *** PaulG has joined #gnucash
06:18:02 <PaulG> OK, I got my free Alpha Vantage "API key" now what do I do with it? Where do I enter it for p5-Finance-Quote towork? :)
06:18:02 <gncbot> PaulG: Sent 6 hours and 27 minutes ago: <CDB-Away> read the gnucash FAQ, you need to create an API key for alpha vantage and edit your GNUcash configuration file with the API key
06:18:26 <PaulG> oh, thanks, gncbot!
06:24:15 *** bertbob has joined #gnucash
06:34:01 *** PaulG has quit IRC
06:34:25 *** PaulG has joined #gnucash
06:35:44 <PaulG> HOWEVER, I'm really not fond of editting a system-wide file for this. Couldn't you have put this in a per-user file, such as ~/.gnucash/xxx ?
06:36:49 *** fabior has joined #gnucash
06:36:52 <PaulG> Or else check the "real unix environment" to see if it is defined there... (I did try to "export ALPHAVANTAGE_API_KEY=xxxx" before starting gnucash, but it did not seem to find the key)
06:41:08 *** fabior has quit IRC
06:49:04 *** Jimraehl1 has joined #gnucash
07:02:03 *** PaulG has quit IRC
07:17:03 *** Jimraehl1 has left #gnucash
08:40:05 <chris> lmat: as I'm slowly working through deprecating timepair, I think I'll have to fix inconsistently-named and applied functions. This will obvioously take time. Perhaps I'll let you know from time to time any hiccups/missing C++ functions. :-O
08:55:28 <chris> I think I'll have to learn emacs :-(
09:00:44 <warlord> chris: emacs is the way of the word.
09:38:04 *** storyjesse has quit IRC
09:38:28 *** Mechtilde has joined #gnucash
10:06:12 <lmat> chris: for the record, vim is better ;-)
10:06:23 <lmat> chris: Yeah, let me know what kind of c support you need to get the job done.
10:18:21 *** User has joined #gnucash
10:19:57 *** kael has joined #gnucash
10:20:59 *** kael has quit IRC
10:22:33 *** mikee_ has joined #gnucash
10:23:52 *** mikee has quit IRC
10:26:14 *** User has quit IRC
10:30:32 *** fabior has joined #gnucash
10:34:36 *** Mechtilde has quit IRC
10:39:02 *** chris has quit IRC
10:58:04 *** kael has joined #gnucash
11:33:43 *** jchonig has quit IRC
11:37:22 *** jchonig has joined #gnucash
11:50:04 *** fabior has quit IRC
12:00:37 *** fekepp has joined #gnucash
12:01:47 *** ArtGravity has joined #gnucash
12:15:40 *** Mechtilde has joined #gnucash
13:54:54 *** fabior has joined #gnucash
13:57:25 *** fekepp has quit IRC
13:57:33 *** fekepp has joined #gnucash
14:00:01 <jralls> gjanssens: I'm re-evaluating my "fix" last June for timespec 0 that's causing so much trouble for MySQL users. Slots will provide nullptrs so it's easy to special-case them to store a NULL and to adjust the handling of MySQL's special 0000-00-00-00:00:00 value accordingly.
14:00:40 *** fekepp has quit IRC
14:02:56 <jralls> gjanssens: Transaction and Split on the other hand have Timespec member variables that aren't nullable and set that to a default value of {0, 0} to mean "no value". IIRC we decided to use either MAXINT64 or MININT64 for the "no value" proxy in the csv-importer, but that was for 2.8.
14:03:21 *** fekepp has joined #gnucash
14:03:57 <jralls> gjanssens: Do you think it would be too invasive to use the same convention in Transaction and split in maint?
14:05:43 *** frakturfreak has joined #gnucash
14:11:27 *** leomuniz has joined #gnucash
14:13:31 <leomuniz> Hi folks! I'm with a problem in Gnucash. The dates showed in the software is drecreased one day from OFX File, Ex: OFX date: 14/11 Gnucash: 13/11... Does anyone had this problem? Thanks
14:15:48 *** fabior has quit IRC
14:18:28 *** chf has quit IRC
14:21:21 *** chf has joined #gnucash
14:39:25 <jralls> leomuniz: Are the dates in the OFX file timestamped at midnight?
14:52:18 *** fabior has joined #gnucash
15:22:03 *** User has joined #gnucash
15:25:51 *** meb has quit IRC
15:28:44 *** fekepp has quit IRC
15:29:59 *** meb has joined #gnucash
15:30:13 *** fekepp has joined #gnucash
15:30:54 *** User has quit IRC
15:32:28 <leomuniz> No, <DTPOSTED>20171023000000[-03:EST]
15:32:30 *** bunk3m has joined #gnucash
15:32:55 *** meb has quit IRC
15:35:01 *** meb has joined #gnucash
15:38:11 *** carwynnelson has joined #gnucash
15:46:03 *** fabior has quit IRC
16:01:24 *** Mechtilde has quit IRC
16:08:26 <jralls> leomuniz: What timezone are you in?
16:09:04 <jralls> leomuniz: And that timestamp is indeed midnight on 23 October.
16:12:03 <leomuniz> -4,
16:12:13 *** meb has quit IRC
16:12:31 <leomuniz> <DTPOSTED>20171016000000[-03:EST] <TRNAMT>-83.61 <FITID>N101CE:16/10/17:-83.61:0118314: Visa Electron: Alpha Construcoes
16:13:08 <leomuniz> UTC -4 Georgetown, Manaus
16:13:25 <jralls> As in Manaus, Brazil?
16:13:33 <leomuniz> Yes
16:13:48 <jralls> And the bank is in the US or in Brazil?
16:14:00 <leomuniz> Brazillian Real (R$)
16:14:17 <jralls> No, not currency, the bank's computer.
16:14:40 <leomuniz> Brazil SP(-3 UTC)
16:15:39 <leomuniz> All my dates are offset one day earlier...
16:15:41 <jralls> OK. So no DST change. The issue is that they post at midnight on the next day, but it's not yet the next day where you are.
16:16:20 <leomuniz> Yes.. I'm one hour earlier than my bank..
16:17:45 <jralls> IOW, 20171016000000 at your bank is 20171015230000 for you, so that's the date that GnuCash uses. Then to make it consistent for almost all timezones it changes the time to 10:59 UTC.
16:18:27 <jralls> But the importer changes the time to your local before that can happen.
16:19:38 <leomuniz> I see.. Is there any way fix it? Edit the OFX file and try change anything?
16:21:00 <jralls> You could pre-process the OFX file to change -3 EST to -4 CST.
16:21:25 <jralls> If you're on Linux or Mac "sed" will work for that.
16:21:48 <leomuniz> Ok.. I'll try change it before import process...
16:24:46 <leomuniz> If I change the timezone in clock also solves the problem???
16:26:54 <jralls> You mean the computer's TZ setting? Yes.
16:27:19 <leomuniz> I got.. I'll try do it before import... Thanks so much for the helping!
16:28:07 <jralls> You're welcome.
16:30:10 *** leomuniz has quit IRC
16:30:45 *** Hirppa has quit IRC
16:31:26 *** Hirppa has joined #gnucash
16:35:38 *** pilotauto has joined #gnucash
16:36:51 *** PaulG has joined #gnucash
16:38:09 *** fekepp has quit IRC
16:38:11 *** fekepp has joined #gnucash
16:40:12 *** gjanssens has quit IRC
16:43:08 *** frakturfreak has quit IRC
17:00:29 *** kael has quit IRC
17:01:06 *** kael has joined #gnucash
17:41:42 *** MrKeuner has quit IRC
17:45:48 *** bunk3m has quit IRC
17:48:27 *** fekepp has quit IRC
17:49:04 *** fekepp has joined #gnucash
17:57:46 *** fekepp has quit IRC
17:57:48 *** fekepp has joined #gnucash
18:09:38 *** chris has joined #gnucash
18:09:44 <chris> .
18:16:23 *** ArtGravity has quit IRC
18:31:28 *** mortisha has joined #gnucash
18:33:23 *** mortisha has quit IRC
18:41:23 <CDB-Away> hmm, my trial balance does not balance, and I have the feeling it's due to FX and stock prices
18:41:34 <CDB-Away> and not being handled correctly
18:41:49 <chris> lmat: there's no exact equivalent for gnc_print_date is there? there's gnc_ctime with an additional the format specifier, and the time is now clamped?
18:42:36 <chris> CDB-Away: the short answer is to enable Trading Accounts, and run Check & Repair All.
18:42:41 <CDB-Away> TB reflectss 22k unrealized gain, BS reflects 17k trading gains
18:42:51 <CDB-Away> that should already be done, but will check again
18:43:03 <chris> CDB-Away: https://wiki.gnucash.org/wiki/Trading_Accounts
18:43:13 <CDB-Away> wait, what do you mean by "enable"?
18:43:20 <CDB-Away> I have about 40 of them already, for all of my equities
18:43:38 <CDB-Away> TB includes all trading accounts in its report
18:43:46 *** osboxes has joined #gnucash
18:44:47 <chris> CDB-Away: read the whole of http://www.mscs.dal.ca/~selinger/accounting/tutorial.html - it'll explain
18:46:16 <CDB-Away> no, I'm already accounting for my derivitives using the equity method -- im aware of the GNUcash trading account types as the corresponding credits to create "stock" type "currency" in the ledger
18:46:46 <CDB-Away> they're setup as securities already, linked to all the trading and currency fiction accounts
18:47:34 <CDB-Away> https://bugzilla.gnome.org/show_bug.cgi?id=776517
18:47:46 <CDB-Away> originally, i thought the issue was due to this bug reported
18:47:59 <CDB-Away> which, that particular bug isnt present anymore, but the numbers don't balance
18:49:42 <CDB-Away> it's due to the handling of the TB report for currencies, likely due to the fact I have 3 currencies across 4 equities
18:49:48 <CDB-Away> the balance sheet handles them fine
18:52:50 <chris> this is beyond me then
18:53:01 <chris> lmat: found qof-print-date... what an oddly named func
18:53:48 <CDB-Away> I was skeptical but hopeful :)
19:07:37 *** fekepp has quit IRC
19:10:08 *** carwynnelson has quit IRC
19:10:28 *** carwynnelson has joined #gnucash
19:13:34 *** carwynnelson has quit IRC
19:13:34 *** carwynne_ has joined #gnucash
19:23:03 *** carwynne_ has quit IRC
19:23:24 *** carwynnelson has joined #gnucash
19:26:36 *** carwynnelson has quit IRC
19:29:14 *** kael has quit IRC
20:27:32 *** bertbob has quit IRC
20:30:40 *** bertbob has joined #gnucash
20:46:50 *** storyjesse has joined #gnucash
22:15:14 *** puck has quit IRC
22:20:16 *** puck has joined #gnucash
23:41:44 *** jotrago has joined #gnucash