Options Tracker Spreadsheet
5 stars based on
The last update was on Stock Symbol The underlying stock that the specific option was sold against. Open Date Open Date is the date that the specific option contract was sold. Exp Date Exp date is the date that the specific option contract is scheduled to end. Keep in mind, not all contracts go to their expiration date. A buyer of a covered call may choose to take the stocks early.
Also, as an options seller, I may choose to close the contract early. Call or Put This field indicates whether I sold a covered call or cash secured put. Stock Price DOC This field shows the underlying stock price at the time of the specific option contract sale. DTE Date to Expiration. The number of days remaining in the options contract. Current Stock Pric e This field shows the current stock price of the underlying stock. My actual tracking spreadsheet is set to update every 5 minutes.
Break Even Price This field shows the dollar amount of the underlying stock that equals my breakeven price. Strike Price Strike Price is the price that I agreed to either buy or sell the underlying stock at. Premium Premium is the price I am paid for selling a call or put. Options work in share increments. A premium is the price paid before fees.
I typically sell just one contract. PUT Cash Reserve This filed shows the amount of money that I need to hold in my broker account to sell the option contract. If I did, I could sell options with less up front money.
For example, I own shares of Philip Morris. I sell one covered call shares. My cost basis can be one of two numbers, either the cost of shares at the contract strike price or the cost basis of my shares. I choose to use my cost basis.
I use my cost basis at a per share price. Fees Fees are all fees I must pay to buy or sell an options contract. Exit Price This is the premium I pay to close a contract. Close Date If I choose to close an option, this field lists the date I closed the contract. Losses are shown in this tab if I paid more to close a contract than it was sold for.
Days Held The actual number of days a contract was held. If this field is empty, a contract is still open or expired. Status Status can be one of four terms open, close, assigned, early assignment. Open and close are pretty self explanatory. Assigned is a contract that I let expire in the money. This means I allowed shares to be sold from my account, or I chose to buy shares.
Early Assignment is when the buyer of a covered call decides to take the stock early. This can happen at any price, either above or below the strike price.
It makes sense in some cases above the strike price. Collecting dividends or cashing out on gains are two popular reasons for early assignment. Early assignment costs me money. Disclaimer I'm not a financial planner. I have no professional training in the financial space. All site content, including comments, should be viewed for entertainment purposes only. Any options trades, buy, sells, call, puts, or any other investing information I publish should not be considered a recommendation.
Information about user behavior could be passed to Google, however, personal identifiable information is not linked with a users IP address. This website provides the option for visitors to post comments. Visitors also have the option to subscribe to newsletters.
Your information will never be shared or sold. You have the option to unsubscribe from any newsletters.