I am having real trouble organizing a spreadshet to track my portfolio in order to link the profit/loss and end amont to my business portfolio to give a reflection fo the worth of my total assets.
I have used the link profided in another thread to the Capital Gains template offered by MS Office. However I am having some trouble with formula, and I am not that experienced with formula.
I need it to reflect the following, but can't get it to work properly with currently held investments and already sold investments;
-on-going cash deposits
-total profit loss
I just can't get it to work after modifying the template.
A ready mate template would be excellent, but I recon id be pushing my luck there...