Skip to content

Settings and activity

15 results found

  1. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  2. 71 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  3. 148 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  4. 261 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  70 comments  ·  VectorVest 7 » Graphs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  5. 235 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  6. 288 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  7. 309 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  8. 308 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  9. 328 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  10. 418 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  11. 513 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  12. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    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

    Mike Ellacott Ellacott shared this idea  · 
  13. 31 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  14. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  · 
  15. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Mike Ellacott Ellacott supported this idea  ·