Blog

Something a little different! I put this worksheet together to help me manage risk and keep track of my stock trading progress. Thought maybe you might find it useful too. It’s got all kinds of formulas and conditional formatting to help you see, at a glance, how well (or poorly) things are going. I tried to make it as logical and visually organized as possible. Feel free to provide feedback if you think there’s anything I can do to improve it. Basically you just have to fill out your entry info (columns A-E), set a stop loss and target (G, I) and the rest is calculated automatically until you close your position by filling in the exit date and price (X, Y). I included info at the top that shows all the totals and averages, with the yellow items being based only on your currently open positions. Let me know what you think and happy trading!