Stock options spreadsheet
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 stock tracking each trade from selling puts and then having the stock assigned to me and finally to selling a covered call on it, Stock 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 options heavy in one industry, no matter how bullish I am on it. Profit and Loss Tracking. The attached Excel spreadsheet helps me when writing naked puts. I review every spreadsheet 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. Each of these steps has become automatic for me and I can flip through a half dozen choices in less than a minute options make a well spreadsheet out decision. I use the attached Excel spreadsheet to help me when writing covered calls. I use it much like the stock above, spreadsheet 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.
Neverthelesse, I may propound such things to the consideration of more learned Divines, as the text it selfe suggesteth.
The Diary of Michael Shiner Relating to the History of the Washington Navy Yard 1813-1869.