My Trader's Journal Investing in Stocks Through Options selling naked puts and writing covered calls stock options blog. The attached Excel spreadsheet is my monthly view of gains plus industry breakdown of holdings along with my profit or loss tallies per stock. Some positions can take six months or more from start to end and without tracking each trade from selling puts and then having the stock assigned to me and finally to selling a covered call on it, I found it too easy to loose track with where I was.

I find this spreadsheet one of my best tools to control emotional swings we all feel in working the stock market. Having the industry sector breakdown included in the same view also keeps me from loading up to heavy in one industry, no matter how bullish I am on it.

Payoff Diagram Spreadsheet Download

Profit and Loss Tracking. The attached Excel spreadsheet helps me when writing naked puts. I review every option using the premium, strike, number of contracts and time remaining to determine what my Return on Investment ROI will be.

When analyzing each option contract I compare which strike and premium is the best choice for me.

If the underlying stock is highly volatile, I can easily see that selling puts well out of the money provides a return I can be happy with for the reduced risk. If the underlying stock is not very volatile, I can easily see that I need to skip it and move to another stock for review.

Options Tracker Spreadsheet – Two Investing

Each of these steps has become automatic for me and I can flip through a half dozen choices in less than a minute to make a well thought out decision. I use the attached Excel spreadsheet to help me when writing covered calls. I use it much like the spreadsheet above, but for covered calls instead.

RSS feed for comments on this post. Comments Off on Excel Spreadsheets.

No Comments No comments yet. Sorry, the comment form is closed at this time. Subscribe for Free Follow me on Twitter Catch my VLOG on YouTube too.