2020-05-28 GnuCash IRC logs

00:55:12 *** Mechtilde has joined #gnucash
01:18:26 *** sbluhm has joined #gnucash
01:18:26 *** ChanServ sets mode: +v sbluhm
01:23:51 *** fell has quit IRC
01:25:11 *** fell has joined #gnucash
01:25:12 *** ChanServ sets mode: +o fell
01:37:09 *** Han has joined #gnucash
01:38:18 *** lmat has quit IRC
01:39:41 *** lmat has joined #gnucash
01:49:16 *** Trel has quit IRC
01:49:31 *** suukim has joined #gnucash
01:49:50 *** hussam has quit IRC
01:50:45 *** hussam has joined #gnucash
01:50:45 *** ChanServ sets mode: +v hussam
02:01:20 *** Trel has joined #gnucash
02:02:34 *** storyjesse has quit IRC
02:23:50 *** Mechtilde has quit IRC
03:26:24 *** gjanssens has joined #gnucash
03:26:24 *** ChanServ sets mode: +o gjanssens
03:26:34 <gjanssens> .
03:26:34 <gncbot> gjanssens: Sent 3 hours and 57 minutes ago: <jralls> I beat it into submission with the May 2019 installer but I had to do the pacman -Syuu by hand and kill a bunch of hung pacman jobs. Once I got the install done Guile built OK but GnuCash is failing because cmake's FindPkgConfig is failing.
04:05:19 *** Mechtilde has joined #gnucash
04:49:34 <chris> gjanssens: I think my cli-reports is ready. feel free to steal when you're ready.
04:50:44 *** keiffer has joined #gnucash
06:10:16 *** lmat has quit IRC
06:18:24 *** lmat has joined #gnucash
06:21:58 *** Aussie_matt has quit IRC
06:31:50 *** YeOldHinnerk has joined #gnucash
06:34:00 <YeOldHinnerk> Hi. Still struggling with online price retrieval, I can't find proper sources. I decided to have some US equity in USD, which closed the issue for one stock. But I also have an australian index etf, issued by lyxor. And an ETF on brent futures, which I can not find. Both are denoted in EUR and traded e.g. at Stuttgart stock exchange.
06:34:36 <YeOldHinnerk> Which would be my best chances? I tried Yahoo JSON, Alphavantage, Vanguard, Deka and maybe more that I already forgot.
06:36:11 <YeOldHinnerk> (and it is quite a clicking orgy to test this. Maybe the security editor and the online price retrieval could be linked better, but haven't thought about a solution yet)
06:36:55 <YeOldHinnerk> (e.g.. adding a "Retrieve prices now" button to the window that allows editing/creating of securities)
06:38:41 <YeOldHinnerk> (and adding a "Edit security" button to the online price retrieval)
06:45:50 *** Jimraehl1 has joined #gnucash
06:46:34 *** User_ has joined #gnucash
06:47:01 *** Jimraehl1 has quit IRC
06:58:01 *** Aussie_matt has joined #gnucash
07:00:10 *** lmat has quit IRC
07:01:07 *** lmat has joined #gnucash
07:08:21 <gjanssens> chris: I hope get my gnucash-cli work ready for merging today
07:20:40 *** Han has quit IRC
07:24:18 <YeOldHinnerk> Other question: I have two equities denoted in USD and retrieve the price in USD. I have an account for this and bought a certain amount. I paid in EUR. How to enter? I just did it as I would with EUR - however, I do not see a booking line in the corresponding cash account
07:24:40 <YeOldHinnerk> How to handle the currency conversion?
07:30:18 <YeOldHinnerk> more precise: the booking is shown, but without any values in the cash account. It looks ok in the stock's account.
07:30:44 <YeOldHinnerk> I see all values I entered there and I did this exactly as I would with EUR stocks.
08:15:30 *** lmat has quit IRC
08:16:14 *** lmat has joined #gnucash
08:27:35 *** lmat has quit IRC
08:29:22 <YeOldHinnerk> It seems I'm struggling with a "double" fx conversion. I buy a stock denoted in USD, however I pay with EUR. I have the transaction to increase Currency EUR, decrease FX of the Stock and corresponding parts for the cash account and the stock account. But in the currency account EUR, the value does not show.
08:29:32 <YeOldHinnerk> Do I first need to convert it to USD?
08:30:43 *** lmat has joined #gnucash
08:38:07 <YeOldHinnerk> I guess I don't really understand how to book this.
08:38:56 <YeOldHinnerk> It works for EUR denoted equities, but for that alone, I would not need the currency conversion.
08:39:32 <YeOldHinnerk> My understanding is that this is how I would book a buy of equity denoted in USD for which I paid in EUR:
08:39:48 <YeOldHinnerk> Cash account -1000 EUR
08:39:56 <YeOldHinnerk> Currency:EUR +1000
08:40:20 <YeOldHinnerk> Currency:Equity(USD) -50
08:40:35 <YeOldHinnerk> Assets:Equity(USD) +50
08:41:12 *** tonysoar has joined #gnucash
08:41:15 <YeOldHinnerk> But the currency:eur line is not accepted. GC always changes that to "Ausgleichskonto-EUR"
08:48:26 <YeOldHinnerk> What am I doing wrong?
08:59:01 *** Mike has joined #gnucash
08:59:50 *** suukim has quit IRC
08:59:58 <YeOldHinnerk> This is what I enter in my cash account: https://imgur.com/a/XyoA8z9
09:00:30 <YeOldHinnerk> and this is what it is changed to as soon as I hit enter: https://imgur.com/a/xmcg93z
09:01:26 <warlord> YeOldHinnerk, What are the account types and currencies of those accounts? In what account/register are you entering this transaction? And how are you going between the lines?
09:02:03 *** suukim has joined #gnucash
09:04:13 <YeOldHinnerk> ... Bankgebühren is EUR, normal expenses account
09:04:55 <YeOldHinnerk> ...Depot:USD:Aktien:Amarin is a stock account with currency of the corresponding security. Its price is retreived in USD.
09:05:26 <YeOldHinnerk> ...Cashkonto is a regular cash account in EUR, meaning in assets.
09:05:43 <YeOldHinnerk> the Devisenhandel accounts were automically generated by GC
09:06:14 *** Mike has quit IRC
09:06:24 *** Mike has joined #gnucash
09:06:35 *** Mike has quit IRC
09:06:45 <YeOldHinnerk> Going between lines: Yes, now that I check, that is a bit interesting. On hitting enter, I get an error about an unbalanced booking (which it doesn't appear to be). Automatic correction fails.
09:07:45 <YeOldHinnerk> If I go to the next line by hitting the arrow down button, the "Devisenhandel:CURRENCY:EUR amount is blanked and an "Ausgleichskonto-EUR" line is added with the same amount as I entered before in the DEvisenhandel account
09:07:55 <YeOldHinnerk> as seen in the second pic
09:09:07 <warlord> Is this an existing transaction you are editing? Or a completely new transaction?
09:09:20 *** GM_Books has joined #gnucash
09:09:32 <warlord> What is the currency of the parent account of Depot:USD:Aktien:Amarin?
09:09:45 <warlord> And in which account/register are you entering this transaction?
09:10:22 <YeOldHinnerk> in the register of the cash account
09:10:35 *** GM_Books has quit IRC
09:11:21 <YeOldHinnerk> the parent acc of Depot:USD:Aktien:Amarin is in USD. Is that correct? Should I change that to EUR?
09:11:37 <warlord> Also note those little [x] boxes? That means the transaction is not (yet) balanced and GnUCash is waiting for you to balance it. If you hit ENTER, it will auto-balance it.
09:11:56 <YeOldHinnerk> ah, was wondering what thos meant :)
09:13:38 <warlord> It means "you're not balanced! Fix it!"
09:13:48 <YeOldHinnerk> but how.
09:14:03 <warlord> That depends on how it's NOT balanced.
09:14:10 <YeOldHinnerk> that is the master question. If you look at the first pic, it does seem balanced
09:14:42 <warlord> But if the AMRN is in USD -- it might not be
09:15:02 <YeOldHinnerk> How is the difference handled?
09:15:13 <YeOldHinnerk> GC has all the prices.
09:15:56 <warlord> The issue is that because the parent is USD, gnucash is expecting that SPLIT to be denoted in USD. But you're trying to balance it in EUR -- which means there is an imbalance based on USD<->EUR
09:16:48 <warlord> But no idea why it's entering an empty split.
09:16:54 <YeOldHinnerk> I switched the parent account of Depot:...:Amarin to EUR.. No diff.
09:24:43 <YeOldHinnerk> I completly reentered the transaction, with parent accs set to EUR, letting GC add the devidenhandel lines. Now it seems to work...
09:25:52 <YeOldHinnerk> entered in the stocks register, not sure if that was the clue.
09:30:26 <YeOldHinnerk> Potential follow up issue: Now I have EUR and USD prices in my price databse for the same stock. Is that an issue?
09:30:59 *** tonysoar has quit IRC
09:32:19 <warlord> I don't know.
09:32:28 <warlord> It may be. It might not be. It shouldn't be.
09:34:15 <YeOldHinnerk> However the asset account shows in "Aktuell (EUR)" not the current market price, but the buy price.
09:34:40 <YeOldHinnerk> even though there are younger prices in usd in the db.
09:36:59 *** Aussie_matt has quit IRC
09:39:40 <YeOldHinnerk> Seems to me, that since the parent acc is now in EUR, the prices for the assets are taken from the same currency, not USD and converted. If it doesn't find a recent EUR price, it takes the last one available, which is the transaction price.
09:40:16 <YeOldHinnerk> When I had the parents account in USD, the "Aktuell (EUR)" would show the correct market value in EUR.
09:40:38 <YeOldHinnerk> (but the booking wasn't balanced, as explained above)
09:42:00 <warlord> Get new prices in EUR into your PriceDB
09:42:28 <YeOldHinnerk> I can do so to test it, but I don't find the prices in EUR anywhere from online...
09:46:10 *** sbluhm has quit IRC
09:47:34 <warlord> How are you transacting with the brokerage in EUR if the stock isn't denoted in EUR somewhere?
09:49:36 <YeOldHinnerk> well, it is with my broker. I just do not have an online price source for GC which lists it in EUR.
09:50:10 <chris> gjanssens: ok my cli not ready yet, export not yet bugfree
09:57:37 <warlord> YeOldHinnerk, I suspect Yahoo has something.
09:58:49 <YeOldHinnerk> tried for several days.
09:59:00 <YeOldHinnerk> yahoo has it in us, symbol is AMRN
09:59:13 <YeOldHinnerk> doesnt work with extensions .DE .S .SU .SG
09:59:16 <YeOldHinnerk> .F
10:00:06 <YeOldHinnerk> would love to set it all up in eur and not having to mess with fx
10:00:29 <YeOldHinnerk> it's not, as if i am actually converting cash to usd and then buy the shares
10:02:13 <YeOldHinnerk> I also checked with vaious other sources
10:02:34 <YeOldHinnerk> alphavantage and quite a few others
10:02:59 <YeOldHinnerk> alphavantage seem to exclusively to USD?
10:05:55 <YeOldHinnerk> nasdaq has it in usd
10:06:14 <YeOldHinnerk> it's not traded a whole lot in europe
10:09:13 <YeOldHinnerk> so i am back to my sources issue
10:09:32 <YeOldHinnerk> i guess i could enter prices manually
10:09:43 <YeOldHinnerk> currently, it is only two stocks
10:12:24 <chris> gjanssens: cli reports fixed.
10:12:34 *** omnireq__ has quit IRC
10:37:52 *** Mechtilde has quit IRC
10:54:00 <fell> YeOldHinnerk: "Devisenhandel" ist die deutsche Bezeichnung für "Currency" accounts.
10:55:28 <fell> Diese solltest du normalerweise nicht von Hand bearbeiten. Die sie betreffenden Buchungsteile werden automatisch erstellt.
10:57:19 <fell> Zur Suche von Quellen: Idealerweise haben international gehandelte Papiere eine ISIN.
10:58:18 <fell> Wenn du die googlest, ist *meist* eine brauchbare Quelle dabei.
11:01:45 <fell> Wenn du z.B. exotische Papiere von karibischen Fond-Gesellschaften (Panama-Papers) hast, müstest du erstmal ein F::Q-MOdul für derenn Website bauen. Würde mich übrigens freuen, wenn du das dann über F::Q teilen würdest. ;-)
11:19:03 *** omnireq has joined #gnucash
11:36:13 *** Mechtilde has joined #gnucash
11:39:37 *** ArtGravity has joined #gnucash
11:39:38 *** ChanServ sets mode: +v ArtGravity
11:44:34 *** Mechtilde has quit IRC
11:47:23 *** omnireq has quit IRC
11:49:21 *** omnireq has joined #gnucash
11:49:21 *** ChanServ sets mode: +v omnireq
11:51:36 <YeOldHinnerk> ISIN habe ich, aber wonach google ich, um eine Qulle zu finden? Wie gesagt finde ich die Aktie in yahoo in USD, aber nicht in EUR. Also nicht so exotisch....
11:54:38 <fell> YeOldHinnerk: Ich habe gerade extra für dich https://wiki.gnucash.org/wiki/De/Aktienhandel#Beispiel:_Buchung_in_Fremdw.C3.A4hrung_notierte_Papiere_f.C3.BCr_EUR_gekauft geschrieben. :-)
11:54:48 <YeOldHinnerk> oh
11:55:39 <fell> Du darfst das gern noch aus bauen, auch da, wo wir sonst noch Unkllarheiten beseitigt haben.
11:57:29 <fell> Ich google die ISIN und gehe die Suchergebnisse durch bis ich eins habe, für das es ein F::Q-Modul gibt.
11:58:50 <fell> Dann teste ich das mit z. B. 'gnc-fq-dump -v yahoo_json AMRN'
11:59:27 *** Mechtilde has joined #gnucash
11:59:39 <fell> Wenn das klappt, gebe ich die Quelle im Wertpapier-Editor an.
11:59:44 <YeOldHinnerk> zum Wiki: D.h. ich muss die Aktie erst in $ einbuchen, dann eur in usd tauschen? und den wert in usd bekomme ich woher? muss ich also alle beträge selbst eintragen oder kommt irgendwo automatisch eine kursumrechnung?
12:00:26 <fell> Die sollten irgendwo au deinem Kaufbeleg stehen.
12:00:40 <YeOldHinnerk> da stehen ja nur EUR :)
12:00:48 <YeOldHinnerk> mein broker kauft die ja in stuttgart
12:01:09 <YeOldHinnerk> oder wo auch immer
12:03:12 *** sbluhm has joined #gnucash
12:03:12 *** ChanServ sets mode: +v sbluhm
12:03:33 <fell> Von der Sparkasse oder Volksbank krieg ich immer seitenlange Belege. Mit Online-Brokern kenne ich mich nichgt aus.
12:05:30 <YeOldHinnerk> die werden ja in deutschland auch gehandelt, also in eur. hat nix mit online zu tun.
12:05:58 <YeOldHinnerk> das problem ist nur, ich finde keine f:q datenquelle, die die in eur führt, in usd schon
12:07:05 *** Couto[m] has quit IRC
12:07:08 *** peter-butler[m] has quit IRC
12:07:08 *** ElonSatoshi[m] has quit IRC
12:07:09 *** Julianold[m] has quit IRC
12:07:10 *** cybertani[m] has quit IRC
12:07:10 *** sunyibo[m] has quit IRC
12:07:11 *** MatrixTravelerbot[m] has quit IRC
12:07:12 *** luwum[m] has quit IRC
12:07:12 *** mmkodali[m] has quit IRC
12:08:22 <fell> Was kommt denn raus, wenn du Aktie[USD] und EUR:USD für den Kauftag abrufst und mit deinem gezahlten Preis vergleichst.
12:08:27 *** sbluhm has quit IRC
12:08:47 *** luwum[m] has joined #gnucash
12:09:18 *** jervin has quit IRC
12:12:09 *** bertbob has quit IRC
12:14:08 <YeOldHinnerk> fell, sicherlich etwas anderes. muss jetzt aber erstmal weg... danke fürs mitdenken
12:15:29 *** bertbob has joined #gnucash
12:15:29 *** ChanServ sets mode: +v bertbob
12:18:58 *** storyjesse has joined #gnucash
12:19:47 *** guak has joined #gnucash
12:26:32 <fell> Mechtilde, ich sehe gerade, ab https://code.gnucash.org/docs/C/gnucash-guide/invest-stockprice1.html#invest-stockprice-report gab es diverse Änderungen in dem Kapitel seit deiner Übersetzung.
12:31:15 <Mechtilde> fell, pong
12:31:33 *** MatrixTravelerbot[m] has joined #gnucash
12:31:34 *** cybertani[m] has joined #gnucash
12:31:35 *** Couto[m] has joined #gnucash
12:31:35 *** Julianold[m] has joined #gnucash
12:31:35 *** peter-butler[m] has joined #gnucash
12:31:36 *** sunyibo[m] has joined #gnucash
12:31:36 *** ElonSatoshi[m] has joined #gnucash
12:31:37 *** mmkodali[m] has joined #gnucash
12:31:39 <Mechtilde> das schaffe ich aber nicht bis zur nächsten Version
12:35:52 <jralls> gjanssens, my clean win7 build problem yesterday turns out to have been due to a failure to retrieve the signature for webkit. Once I rectified that by hand there's a cmake update today so I had to re-patch FindSWIG.cmake. Now GnuCash is at least building...
12:36:28 <jralls> gjanssens, where did guile fail for you?
12:40:36 <gjanssens> jralls: It errorred out while SNARFing expand.doc
12:40:56 <gjanssens> Error message was multiple definitions of mktime_internal
12:41:18 <gjanssens> I'll see if I can restart a build, but probably not for tonight :(
12:41:36 <jralls> That sounds like it didn't autoreconf after patching mktime.m4.
12:42:14 <gjanssens> Possibly, though I *thought* I had also tried wipe and rebuild on guile.
12:42:20 <gjanssens> It was late though so maybe I didn't
12:43:19 <jralls> You could cd /c/gcdev64/gnucash/master/src/guile-2.2.4-xxx && autoreconf -fi
12:43:57 <jralls> Or delete both the source and build dirs before restarting the build.
12:45:09 <jralls> My comment about 2.2.7 is about getting that to build so that windows is on the latest (and I think last) guile 2.2 release.
12:45:54 <gjanssens> Ok
12:47:57 <jralls> What's really strange is that a build from git works just fine but a build from the tarball crashes with a messed-up path trying to generate guile-procedures.texi.
13:09:39 *** sbluhm has joined #gnucash
13:09:39 *** ChanServ sets mode: +v sbluhm
13:32:07 *** storyjesse has quit IRC
13:32:10 *** angel has joined #gnucash
13:39:39 *** sbluhm has quit IRC
13:43:29 *** lennox has joined #gnucash
13:44:34 *** lennox_ has joined #gnucash
13:51:01 *** lennox_ has quit IRC
13:51:13 *** lennox has quit IRC
14:14:59 *** frakturfreak has joined #gnucash
14:21:31 *** sbluhm has joined #gnucash
14:21:31 *** ChanServ sets mode: +v sbluhm
14:45:16 <jralls> gjanssens mingw64 upgraded ICU to 67 so I need to rebuild webkit.
14:50:26 *** angel has quit IRC
15:04:30 *** fell has quit IRC
15:07:40 *** fell has joined #gnucash
15:07:40 *** ChanServ sets mode: +o fell
15:13:47 *** PowaBanga has quit IRC
15:14:55 *** PowaBanga has joined #gnucash
15:25:01 *** suukim has quit IRC
15:45:31 *** sbluhm has quit IRC
16:01:05 *** Mechtilde has quit IRC
16:18:52 <gjanssens> jralls: poor timing :(
16:19:14 <jralls> No kidding.
16:20:17 <gjanssens> chris: I didn't manage to finish it this evening, but I still have tomorrow morning available. That should be enough to get a rough first implementation ready
16:21:19 <jralls> Maybe we could just stuff chris's in and call that the rough first implementation.
16:21:51 <jralls> Or is your's different enough that calling the changes bugs would be pushing things?
16:25:32 <gjanssens> It probably would. I have converted gnucash-bin into a class hierarchy...
16:26:23 <gjanssens> If you want to see my work so far, I have just pushed it to https://github.com/gjanssens/gnucash/tree/gnucash-cli
16:27:34 <gjanssens> It's almost there. I still want to tweak the final step of running the application(s), which is the part that decides what to do (fetch quotes, run reports,...)
16:27:52 <gjanssens> Then after this weekend's release I can continue polishing.
16:27:56 *** sbluhm has joined #gnucash
16:27:56 *** ChanServ sets mode: +v sbluhm
16:28:03 <gjanssens> Got to go now.
16:28:08 <gjanssens> Good night!
16:28:09 <jralls> G'night.
16:29:45 *** gjanssens has quit IRC
16:40:11 *** User_ has quit IRC
17:02:26 *** sbluhm has quit IRC
17:10:28 *** frakturfreak has quit IRC
17:10:42 *** Simon has quit IRC
17:11:19 *** Simon has joined #gnucash
17:11:19 *** ChanServ sets mode: +v Simon
17:13:33 <jralls> @tell gjanssens Note on boost::program_options, it seems not to be documented but a look at the sources shows that it signals its errors by throwing so you need try-catch blocks around everything.
17:13:33 <gncbot> jralls: The operation succeeded.
17:22:42 *** jervin has joined #gnucash
17:32:40 *** o01eg has quit IRC
17:40:46 *** keiffer has quit IRC
18:47:36 *** phoenix has joined #gnucash
18:56:40 *** phoenix has quit IRC
19:13:21 *** phoenix has joined #gnucash
19:19:12 *** omnireq has quit IRC
19:23:55 *** Aussie_matt has joined #gnucash
19:24:28 *** Aussie_matt_ has joined #gnucash
19:37:47 *** ArtGravity has quit IRC
19:37:58 *** phoenix has quit IRC
19:55:53 *** chf has quit IRC
19:57:16 *** chf has joined #gnucash
20:10:54 *** phoenix has joined #gnucash
20:25:11 *** phoenix has quit IRC
20:25:33 *** phoenix_ has joined #gnucash
20:28:14 *** guak has quit IRC
20:28:39 *** phoenix_ has quit IRC
20:34:13 *** phoenix has joined #gnucash
20:38:08 *** phoenix has quit IRC
20:40:00 *** Aussie_matt has quit IRC
21:17:06 *** omnireq has joined #gnucash
21:29:01 <fell> jralls, did you sent holtermann the desired gnucash.pot? Else I will create it now.
21:45:41 *** YeOldHinnerk has quit IRC
22:39:04 *** Gerd1 has joined #gnucash
22:39:40 *** Gerd has quit IRC
22:39:40 *** Gerd1 is now known as Gerd
22:47:16 *** jervin has quit IRC
22:51:36 *** jervin has joined #gnucash
22:59:41 *** fell has quit IRC
23:00:02 *** fell has joined #gnucash
23:00:02 *** ChanServ sets mode: +o fell
23:57:49 *** omnireq has quit IRC