2021-04-18 GnuCash IRC logs

00:02:44 *** FH_thecat has quit IRC
00:21:47 *** adder has quit IRC
01:17:44 *** fell has quit IRC
01:19:03 *** fell has joined #gnucash
01:19:03 *** ChanServ sets mode: +o fell
01:57:02 *** frakturfreak has quit IRC
02:08:33 *** Hrisfur has joined #gnucash
02:08:33 *** ChanServ sets mode: +v Hrisfur
02:09:56 *** Hrisfur has quit IRC
02:10:17 *** sbluhm has joined #gnucash
02:10:17 *** ChanServ sets mode: +v sbluhm
02:11:21 *** frakturfreak has joined #gnucash
02:11:21 *** ChanServ sets mode: +v frakturfreak
02:15:32 *** sbluhm has quit IRC
02:45:08 *** Hrisfur has joined #gnucash
02:45:08 *** ChanServ sets mode: +v Hrisfur
03:04:32 *** Hrisfur has quit IRC
03:05:04 *** Hrisfur has joined #gnucash
03:05:04 *** ChanServ sets mode: +v Hrisfur
04:04:10 *** storyjesse has joined #gnucash
04:06:41 *** David has quit IRC
04:06:46 *** David has joined #gnucash
04:12:42 *** sbluhm has joined #gnucash
04:12:43 *** ChanServ sets mode: +v sbluhm
04:23:50 *** sbluhm has quit IRC
04:33:12 *** fabior has joined #gnucash
04:45:10 *** Hrisfur has quit IRC
04:52:08 *** User_ has joined #gnucash
05:00:52 *** jervin has quit IRC
05:01:01 *** jervin has joined #gnucash
05:09:13 *** fabior has quit IRC
06:40:37 *** field^Mop has joined #gnucash
06:50:23 *** mydogsnameisrudy has joined #gnucash
06:52:04 *** mydogsnameisrudy has quit IRC
07:05:08 *** adder has joined #gnucash
07:25:21 *** adder has quit IRC
07:25:37 *** field^Mop has quit IRC
07:28:45 *** adder has joined #gnucash
07:28:50 <adder> I have a problem regarding multi-currency trading accounts. I just did 3 month's accounting before realizing that I had not selected the "use trading accounts" option in my preferences. Is there any way to update or re-run all of my inter-currency transactions? (Sorry, I asked this the other day but disconnected before getting an answer)
07:28:50 <gncbot> adder: Sent 3 days, 14 hours, and 2 minutes ago: <warlord> Turn on trading accounts and then you can run the scrub routines.
07:30:02 <adder> (Oh I just realized the bot let me know what my response was. Warlord suggested that I scrub the routines... I don't actually know what that means in this context.
07:36:52 <Midnight_Rider> I'm looking to get an idea of what it would take to upgrade my version of GnuCash 2.4.13 to a newer version on a windows 7 operating system.
07:45:16 <adder> (And I found the scrub tool. Thank you!)
07:46:23 *** Aussie_matt has joined #gnucash
07:56:19 *** epistax has joined #gnucash
07:56:38 *** ChanServ sets mode: +v epistax
07:59:58 *** halipaul has joined #gnucash
08:02:29 *** adder has quit IRC
08:04:48 <epistax> I'm having some difficulty getting price quotes for Silver (XAG). For my regular securities I had to select yahoo (json) as my source, but I don't see how to do that for XAG. I set up an asset for XAG and provided the weight (in oz). What am I doing wrong?
08:05:01 <epistax> (Thanks)
08:14:10 *** Mechtilde has quit IRC
08:14:53 *** Mechtilde has joined #gnucash
08:23:21 <chris> jralls: instead of converting dialog to assistant, how about setting gtk_widget hidden property instead of sensitive?
08:26:41 *** sbluhm has joined #gnucash
08:26:42 *** ChanServ sets mode: +v sbluhm
08:33:27 *** sbluhm has quit IRC
08:41:11 *** sbluhm has joined #gnucash
08:41:11 *** ChanServ sets mode: +v sbluhm
08:44:11 *** sbluhm has quit IRC
08:44:54 *** emc has quit IRC
09:13:10 <warlord> Midnight_Rider, from 2.4.13 you will want to ugrade to a 2.6 version, load your data file, save it again, and then from there you should be able to jump directly to 4.x -- although you could make a step to 3.x if you prefer. At each step just download the installer, install it, and then run it. NB, Win7 is EOL, so you might get stuck at 2.6 or 3.x.
09:13:44 <warlord> epistax, currency quotes should be automatic (I don't know what source it uses offhand).
09:14:43 <epistax> warlord, when I ask for a price database "Get Quotes" update, I get a message saying that XAG failed, would I like to proceed with the rest.
09:15:19 <epistax> My price history for XAG only includes two transfers between a USD account and XAG account.
09:15:25 <warlord> Does the Tracefile have anything to say about it?
09:15:53 <Midnight_Rider> Thanks for the response warlord, I'll work on it.
09:16:32 <warlord> Midnight_Rider, just backup your data file(s) first...
09:16:36 <warlord> (Just In Case)
09:17:02 <warlord> epistax, I don't recall what quote source is used for currencies.
09:17:21 <warlord> It's POSSIBLE it uses alphavantage, which requires an API Key
09:17:26 <Midnight_Rider> :) Got it, thanks!
09:17:31 *** Midnight_Rider has quit IRC
09:18:16 <epistax> warload I just tried to update the price database then checked /tmp/gnucash.trace. There are no new lines.
09:19:07 <warlord> hmm
09:19:22 <warlord> I know jralls is still asleep. Dunno if chris has any ideas/
09:19:49 <epistax> I'm patient. I'll check back in a while. I won't miss anything that gets posted. Thanks :)
09:20:42 <chris> I have no idea if the alphavantage or yahoo sources offer XAU/XAG
09:20:54 <chris> there's also the weird USN currency
09:21:19 <warlord> chris, I tried yahoo_json and it didn't work..
09:21:42 <warlord> And I don't have an AlphaVantage key
09:22:00 <warlord> If I try: gnc-fq-dump currency XAGUSD
09:22:01 <warlord> ERROR: ALPHAVANTAGE_API_KEY *must* be set for currency quotes and
09:22:01 <warlord> stock quotes with source 'alphavantage' or 'vanguard'; see
09:22:01 <warlord> https://wiki.gnucash.org/wiki/Online_Quotes#Source_Alphavantage.2C_US
09:35:10 *** storyjesse has quit IRC
09:35:28 *** field^Mop has joined #gnucash
09:35:58 <fell> XAG etc. are ISO currencies. Currency in Finance::Quote version 1.49 are hardcoded to alphavantage,but you should be able to query .yahoo_json XAGUSDX or so.
09:40:41 *** sbluhm has joined #gnucash
09:45:45 <fell> with an alphavantage key in my bash environment I get:
09:45:46 <fell> gnc-fq-dump currency XAG USD
09:45:48 <fell> 1 XAG = 25.96845 USD
09:48:13 <epistax> gnc-fq-dump currency XAG USD
09:48:13 <epistax> 1 XAG = <unknown> USD
09:48:13 <epistax> Maybe I need one of those keys
09:52:42 *** sbluhm has quit IRC
09:53:08 <epistax> gnc-fq-dump currency XAG USD
09:53:08 <epistax> 1 XAG = 25.96845 USD
09:53:08 <epistax> That worked, now the gui...
09:54:09 <epistax> That worked too! Great, thanks. I think if this is going to be a hard-coded source, a more appropriate error message would save you from people like me. :-)
10:02:44 <chris> CDB-Man the average-cost.scm report could be merged into the nightlies in Experimental for better access to testing, maybe even hidden behind --extra WDYT jralls
10:03:10 <epistax> Oh, totally different topic. I switched "Date Completion" to "In the current calendar year" because the default option, "in a sliding 12-month window starting with many months before the current month" seems a little bonkers. If I put 4/15 for a date it (US format) it completes to 4/15/1899.
10:04:00 <chris> epistax: we have bugzilla for unexpected reports like this -- care to add there? some skilled devs don't watch irc
10:04:12 <epistax> Sure I'll hop over there
10:10:28 *** field^Mop has quit IRC
10:19:23 *** sbluhm has joined #gnucash
10:19:24 *** ChanServ sets mode: +v sbluhm
10:20:17 *** Aussie_matt has quit IRC
10:36:13 <CDB-Man> Thanks Chris
10:36:20 <CDB-Man> I just haven't the time lately
10:42:03 <fell> epistax on th console you can also use:
10:42:05 <fell> gnc-fq-dump yahoo_json XAGUSD=X
10:42:06 <fell> Finance::Quote fields Gnucash uses:
10:42:08 <fell> symbol: XAGUSD=X <=== required
10:42:09 <fell> date: 04/08/2019 <=== recommended
10:42:11 <fell> currency: USD <=== required
10:42:12 <fell> last: 15.220006 <=\
10:42:14 <fell> nav: <=== one of these
10:42:15 <fell> price: <=/
10:42:17 <fell> timezone: <=== optional
10:42:49 <fell> oh, hisstorical data :-(
10:45:36 <fell> but real currencies can still be queried that way.
11:15:38 *** sbluhm has quit IRC
11:40:36 *** frakturfreak has quit IRC
11:41:52 *** mydogsnameisrudy has joined #gnucash
11:47:19 *** mydogsnameisrudy has quit IRC
11:52:48 <jralls> chris, showing and hiding UI elements is even worse than changing the labels.
12:02:53 <jralls> chris, master gets nightly builds too and that's where your tool goes. But I haven't had time to code-review your PR except for the join_string snippet yesterday and nobody else has looked at it since November.
12:05:03 *** TownsendHardware has joined #gnucash
12:41:08 *** Hrisfur has joined #gnucash
12:41:08 *** ChanServ sets mode: +v Hrisfur
12:41:53 *** Hrisfur has quit IRC
12:49:14 *** Mechtilde has quit IRC
12:50:33 *** Mechtilde has joined #gnucash
13:11:49 *** jervin has quit IRC
13:18:12 *** jervin has joined #gnucash
13:35:20 *** sbluhm has joined #gnucash
13:35:20 *** ChanServ sets mode: +v sbluhm
13:36:11 *** sbluhm has quit IRC
13:53:38 *** jervin has quit IRC
14:07:23 *** sbluhm has joined #gnucash
14:07:23 *** ChanServ sets mode: +v sbluhm
14:07:39 *** sbluhm has quit IRC
14:07:48 *** sbluhm has joined #gnucash
14:07:48 *** ChanServ sets mode: +v sbluhm
14:27:58 *** field^Mop has joined #gnucash
14:30:28 *** David has quit IRC
14:30:35 *** David has joined #gnucash
14:39:50 *** noregret has quit IRC
14:51:41 *** Midnight_Rider has joined #gnucash
14:55:28 <Midnight_Rider> warlord, just a shout-out for that direction earlier in reference to an upgrade. Went through the entire process and ended up with version 4! (nice) Anyway, appreciate your input!
15:02:51 *** jervin has joined #gnucash
15:11:58 *** field^Mop has quit IRC
15:19:08 *** gjanssens has joined #gnucash
15:19:08 *** ChanServ sets mode: +o gjanssens
15:55:48 *** sbluhm has quit IRC
16:05:14 *** Mechtilde has quit IRC
16:31:46 *** mikee has quit IRC
16:33:06 *** mikee has joined #gnucash
16:40:52 *** gjanssens has quit IRC
16:55:33 <warlord> Midnight_Rider, glad that worked out for you!
17:02:52 *** frakturfreak has joined #gnucash
17:08:52 *** o01eg has quit IRC
18:10:16 *** jw4 has quit IRC
18:10:53 *** jw4 has joined #gnucash
18:57:34 *** Aussie_matt has joined #gnucash
19:38:33 <chris> jralls/cdb-man there are two tools - the acb report (which I'm proposing can be merged into maint experimental soon) and the stock-editor (which is nowhere near ready)
19:39:28 <jralls> chris, maybe you should have separate PRs.
19:39:30 <chris> the ACB report could be into experimental --extra and receive bug reports, usability upgrades (eg option simple/detailed), label fixes etc
19:39:30 <CDB-Man> And I still owe you a truth table for the report
19:40:00 <chris> cdb-man- exactly the truth table is afaiu only for the 'english interpretation of a stock txn'
19:40:09 <chris> jralls - I'll split the PRs then
19:40:23 <chris> cdb-man AFAIU the numeric ACB calculations are A-ok
19:40:32 <jralls> But don't make it dependent on --extra, that guarantees nobody will test it. Just put it in Reports>Experimental.
19:40:34 <CDB-Man> No, the truth table also affects how you aggregate some of the cost basis items
19:40:46 <CDB-Man> There were some errors depending on sequencing
19:41:09 <chris> Ok and maybe some enlightened users will also kick its tyres
19:41:19 <CDB-Man> Because of how you were mapping some of the transactions
19:41:29 <CDB-Man> I still need to do it, I just haven't the time yet
19:41:53 <CDB-Man> I need to get my taxes filed first
19:42:00 <CDB-Man> Before April 30
19:42:25 <chris> it's the last stretch
19:42:52 <CDB-Man> I also need to catch up on 2 months of options trading volumes
19:43:09 <CDB-Man> I was sent back to work (grudgingly) in my old department
19:43:16 <CDB-Man> Due to a staffing shortage there
19:43:32 <CDB-Man> Sent back really means "hey do your old job on top of your new one)
19:43:55 <CDB-Man> So I've been backlogged on keeping up my trading activity in gnucash ever since
19:47:17 <chris> usually it's a more civilised life as a contractor :)
19:48:02 <CDB-Man> If you mean me, I've never been a contractor
19:58:32 <chris> as a contractor, any potential hirer/client will first need to convince us why the job should be done (by us) :)
19:58:54 <chris> that's before the money negotiations start
20:36:28 *** jervin has quit IRC
21:14:15 *** User_ has quit IRC
21:24:07 *** Midnight_Rider has quit IRC
22:04:15 *** angel has joined #gnucash
22:13:42 *** storyjesse has joined #gnucash
22:43:40 *** storyjesse has quit IRC
22:44:02 *** storyjesse has joined #gnucash
22:51:47 *** angel has quit IRC
23:17:20 *** angel has joined #gnucash