I'm looking for a spreadsheet that will allow me to track stock purchases. There's a couple out there but I can't find something that really meets my needs. I'm looking for a spreadsheet that will allow multiple exits from a stock.
Something like:
BUY: AAPL 5000@$20 BUY: IBM 100@$100 SELL: AAPL 4000@$25 SELL: AAPL 500@$26 BUY: AAPL 10@27
Would show a summary of my positions and perhaps some extra reporting. I've searched around but all I find are spreadsheets that have single exits from stock purchases.
Or, am I making this too complicated.
How do other group readers track their portfolios in excel?
S.