sharetrader
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Apr 2017
    Posts
    219

    Default Recording Average Prices

    Hi all how do you record the following:

    10,000 shares bought at $1 say 1 Jan 2019
    10,000 shares sold at $2 say 1 Jan 2020
    10,000 shares bought for 60c say 1 Mar 2020

    I see some software record only the last purchase so 60c. Other software record all transactions and give you an average price of -40c as a simple example. I prefer the second option and that is how my spreadsheet is set up. What do other do?

  2. #2
    A BEARISH BULL winner69's Avatar
    Join Date
    Jun 2001
    Location
    , , .
    Posts
    26,538

    Default

    Quote Originally Posted by dabsman View Post
    Hi all how do you record the following:

    10,000 shares bought at $1 say 1 Jan 2019
    10,000 shares sold at $2 say 1 Jan 2020
    10,000 shares bought for 60c say 1 Mar 2020

    I see some software record only the last purchase so 60c. Other software record all transactions and give you an average price of -40c as a simple example. I prefer the second option and that is how my spreadsheet is set up. What do other do?
    Definitely the -40c ...you got paid for buying them eh

    Popular way of looking at it and gives punters warm fuzzies when under water.

    But in your example surely the answer is 60 cents. (More so if you spent the $10000 profit on a good piss up or something)
    “Just consider that maybe the probability of you being wrong is higher than you think.”

  3. #3
    Member
    Join Date
    Apr 2017
    Posts
    219

    Default

    Quote Originally Posted by winner69 View Post
    Definitely the -40c ...you got paid for buying them eh

    Popular way of looking at it and gives punters warm fuzzies when under water.

    But in your example surely the answer is 60 cents. (More so if you spent the $10000 profit on a good piss up or something)
    I have a few shares in this situation now where average price is negative or slightly positive. I dont spend anything from staremarket gains/divvies etc. All pumped back in

  4. #4
    Senior Member
    Join Date
    Mar 2001
    Location
    Auckland, , New Zealand.
    Posts
    1,284

    Default

    I would agree with winner, really can only average your price on the number of share you have now and what you paid for those shares- not what you bought and 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
  •