MS Excel Template for stock profit/loss tracking
Does anyone know where I can download a formulated Excel template whereby I can use as a journal to keep track of my stock transactions. I need it where I can just input the ticker and price bought/sold to calculate cost basis and gain/loss for both long and short positions. I'm just too lazy to create one in Excel
This is great! Thanks. Would it be able to add a column to allow remaining of shares to continue? I explain
for example, I bought 3200 shares of BAC in 2010, and sold 3000 shares in 2011, then there are 200 shares remaining. I have do the substruction manually and add new trade.
Thanks in advance