Portfolio Administration

colinjd

Hi,

I'm not the greatest when it comes to creating or using spreadsheets and the one I've created is beginning to get a bit unwieldly, so I was wondering if anyone could recommend a simple spreadsheet layout that will allow me to consolidate all the information I have, covering Cash & S&S ISA's and my SIPP.

Also, I'm having difficulty with some basic maths for some reason, for eg:
I have 10 units of Fund A, bought at £10, now valued at £11 giving me a GP of 10%/£10
I sell 1 unit for £11 leaving me 9 units at £11 (still at 10%GP) + £11 cash.
I buy 1 unit of Fund B for £11
I now have 9 x Fund A and 1 x Fund B
So what is the actual 'cost' to me (for admin purposes) of Fund B?

Where's my profit gone? I know it's hiding somewhere but I can't see it

I understand if that doesn't make sense, I think the weather is having a detrimental effect on my brain today!

Thanks for looking anyway!

quotememiserable

What I track is the current value of the portfolio. For fund B that is £11.

redbuzzard

A tenth of your profit has 'disappeared' but your capital has gone up by the same £amount, right?

You have crystallized a capital gain by selling a unit of fund A.

I guess your 'problem' is that you want to see how much profit you have made since you put the money in the account.

You'll just have to keep a tally of how much actual money you have added, and compare it with the total value of your investments.

Totton

You could take a look here if using Excel - http://office.microsoft.com/en-us/templates/excel-templates-FX102828204.aspx

colinjd

Totton wrote: »

You could take a look here if using Excel - http://office.microsoft.com/en-us/templates/excel-templates-FX102828204.aspx

Thanks, I'll check it out over the weekend.

waiax73

If you're trying to track the performance of your investments, you can key in the data and create a virtual portfolio here: https://www.rplan.co.uk/ ("What's my number" section)

The good thing is that you don't have to even register to give the portfolio a try.

I think that TD and III have similar tools but I don't know if they are available to users who aren't their clients.

It will save you loads of time because you won't have to type in the price changes etc. On the contrary it's limited to investment funds and unit trusts.

If any of you know providers with similar tools please share - would love to test them out! (I'm fairly new to investing)

Cheers!

redbuzzard

Trustnet portfolios will handle shares, funds, etfs, etc.