or Connect
HotStockMarket › Forums › Stock Market How To › Stock Market Education › MS Excel Template for stock profit/loss tracking
New Posts  All Forums:Forum Nav:

MS Excel Template for stock profit/loss tracking

post #1 of 4
Thread Starter 
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
post #2 of 4
Quote:
Originally Posted by CsT View Post
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
check my signature
post #3 of 4
Thread Starter 
^ Cool Thanks!
post #4 of 4

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

txt007

New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Stock Market Education
HotStockMarket › Forums › Stock Market How To › Stock Market Education › MS Excel Template for stock profit/loss tracking