2013-06-02 GnuCash IRC logs
00:04:18 *** arrainey has quit IRC
00:04:52 *** arrainey has joined #gnucash
00:09:53 *** arrainey has quit IRC
00:10:26 *** arrainey has joined #gnucash
00:11:38 *** arrainey has quit IRC
00:16:29 *** arrainey has joined #gnucash
00:20:35 *** arrainey has quit IRC
01:04:16 *** ErKa has joined #gnucash
01:15:06 *** kpreid has quit IRC
01:53:52 *** ErKa has quit IRC
02:12:17 *** calbasi has joined #gnucash
02:56:46 *** fell__ has joined #gnucash
02:56:46 *** gncbot sets mode: +o fell__
03:54:17 *** shanny has joined #gnucash
03:54:41 *** JesseW has joined #gnucash
03:56:50 *** shanny has quit IRC
04:12:35 *** calbasi has left #gnucash
04:21:31 *** Krzysiek_K has quit IRC
04:22:07 *** Krzysiek_K has joined #gnucash
04:38:56 *** cristian has joined #gnucash
04:41:52 *** cristian has quit IRC
04:58:19 *** aqua___ has joined #gnucash
05:00:57 *** JesseW has quit IRC
05:06:03 *** aqua___ has quit IRC
05:14:09 *** Krzysiek_K has quit IRC
05:14:40 *** Krzysiek_K has joined #gnucash
05:47:11 *** jmd has joined #gnucash
06:28:38 *** Krzysiek_K1 has joined #gnucash
06:28:49 *** Krzysiek_K has quit IRC
06:30:44 *** fabior has joined #gnucash
07:59:21 *** Jimraehl2 has left #gnucash
08:23:57 *** ecocode has joined #gnucash
08:28:26 *** Topcat has joined #gnucash
08:32:47 *** fabior has quit IRC
08:41:31 *** benste has joined #gnucash
08:43:36 *** Topcat has quit IRC
09:06:16 *** Jimraehl2 has joined #gnucash
09:36:18 *** Topcat has joined #gnucash
09:56:02 *** benste has quit IRC
10:03:13 *** benste has joined #gnucash
10:16:09 *** Topcat has quit IRC
10:16:32 *** Topcat has joined #gnucash
10:31:36 *** Topcat has quit IRC
10:32:14 *** Topcat has joined #gnucash
10:37:17 *** Topcat has quit IRC
10:37:39 *** Topcat has joined #gnucash
10:42:13 *** fabior has joined #gnucash
10:44:54 *** kpreid has joined #gnucash
10:52:44 *** Topcat has quit IRC
10:53:30 *** Topcat has joined #gnucash
10:57:54 *** benste has quit IRC
11:03:40 *** Topcat has quit IRC
11:04:16 *** Topcat has joined #gnucash
11:06:51 *** jmd has quit IRC
11:14:18 *** Topcat has quit IRC
11:14:41 *** Topcat has joined #gnucash
11:24:44 *** Topcat has quit IRC
11:25:33 *** Topcat has joined #gnucash
11:30:35 *** Topcat has quit IRC
11:31:16 *** Topcat has joined #gnucash
11:36:19 *** Topcat has quit IRC
11:36:42 *** Topcat has joined #gnucash
11:45:13 *** aqua___ has joined #gnucash
11:50:24 *** aqua___ has quit IRC
11:56:21 *** arrainey has joined #gnucash
12:10:33 *** Topcat has quit IRC
12:10:55 *** Topcat has joined #gnucash
12:28:42 *** ErKa has joined #gnucash
12:36:44 *** Topcat has quit IRC
12:37:06 *** Topcat has joined #gnucash
12:42:08 *** Topcat has quit IRC
12:42:41 *** Topcat has joined #gnucash
12:45:02 *** smw has quit IRC
12:45:17 *** smw has joined #gnucash
12:47:35 *** smw has quit IRC
12:52:46 *** Topcat has quit IRC
12:53:09 *** Topcat has joined #gnucash
13:03:12 *** Topcat has quit IRC
13:03:35 *** Topcat has joined #gnucash
13:14:57 *** Topcat has quit IRC
13:15:19 *** Topcat has joined #gnucash
13:31:32 *** fell has joined #gnucash
13:31:32 *** gncbot sets mode: +o fell
13:40:31 *** fell__ has quit IRC
13:45:35 *** Topcat has quit IRC
13:45:59 *** Topcat has joined #gnucash
13:46:54 *** Bodhi-Baum has joined #gnucash
13:56:07 *** Topcat has quit IRC
13:56:43 *** Topcat has joined #gnucash
14:01:08 *** ErKa has quit IRC
14:11:55 *** Topcat has quit IRC
14:12:18 *** Topcat has joined #gnucash
14:17:24 *** Topcat has quit IRC
14:17:47 *** Topcat has joined #gnucash
14:22:49 *** Topcat has quit IRC
14:23:12 *** Topcat has joined #gnucash
14:33:19 *** Topcat has quit IRC
14:33:56 *** Topcat has joined #gnucash
14:43:59 *** Topcat has quit IRC
14:44:21 *** Topcat has joined #gnucash
14:48:03 *** JesseW has joined #gnucash
14:54:23 *** Topcat has quit IRC
14:54:57 *** Topcat has joined #gnucash
15:15:07 *** Topcat has quit IRC
15:15:30 *** Topcat has joined #gnucash
15:24:06 *** JesseW has quit IRC
15:24:28 *** JesseW has joined #gnucash
15:27:37 *** Bodhi-Baum has quit IRC
15:31:57 *** Bodhi-Baum has joined #gnucash
15:40:10 *** Krzysiek_K1 has quit IRC
15:40:20 <Vantage_> warlord: Well, if I have money invested in an index fund, I can only see how much I invested, not how much that investment is currently worth or how much has been gained/lost
15:48:47 *** aqua___ has joined #gnucash
15:57:15 *** Ryan_ has joined #gnucash
16:02:26 *** JesseW has quit IRC
16:04:37 *** JesseW has joined #gnucash
16:05:49 *** Ryan has quit IRC
16:05:50 *** Ryan_ is now known as Ryan
16:12:06 *** Bodhi-Baum has quit IRC
16:23:32 *** Topcat has quit IRC
16:24:16 *** Topcat has joined #gnucash
16:34:30 *** aqua___ has quit IRC
16:44:53 *** aqua___ has joined #gnucash
16:46:15 *** fell_ has joined #gnucash
16:46:15 *** gncbot sets mode: +o fell_
16:51:14 *** fabior has quit IRC
16:51:25 *** aqua___ has quit IRC
16:55:13 *** fell has quit IRC
16:55:19 *** Topcat has quit IRC
17:03:39 *** Bodhi-Baum has joined #gnucash
17:13:25 *** JesseW has quit IRC
17:13:56 *** JesseW has joined #gnucash
18:10:34 *** JesseW has quit IRC
18:14:27 *** arrainey has joined #gnucash
18:21:53 *** JesseW has joined #gnucash
18:25:43 *** ecocode has quit IRC
18:25:43 *** ecocode has joined #gnucash
18:34:35 *** arrainey has quit IRC
18:35:15 *** arrainey has joined #gnucash
18:40:22 *** arrainey has quit IRC
18:41:16 *** arrainey has joined #gnucash
18:51:17 *** arrainey has quit IRC
18:52:10 *** arrainey has joined #gnucash
18:57:12 *** arrainey has quit IRC
18:57:48 *** arrainey has joined #gnucash
18:58:40 *** ecocode has quit IRC
19:05:41 *** smw has joined #gnucash
19:12:59 *** arrainey has quit IRC
19:13:35 *** arrainey has joined #gnucash
19:18:37 *** arrainey has quit IRC
19:19:10 *** arrainey has joined #gnucash
19:24:11 *** arrainey has quit IRC
19:24:45 *** arrainey has joined #gnucash
19:29:45 *** arrainey has quit IRC
19:30:24 *** arrainey has joined #gnucash
19:37:34 <warlord> Vantage_: you know how many shares you own, and the current price of those shares..
19:38:16 <Vantage_> warlord: Right, I'm trying to get gnucash to calculate that for me, but that doesn't seem to be working either
19:39:03 <warlord> Vantage_: it's a stock/fund. read the docs on how to track stocks.
19:39:31 <warlord> Create a security for your fund, create a Stock or Mutual Fund account, denoted in that security, and then buy your shares.
19:39:56 <warlord> If you set up the quote grabber you can get gnucash to download stock prices for you to learn the current price.
19:40:34 <warlord> And in the CoA enable up the "Total (YourCurrency)" column.
19:41:33 <Vantage_> warlord: I've created the security/fun and try to get quotes, but I get "Unable to retrieve quotes for these items"
19:42:05 <Vantage_> warlord: this is the one I'm trying to setup, http://ca.finance.yahoo.com/q?s=F00000NNHK.TO
19:42:19 <warlord> Vantage_: that implies you either don't have F::Q installed properly, or dont have the stock quote setup properly.
19:44:28 <Vantage_> warlord: F::Q Is the fiance quote perl module, right?
19:44:34 <warlord> yes
19:44:53 <Vantage_> warlord: looks installed ii libfinance-quote-perl 1.17+git20120506-1 all
19:45:14 <Vantage_> warlord: does it need any other perl modules? I installed the yahoo one just in case as well
19:46:10 <warlord> run gnc-fq-dump and check? But you'll need to find the right quote source.
19:46:36 <Vantage_> warlord: so the security is setup with symbol F00000NNHK.TO type FUND, ISIN, CUSIP is blank and source is single yahoo USA. Does that sound right?
19:47:30 <warlord> Except that at least on my machine that config doesn't work. But it could be that my F::Q yahoo grabber is broken.
19:48:22 <Vantage_> warlord: here's the command output : http://pastebin.com/uVq8aVrE
19:48:35 <Vantage_> warlord: how would I know the right quote source?
19:48:48 * warlord has no idea..
19:48:58 <warlord> In the USA, yahoo works for all my stuff.
19:49:58 <Vantage_> warlord: I've done multiple with Canada (yahoo, etc.) and that doesn't seem to come up with anything either. Is that the correct symbol they're looking for?
19:50:10 <warlord> Probably notl
19:52:25 *** Krzysiek_K has joined #gnucash
19:52:30 *** Krzysiek_K has left #gnucash
19:52:34 <warlord> Oh, the last quote is from May 22.. That's probably why -dump isn't working.
19:52:50 <warlord> I think it'll only look for something in the last 2-3 days.
19:52:58 <warlord> ... and yahoo *should* work.
19:53:14 <warlord> (but it's not for me)
19:58:45 <Vantage_> warlord: weird, but it looks like it's setup correctly?
20:02:15 <warlord> yeah, but the last quote is May 22, which is too old.
20:04:28 <Vantage_> warlord: Thanks. Any idea how I set it up manually when I'm not sure what price I originally bought at?
20:05:21 <warlord> Vantage_: nope.. you would need to know that information for tax purposes.
20:05:27 <warlord> (at least in the US)
20:06:32 *** JesseW has left #gnucash
20:13:18 *** arrainey has quit IRC
20:13:56 *** arrainey has joined #gnucash
20:18:56 *** arrainey has quit IRC
20:19:30 *** arrainey has joined #gnucash
20:19:33 <Vantage_> warlord: Ok, got the info, but having a hard time getting it in. I set the number of shares I bought, at the price I bought them. What is buy?
20:31:18 *** arrainey has quit IRC
20:31:51 *** arrainey has joined #gnucash
20:38:01 <warlord> Vantage_: Buy == price * #shares. You need to set 2; gnucash will compute the third.
20:38:22 <warlord> Internally it stores #shares and "buy" (or sell), and computes the price.
20:38:36 <warlord> So IMHO it's better to input those two values and let gnucash compute the price.
20:40:05 <Vantage_> warlord: I do that and it calculates the price correctly, but the balance goes way off?
20:40:17 <Vantage_> warlord: for the first transaction shouldn't the balance equal the buy?
20:40:34 <warlord> No, the balance will be #shares
20:40:48 <Vantage_> warlord: ah...
20:44:30 <Vantage_> warlord: and then how do I record distributions that get reinvested? What account should those come from?
20:46:30 <warlord> There are two ways to do it. One is just from Income straight into the stock account. The other is from Income -> Brokerage and then from Brokerage -> Stock.
20:47:03 <warlord> I do the former, however apparently the Advanced Portfolio Report prefers the latter. Hopefully that will get fixed one day
20:52:41 <Vantage_> warlord: so just create an income account for it?
21:02:22 *** arrainey has quit IRC
21:03:01 *** arrainey has joined #gnucash
21:04:01 <warlord> Yes.
21:13:02 *** arrainey has quit IRC
21:13:36 *** arrainey has joined #gnucash
21:18:41 *** arrainey has quit IRC
21:18:50 <Vantage_> warlord: and lastly. Is there a way to see principle invested value vs. gains/losses on it?
21:19:16 *** arrainey has joined #gnucash
21:20:17 <warlord> Vantage_: that would be the Advanced Portfolio
21:23:55 <Vantage_> warlord: cool. It seems to work for me without the brokerage.
21:24:21 <Vantage_> warlord: now if only I could get the price downloaded automatically.
21:24:53 <warlord> Vantage_: look for another price source?
21:25:20 <Vantage_> warlord: Is it possible to add new source to gnucash?
21:25:33 <warlord> Sure, add the code to F::Q
21:25:38 <warlord> gnucash picks it up dynamically
21:25:54 <Vantage_> warlord: I've got the latest here http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=87199
21:29:24 <warlord> Try to see if you can find it at any other places that already have quote grabbers?
21:35:41 *** arrainey has quit IRC
21:36:13 *** arrainey has joined #gnucash
21:41:14 *** arrainey has quit IRC
21:41:54 *** arrainey has joined #gnucash
22:00:56 <Vantage_> warlord: trying a few, no luck so far. Anyway, I just wanted to say thanks a lot for all your help, I really appreciate it!
22:03:08 <warlord> youre welcome. You can *try* asking on the gnucash-user mailing list for more help with the quote source.
22:11:56 *** arrainey has quit IRC
22:12:31 *** arrainey has joined #gnucash
22:22:33 *** arrainey has quit IRC
22:23:08 *** arrainey has joined #gnucash
22:28:11 *** arrainey has quit IRC
22:28:47 *** arrainey has joined #gnucash
22:33:47 *** arrainey has quit IRC
22:34:29 *** arrainey has joined #gnucash
22:39:29 *** arrainey has quit IRC
22:40:02 *** arrainey has joined #gnucash
22:50:04 *** arrainey has quit IRC
22:50:37 *** arrainey has joined #gnucash
23:00:40 *** arrainey has quit IRC
23:01:13 *** arrainey has joined #gnucash
23:11:15 *** arrainey has quit IRC
23:11:53 *** arrainey has joined #gnucash
23:31:57 *** arrainey has quit IRC
23:32:31 *** arrainey has joined #gnucash
23:37:34 *** arrainey has quit IRC
23:38:07 *** arrainey has joined #gnucash
23:43:08 *** arrainey has quit IRC
23:43:41 *** arrainey has joined #gnucash
23:45:15 *** smw has quit IRC
23:53:43 *** arrainey has quit IRC
23:54:17 *** arrainey has joined #gnucash
23:59:19 *** arrainey has quit IRC