2013-09-28 GnuCash IRC logs
02:06:11 *** fell has joined #gnucash
02:06:12 *** gncbot sets mode: +o fell
04:10:01 *** john has quit IRC
06:39:28 *** fell_ has joined #gnucash
06:39:29 *** gncbot sets mode: +o fell_
06:44:39 *** fell has quit IRC
07:01:43 *** TradeBorG has joined #gnucash
07:01:49 *** fell_ is now known as fell
08:09:01 *** Jimraehl1 has left #gnucash
08:39:16 *** Jimraehl1 has joined #gnucash
09:16:15 *** Ard0nik has joined #gnucash
09:25:21 *** Caesar has quit IRC
10:42:55 *** fell has quit IRC
10:56:04 *** fell has joined #gnucash
10:56:04 *** gncbot sets mode: +o fell
11:02:43 *** fell has quit IRC
11:04:08 *** fell has joined #gnucash
11:04:10 *** gncbot sets mode: +o fell
11:28:40 *** aqua___ has joined #gnucash
11:30:17 *** Ard0nik has quit IRC
11:31:03 *** Ard0nik has joined #gnucash
11:42:20 *** ErKa has joined #gnucash
11:54:36 *** Caesar has joined #gnucash
12:03:54 *** Ard0nik has quit IRC
12:05:10 *** Topcat has joined #gnucash
12:07:52 *** Topcat has quit IRC
12:19:34 *** aqua___ has quit IRC
12:27:41 *** aqua___ has joined #gnucash
12:35:23 *** aqua___ has quit IRC
12:48:25 *** Caesar has quit IRC
12:48:30 *** Caesar has joined #gnucash
12:57:18 *** hamid has joined #gnucash
13:03:18 <hamid> Hi, I am new to gnucash
13:03:39 <hamid> I am trying to setup loan repayment scheduled transaction
13:04:08 <hamid> but since I am trying to setup a Canadian mortgage, I am trying to use custom formula
13:04:38 <hamid> How do I test if the formula I entered is giving me correct value?
14:08:46 *** fuzzybun_ has joined #gnucash
14:08:47 *** hamid has quit IRC
14:08:53 *** hamid has joined #gnucash
14:11:40 *** fuzzybunny69y has quit IRC
14:11:41 *** fuzzybun_ is now known as fuzzybunny69y
14:15:44 *** aqua___ has joined #gnucash
14:20:03 <warlord> hamid: what kind of custom formula are you trying to enter? Does the M&L Druid not work for you?
14:21:21 <hamid> cpd_pmt( 0.03090 : 12:12: 300.00 : 404430.00 : 0 : 0 ) + 383.32
14:22:20 <hamid> M&L Druid gave me the formula which was just normal pmt
14:27:35 <warlord> Right, it's not going to know about anytihng else..
14:28:09 <warlord> What's the "+383.32"? I'm guessing escrow?
14:28:23 <hamid> yes, thats the property tax
14:28:46 <warlord> What's the 12:12 ?
14:29:12 <hamid> I am trying to test directly using scheme, but I am not very familiar with the language
14:29:41 <hamid> 12:12 is the parameters that this function accepts
14:30:19 <hamid> This function is in fin.scm file. I want to test if the parameter that I am passing is correct or not
14:30:27 <hamid> 12 is number of months
14:31:19 <warlord> The normal PMT only takes 6 arguments. You appear to have 7
14:31:51 <warlord> What's your cpd_pmt definition?
14:32:47 <hamid> the definition was already present in fin.scm filr
14:32:51 <hamid> *file
14:32:56 <hamid> I did not add this
14:34:19 <warlord> Wow, it's been a long LONG time since I've looked in there. Didn't know those were there.
14:35:34 <hamid> ok
14:35:46 <warlord> So you've got a 3.090% Annual Rate? You might try putting spaces around the : between then 12:12
14:36:01 *** ErKa has quit IRC
14:36:45 <hamid> k, I'll try that
14:37:37 <warlord> As for testing it.... Save your file, then set the SX to fire 360 days in advance, run the SLR, and check the results. Then quit without saving.
14:37:52 *** aqua___ has quit IRC
14:38:19 <hamid> ok
15:05:07 <warlord> (unfortunately AFAIK we don't have a "view amortization table" for manually entered/created SXes
15:11:29 <hamid> sorry, was afk. I'll try testing the way you said. Thanks for the help
15:13:30 <warlord> You're welcome.
15:25:50 *** aqua___ has joined #gnucash
15:27:50 *** aqua___ has quit IRC
15:35:58 *** ErKa has joined #gnucash
15:54:54 *** john has joined #gnucash
15:54:55 *** gncbot sets mode: +o john
16:16:30 *** hamid has quit IRC
16:48:06 *** ErKa has quit IRC
17:25:25 *** TradeBorG has quit IRC
17:31:55 *** fell has quit IRC
17:50:28 *** ErKa has joined #gnucash
18:06:34 *** ErKa has quit IRC
18:06:56 *** ErKa has joined #gnucash
18:09:42 *** Caesar has quit IRC
18:10:27 *** Caesar has joined #gnucash
19:24:20 *** Ard0nik has joined #gnucash
19:33:53 *** Caesar has quit IRC
19:36:29 *** mikee_ has joined #gnucash
19:41:40 *** mikee has quit IRC
20:15:43 *** Caesar has joined #gnucash
20:24:15 *** Ard0nik has quit IRC
21:30:44 *** nafg has joined #gnucash
22:14:26 *** fuzzybunny69y has quit IRC
22:25:03 *** fuzzybunny69y has joined #gnucash
22:34:12 *** bpburns has quit IRC
22:36:22 *** fell has joined #gnucash
22:36:22 *** gncbot sets mode: +o fell
22:39:23 *** fell_ has joined #gnucash
22:39:23 *** fell has quit IRC
22:39:24 *** gncbot sets mode: +o fell_
23:05:59 *** fuzzybunny69y has quit IRC
23:09:24 *** mishehu has joined #gnucash
23:10:19 *** fell_ has quit IRC
23:10:37 *** fell_ has joined #gnucash
23:10:38 *** gncbot sets mode: +o fell_
23:12:13 *** fuzzybunny69y has joined #gnucash
23:37:26 *** fell_ has quit IRC