Settings and activity
15 results found
-
11 votes
Mike Ellacott Ellacott
supported this idea
·
-
73 votes
Mike Ellacott Ellacott
supported this idea
·
-
154 votes
Mike Ellacott Ellacott
supported this idea
·
-
269 votes
Mike Ellacott Ellacott
supported this idea
·
-
243 votes
Mike Ellacott Ellacott
supported this idea
·
-
295 votes
Mike Ellacott Ellacott
supported this idea
·
-
317 votes
Mike Ellacott Ellacott
supported this idea
·
-
317 votes
Mike Ellacott Ellacott
supported this idea
·
-
338 votes
Mike Ellacott Ellacott
supported this idea
·
-
428 votes
Mike Ellacott Ellacott
supported this idea
·
-
525 votes
Mike Ellacott Ellacott
supported this idea
·
-
3 votes
An error occurred while saving the comment
Mike Ellacott Ellacott
shared this idea
·
-
31 votes
Mike Ellacott Ellacott
supported this idea
·
-
2 votes
Mike Ellacott Ellacott
supported this idea
·
-
4 votes
Mike Ellacott Ellacott
supported this idea
·
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