2021-02-08 GnuCash IRC logs

00:00:05 *** David has quit IRC
00:00:11 *** David has joined #gnucash
00:06:27 *** kd1yv3 has quit IRC
00:06:59 *** angel has quit IRC
00:09:07 *** dtux has joined #gnucash
00:10:26 *** kd1yv3 has joined #gnucash
00:18:40 *** dtux has quit IRC
00:24:30 *** bertbob has joined #gnucash
00:24:31 *** ChanServ sets mode: +v bertbob
01:02:40 *** Mechtilde has joined #gnucash
01:06:02 *** jervin has joined #gnucash
01:17:23 *** marusich has quit IRC
01:17:50 *** fell has quit IRC
01:18:24 *** marusich has joined #gnucash
01:18:24 *** ChanServ sets mode: +v marusich
01:19:09 *** fell has joined #gnucash
01:19:09 *** ChanServ sets mode: +o fell
01:30:35 *** marusich has quit IRC
01:40:48 *** sbluhm has joined #gnucash
01:40:48 *** ChanServ sets mode: +v sbluhm
01:54:03 *** frakturfreak has quit IRC
02:08:13 *** frakturfreak has joined #gnucash
02:08:14 *** ChanServ sets mode: +v frakturfreak
03:29:23 *** Mechtilde has quit IRC
03:29:40 *** Mechtilde has joined #gnucash
03:59:12 *** CDB-PHONE_ has quit IRC
03:59:14 *** CDB-PHONE_ has joined #gnucash
04:10:49 *** Aussie_matt has quit IRC
04:12:46 *** CDB-PHONE_ has quit IRC
04:12:48 *** CDB-PHONE_ has joined #gnucash
04:23:00 *** gjanssens has joined #gnucash
04:23:00 *** ChanServ sets mode: +o gjanssens
04:33:06 *** Guest38 has joined #gnucash
04:36:50 <Guest38> Hi There. How can I show unrealized gains for an asset in foreign currency in "P&L" and "Change in Capital". Example, my base currency is CHF. I have an account of 100k in EUR. FX Rates are set correctly for two dates and it correctly values what it is worth in CHF. But how can I make it show up in P&L?
04:37:54 <Guest38> "Change in Capital" shows correct value at beginning of period and also the correct value at the end of the period, but it is missing something like "Currency Gain/Loss" to show where the difference is coming from.
05:11:04 <Guest38> Screenshot here. Example account of 100k EUR, valued in CHF: https://postimg.cc/0zYGzTdR
05:30:34 *** Aussie_matt has joined #gnucash
05:35:11 *** User_ has joined #gnucash
05:54:19 *** User_ has quit IRC
05:56:07 <chris> Guest38: you're likely to get more responses in the gnucash-user mailing list
06:20:50 <chris> CDB-Man_ I cannot see pricedb difference in my book. Can you analyse your pricedb CAD/USD around 31/12/2020 and determine exactly which date it's picking up the price?
06:55:56 *** sbluhm has quit IRC
07:27:57 *** mikey has joined #gnucash
07:27:57 *** ChanServ sets mode: +v mikey
07:46:29 *** mydogsnameisrudy has joined #gnucash
07:47:37 *** mydogsnameisrudy has quit IRC
07:52:57 *** sbluhm has joined #gnucash
07:52:57 *** ChanServ sets mode: +v sbluhm
08:01:05 *** field^Mop has joined #gnucash
08:04:35 <warlord> chris, I think Guest38 is asking about showing the change in price from start to end.
08:04:52 <warlord> I.e., picking TWO prices.
08:05:14 <warlord> Although for a P&L, I don't think that's correct, because change in value in a holding is neither Income nor Loss.
08:25:10 *** Aussie_matt has quit IRC
08:44:21 <chris> warlord: I stay away from fx and prices. I keep my two books AUD and GBP, all in 1 currency each!
08:46:15 <warlord> I only use USD, but I do have stocks/mutual funds.
08:54:56 <CDB-PHONE_> chris I'll check this evening
09:08:17 *** JayC has quit IRC
09:45:25 <chris> CDB-PHONE_ with pricedb-nearest and pricedb-latest the prices chosen are either exact prices available (ie USD/CAD in pricedb), or it may hop ONE currency
09:46:04 <CDB-PHONE_> okay I'll keep that in mind when checking in 12 hours
09:46:19 <chris> hopping: consider you have several USD/SPY and several USD/CAD, on various dates; it will calculate SPY/CAD from pricedb by considering the *closest* SPY/USD and USD/CAD applicable.
10:02:45 *** mikey has quit IRC
10:02:46 <CDB-PHONE_> closest on a per transaction basis? or closest to 2020-12-31
10:03:11 <CDB-PHONE_> I ran price db on 2020-12-31 so I should have pricing for everything on 31
10:03:39 <CDB-PHONE_> also ran price db on Jan 1
10:03:39 <chris> pricedb entry closest to 31-12-2020
10:03:58 <CDB-PHONE_> 31 was a trading day as well
10:04:40 <chris> ie. try find out which pricedb date generates the 1.2727 and 1.2729 ratios
10:07:14 <chris> both 1.2727 and 1.2729 should be genuine pricedb entries
10:18:23 <CDB-PHONE_> okay
10:34:45 <chris> CDB-PHONE_ I think I know: balsheet-pnl will choose pricedb 2021-01-01 because, reasons
10:35:04 *** field^Mop has quit IRC
10:35:21 <chris> reasons: the list of dates is: 2020-01-01 then 2021-01-01 then 2021-02-08
10:35:42 <chris> the balances are determined on the beginning of these dates
10:36:04 <chris> the headers are written as 'this-date' to 'next-date less 1'
10:36:37 <chris> hence the 2020-01-01 to 2020-12-31 year gets the 2021-01-01 price in error
10:37:30 <CDB-PHONE_> sounds possible
10:37:53 <chris> only a dedicated user with daily prices would encounter this error O_o
10:39:55 <chris> https://pastebin.com/raw/JhUDN1UV
10:45:47 *** jcarl43 has joined #gnucash
10:45:47 *** ChanServ sets mode: +v jcarl43
10:46:25 <chris> gtg
11:03:22 *** guak has joined #gnucash
11:04:26 *** JayC has joined #gnucash
11:04:26 *** ChanServ sets mode: +v JayC
11:09:40 <CDB-PHONE_> chris I make it a point to download all prices on 31st and Jan 1 so that I have super accurate year end cutoff lol
11:27:37 *** ArtGravity has joined #gnucash
11:27:37 *** ChanServ sets mode: +v ArtGravity
11:35:48 *** qwer has joined #gnucash
11:38:35 *** TownsendHardware has joined #gnucash
11:40:04 *** eight-bob has joined #gnucash
11:40:12 *** eight-bob has quit IRC
11:46:57 *** sbluhm has quit IRC
12:04:37 *** sbluhm has joined #gnucash
12:04:37 *** ChanServ sets mode: +v sbluhm
12:06:58 *** mikey has joined #gnucash
12:06:58 *** ChanServ sets mode: +v mikey
12:11:33 *** Pegasus_RPG has joined #gnucash
12:13:18 *** gjanssens has quit IRC
12:15:47 *** field^Mop has joined #gnucash
12:16:37 *** sbluhm has quit IRC
12:20:48 *** gjanssens has joined #gnucash
12:20:48 *** ChanServ sets mode: +o gjanssens
12:33:08 *** AdrienM has quit IRC
12:33:48 *** AdrienM has joined #gnucash
12:33:48 *** ChanServ sets mode: +v AdrienM
12:36:09 *** AdrienM_ has joined #gnucash
12:37:43 *** AdrienM has quit IRC
13:05:47 *** field^Mop has quit IRC
13:13:34 *** mauritslamers has quit IRC
13:14:18 *** mauritslamers has joined #gnucash
13:14:18 *** ChanServ sets mode: +v mauritslamers
13:15:08 *** Guest38 has quit IRC
13:38:37 *** guak1 has joined #gnucash
13:39:02 *** guak has quit IRC
13:39:02 *** guak1 is now known as guak
13:40:25 <jralls> warlord, https://bugs.gnucash.org/show_bug.cgi?id=797951 got a new comment (very polite of him, instead of opening a new bug!) with a spam link.
13:42:05 <warlord> Grr
13:42:21 *** jervin has quit IRC
14:01:15 *** sbluhm has joined #gnucash
14:08:18 *** AdrienM_ has quit IRC
14:16:36 *** tzhuang has joined #gnucash
14:18:20 *** qwer has quit IRC
14:31:20 *** AdrienM has joined #gnucash
14:31:20 *** ChanServ sets mode: +v AdrienM
14:34:57 *** field^Mop has joined #gnucash
14:48:23 *** Mechtilde has quit IRC
14:53:56 *** kd1yv3 has quit IRC
14:55:30 *** jervin has joined #gnucash
14:56:37 *** tzhuang has quit IRC
15:28:16 *** sbluhm has quit IRC
15:37:06 *** Agfarmer18 has joined #gnucash
15:40:18 *** gjanssens has quit IRC
15:46:11 *** flips has joined #gnucash
15:46:12 *** ChanServ sets mode: +v flips
15:59:45 *** gncbot has joined #gnucash
16:00:05 *** Guest42564 is now known as JayC
16:00:07 *** ChanServ sets mode: +v JayC
16:01:02 *** jw4 has quit IRC
16:01:24 *** ericdm has quit IRC
16:01:46 *** ericdm has joined #gnucash
16:02:09 *** jw4 has joined #gnucash
16:02:10 *** ChanServ sets mode: +v jw4
16:05:47 *** Agfarmer18 has quit IRC
16:07:15 *** kestrel has joined #gnucash
16:07:21 *** mikee_ has joined #gnucash
16:07:54 *** mikee has quit IRC
16:08:02 *** sparrohawk has quit IRC
16:10:37 *** mydogsnameisrudy has joined #gnucash
16:11:43 *** mydogsnameisrudy has quit IRC
16:23:18 *** o01eg has quit IRC
16:26:42 *** o01eg has joined #gnucash
16:28:10 *** mydogsnameisrudy has joined #gnucash
16:44:58 *** ErikSchillingAblu[m] has joined #gnucash
16:45:17 *** mydogsnameisrudy has quit IRC
16:48:11 *** peter-butler[m] has joined #gnucash
17:00:27 *** field^Mop has quit IRC
17:14:56 *** cybertani[m] has joined #gnucash
17:20:16 <fell> jralls, its been a week without response from TPs tr team.
17:20:48 <fell> Writing to Benno?
17:21:53 <fell> Or should I at first generate glossary/tr and we can see what the requester will produce?
17:27:25 *** jojo[m] has joined #gnucash
17:48:55 *** Aussie_matt has joined #gnucash
18:03:34 *** jervin has quit IRC
18:22:40 *** PeterScholtens[m] has joined #gnucash
18:33:58 <jralls> fell, If no response for a week go ahead and ask Benno to make tr external.
18:41:01 *** jervin has joined #gnucash
18:45:46 *** jervin has quit IRC
18:53:16 *** Agfarmer18 has joined #gnucash
19:09:34 *** Julianold[m] has joined #gnucash
19:22:43 *** User_ has joined #gnucash
19:27:35 *** luwum[m] has joined #gnucash
19:28:46 *** User_ has quit IRC
19:29:47 *** jcarl43 has quit IRC
19:45:53 *** kestrel has quit IRC
19:46:04 *** sparrohawk has joined #gnucash
19:57:23 *** jervin has joined #gnucash
19:58:52 *** ArtGravity has quit IRC
20:02:16 *** guak has quit IRC
20:08:41 <fell> FYI: The rrecent Weblate alarm is fixed again.
20:18:18 *** grepular has joined #gnucash
20:18:18 *** ChanServ sets mode: +v grepular
21:26:08 *** Agfarmer18 has joined #gnucash
21:41:50 *** Agfarmer18 has quit IRC
21:59:20 *** storyjesse has joined #gnucash
22:26:41 *** jervin has quit IRC
22:36:05 *** jervin has joined #gnucash
23:46:59 *** jervin has joined #gnucash
23:48:46 *** jervin has quit IRC