November 12

Options Tracker

0  comments

Here you’ll find all of my open options contracts. I update this options tracker weekly. The last update was on 11-5-2017.

Options Tracker Definitions

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.

B/S
Buy or Sell

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 Price
This field shows the current stock price of the underlying stock. This doesn’t apply to this page because I’m showing you an image. My actual tracking spreadsheet is set to update every 5 minutes. I use red or green to indicate if I’m winning or losing at a specific option.

Break Even Price
This field shows the dollar amount of the underlying stock that equals my breakeven price. For example, let’s say I sold a covered call on Philip Morris, PM at a $100 strike price. This contract paid me a premium of $3.41 or $341 dollars. My breakeven price on this trade is $103.41. This is because I was already paid $341 at the time of the contract sale.

If the contract closes at $101.41, I lose my PM stock, but I sold it for $2 more than market value. If the contract closes at $105.41, I lose my PM stock, but I sold it for $2 less than market value.

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 100 share increments. A $1.32 premium is $132.00. I don’t get all of this money. A premium is the price paid before fees.

Contracts
This field indicates the number of contracts I’ve sold. 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. I don’t use margin accounts. If I did, I could sell options with less upfront money. Margins are risky, and I don’t want to add more risk. Because of this, I cover all puts with 100% cash equivalents.

(CALL) Cost Basis
Covered calls are options sold against stocks already owned. For example, I own 100 shares of Philip Morris. I sell one covered call (100) shares. My cost basis can be one of two numbers, either the cost of 100 shares at the contract strike price or the cost basis of my 100 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. Generally, these fees are $9.71 for Schwab or $1.09 for Interactive Brokers.

Exit Price
This is the premium I pay to close a contract.

Close DateIf I choose to close an option, this field lists the date I closed the contract.

Profit or Loss
Profit is the amount of money I’m paid after fees for selling an option 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.

Annualized ROR
Annualized ROR takes the ROI of a contract and annualizes it.

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 100 shares to be sold from my account, or I chose to buy 100 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 doesn’t make sense to do this below a 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. I’ve sold a handful of covered calls where early assignment occurs. As a seller, this sucks because I’m planning on the contract expiring worthless or closing and reselling the contract. Early assignment costs me money. Here’s an example of an AT&T Early Assigned Option.


Tags


You may also like