|
Post by realisedurgency on Jun 15, 2015 13:23:38 GMT 7
|
|
|
Post by Fletchsmile on Jun 15, 2015 19:18:16 GMT 7
My key source is the Excel spreadsheets I've built over the years. By organising data in rows and columns that can be converted into pivot tables on other work sheets, I can slice and dice data however I want. Each month I insert a new column, update the formula cells and add the prices at month end On the main input sheet the column headings I use are: Person Account Manager Investment Status Fees Type Liquidity Tax Inc/ Acc Inc Yield Freq Loc Class Vintage Date Holding CUR Cost LTD CUR YTD CUR LTD GBP YTD GBP Cash 31-Dec-98 31-Jan-99 28-Feb-99 .... 31-May-15 30-Jun-15 YTD 1m 2m 3 m 6 m 1 yr 2 yr 3 yr 4 yr 5 yr 6 yr 7 yr 8yr 9yr 10yr 15yr C 21st Av Yr 2015 Pro 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 Start Ann% Value % Total % Ex-Pen % Pen %Fund % INV & TRA % Acc +/- USD SGD THB Then rows would be something like LM SCBT ABERDEEN THAILAND Growth (THB) Active Inclusive INV INV TTH Acc 0.00% TH PM SCBT ABERDEEN THAILAND Long Term Equity Fund Active Inclusive INV INV LTF Acc 0.00% TH ...... Cheers Fletch
|
|
|
Post by Fletchsmile on Jun 15, 2015 19:26:27 GMT 7
Years back I did experiment with software like Quicken. Things I found, were that while they did the basics quite nicely, one of the biggest hassles was dealing with multiple currencies, and different asset classes. In Excel I could add cash balances, property, pensions etc, easily to a spreadsheet just not all fields were needed. Should add though I originally trained as an accountant, so knew most of what I was looking for. Plus I've added different features to the spreadsheets over the course of 20 years or more as circumstances change. That's what I like about Excel, if you want to capture something additional you just start doing so eg add a column for person: wife, kid1, kid2, when got married and had kids, so I can bow look at consolidated info or any person individually Cheers Fletch
|
|
|
Post by realisedurgency on Jun 15, 2015 20:01:47 GMT 7
Years back I did experiment with software like Quicken. Things I found, were that while they did the basics quite nicely, one of the biggest hassles was dealing with multiple currencies, and different asset classes. In Excel I could add cash balances, property, pensions etc, easily to a spreadsheet just not all fields were needed. I have downloaded and started playing with GnuCash (the open source alternative to Quicken), I haven't done much so far but one thing I have got working is support for multiple currencies. With the click of a single button all exchange rates are updated, too bad I haven't figured out how to do much else though! I think spreadsheets will have to be my default. I don't think I would feel comfortable with some of the online tools and having them linked to my bank. Thanks, RealisedUrgency
|
|
|
Post by Fletchsmile on Jun 15, 2015 20:56:15 GMT 7
On the multi-currencies what I found was they could store maybe one or two rates for each currency, and you could update the rate.
The problem was storing multiple historic rates for multiple currencies. For THB for example I have rates for every month going back to the late 90's, so I can look at YearToDate returns or LivetoDate returns in GBP or THB using historic rates, today's rate, etc for Quicken I could only use one or two GBP/THB rates, and same rates were needed for all investments regardless of when bought. So OK to vallue today, but not historic values.
|
|
|
Post by realisedurgency on Jun 15, 2015 21:45:42 GMT 7
Ah I see, yes that is probably an issue with GnuCash also. It sounds like one would need solid excel skills to have records as detailed as yours!
|
|
|
Post by Fletchsmile on Jul 13, 2017 16:27:58 GMT 7
Here's an extract of one of the key files I use. I've deleted a lot of info to reduce the file size and for personal reasons , but gives a flavour The first worksheet <Input> is where I've captured the price data every month-end since late 90's Worksheets <PvCum> and <PvDSc> are then pivot tables which feed off this input sheet to show cumulative performance and discrete performance and so on
|
|
|
Post by rgs2001uk on Jul 13, 2017 22:29:46 GMT 7
Not a day trader, I review my investments every 3 months, but am looking at the long term. What is it you want, capital growth or regular income?
|
|