2020-06-09 GnuCash IRC logs
00:18:39 *** fell_laptop has joined #gnucash
00:18:40 *** ChanServ sets mode: +o fell_laptop
00:18:47 *** fell has quit IRC
00:19:29 *** jervin1 has joined #gnucash
00:19:56 *** jervin has quit IRC
00:19:56 *** jervin1 is now known as jervin
00:26:17 *** fell_laptop is now known as fell
00:27:44 *** jervin has quit IRC
00:28:31 <fell> @tell gjanssens jralls, we did not uplöad a flatpak 3.904 release?
00:28:31 <gncbot> fell: The operation succeeded.
00:44:06 *** Mechtilde has joined #gnucash
00:47:08 *** Mechtilde has quit IRC
00:48:53 *** Mechtilde has joined #gnucash
00:55:49 *** dtux has quit IRC
01:01:27 *** sbluhm has joined #gnucash
01:01:27 *** ChanServ sets mode: +v sbluhm
01:08:59 *** fell_laptop has joined #gnucash
01:09:00 *** ChanServ sets mode: +o fell_laptop
01:11:09 *** fell has quit IRC
01:12:49 *** fell_laptop is now known as fell
01:42:50 *** jervin has joined #gnucash
01:45:23 *** jervin1 has joined #gnucash
01:45:50 *** jervin has quit IRC
01:45:52 *** jervin1 is now known as jervin
01:48:58 *** jervin has quit IRC
01:49:00 *** jervin has joined #gnucash
01:52:57 *** jervin1 has joined #gnucash
01:52:58 *** jervin has quit IRC
01:52:58 *** jervin1 is now known as jervin
01:54:42 *** jervin1 has joined #gnucash
01:55:58 *** jervin has quit IRC
01:56:04 *** bertbob has quit IRC
01:57:16 *** jervin has joined #gnucash
01:57:24 *** bertbob has joined #gnucash
01:57:24 *** ChanServ sets mode: +v bertbob
01:57:42 *** jervin1 has quit IRC
02:00:39 *** jervin has quit IRC
02:00:52 *** jervin has joined #gnucash
02:03:09 *** jralls has quit IRC
02:04:01 *** jralls has joined #gnucash
02:04:01 *** ChanServ sets mode: +o jralls
02:04:38 *** jervin has quit IRC
02:04:44 *** jervin has joined #gnucash
02:06:35 *** jervin has quit IRC
02:06:38 *** jervin has joined #gnucash
02:10:59 *** jervin1 has joined #gnucash
02:10:59 *** jervin has quit IRC
02:10:59 *** jervin1 is now known as jervin
02:11:55 *** dtux has joined #gnucash
02:12:31 *** jervin has quit IRC
02:12:34 *** jervin has joined #gnucash
02:13:45 *** sbluhm has quit IRC
02:15:48 *** sbluhm has joined #gnucash
02:15:48 *** ChanServ sets mode: +v sbluhm
02:19:37 *** jervin has quit IRC
02:25:35 *** Mechtilde has quit IRC
02:56:23 *** omnireq_ has joined #gnucash
02:57:37 *** omnireq has quit IRC
03:31:38 *** gjanssens has joined #gnucash
03:31:38 *** ChanServ sets mode: +o gjanssens
03:40:34 *** Hamaryns has joined #gnucash
03:40:34 *** ChanServ sets mode: +v Hamaryns
03:43:55 <gjanssens> .
03:43:55 <gncbot> gjanssens: Sent 3 hours and 15 minutes ago: <fell> jralls, we did not uplöad a flatpak 3.904 release?
03:44:48 *** Mechtilde has joined #gnucash
04:04:34 *** Hamaryns has quit IRC
04:06:12 *** Hamaryns has joined #gnucash
04:06:12 *** ChanServ sets mode: +v Hamaryns
04:33:23 *** keiffer has quit IRC
04:44:02 *** dtux has quit IRC
04:56:26 *** Aussie_matt has quit IRC
05:26:00 *** Hamaryns has quit IRC
05:41:27 *** Hamaryns has joined #gnucash
05:41:27 *** ChanServ sets mode: +v Hamaryns
06:37:04 *** Jimraehl1 has joined #gnucash
06:38:06 *** Jimraehl1 has quit IRC
06:44:42 *** keiffer has joined #gnucash
06:44:43 *** PowaBanga has quit IRC
06:44:56 *** keiffer has quit IRC
06:45:35 *** keiffer has joined #gnucash
06:45:53 *** David has quit IRC
06:45:57 *** David has joined #gnucash
06:53:56 *** User_ has joined #gnucash
07:05:22 *** Hamaryns has quit IRC
07:28:12 *** lmat has quit IRC
07:31:16 *** shaggy has quit IRC
07:32:33 *** shaggy has joined #gnucash
08:22:05 *** lmat has joined #gnucash
09:07:31 *** storyjesse has joined #gnucash
09:23:42 *** sbluhm has quit IRC
09:54:28 *** jervin has joined #gnucash
10:06:45 *** mohave has joined #gnucash
10:07:57 <mohave> .
10:07:57 <gncbot> mohave: Sent 17 hours and 52 minutes ago: <jralls> chris I've worked out a better way to fix the dependency flow in reports and pushed the changes.
10:08:24 <mohave> jralls: your fix worked well, thanks!
10:24:58 *** omnireq_ has quit IRC
10:40:45 <gjanssens> @notes gjanssens,
10:40:45 <gncbot> gjanssens: Sent 6 weeks, 1 day, 8 hours, and 59 minutes ago: <jralls> in gnucash/report/reports/CMakeLists.txt there are 3 targets used as dependencies that don't seem to be created anywhere: scm-reports-common-links, scm-reports-standard-links, and scm-reports-example-links. I'd expect cmake to crash out if they didn't exist, so where do they come from?
10:40:59 <gjanssens> jralls: I presume by now you have figured this out yourself ?
10:42:25 <gjanssens> If not, the *-links targets are optionally created if the MAKE_LINKS flag is set to the gnc_add_scheme_targets command.
10:43:17 <gjanssens> If the command normally creates target scm-reports-common it would additionally create target scm-reports-common-links if MAKE_LINKS is set.
10:44:29 *** zontag has joined #gnucash
10:44:48 <zontag> Hi all
10:45:43 <zontag> gnucash do not get price stocks
10:46:50 <zontag> Is this an old problem that is ok in some version or it is still an open bug to fix?
10:58:20 <Simon> there may be failures in Finance::Quote that you'd need to debug
10:59:18 <Simon> I use a python script to get quotes: https://github.com/nomis/gnucash-prices/
11:03:25 *** Mechtilde has quit IRC
11:07:53 *** ArtGravity has joined #gnucash
11:07:53 *** ChanServ sets mode: +v ArtGravity
11:15:53 *** angel has joined #gnucash
11:28:42 *** bertbob has quit IRC
11:29:46 *** bertbob has joined #gnucash
11:29:46 *** ChanServ sets mode: +v bertbob
11:30:50 *** omnireq has joined #gnucash
11:30:50 *** ChanServ sets mode: +v omnireq
11:32:44 <chris> jralls: the reports whose guid had been changed were: balance-sheet, income-statment, payable/receivable, customer/vendor/employee/job. the first two are now restored.
11:34:21 *** PowaBanga has joined #gnucash
11:38:25 *** mohave has quit IRC
11:40:25 *** guak has joined #gnucash
11:40:31 <chris> CDB-Man_ if you're using bleeding-edge master (as opposed to daily builds), and disable book trading accounts, the experimental balsheet UG calculator *may* need a further change: https://pastebin.com/raw/kErHp9th
11:47:44 *** mohave has joined #gnucash
11:51:07 *** dtux has joined #gnucash
11:54:55 <zontag> Thank you Simon for your help
11:55:00 *** sbluhm has joined #gnucash
11:57:56 <chris> ^CDB-man_ actually I think no need... but for correctness I think I will include this change. will explain in commit msg.
12:00:07 *** CDB-Work has joined #gnucash
12:00:07 *** ChanServ sets mode: +v CDB-Work
12:01:49 <CDB-Man_> [11:40:31] <+9d54b3chris> CDB-Man_ if you're using bleeding-edge master (as opposed to daily builds), and disable book trading accounts, the experimental balsheet UG calculator *may* need a further change: https://pastebin.com/raw/kErHp9th
12:02:09 <CDB-Work> I typically re-download the bleeding edge master from code every few days, yeah
12:02:24 *** angel has quit IRC
12:04:12 <CDB-Work> if my bleeding edge chris i assume you mean https://code.gnucash.org/builds/win32/master/
12:08:07 *** angel has joined #gnucash
12:14:22 <chris> bleeding edge means github master. https://code.gnucash.org/builds/win32/master/ is only updated every 24h at most :) anyway ignore my last comment about UG calculator, ths pastebin has no effect
12:14:30 *** sbluhm has quit IRC
12:21:49 *** Mechtilde has joined #gnucash
12:23:13 *** flips has quit IRC
12:27:38 <CDB-Work> yeah, i dont have the ability to build off github, so im happy to wait for the nightlies
12:28:59 *** flips has joined #gnucash
12:29:01 *** ChanServ sets mode: +v flips
12:35:24 *** angel has quit IRC
12:36:28 *** zontag1 has joined #gnucash
12:37:08 *** storyjesse has quit IRC
12:37:09 <jralls> CDB-Work: I wonder if the average-cost computation is treating those USD stock purchases as CAD.
12:38:26 *** zontag1 has quit IRC
12:39:03 <CDB-Man_> [22:11:36] <+CDB-Man_> jralls: here is the transacton data: blob:https://imgur.com/343877ee-2a4b-4070-b028-23994334c81c - the TB and account summary were run with average cost, and therefore the numbers line up to transaction date of course
12:39:12 <CDB-Work> grr, I copied the wrong link...
12:39:38 <jralls> I saw your messages from last night. No need to repeat them.
12:40:03 <CDB-Work> I know, but in trying to re-read what i sent, i realize that screenshot fails to materialize
12:40:24 <CDB-Work> so on to pulling one that will shine some light to the question you just posed
12:43:01 <CDB-Man_> here is a valid link with the transcational data: https://i.imgur.com/iT0Sv8j.png
12:43:51 <CDB-Work> particular, it shows the # units/shares and the price assigned
12:44:06 <CDB-Work> which was the objective of the screenshot
12:51:12 <CDB-Work> in* particular
12:51:17 <jralls> So in the account report you posted last night the 23 MSFT is valued at C$1011.71, but using the CAD->USD price from 2014-06-02 it would be 1030.65.
12:52:13 <CDB-Man_> CDB-Work: https://i.imgur.com/CGu6VFY.png
12:53:35 <jralls> Yes, that one. And the 5 SPY would be C$213.49, but there's 10 on the account summary valued at C$0.
12:53:53 <CDB-Work> $1,030.65 I understond how you got that: 934.32 / 0.9065 --- not sure how you got the $1,011.71 figure
12:55:07 <CDB-Work> hmm, the 10 at $0, let's see if I can get the details on that
12:56:49 <jralls> I read it off of the report. The Trading:NYSE:SPY split prices the 5 SPY at $US 193.54 but the TFSA:RBC...:USD:SPY prices it at $US 191.55.
12:57:23 <CDB-Work> hmm, I wonder if that's the capitalizing of commissions
12:58:12 <CDB-Man_> https://i.imgur.com/WHuxGnW.png SPY trading account trasaction
12:59:29 <CDB-Work> in register form shortly:
12:59:36 <jralls> There doesn't seem to be a separate commissions split. Also it looks like there's a CAD->USD transfer at 1.0000 instead of 1.103 in the transfer transaction.
13:00:06 <CDB-Man_> https://i.imgur.com/6atbMEi.png
13:00:08 <CDB-Man_> here's the commssion
13:01:20 <CDB-Man_> ... that screenshot chopped off a line
13:01:52 <CDB-Man_> https://i.imgur.com/Zwj6hVa.png
13:03:28 <CDB-Work> > there's a CAD->USD transfer at 1.0000 instead of 1.103 <-- if you mean the 2nd transaction of $4,255.34, that's from a CAD account to anotehr CAD account
13:04:13 <CDB-Work> note the account names "!Cash CAD" and "!CAD Cash"
13:05:17 <jralls> No, I'm on the SPY txn. But comparing it to the register screen shot I think that's just the cr Cash USD line.
13:06:23 <CDB-Work> I'm just quite glad that back in 2014, I had very little activity, else this exercise would have been much more painful
13:06:57 <CDB-Work> I started my GL in May 2015, but I retroactively entered ALL of my brokerage transactions from 2008 onwards, to have accurate cost basis info for everything
13:07:00 <jralls> But the 10 SPY at 0 on the account summary is surely a problem.
13:07:48 <CDB-Work> hmm
13:08:52 <CDB-Man_> https://i.imgur.com/M4waAZa.png
13:09:11 <CDB-Man_> the 10 units is explained by 2 purchases in 2 separate accounts, though that doesnt explain the $0 valuation
13:09:31 <CDB-Man_> and curiously, there was no out of balance on the date of the 1st
13:10:15 <CDB-Man_> > and curiously, there was no out of balance on the date of the 1st <-- I should re-run the TB on this date first to validate this claim... 1 sec
13:10:20 <jralls> What register is that? Trading:NYSE:SPY?
13:10:53 <CDB-Man_> Trading:NYSE:SPY -- correct
13:11:45 <CDB-Man_> yep, TB dates 2014-01-16 balances
13:14:04 <jralls> Does it value the SPY at US$908?
13:15:15 <CDB-Man_> > 5 SPY $ 1,004.36 (CAD presumably)
13:15:56 <CDB-Man_> per TB 2014-01-16
13:16:02 *** sbluhm has joined #gnucash
13:17:06 <jralls> What does the 06-01 TB value the SPY at?
13:18:47 <CDB-Man_> on 06-01: 5 SPY $ 1,006.00 TB, 5 SPY $ 1,006.00 account summary asset, (5) SPY $ (1,006.00) account summary TRADING
13:19:21 <CDB-Man_> note: the purchase on 01-16 was in a commission free account
13:19:30 <CDB-Man_> the one on 06-02 is in a commissions payable account
13:19:38 <CDB-Man_> which has that extra split with 0 units and price
13:19:44 <CDB-Man_> as seen in the gegister screenshot
13:19:50 <CDB-Man_> could that be how the 0 was introduced?
13:20:13 <CDB-Man_> I am checking to see if the other pourchase on 06-1, in MSFT, was with or without commission
13:22:06 <jralls> It *shouldn't* matter, it has 0 shares too so it should be ignored. Unfortunately "should" doesn't mean "is". :-(
13:24:00 <CDB-Man_> Confirmed the MSFT trade was commissioned, and had the 0 unit split
13:28:15 *** User_ has quit IRC
13:29:06 <CDB-Work> this $0 valuation on SPY at 06-02, when it was doing fine at 06-01, is really quite puzzling
13:29:18 <CDB-Work> if you have some ideas on how to kick tires on this, I'm happy to test
13:29:26 <jralls> Right, and that's reflected in the prices of the MSFT asset and trading splits on the transaction repoort.
13:31:27 *** User has joined #gnucash
13:32:12 <jralls> Does the SPY asset account register look reasonable?
13:34:06 <jralls> I just noticed something else: The total on the transaction report for CashUSD reflects only the MSFT buy.
13:35:48 <CDB-Man_> https://i.imgur.com/Csl1rCM.png SPY stock account 01-16, https://i.imgur.com/3xYv5SG.png SPY stock 06-02, https://i.imgur.com/lmVP7Oj.png MSFT 06-02
13:36:09 <jralls> Ah, that's because you transferred in the US$967 to cover the purchase of the SPY.
13:37:10 <CDB-Man_> from those screenshots, all 4 asset accounts look kosher
13:37:14 <CDB-Man_> all 3*
13:39:30 <jralls> Thou shalt count unto 3...
13:44:39 <jralls> What happens to the 06-02 TB if you change the date on the C$1067.47->US$967.70 transaction to 06-01?
13:48:24 <CDB-Man_> Will try in a minute
13:49:29 <CDB-Man_> Curious though why you want to try changing that cash transaction, rather than something like re-enter the SPY purchase
13:51:03 <jralls> Because I wonder if there's something about the net 0 effect of the 967 in the trading account on that day.
13:51:47 <CDB-Man_> Very interesting theory, will do when back at laptop (currently on cell phone bouncer)
13:56:59 *** zontag has quit IRC
13:59:21 <CDB-Man_> jralls: no effect, SPY still $0 in both assets and TRADING
14:01:30 <jralls> OK. Does it show a value on the legacy balance sheet with average-cost as the price source?
14:02:54 <CDB-Man_> hmm, legacy B/S shows asset SPY 10 shs $0, trading loss the $2 (since it accumulates that 0 on the TRADING accounts too)
14:03:04 <CDB-Man_> run on date 2014-06-02
14:03:33 <CDB-Man_> i get the feeling even with a TB report dated today, that perhaps this 1 transaction is the only one that is giving me grief
14:04:30 <CDB-Man_> yep, I ran an account summary report on TRADING balances with average cost dated today, and that SPY account is still valued $0
14:05:24 <CDB-Man_> coincidentally... also with 10 shares in it as of today, despite several intervening transactions between 2014 and 2020
14:06:11 <CDB-Man_> unless you have other things you want to try first... the eventual next test is to re-key this 2014-06-02 transacton and delete the old one
14:06:23 <CDB-Man_> in case that transaction is somehow corrupt... despite the register looking 100% kosher
14:07:49 <CDB-Work> CDB-Man> yep, I ran an account summary report on TRADING balances with average cost dated today, and that SPY account is still valued $0 <-- to expand on this, the average cost of TRADING accounts per account summary does not total to $0, as it should, so this $0 value on 10 SPY shares is definitely the problem child
14:08:05 <CDB-Work> as on 2020-06-09 today
14:13:38 <jralls> Well, *a* problem child. IIRC the balance error is ~$2700 so this is rather less than half.
14:14:28 <CDB-Work> well, it could be the impact of change in FX rate since 2014
14:14:45 <CDB-Work> 2014 USD and CAD at 0.90, today it's 0.70
14:14:49 <CDB-Work> so it's likely this
14:15:04 <CDB-Work> the CAD impact magnified
14:18:18 <jralls> Hmm, actually since you've been buying and selling SPY it's not those 2014 txns that make for the error it's whatever were the most recent purchases.
14:19:00 <jralls> So what's the SPY value on the BS after the next SPY transaction?
14:19:03 <CDB-Work> unless, there is some corruption that's been carrying through
14:19:29 <CDB-Man_> well
14:20:13 <CDB-Man_> if i run legacy BS dated today, my SPY value is $0 on average cost
14:20:21 <jralls> Well there's some corruption somewhere. But if your *current* basis in SPY is C$2700 then that would explain the whole discrepancy, right?
14:20:22 <CDB-Man_> wait sorry, wrong date
14:21:14 <CDB-Man_> okay, the statement is correct. run dated today, the BS legacy report shows $0 10 shs
14:22:01 <CDB-Man_> at $okay, the statement is correct. run dated today, the BS legacy report shows $0 10 shs- USD
14:22:12 <CDB-Man_> .... why did it repeat the same message
14:22:48 <jralls> Usually because you pushed an up-arrow.
14:22:51 <CDB-Man_> the last, most recent purchase of SPY is 2018-08-17 10 shs for $2,851 USD
14:23:14 <CDB-Man_> so i don't think this is the cause of the $2700 CAD diff in TRADING at average cost
14:23:22 <jralls> fell, gjanssens, I've been trying to use the flathub beta branch for the beta releases, https://blogs.gnome.org/alexl/2019/02/19/changes-in-flathub-land/.
14:23:46 <CDB-Man_> if you're out of other ideas, I am going to try and re-key the 2016-06-02 transaction next and see if that puts everything to bed
14:24:02 <CDB-Man_> in case that intry is somehow corrupted... despite everything in the registers indicating otherwise
14:24:57 <jralls> OK. The alternative is examining the XML, and I expect your book is in the 30-50MB range so I'd rather not.
14:25:32 <CDB-Man_> indeed, its 1 MB when compressed!
14:30:13 <warlord> FWIW, my data file is 2.5MB compressed XML.
14:30:53 *** frakturfreak has joined #gnucash
14:30:53 *** ChanServ sets mode: +v frakturfreak
14:31:06 <CDB-Man_> well, re-keying didn't work.
14:31:31 <CDB-Man_> even when I had just zero'd the transactions first, the TRADING at average cost was $22.01 and not $0
14:31:58 <CDB-Man_> adding the transcation back in, SPY went from $1005 & 5 shs to $0 and 10 shs
14:32:30 *** Agfarmer18 has joined #gnucash
14:35:46 <CDB-Man_> hmm, if I double enter th purchase
14:35:57 <CDB-Man_> ie, record the 2014-06-02 purchase twice
14:36:07 <CDB-Man_> I now get 15 shares and $3408 CAD
14:37:24 <CDB-Man_> so somehow, there is some logic error when the same # units exist across 2 accounts.... (note the 2014-01-16 purchase of 5 shares was in the questrade account, and the 2014-06-02 was in RBC)
14:39:16 <CDB-Man_> some weird superpositioning going on...
14:42:11 *** zontag has joined #gnucash
14:48:19 <jralls> curiouser and curiouser.
14:49:28 <jralls> And with the extra purchase of SPY does the TB balance?
14:50:47 <jralls> Does the Questtrade account still have 5 SPY in it?
14:53:10 <CDB-Work> Yes, QT has 5 shs, RBC has 10. still does not balance though, the out of balance is $240
14:54:00 <CDB-Man_> might be due to the fact that i'm overdrafting cash by force-feeding a duplicate transaction... but i don't think that's the case as the reporting typically handles my madgin debt correctly...
15:03:07 <jralls> fell There's a different URL for beta builds, took me a few minutes to find it: https://flathub.org/builds/#/apps/org.gnucash.GnuCash~2Fbeta. I added it to the flatpak section of Release_Process.
15:05:33 <jralls> CDB-Man_ was the SPY trading between June 2014 and now done from QT or RBC? If you back out your extra buy and look at the BS immediately after each of those trades is the SPY value nonzero when the two accounts have different balances?
15:12:47 <fell> Thanks, jralls.
15:14:11 <gjanssens> jralls: using the betas looks like a good idea. Should we document in the release notes how to install these betas ?
15:14:12 <CDB-Work> from both accounts. as of today through, 2020-06-09, SPY is only held in RBC
15:15:33 <jralls> gjanssens, Let's do it on a wiki page instead. The release notes are getting overwhelmingly long.
15:16:46 <jralls> CDB-Work, Only in RBC but the BS value is still 0? What was the final disposition of the QT SPY account, sold or transferred?
15:17:57 <CDB-Work> only in RBC and the value is $0 for 10 shs, correct
15:18:05 <CDB-Work> the disposition of QT.... lets see
15:18:37 <gjanssens> jralls: good point. Just a link in the release notes is sufficient.
15:19:32 <CDB-Work> QT was disposed via sale in 2016. i should note that the 2014 purchase in RBC was in "TFSA" account, and the 2018 and BRC purchase (the current holding) is in RBC "RRSP" account
15:20:06 <jralls> gjanssens, which we already have, to https://wiki.gnucash.org/wiki/Flatpak.
15:20:48 <jralls> CDB-Work, and how was the TFSA account disposed of?
15:21:08 <CDB-Work> the RBC TFSA holding of SPY was disposed on 2018-08-17 via sale. it was repurchased same day in RBC RRSP 2018-08-17
15:22:19 <CDB-Work> if I run an accoutn summary report, average cost, dated 2018-08-16, the RBC TFSA shows 8 shs of SPY with a $ value
15:23:21 <jralls> *8* shares?
15:23:25 <CDB-Work> a TB dates 2018-08-16 with average cost does not balance
15:23:49 <CDB-Work> the difference is $~47K debits greater than credits
15:24:21 <jralls> Yow.
15:26:56 <CDB-Work> the account summary shows the balance in TRADING is the $46k diff
15:27:08 *** zontag has quit IRC
15:27:23 <CDB-Work> so, this SPY thing has some quirks, and unfortunately, you were right, in that it is not the only problem child
15:30:29 *** Mechtilde has quit IRC
15:32:25 <gjanssens> jralls: nice
15:32:42 <gjanssens> Seems I'm running a bit behind :)
15:39:26 <jralls> You've been busy.
15:41:36 <CDB-Work> so yeah... i get the feeling that even if we somehow fix this 10 SPY units issue, it wont resolve the TB out of balance issue
15:41:50 <CDB-Work> 10 SPY units in 2 different account registers!
15:42:18 <CDB-Work> << insert some joke about spies coming in packs of 10>>
15:43:47 <jralls> You should be buying VOO anyway. Lower expense ratio. ;-)
15:45:18 <CDB-Work> I use SPY because there's way more volume, so safer for when I do options plays like covered calls and such
15:49:38 *** fell has quit IRC
15:49:57 <CDB-Man_> interesting... if i put in a purchase 1 1 additional spy share on 2018-08-17 in the RBC RRSP, using the same price as the 10 share purchase, my SPY average cost goes from ~$2800 USD to $18000 CAD............
15:50:08 <CDB-Man_> purchase 1* additional
15:52:59 <CDB-Man_> there has got to be some sort of division by zero logic in here
15:53:45 *** fell has joined #gnucash
15:53:45 *** ChanServ sets mode: +o fell
15:55:01 <jralls> If you change the account summary report's currency = USD does it make the SPY have a value?
15:55:24 <jralls> A div by 0 will crash.
15:56:23 <CDB-Man_> yes it does, average cost 2851 USD as per the last purchase in RBC RRSP
16:00:47 <jralls> So the problem is in part that somewhere along the line that isn't getting correctly converted to CAD.
16:01:20 <CDB-Man_> in general for all acoounts yes, and in particular for this SPY accoutn but only when holding exactly 10 units it values it at $0
16:01:57 <CDB-Man_> and when I purchase an 11th unit... the valuation goes haywire (I can see th eexchagne rate printed at the bottom of the report goes from $~300 CAd or whatever... to $1,721 CAD per SPY share
16:02:54 <CDB-Man_> but more importantly, the issue is not unieuq to TB, it applies to account summary and legacy BS as well
16:03:14 <jralls> How about the new BS?
16:03:27 <jralls> I'll be surprised if it matters...
16:17:07 <jralls> I made a test book in CAD and set up two USD brokerage accounts and bought SPY in each, mirroring your first two transactions, and indeed with 5 shares in each account the SPY->CAD rate is 0, but with 5 in one and 6 in the other it's C$288.43. Switch to USD and the prices are 187.41 and 188.02 respectively.
16:19:19 <jralls> The Nearest in time prices are sane, so it has to be the average cost calculation that's confused by 3-way conversions.
16:21:17 <CDB-Man_> hmm, my gnucash froze.... - hope i dont lose all my reports...
16:24:42 <CDB-Man_> okay, i think the new BS report cannot handle the complexity of running average cost
16:24:48 <CDB-Man_> it freezes as soon as i start the operation
16:24:57 <CDB-Man_> maybe if i give it 5 minutes....
16:25:58 <jralls> What OS?
16:26:28 <CDB-Work> Windows 10
16:27:43 *** jervin has quit IRC
16:28:01 *** jervin has joined #gnucash
16:31:48 <CDB-Man_> yep. i dont think chris new BS can handle running average cost
16:31:55 <CDB-Man_> it's still stuck, for 6 minutes
16:32:10 <CDB-Man_> so that's your answer!
16:34:15 <jralls> It ran OK for me just now, taking about a minute, but I don't have as torturous a set of commodity combinations as you.
16:36:11 <jralls> Then again that was Friday's master so it didn't have chris's more recent changes.
16:40:40 <CDB-Man_> I'm going to stop trying to run average cost new BS for now
16:40:59 <jralls> OK.
16:41:10 <CDB-Man_> its clearly not going to work (for me)
16:41:57 <CDB-Man_> hmm, better re-run nearest in time today's BS to make sure I didn't break all of my actual balances
16:45:03 <jralls> I suggest that you either quit without saving or revert to the backup from before you started experimenting.
16:53:31 *** sbluhm has quit IRC
17:00:54 *** frakturfreak has quit IRC
17:09:54 <CDB-Man_> OK, loaded my file from 9 PM last night, back in business again
17:22:51 *** gjanssens has quit IRC
17:24:03 *** jervin has quit IRC
17:36:15 <jralls> CDB-Man_: https://bugs.gnucash.org/show_bug.cgi?id=797796
17:37:35 <CDB-Work> thanks jralls, added myself to the cc list (I think)
17:39:26 <CDB-Work> hmm, is the calculation of the price done by 1) the report itself, 2) some report utility, or 3) by gnucash core?
17:43:57 <jralls> It's done by gnc:case-exchange-fn in https://github.com/Gnucash/gnucash/blob/master/gnucash/report/commodity-utilities.scm
17:58:38 <CDB-Work> okay, so a scheme based util, rather than the software itself
17:59:05 <CDB-Work> given that the issue is pervasive across multiple reports, my guess is that it's commodity-utilities that probably needs a patch?
18:29:42 <fell> jralls, you did not increment the version of docs. Prbably because I was too late with any changes?
18:31:50 <fell> running make distcheck, I got a gnucash-docs-3.903.tar.gz
18:34:08 <fell> ... using autotools
18:35:51 <fell> I will set both to 3.904 now, OK?
18:40:18 *** User has quit IRC
18:46:10 *** Aussie_matt has joined #gnucash
18:58:29 <jralls> fell: Thanks, I just missed configure.ac, I guess you figured that out. I built the tarball with cmake.
19:00:35 <jralls> Yes, your changes were after I did the release. No matter, there's another one this weekend.
19:02:40 *** omnireq has quit IRC
19:05:04 *** jralls has quit IRC
19:15:10 *** jralls has joined #gnucash
19:15:10 *** ChanServ sets mode: +o jralls
19:28:33 *** Anubis169 has joined #gnucash
19:28:49 <Anubis169> Heyo :) Very silly newbie question.
19:29:49 <Anubis169> When adding a liability (credit card, for example with $1000 available on it) to an account.
19:30:26 <Anubis169> is it added with opening balance $1000, and then reconciled back to $1000 at the end of the billing cycle
19:30:55 <Anubis169> or is it added with opening balance $0, and reconciled from the negative amount generated in the month back to $0?
19:32:26 <jralls> If it's a new credit card then you'd usually open with 0. If you've got a balance on it when you start accounting for it in GnuCash then you'd use that balance as the opening balance.
19:33:23 <jralls> You want the balance to reflect what you owe, not what you can borrow.
19:33:43 <Anubis169> much thankies
19:33:49 <Anubis169> then... if I accidentally overpaid the previous month, and i'm adding it now
19:34:02 <Anubis169> i'd add the credit card with a positive balance?
19:35:08 <jralls> Yes.
19:35:15 <Anubis169> <3
19:35:33 <Anubis169> much thanks, that one was frying my brain
19:36:07 <jralls> Just to be sure, you have Preferences>Accounts Reverse-Balanced Accounts set to None, right?
19:36:37 <Anubis169> ya know i've never checked that...
19:36:46 <Anubis169> looks like it's set to credit accounts
19:37:51 <Anubis169> should I change that to 'None' or keep it as-is?
19:38:11 <jralls> OK, that's the default. In that case the balances in a liability account will be positive but since it's a liability account it still increases with a credit (right column) and decreases with a debit (left column).
19:38:50 <Anubis169> Understood o7
19:38:58 <jralls> If you want liability account balances to display as negative numbers then change it to None.
19:40:48 <Anubis169> Hmm... will probably keep it as-is on the default then, the negative red number on a credit card for how much I owe lines up better in my brain
19:41:20 <jralls> Then you want to change it to None.
19:42:04 <Anubis169> hmm?
19:42:46 <Anubis169> I added the card with a positive amount, and the display's set to Credit Accounts.. it's showing as black and white :)
19:43:03 <Anubis169> presumably it'll only turn negative red when I actually owe something, that's what I'm after
19:44:51 <jralls> You told GnuCash you owe that positive amount. Open the credit card register and look which column the amount is in.
19:45:13 <Anubis169> ...
19:45:16 <Anubis169> *mental derp*
19:45:19 <Anubis169> lemme undo that :D
19:45:59 <jralls> Just edit it. It's a transaction like any other. Delete the amount from the right column and re-type it or paste it into the left one.
19:47:37 <Anubis169> Done :)
19:47:39 <Anubis169> ...
19:47:54 <Anubis169> why's my equity showing as negative-sillynumber?
19:49:42 <jralls> Equity also increases with credit but isn't sign-reversed. Do you still have the cursor in the opening balance transaction on the CC register?
19:51:09 <Anubis169> Reverse Balance Accounts set to None
19:51:41 <Anubis169> when I switched it to 'None', all my equity started showing as negative
19:51:48 <jralls> OK, but did you commit the edit in the opening balance transaction?
19:51:54 <Anubis169> oh, yeah
19:52:41 <Anubis169> Credit card showing with the amount I overpaid last month in the left 'Decrease' column
19:52:50 <Anubis169> (in green)
19:53:04 <Anubis169> and a yellow line underneath ready for another entry
19:53:55 <jralls> And Equity is now positive, right?
19:54:00 <Anubis169> nope
19:54:52 <jralls> Press the Enter key in the CC register.
19:55:08 <Anubis169> done, no change :/
19:55:17 <jralls> brb
19:55:25 <Anubis169> i can try reopening the program if ya like
19:57:56 <jralls> That won't do anything. When you created the CC account did you set it to type Credit Card in the lower left of the dialog box?
19:58:43 <Anubis169> I think I did, but it's possible not... it's almost 1am
19:58:45 <Anubis169> lemme check
19:59:14 <jralls> Or, another way, when you change the sign reverse preference does the balance switch from positive to negative?
19:59:27 <Anubis169> yeah it does
19:59:30 <Anubis169> lemme re-add the card
19:59:41 <Anubis169> it was added as 'liability' not 'credit card'
19:59:51 <jralls> That's OK.
20:00:06 <jralls> Are there other opening balances?
20:00:18 <Anubis169> yeah
20:00:22 <Anubis169> they're all negative too
20:01:02 <jralls> In the Equity register?
20:01:25 <Anubis169> Yeah
20:02:52 <jralls> Huh, I thought Equity didn't sign-reverse, but it does.
20:03:29 <Anubis169> Ah, so it's supposed to be like that?
20:03:33 <Anubis169> *phew*
20:04:05 <Anubis169> yeah every time I've opened a new account with an opening balance, that normally displayed a positive amount
20:04:17 <Anubis169> since switching to 'None' in the display, it's all negative
20:05:05 <jralls> Right. That's because with sign reversal turned off the positive asset has to be balanced by negative equity.
20:05:15 <Anubis169> I guess that tracks since an opening balance has to come from somewhere
20:05:17 <Anubis169> ya
20:05:48 <jralls> Now I've got to go.
20:05:57 <Anubis169> much thanks :D
20:06:00 * Anubis169 bounces
20:11:34 *** Anubis169 has quit IRC
20:14:38 *** ArtGravity has quit IRC
20:15:13 *** omnireq has joined #gnucash
20:24:57 <CDB-Work> good to see that non-finance people also care about their personal finances
20:31:04 *** guak has quit IRC
21:09:20 *** omnireq has quit IRC
21:09:24 *** omnireq_ has joined #gnucash
21:13:01 *** jervin has joined #gnucash
21:15:55 *** storyjesse has joined #gnucash
21:36:13 *** jervin has quit IRC
21:45:54 *** jost has quit IRC
21:59:36 *** jost has joined #gnucash
22:19:23 *** storyjesse has quit IRC
22:45:39 *** storyjesse has joined #gnucash
22:46:44 *** Agfarmer18 has quit IRC
22:54:50 *** jervin has joined #gnucash
23:33:58 *** Agfarmer18 has joined #gnucash
23:42:41 *** omnireq_ has quit IRC
23:42:52 *** omnireq_ has joined #gnucash
23:53:28 *** jralls_afk has joined #gnucash
23:53:28 *** ChanServ sets mode: +o jralls_afk
23:54:27 *** jralls has quit IRC