How to pair up buy/sell trades of the same ticker?

Hi, I was typing in multiple trades of the same ticker and I realised how stocks cafe calculates is different from what I have in mind. For example:

  1. Buy 10 shares of AAPL at $100/share
  2. Buy 5 shares of AAPL at $110/share
  3. Sell 5 shares of AAPL at $115/share

I think how stocks cafe calculates will be to calculate the Closed P/Lby subtracting 1 from 3. Meaning the Closed P/L will be 5*(115-100) = $75.

What I want to do is pair up 2 and 3 such that the Closed P/L will be 5*(115-110) = $25. Is it possible to do this?

Hi there,

Thank you for reaching out.

Yes, StocksCafe uses the averaging approach. Please read this post for more information -> https://stockscafe.academy/520/how-to-calculate-average-share-price/

What you are describing is FIFO approach which is currently not supported.

Thanks,
Evan

1 Like