2019-07-14 GnuCash IRC logs
00:00:05 <chris> jralls I'll be adding owner-report tests, finalising merging job+owner, and supercharge owner-report
00:03:51 <chris> owner-report may show linked payments/invoices, none(default)/simple/detailed
00:04:16 <chris> afterwards aging will be cleaned up
00:08:23 <chris> wrt budget-ytd upgrade i'm not 100% sure of the option-name. It could be renamed "Accumulate amounts across periods" instead
00:13:32 *** jangid has joined #gnucash
00:13:32 *** ChanServ sets mode: +v jangid
00:30:53 *** storyjesse has joined #gnucash
00:34:47 <chris> moreover I intend to *remove* owner-report's account option... hope there's no objection. owner-report will search all APAR accts for posted txns
00:35:27 <chris> this means the recent upgrade to gnc:owner-report-create for #:currency is also unnecessary
00:45:45 *** storyjesse has quit IRC
00:49:38 *** storyjesse has joined #gnucash
00:54:08 *** storyjesse has quit IRC
00:55:17 *** Mechtilde has joined #gnucash
00:57:25 *** ChanServ sets mode: +v Mechtilde
02:16:27 *** jangid has quit IRC
02:31:49 *** Aussie_matt has quit IRC
02:50:30 *** jangid has joined #gnucash
02:50:30 *** ChanServ sets mode: +v jangid
03:08:59 *** karelk has quit IRC
03:24:02 *** jangid has quit IRC
03:26:53 *** jangid has joined #gnucash
03:26:54 *** ChanServ sets mode: +v jangid
04:04:49 *** karelk has joined #gnucash
04:16:56 *** bertbob has quit IRC
04:18:10 *** Aussie_matt has joined #gnucash
04:25:19 *** bertbob has joined #gnucash
04:25:20 *** ChanServ sets mode: +v bertbob
04:30:11 *** jangid has quit IRC
04:30:39 *** jangid has joined #gnucash
04:30:39 *** ChanServ sets mode: +v jangid
04:30:55 *** bertbob has quit IRC
04:45:23 *** Aussie_matt has quit IRC
04:53:46 *** Aussie_matt has joined #gnucash
05:08:12 *** jangid has quit IRC
05:09:58 *** jangid has joined #gnucash
05:09:58 *** ChanServ sets mode: +v jangid
05:13:11 *** jangid has quit IRC
05:22:34 *** Aussie_matt has quit IRC
05:27:23 *** Aussie_matt has joined #gnucash
05:33:56 *** phoenix has joined #gnucash
05:39:00 *** phoenix has quit IRC
05:40:51 *** fabior has joined #gnucash
05:49:50 *** jangid has joined #gnucash
05:49:51 *** ChanServ sets mode: +v jangid
05:51:17 *** storyjesse has joined #gnucash
06:05:14 *** Aussie_matt has quit IRC
06:08:33 *** Aussie_matt has joined #gnucash
06:12:20 *** fell_laptop has joined #gnucash
06:12:21 *** ChanServ sets mode: +o fell_laptop
06:12:21 *** fell has quit IRC
06:12:49 *** Aussie_matt has quit IRC
06:16:04 *** Aussie_matt has joined #gnucash
06:29:04 *** jangid has quit IRC
06:34:09 *** phoenix has joined #gnucash
06:47:54 *** phoenix has quit IRC
06:48:51 *** phoenix has joined #gnucash
06:55:29 *** Mechtilde has quit IRC
07:07:48 *** fabior has quit IRC
07:16:01 *** User has joined #gnucash
07:21:57 *** phoenix has quit IRC
07:22:14 *** phoenix_ has joined #gnucash
07:23:02 *** phoenix_ is now known as phoenix
07:36:38 *** phoenix has quit IRC
07:49:40 *** bertbob has joined #gnucash
07:49:41 *** ChanServ sets mode: +v bertbob
07:53:25 *** Mechtilde has joined #gnucash
07:53:25 *** ChanServ sets mode: +v Mechtilde
08:35:23 *** fabior has joined #gnucash
08:36:28 *** fell_laptop has quit IRC
08:50:49 *** fell_laptop has joined #gnucash
08:50:49 *** ChanServ sets mode: +o fell_laptop
08:59:50 *** fell_laptop has quit IRC
09:00:49 *** Jimraehl1 has joined #gnucash
09:02:08 *** Jimraehl1 has quit IRC
09:10:36 *** Aussie_matt has quit IRC
09:13:52 <warlord> .
09:16:44 *** boldstripe has joined #gnucash
09:19:56 *** phoenix has joined #gnucash
09:23:44 *** phoenix has quit IRC
09:24:35 *** phoenix has joined #gnucash
09:26:28 *** O01eg has joined #gnucash
09:34:42 *** phoenix has quit IRC
09:54:58 *** phoenix_ has joined #gnucash
09:56:13 *** phoenix_ has quit IRC
09:56:42 *** phoenix has joined #gnucash
10:38:08 *** storyjesse has quit IRC
10:38:35 <chris> #535 is now feature complete. merges job-report, cleans up owner-report a bit, shows links between inv/CN/payments. would be good to have review.
10:38:53 <chris> and defaults to none, options for simple/detailed links
11:29:51 *** chris__ has joined #gnucash
11:31:56 *** fabior has quit IRC
11:41:52 *** jerryq has quit IRC
11:43:23 *** jerryq has joined #gnucash
11:57:43 *** boldstripe has quit IRC
11:58:37 *** boldstripe has joined #gnucash
12:00:36 *** Mechtilde has quit IRC
12:08:25 *** jralls has quit IRC
12:12:06 *** jralls has joined #gnucash
12:12:06 *** ChanServ sets mode: +o jralls
12:14:16 *** chris__ has quit IRC
12:19:18 *** phoenix has quit IRC
12:25:49 *** jralls has quit IRC
12:30:26 *** jralls has joined #gnucash
12:30:26 *** ChanServ sets mode: +o jralls
12:49:23 *** bralyclow has joined #gnucash
12:50:08 *** User has quit IRC
13:15:28 *** Mechtilde has joined #gnucash
13:15:28 *** ChanServ sets mode: +v Mechtilde
13:22:14 *** bralyclow has quit IRC
13:40:25 *** jangid has joined #gnucash
13:40:25 *** ChanServ sets mode: +v jangid
13:41:25 *** phoenix has joined #gnucash
13:41:49 <jangid> If a transaction goes into dispute. For example a failed online payment. How to make such an entry? The money is deducted from my account but I am waiting for returns.
13:42:47 <jangid> Is this receivable?
13:56:43 *** bralyclow has joined #gnucash
13:58:23 *** boldstripe has quit IRC
13:59:17 *** boldstripe has joined #gnucash
14:04:29 *** ypical has joined #gnucash
14:16:03 *** ypical has left #gnucash
14:28:07 *** User has joined #gnucash
14:31:45 *** bralyclow has quit IRC
14:59:35 *** badger92 has quit IRC
15:00:00 *** badger92 has joined #gnucash
15:00:15 *** frakturfreak has joined #gnucash
15:16:01 *** Mechtilde has quit IRC
15:49:51 *** sokol99 has quit IRC
15:49:59 *** sokol99 has joined #gnucash
15:54:21 *** gjanssens has joined #gnucash
15:54:21 *** ChanServ sets mode: +o gjanssens
15:58:31 <jralls> gjanssens, how's the holiday going?
15:59:03 *** jervin has joined #gnucash
15:59:04 *** boldstripe has quit IRC
16:00:01 *** boldstripe has joined #gnucash
16:04:08 *** jerryq has quit IRC
16:05:33 *** jerryq has joined #gnucash
16:07:19 *** jervin has quit IRC
16:09:52 <gjanssens> jralls: good. In between travels now. Just got back from a week out and will leave again tomorrow.
16:09:52 <gncbot> gjanssens: Sent 1 day, 14 hours, and 56 minutes ago: <chris> I've merged envelope-budgeting into budget.scm -- my query is whether the terminology is correct. It replicates Phil Longstaff's ytd-budget.scm functionality. We can modify option name to a better one.
16:10:26 <gjanssens> So I'm basically repacking my bags :)
16:11:02 <gjanssens> chris: feedback on your work will have to wait some more...
16:18:31 *** phoenix has quit IRC
16:28:03 <CDB-Man> to what extent does finance quote support cryptocurrency, if at all?
16:35:39 <jralls> CDB-Man: AFAICT not at all.
16:36:49 <CDB-Man> hmm, well, I did see this: https://metacpan.org/pod/CryptoCurrency::Catalog which says it at least has then enumerated, but not sure if it can quote them or anything. that and even if it's doable, if gnucash can set them up as a security/currency or not
16:38:27 *** gjanssens has quit IRC
16:39:38 <jralls> CDB-Man: You can set up anything you like as a security. Currencies are limited to what ISO4217 says they are. Aside from that CryptoCurrency::Catalog has *nothing* to do with Finance::Quote except that they're both written in Perl.
16:40:05 <CDB-Man> Hmm.
16:40:28 <CDB-Man> In that case, I think ym roadblock here is what to define as "Type" when creating a new security
16:40:43 <CDB-Man> given that there's on "exchange" to put BTC or other cryptocurrencies under
16:40:47 <CDB-Man> there's no*
16:42:49 *** oozer has joined #gnucash
16:42:54 <jralls> That's a free-form text field. You can make any "type" (aka "namespace") that you want; the values provided are just some suggestions.
16:43:03 *** User has quit IRC
16:43:20 <CDB-Man> hmm, well, my thought was more regarding pulling data from Yahoo finance, since it seems yahoo finance has quotes for crypto currencies, so perhaps it may just work...
16:44:46 <jralls> It might, using the yahoo-json source (Yahoo! shut down all of the others). Just define the symbol to be whatever Yahoo! uses and it might match up. Test with gnc-fq-dump. If that works, GnuCash will too.
16:48:26 <CDB-Man> interesting. Y! uses CCC as the "exchange", and in the case of bitcoin, "BTC-USD" works as a ticker out of the box
16:48:31 <CDB-Man> https://finance.yahoo.com/quote/BTC-USD/?p=BTC-USD
16:49:37 <CDB-Man> as a housecleaning question, in the edit security, since Type is a freeform field, at one point I entered "CRYPTOCURRENCY" as an entry. this is now not needed now that ive discovered yahoo's correct syntax. can I clear this from the cache somehow?
16:50:12 *** hackdown1 has joined #gnucash
16:50:24 *** hackdown1 has left #gnucash
16:53:13 <CDB-Man> it also looks like alphavantage supports cryptocurrencies, so we could probably use that, but by default the Gnucash GUI doesn't let yo define new currencies https://www.alphavantage.co/documentation/#digital-currency
16:53:27 <jralls> You can edit your file/database. I don't know of any way to remove a namespace using the GUI.
16:54:35 *** fell_laptop has joined #gnucash
16:54:35 *** ChanServ sets mode: +o fell_laptop
16:54:53 <jralls> By design, not by default. We're very firm that "currency" means what ISO4217 says it means.
16:57:00 <CDB-Man> In that case then, is it possible to add to the security listing something that can be looked up via alhpavantage's currency mechanic, without calling it a currency within gnucash?
16:57:33 <jralls> I don't think so.
17:01:01 <CDB-Man> Oh well then. looks like I will just have to wait then until Y! adds GUSD (Gemini Dollar) to its list of quoted cryptos
17:03:04 <CDB-Man> [2019.07.14 16:53:27] <jralls> You can edit your file/database. I don't know of any way to remove a namespace using the GUI. <-- editing the raw .gnucash file, there's actually no hits when I grep for "CRYPTOCURRENCY", the entry I added to that namespace. I'm looking in the wrong file, I take it?
17:06:55 *** boldstripe has quit IRC
17:07:43 <jralls> Hmm. There's no separate list of spaces, it's just an element (cmdty:space) in gnc:commodity elements. I guess if there aren't any entries using it it just goes away. The exception would be the "example" ones, they're in the code.
17:07:50 *** boldstripe has joined #gnucash
17:09:35 <jralls> According to https://gemini.com/dollar/ a Gemini Dollar is worth a US Dollar. No pricing required.
17:09:46 <CDB-Man> hmm. maybe its a simple matter of just re-launching then to clear the memcache
17:10:14 <CDB-Man> yeah it's worth a US dollar, but due to market arbitrage it's something like 0.98:1 to 1.01:1
17:11:05 <CDB-Man> but yeah, in terms of materiality, not having active quotes for that won't be the end of the world
17:11:19 <CDB-Man> if I really need to, I can enter a manual entry into the price DB via the GUI
17:11:20 <jralls> I'd think that would vary per-transaction and market prices wouldn't be particularly useful.
17:11:38 *** chris__ has joined #gnucash
17:11:45 *** KevinDB has quit IRC
17:14:39 *** KevinDB has joined #gnucash
17:14:39 *** ChanServ sets mode: +v KevinDB
17:20:47 *** frakturfreak has quit IRC
17:46:21 *** RASSRQ has joined #gnucash
17:47:53 *** RASSRQ1 has joined #gnucash
17:53:01 *** jangid has quit IRC
18:29:44 *** bertbob has quit IRC
18:32:07 *** bertbob has joined #gnucash
18:32:08 *** ChanServ sets mode: +v bertbob
18:32:18 *** RASSRQ1 has left #gnucash
18:36:12 *** RASSRQ has quit IRC
18:44:44 *** Aussie_matt has joined #gnucash
19:07:36 *** boldstripe has quit IRC
19:08:31 *** boldstripe has joined #gnucash
20:25:11 *** chris__ has quit IRC
21:08:16 *** boldstripe has quit IRC
21:09:13 *** boldstripe has joined #gnucash
21:23:58 *** oozer has quit IRC
22:24:23 *** chris__ has joined #gnucash
22:47:43 *** omnireq has quit IRC
22:47:53 *** omnireq has joined #gnucash
22:47:54 *** ChanServ sets mode: +v omnireq
22:51:50 *** omnireq has quit IRC
23:08:34 *** Robert847 has joined #gnucash
23:08:57 *** boldstripe has quit IRC
23:09:53 *** boldstripe has joined #gnucash
23:33:57 *** jangid has joined #gnucash