2019-10-12 GnuCash IRC logs
00:25:57 *** fell has quit IRC
00:32:22 *** Mechtilde has joined #gnucash
00:36:22 *** fell has joined #gnucash
00:36:22 *** ChanServ sets mode: +o fell
01:24:40 *** fell_laptop has joined #gnucash
01:24:41 *** ChanServ sets mode: +o fell_laptop
01:26:23 *** fell has quit IRC
01:35:19 *** fell_laptop has quit IRC
01:38:39 *** fell has joined #gnucash
01:38:39 *** ChanServ sets mode: +o fell
02:32:41 *** fell has quit IRC
03:16:09 *** fell has joined #gnucash
03:16:10 *** ChanServ sets mode: +o fell
03:49:13 *** gjanssens has joined #gnucash
03:49:13 *** ChanServ sets mode: +o gjanssens
04:08:27 *** fell has quit IRC
04:12:55 *** fell has joined #gnucash
04:12:55 *** ChanServ sets mode: +o fell
05:01:34 *** phoenix has joined #gnucash
05:07:24 *** phoenix has quit IRC
05:30:29 *** fabior has joined #gnucash
05:46:31 *** User_ has joined #gnucash
06:47:38 *** User_ has quit IRC
06:57:32 *** oozer has joined #gnucash
07:10:38 *** sbluhm has joined #gnucash
07:10:38 *** ChanServ sets mode: +v sbluhm
07:18:14 *** FoxT has quit IRC
07:24:35 *** FoxT has joined #gnucash
07:28:56 *** Gerd has joined #gnucash
07:30:08 *** sbluhm has quit IRC
07:37:43 <chris> gjanssens there's a glitch in master for report/test -- test-report-html.scm imports stylesheets but report/test/CMakeLists.txt doesn't have it. to fix this glitch, two options: (1) import stylesheets in CMakelists (2) modify test-report-html to test via trivial renderer rather than stylesheet.
07:38:14 <chris> I guess we want to keep purity of report, hence (2) is better?
07:49:58 *** fell has quit IRC
08:18:02 <warlord> .
08:33:50 *** omnireq_ has joined #gnucash
08:34:39 *** omnireq has quit IRC
08:37:27 *** sbluhm has joined #gnucash
08:37:27 *** ChanServ sets mode: +v sbluhm
08:56:32 *** CDB-Man has joined #gnucash
08:56:32 *** ChanServ sets mode: +v CDB-Man
08:58:59 *** CDB-Man_ has quit IRC
09:17:18 *** oozer has quit IRC
09:19:27 *** sbluhm has quit IRC
09:28:32 *** Jimraehl1 has joined #gnucash
09:30:30 *** Jimraehl1 has left #gnucash
09:42:27 *** sbluhm has joined #gnucash
09:43:49 *** jervin has joined #gnucash
09:45:43 *** jervin has quit IRC
10:22:27 *** sbluhm has quit IRC
10:33:12 *** mohave has joined #gnucash
10:33:12 *** mohave_ has joined #gnucash
10:40:34 *** mohave_ has quit IRC
10:40:34 *** mohave has quit IRC
10:46:57 *** chris has quit IRC
10:49:53 *** chris has joined #gnucash
10:49:53 *** ChanServ sets mode: +v chris
10:52:07 *** fabior has quit IRC
11:15:15 *** tienne has joined #gnucash
12:02:12 <jralls> gjanssens, did you see fell's objections to putting saved reports in the book?
12:10:25 *** monkeyjuice has joined #gnucash
12:22:19 *** bertbob has quit IRC
12:27:53 *** bertbob has joined #gnucash
12:27:53 *** ChanServ sets mode: +v bertbob
12:34:46 *** sjk has joined #gnucash
12:39:14 *** oozer has joined #gnucash
12:48:07 <sjk> According to the manual, gnucash can track mutual funds and stocks
12:48:27 <sjk> But does anyone use these features? I'd like to, but it seems so... complicated...
12:50:48 <sjk> perhaps it's a better idea to just do track "regular" transactions in gnucash and use a google sheets spreadsheet for investments
12:59:32 <jralls> sjk: GnuCash can retrieve prices for a variety of securities and maintains a database of price history. It uses those prices to provide a currency value for the account denominated in shares.
13:00:24 <jralls> sjk: It provides other features to account for capital gains and losses, dividends, etc.
13:01:05 <jralls> sjk: I've used these features for many years to help manage multiple large portfolios.
13:02:01 <sjk> jralls: is the support, hmmm, how should I say... geographically agnostic? Eg. would it work just as well for stocks and mutual funds traded in Sweden compared to the US for example?
13:02:14 <sjk> jralls: interesting!
13:02:15 <jralls> sjk: But it's an accounting program, not a trading program. It won't help with evaluating individual security performance.
13:04:41 * sjk nods
13:05:18 <jralls> sjk: If the securities prices are available on Yahoo! or https://alphavantage.com then you can retrieve prices for them. There's also a module for retrieving prices from https://seb.se.
13:06:24 <sjk> A module? As in a perl module?
13:09:39 *** fell has joined #gnucash
13:09:40 *** ChanServ sets mode: +o fell
13:10:08 <jralls> sjk: Yes, a perl module. GnuCash uses perl Finance::Quote for price retrieval
13:13:25 <sjk> Ah, yes. Trying to get that installed (on OS X). The manual says something about a FinanceQuote Update app that should be on the same .dmg as gnucash, but I can't find it... hmm
13:13:41 *** fabior has joined #gnucash
13:13:50 <sjk> oh hold on, I found the gnc-fq-update :)
13:15:11 <jralls> sjk: I had to remove FinanceQuote Update.app in order to pass Apple Notarization. Running gnc-fq-update may work, I had a problem last week getting JSON::Parse to build, maybe because of SIP issues.
13:15:49 <sjk> Ah
13:15:57 <sjk> I'll tell you how it goes, it's building right now. :-)
13:19:34 <sjk> Looks like it installed all right
13:25:37 <jralls> cool.
13:27:12 <sjk> Adding a Security (following the guide), but wondering what "Type" I should use. The docs say "More information can be found in the Help Manual in section 7.7", but section 7.7 seems to be about changing the appearance of invoices :)
13:27:45 <sjk> Oh, it's in 8.7, must've been a typo
13:29:08 <jralls> Whatever you want except "CURRENCY" or "ISO4217". Type (sometimes called "namespace") is a free field, pre-populated with some US stock exchanges.
13:29:28 <sjk> ah yes, I see
13:37:32 *** fabior has quit IRC
13:39:37 <sjk> the Price Editor is now called Price Database, right?
13:40:20 *** sbluhm has joined #gnucash
13:40:20 *** ChanServ sets mode: +v sbluhm
13:43:19 <sjk> Hmm. The abbreviation/symbol for the security puzzles me a bit
13:43:52 <sjk> it must exactly match what's at the quote source
13:45:10 <sjk> Oh, ok, got it.
13:45:30 <sjk> 0P0000X2A9 is the abbreviation to use for https://www.morningstar.se/guide/quicktake?id=0P0000X2A9 , for example
13:51:06 <sjk> Oh
13:51:31 *** omnireq_ has quit IRC
13:52:55 *** omnireq has joined #gnucash
13:53:13 <sjk> When entering a purchase of a mutual fund, do I have to specify the amount of shares in the Shares column, or could gnucash figure that out for me using the date and the sum spent?
13:54:10 <sjk> I'm asking because it'd be essential when doing automatic transactions (eg. buying mutual funds automatically every month)
14:00:50 <jralls> sjk: No. That would work only with open-ended mutual funds where the price for the day is the previous day's closing NAV. For everything else the price you pay is almost never the price you'd get from the exchange, even if you have a real-time quote source.
14:02:17 <sjk> Mm, I see. I was hoping to be able to automate this, but I guess entering the values into gnucash once a month isn't that bad
14:02:29 <jralls> Your best solution for a scheduled transaction would be to set the number of shares as a variable, then the SLR (since-last-run) dialog will ask you for it when it creates the transaction.
14:02:46 <sjk> O_O
14:02:51 <sjk> You can do that?
14:03:46 <sjk> I just recently upgraded to 3.7. I've been using medieval gnucash for years.
14:04:06 <jralls> That's been in GnuCash since at least 2.0.
14:06:08 * sjk is baffled!
14:07:33 *** frakturfreak has joined #gnucash
14:07:33 *** ChanServ sets mode: +v frakturfreak
14:10:33 *** marusich has joined #gnucash
14:10:33 *** ChanServ sets mode: +v marusich
14:25:20 *** sbluhm has quit IRC
14:29:32 <jralls> gjanssens: cstim just provided updates to gwen and aqb for gnucash-on-windows. Shall I echo them to gnucash-on-flatpak?
14:45:31 <sjk> So, I added a stock, but I get "Current Value: 0,00 kr" eventhough the Price Database has an entry for it
14:46:08 <sjk> (and the Price Database entry was obtained using Finance::Quote)
14:46:11 <sjk> any idea what's going on?
14:48:19 <jralls> How many shares are in the account?
14:48:44 <jralls> And what's the price?
14:49:27 <sjk> 21 shares, price 2 718.7000 and "Buy" 57 092.70
14:51:48 <jralls> And the only currency in the book is SEK? Where are you seeing the 0 value?
14:52:17 <jralls> Is the "buy" on the same date as the F::Q price?
14:53:34 <sjk> I'm seeing the 0 value in the lower left hand corner of the 'share account' (does that make sense? I feel I'm not fully up to speed with the terminology... :)
14:53:53 <sjk> It says: Shares: 21 TSLA Current Value: 0,00 kr
14:54:14 <sjk> oh, wait.
14:54:19 <sjk> Riiight.
14:54:44 <jralls> Is that TSLA the US Stock whose manufacturing plant is a couple of miles from my house here in Fremont, CA?
14:54:45 <sjk> The currency in the price database is USD!
14:55:20 <sjk> Yes :)
14:57:12 <sjk> Are you a friend of Elon's? ;)
14:58:17 <jralls> US Stocks are traded in USD. You need an asset account denominated in USD inside your SEK brokerage account with the US stocks under the USD account. After that run get quotes again and it will get the SEK<->USD exchange rate and you'll be able to see values in SEK--though I'm not sure that they'll show up in the status bar.
14:58:47 <jralls> Nah, he's a bit too wild for me!
14:59:13 *** User_ has joined #gnucash
15:00:34 <sjk> Does that mean I have to enter the purchases etc in USD too?
15:05:52 <jralls> Yes.
15:07:28 *** sbluhm has joined #gnucash
15:07:29 *** ChanServ sets mode: +v sbluhm
15:07:38 <sjk> Buh. I pay in SEK and my broker does the exchange to USD etc... but I only see what I pay in SEK
15:07:48 <jralls> Or maybe, it depends. If your broker is actually buying the stock on the US Nasdaq exchange then that's what you want to model: A transfer from your brokerage cash account in SEK to a temporary USD account and then the purchase in USD.
15:09:21 *** User_ has quit IRC
15:09:43 <jralls> If you're actually buying a derivative SEK denominated security based on the US Shares (here they're called "American Depository Receipts" or ADRs) then you want to treat it as an SEK security and find a price source for that.
15:12:48 <sjk> Hm no, I'm quite sure it's actually traded in USD but that my online broker automagically does the exchange and never shows me the numbers in USD
15:12:50 <sjk> hmm
15:13:20 <jralls> If your broker isn't disclosing the USD prices and the USD<->SEK rate he's using you can work it out pretty easily: Even though you can't get the exact USD price you can get the day's range from a variety of financial websites as well as the SEK<->USD exchange rate range (be careful to get *today's* rate; a lot of exchange-rate quotes are for 90-day futures) and check your broker's math.
15:14:19 <sjk> Ah, hold on, checking the transaction list online I see there's a pdf receipt specifying the price in usd!
15:20:13 <sjk> Hm, when fetching quotes in the price database I get this message: "Unable to retreive quotes for these items: CURRENCY:USD"
15:26:00 <jralls> Have you configured an ALPHAVANTAGE_API_KEY?
15:31:17 <jralls> gjanssens: Ubuntu 18.04 has boost 1.65, but it worked when I tested setting C++17 because they've patched boost::locale to fix the auto_ptr issue. It failed on travis because I told cmake to require boost-1.67.
15:35:00 <jralls> gjanssens: So I guess we can still get to C++17, I just need to test if #include <boost/locale.hpp> will compile.
15:35:18 <jralls> gjanssens: Is that sane?
15:36:17 <jralls> sjk: I'm going for a bike ride, be back in a couple of hours.
15:37:55 <sjk> jralls: no, no key.
15:38:03 <sjk> All right, thanks for your help so far and enjoy your ride!
15:52:27 *** monkeyjuice has joined #gnucash
15:53:11 *** monkeyjuice has quit IRC
16:07:25 <gjanssens> jralls: I'm ok with going for C++17 and just testing whether boost/locale.hpp compiles.
16:08:27 <gjanssens> We just have to communicate clearly we have switched to it and that boost needs to compile with c++17 as well (which typically means boost 1.67 or an older version that is patched to be C++17 compatible)
16:08:48 <gjanssens> Re qwen and aqb, please do.
16:09:12 <gjanssens> I'll be mostly afk for the next week so I probably won't be able to push these updates myself.
16:09:58 <gjanssens> Finally re fell's objection to store report options in the file, let's keep this discussion for when I'm back.
16:10:18 <fell> I thought, I had sent the same PR as cstim 2 days ago. Did It not arrive?
16:10:43 <gjanssens> I may not have noticed.
16:11:06 <gjanssens> I just got back at my pc, and am just about to sign off.
16:11:43 <fell> I made also one for Flatpak, but messed up my repo before sending.
16:11:59 *** badger92 has quit IRC
16:12:31 *** gjanssens has quit IRC
16:15:36 *** bertbob has quit IRC
16:22:01 *** badger92 has joined #gnucash
16:39:49 *** guak has joined #gnucash
16:52:28 *** sbluhm has quit IRC
16:57:29 *** Mechtilde has quit IRC
17:06:32 <jralls> sjk: https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
17:09:17 <jralls> fell: So you did. Sorry. I thought that you'd pushed it and saw only your commit for 5.99.35.
17:10:40 <fell> Hi, jralls, no, I have no windows set up to build and run it
17:11:16 <jralls> Oh, OK. Do you want to do the flatpak one?
17:11:36 <fell> You can apply it.
17:12:12 <fell> I got it built recently and just verified, one can start it.
17:16:03 <fell> I am still fighting to get gnucash-on-flatpak's directory structure in eclipse.
17:18:37 <jralls> You mean you want to use Eclipse inside of the flatpak? Is that even supposed to work?
17:20:17 *** guak has quit IRC
17:22:46 <fell> No, to have the git source on the 3. level of the eclipse project.
17:23:30 <fell> ldconfig: /app/lib/libguile-2.2.so.1.3.0-gdb.scm ist keine ELF-Datei - sie weist falsche »magische Bytes« am Beginn auf.
17:24:58 <jralls> I'm not an Eclipse user so I don't know what the 3. level means.
17:24:59 <fell> ... appears only on the first start (wrong magic byte in libuile...gdb.scm)
17:25:22 <fell> of the directory structure.
17:26:16 <jralls> libguile-2.2.so.1.3.0-gdb.scm is probably a gdb (i.e. DWARF) symbols file. The ELF shared library would be libguile-2.2.so.1.3.0.
17:26:38 <jralls> And there should be a symlink to libguile-2.2.so
17:36:35 <sjk> jralls: thanks, that solved it!
17:36:53 <jralls> Wow, that was it?
17:37:06 <jralls> Oh, sorry, wrong solution.
17:37:34 <sjk> Hehe! It fixed the problem of not being able to retrieve quotes for currencies :)
17:38:16 <jralls> sjk: Right. That's because F::Q uses Alphavantage to retrieve currencies, it's hard coded.
17:39:22 * sjk nods
17:53:03 *** frakturfreak has quit IRC
18:10:14 *** User_ has joined #gnucash
18:13:17 *** User_ has quit IRC
19:09:47 *** tienne has quit IRC
19:14:20 *** jervin has joined #gnucash
19:20:10 *** jervin has quit IRC
19:55:52 *** bertbob has joined #gnucash
19:55:52 *** ChanServ sets mode: +v bertbob
20:01:13 *** warlord has quit IRC
21:31:37 *** oozer has quit IRC
21:45:43 *** jervin has joined #gnucash
22:11:58 *** TownsendHardware has quit IRC
22:34:06 *** jervin has quit IRC
22:53:32 *** Gerd1 has joined #gnucash
22:54:08 *** Gerd has quit IRC
22:54:08 *** Gerd1 is now known as Gerd
23:30:05 *** jervin has joined #gnucash