The function 'annualised return per share' needs adding to the portfolio section.
Buying individual shares during the year it is difficult to see the comparable return per share. By annualising the return per share you can compare performance at a glance. The data for this formula is already there eg
(Current Price/Bought Price times 100) times (number of days share held/365)
Mike Ellacott Ellacott
shared this idea
-
Howard Beckett
commented
Michael Ellacott describes the work around calculation. This should be integral to VV-7. This subject is also covered by IRs with more votes. Move these votes there.
-
Mike Ellacott Ellacott
commented
This is easy to do. A colleague of mine solved it easily. Essentially, the trick is around getting the date you acquired the shares correctly formatted. Behind a correctly formatted date is a number ( e.g 01/01/1900 is day 1 ) so if you subtract two dates you get the number of days between the two dates ie the number of days you have held the share. This must be a positive number ie recent date minus an earlier date
If you set up one fixed cell with todays date ie when you switch on you automatically get the current date in your spreadsheet. You then subtract the date you acquired each share (say the settlement date from the contract) from todays date to give you the number of days you have owned that particular share. Its easy then to calculate an annualised return. From this point you only have to type in the date and you get an automatic update of the annualised returns every time you switch on