sharetrader
Page 1 of 2 12 LastLast
Results 1 to 10 of 17
  1. #1
    Member
    Join Date
    Jun 2013
    Posts
    254

    Default How to Monitor Captial Gains/Losses Over Time

    Hi,

    I've recently decided to invest a small amount in shares and am slowly learning the ropes. I'm with ASB Securities and use the Portfolio page to see how my stocks are doing relative to the price I purchased them. This works fine at the moment because I have only made one purchase of each stock, however I was wondering how this works over time if I make more purchases of the same stocks at different prices - i.e. how do I work out the net gain/loss on a stock if I have bought them at different prices.

    Would I need external software to do this?

    Chris

  2. #2
    Guru
    Join Date
    Feb 2005
    Location
    Auckland
    Posts
    3,115

    Default

    Quote Originally Posted by blackcap80 View Post
    Would I need external software to do this?
    I use sharesight.co.nz

    A bit overkill for just a few shares though. Before that I set up a complex excel spreadsheet to tell me pretty much everything sharesight does - I put a value on my time and went the paid option since it is always upto date and doesn't require me to tinker with it all the time.

    Actually - just remember that Sharesight is free for your first 10 shares (and this is what I started with). I only moved to the paid version when I went over 10 shares.
    Free delivery worldwide with Book Depository http://www.bookdepository.co.uk

  3. #3
    The Good Banksie's Avatar
    Join Date
    Mar 2013
    Location
    Banks Peninsula
    Posts
    516

    Default

    I use excel to record all my transactions. I keep the date, purchase price, number of shares and commission paid. With that raw information you should be able to work out capital gains, yield etc. I haven't been investing long (only a few months) but I intend to use it to record dividend payments and/or dividend reinvestment's as well.

    This should be fine if you are an investor, but if you are a trader constantly buying and selling a particular share then the admin overhead would be quite large.

  4. #4
    The Good Banksie's Avatar
    Join Date
    Mar 2013
    Location
    Banks Peninsula
    Posts
    516

    Default

    Quote Originally Posted by CJ View Post
    I use sharesight.co.nz
    Thanks CJ - I have signed up for the free version. I like try before you buy software.

    (Now I wonder if I can buy shares in sharesight )

  5. #5
    Member
    Join Date
    Jun 2013
    Posts
    254

    Default

    Quote Originally Posted by CJ View Post
    I use sharesight.co.nz

    A bit overkill for just a few shares though. Before that I set up a complex excel spreadsheet to tell me pretty much everything sharesight does - I put a value on my time and went the paid option since it is always upto date and doesn't require me to tinker with it all the time.

    Actually - just remember that Sharesight is free for your first 10 shares (and this is what I started with). I only moved to the paid version when I went over 10 shares.
    Thanks, I currently have fewer than 10 shares so I'll try Sharesight for a while.

  6. #6
    Member
    Join Date
    Mar 2010
    Posts
    263

    Default

    Hi Chris,

    If you are reasonably familiar with using a spread sheet, try searching Microsoft Excel for "Stock Investment Performance" template and download. You can rearrange it to suit - add/delete columns/rows which would enable you to record more than one tranche of a particular stock. You can also add any other information you wish, date, etc.

    And, just as KW has pointed out above, NZX offer a similar service if you want to sign up - free.

    Good luck with your investing.

  7. #7
    Member
    Join Date
    Jun 2013
    Posts
    254

    Default

    Thanks again for the replies. I've signed up for the Sharesight free account and will see how it goes.

    One question I have though. In some cases the current price it's reporting for a stock is different than I see in ASB Sercurities.

    For example, on Sharesight, Fisher and Paykel (FPH) is showing as 3.340, on ASB Securities it's 3.270. Both are apparently as at COB yesterday. Why the difference?

  8. #8
    Guru
    Join Date
    Feb 2005
    Location
    Auckland
    Posts
    3,115

    Default

    Quote Originally Posted by blackcap80 View Post
    For example, on Sharesight, Fisher and Paykel (FPH) is showing as 3.340, on ASB Securities it's 3.270. Both are apparently as at COB yesterday. Why the difference?
    Not sure where you got the $3.27 from. $3.34 is correct.

    For those that have signed up to Sharesight, note that they only update their prices at close of business so it is always one day behind. I have been using since December (for the paid version and the free version before that) so if you have any questions, let me know.

    I also have it integrating into Xero.
    Free delivery worldwide with Book Depository http://www.bookdepository.co.uk

  9. #9
    Member
    Join Date
    Mar 2002
    Location
    Auckland, , New Zealand.
    Posts
    236

    Default

    I have found ASB NZX end of day prices to have regular errors, no idea why.
    At least one a day on average
    I have checked with other sources and it has always been ASB that was incorrect

  10. #10
    Senior Member
    Join Date
    Mar 2001
    Location
    Auckland, , New Zealand.
    Posts
    1,408

    Default

    CJ do you know , with Sharesight Free 10 shares, does 10 relate to only open/current positions, that is it does not count ones you have sold??

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •