2021-02-12 GnuCash IRC logs
00:00:06 *** AdrienM has joined #gnucash
00:00:06 *** ChanServ sets mode: +v AdrienM
00:08:05 <linas> Heh. I have extensive sysadmin notes. The problem is that the software infrastructure keeps changing. Commands that used to work become obsolete, or they just work differently.
00:11:05 *** ericdm2 has joined #gnucash
00:11:26 *** ericdm has quit IRC
00:11:26 *** ericdm2 is now known as ericdm
01:12:56 *** fell has quit IRC
01:14:14 *** fell has joined #gnucash
01:14:14 *** ChanServ sets mode: +o fell
01:16:45 *** David has quit IRC
01:16:55 *** David has joined #gnucash
01:17:44 *** Mechtilde has joined #gnucash
01:35:52 *** sbluhm has joined #gnucash
01:47:44 *** dtux has quit IRC
01:49:58 *** frakturfreak has quit IRC
02:04:18 *** frakturfreak has joined #gnucash
02:39:08 *** ericdm has quit IRC
02:39:17 *** ericdm has joined #gnucash
03:27:52 *** qwer has joined #gnucash
03:40:22 *** jervin has quit IRC
03:40:54 *** jervin has joined #gnucash
04:02:11 *** fabior has joined #gnucash
04:06:43 *** PowaBanga has quit IRC
04:08:00 *** PowaBanga has joined #gnucash
04:15:32 *** PowaBanga has quit IRC
04:22:52 *** PowaBanga has joined #gnucash
04:27:44 *** fabior has quit IRC
04:31:54 *** PowaBanga has quit IRC
04:32:57 *** PowaBanga has joined #gnucash
04:41:29 *** chris has joined #gnucash
04:41:29 *** ChanServ sets mode: +v chris
04:41:29 *** gncbot sets mode: +o chris
04:54:08 *** fabior has joined #gnucash
05:05:51 *** fabior has quit IRC
05:21:59 *** Aussie_matt has quit IRC
05:23:11 *** fabior has joined #gnucash
06:09:39 *** fabior has quit IRC
06:15:16 *** sbluhm has quit IRC
06:15:44 *** Aussie_matt has joined #gnucash
06:32:34 *** Guest55 has joined #gnucash
06:32:49 <Guest55> Hi!
06:33:26 <Guest55> I have a question about GetAccountBalanceAsOfDate() from the API:
06:34:40 <Guest55> I have been using it to calculate performance of stock prices in my account, but I see that it doesn't seem to respect the prices of the underlying instruments.
06:36:00 <Guest55> I download the prices of the instruments (mostly) daily from alphavantage, but I see that the value of a stock account as returned by GetAccountBalanceAsOfDate() seems to use (I think) only the most recent price
06:37:30 <Guest55> (sorry, it's called GetBalanceAsOfDate() )
06:38:59 <Guest55> looking at the code, it seems to just iterate over the splits in an account until the cutoff date arg is reached, and then asks the most recent split what its balance is
06:39:45 <Guest55> which is fine if the value of the underlying commodity of that account doesn't change, but doesn't make sense if it's something like a stock which does.
06:41:16 <Guest55> Is there a better way to do this? I couldn't find any mentions on bugzilla relating to GetBalanceAsOfDate(), so maybe I'm just using the wrong function for this.
06:59:12 <chris> is this the python API?
07:00:54 <Guest55> yes
07:05:06 <Guest55> Ah, I see there is a function GetBalanceAsOfDateInCurrency(), I wonder if that would work if I passed a stock as the currency?
07:05:35 <Guest55> looking at the C++ code it just accepts a commodity, doesn't have to be a currency I suppose
07:05:38 *** puck has quit IRC
07:07:17 <Guest55> (not ideal for stocks in currencies other than the base currency though if that's the case)
07:08:32 *** puck has joined #gnucash
07:31:49 *** chris-phone has joined #gnucash
07:31:49 *** ChanServ sets mode: +v chris-phone
07:34:27 <chris-phone> Guest55 the basic API should return number of stock units rather than the dollar valuation
07:46:10 <Guest55> ugh sorry
07:46:17 <Guest55> I was looking at the wrong bit of code
07:46:29 <Guest55> I'm in fact using GetBalanceAsOfDateInCurrency()
07:46:51 <Guest55> (been a while since I wrote this)
07:50:18 <Guest55> but I see this uses GetBalanceAsOfDate() under the hood to look that up
07:51:39 <Guest55> I'll experiment using GetBalanceAsOfDateInCurrency with the stock as the currency, maybe that will work
07:55:29 <chris-phone> What exactly do you wish to achieve
08:02:38 <Guest55> the (dollar) value of a stock account over time
08:03:52 <Guest55> so, say I have 10 lots MSFT which I bought at a price of 100USD and hold for a year, and also download price updates of MSFT for a year, I'd like to see how the value of my 10 lots changes over that time
08:08:09 *** chris-phone has quit IRC
08:08:20 *** chris-phone has joined #gnucash
08:08:20 *** ChanServ sets mode: +v chris-phone
08:10:10 *** gjanssens has joined #gnucash
08:10:10 *** ChanServ sets mode: +o gjanssens
08:28:50 <chris> Guest55: this is difficult because (1) the account's balance will vary over time (2) price values vary over time. You'll need to traverse both lists, tallying the balances over timeperiod (eg monthly), then use nearest pricedb entry to get a fair valuation
08:33:40 <chris> more complications: stock-splits sets the new price upon split, but the pricedb-nearest for balance *before* stock-split will pick up the new price
08:44:43 <Guest55> indeed, sounds tricky
08:44:54 <Guest55> I'll have a go though
08:44:59 <Guest55> thanks a lot for the help
08:45:56 <chris> you're welcome!
08:50:12 *** chris-phone has quit IRC
08:55:05 *** Jimraehl1 has joined #gnucash
08:55:32 <warlord> linas, serial number should be YYYYMMDDVV ... :)
08:55:51 *** Jimraehl1 has quit IRC
08:57:24 <warlord> Guest55, that API will return the total number of stocks (or foreign currency) as of that date. Then you need to convert that to whatever currency you wish using the PriceDB.
08:58:12 <Guest55> yeah got it, thanks
08:58:42 <warlord> sorry, catching up and responding to older messages before finishing the conversation.
08:58:48 <warlord> At least chris and I are in agreement ;)
08:58:56 <Guest55> indeed :-)
09:01:15 <chris> I taught warlord well
09:02:52 <warlord> LOL
09:25:30 *** Guest55 has quit IRC
09:47:23 *** mikey has quit IRC
09:48:51 *** jervin has quit IRC
09:49:08 *** jervin has joined #gnucash
09:57:18 *** mikey has joined #gnucash
09:57:19 *** ChanServ sets mode: +v mikey
10:06:34 *** Aussie_matt has quit IRC
10:42:04 *** mydogsnameisrudy has joined #gnucash
10:47:42 *** jervin has joined #gnucash
10:52:34 *** mydogsnameisrudy has quit IRC
10:56:48 *** jervin has quit IRC
11:01:55 *** jcarl43 has joined #gnucash
11:01:55 *** ChanServ sets mode: +v jcarl43
11:05:05 *** ArtGravity has joined #gnucash
11:05:05 *** ChanServ sets mode: +v ArtGravity
11:14:25 *** suukim has joined #gnucash
11:20:10 *** bertbob has quit IRC
11:25:47 *** mydogsnameisrudy has joined #gnucash
11:25:57 *** bertbob has joined #gnucash
11:25:58 *** ChanServ sets mode: +v bertbob
11:31:33 *** bertbob has quit IRC
11:36:41 *** guak has joined #gnucash
11:39:16 *** mydogsnameisrudy has quit IRC
11:45:49 *** bertbob has joined #gnucash
11:45:50 *** ChanServ sets mode: +v bertbob
11:51:27 *** bertbob has quit IRC
11:54:22 *** bertbob has joined #gnucash
11:54:22 *** ChanServ sets mode: +v bertbob
11:56:16 *** David has quit IRC
11:56:34 *** David has joined #gnucash
12:34:32 *** bertbob has quit IRC
12:44:21 *** bertbob has joined #gnucash
12:44:21 *** ChanServ sets mode: +v bertbob
12:56:41 *** field^Mop has joined #gnucash
13:07:59 *** bertbob has quit IRC
13:14:37 *** suukim has quit IRC
13:20:00 *** bertbob has joined #gnucash
13:20:01 *** ChanServ sets mode: +v bertbob
13:21:44 *** sbluhm has joined #gnucash
13:24:00 *** bertbob has quit IRC
13:27:16 *** jervin has joined #gnucash
13:38:50 *** jervin has quit IRC
13:48:40 *** bertbob has joined #gnucash
13:48:40 *** ChanServ sets mode: +v bertbob
14:23:14 *** sbluhm has quit IRC
14:29:49 *** sbluhm has joined #gnucash
14:29:49 *** ChanServ sets mode: +v sbluhm
14:34:58 *** truelehr has joined #gnucash
14:40:18 *** sbluhm has quit IRC
14:43:54 *** mydogsnameisrudy has joined #gnucash
14:49:03 *** truelehr has quit IRC
14:50:07 *** sbluhm has joined #gnucash
14:50:07 *** ChanServ sets mode: +v sbluhm
15:04:21 *** sbluhm has quit IRC
15:05:51 *** mydogsnameisrudy has quit IRC
15:44:57 *** Mechtilde has quit IRC
15:45:41 *** field^Mop has quit IRC
16:02:37 *** mydogsnameisrudy has joined #gnucash
16:02:37 *** jw4 has quit IRC
16:03:04 *** jw4 has joined #gnucash
16:03:38 *** mydogsnameisrudy has quit IRC
16:07:17 *** qwer has quit IRC
16:33:37 *** jervin has joined #gnucash
17:03:15 *** Pegasus_RPG has joined #gnucash
17:30:20 *** gjanssens has quit IRC
17:46:20 *** User_ has joined #gnucash
17:53:20 *** flips has quit IRC
17:53:29 *** flips has joined #gnucash
17:53:30 *** ChanServ sets mode: +v flips
18:06:50 *** KaiForce has quit IRC
18:06:53 *** User_ has quit IRC
18:10:36 *** User_ has joined #gnucash
18:13:13 <fell> jralls, you saw: Error on line 192 in C:\gcdev64\gnucash\maint\gnucash.iss: No files found matching "C:\gcdev64\msys2\mingw32\lib\mariadb\plugin\*" Compile aborted. Cannot rename because item at 'C:\gcdev64\gnucash\maint\gnucash-4.4.setup.exe' does not exist. C:\gcdev64\gnucash\maint\gnucash-4.4-2021-02-12-git-4.4-186-g6e135537b+.setup.exe
18:30:23 <jralls> fell, Yes. I've already pushed a fix.
18:30:46 <fell> OK
18:34:00 *** jervin has quit IRC
19:10:26 *** User_ has quit IRC
19:12:19 *** David has quit IRC
19:12:38 *** David has joined #gnucash
19:39:06 *** jcarl43 has quit IRC
20:24:05 <fell> jralls, Martin fulfilled your wish. :-)
20:48:01 *** Agfarmer18 has joined #gnucash
20:52:35 *** Agfarmer18 has quit IRC
20:55:24 *** mikey has quit IRC
20:56:21 *** mikey has joined #gnucash
20:56:21 *** ChanServ sets mode: +v mikey
21:39:31 *** guak has quit IRC
22:24:09 *** bertbob has quit IRC
22:37:38 *** bertbob has joined #gnucash
22:37:38 *** ChanServ sets mode: +v bertbob
22:38:44 *** storyjesse has joined #gnucash
23:00:02 *** Aussie_matt has joined #gnucash
23:12:23 *** ArtGravity has quit IRC