Retirement Income Series: Find The Best Covered Call Option Using Marketxls

Background

I like to sell covered calls against many of my stock positions. It’s a safe and easy way to boost the income I receive. As a retired person who does not yet receive social security, and does not have a pension, income from investments is very important to me! 

Today’s Income Challenge

Today I was looking at my Apple (AAPL) shares. My call on those shares expired last week so I’m looking to sell a new call today. I bought my 100 shares on 9/11/20 at $117.70. Today’s price is $126.88. I would like to keep them but, when I sell a call, there is some risk the shares could be called away. So I want to set my strike price higher than I think the shares will rise. If they do get called, at least it will be at a price I’m comfortable with.

Note: when I sell a covered call against my shares, I am being paid to take on a contractual obligation. I choose the strike price and expiry date, and receive a premium, which is paid in cash into my account. The contract says that the option buyer can buy my shares at the strike price any time between now and the expiry date. In practice, the option buyer would most likely exercise this right only if the share price exceeded the strike price at expiry. 

Back to AAPL. Based on my observation of recent share price movements, I would like to set a strike price between $135 and $145 because I don’t think the shares will rise above that in the next few months. It’s been range-bound between $115 and $135 for almost 6 months, and I’m not aware of any major catalyst which will boost the price much above that in the near future. But which specific contract will give me the best return? 

And I am looking at expiration dates between 52 and 388 days into the future. 

Tackling the Challenge

I can view the option table in my broker (Fidelity) software and do the calculations, one by one.

Or I can use MarketXLS to download the option chain into Excel and get exact returns in a format that makes it easy to compare. Let’s take a look.

Here’s the AAPL option chain from Fidelity, filtered to show the strikes and expiries of interest. Note that the call options are on the left-hand side.

options chain
From fidelity.com

At this point, my task is to find the row that gives me the best annualized return, and also has a strike price that makes it unlikely for the shares to be called away.

I can do each calculation. Like on the first row, using the last price: I would receive $149 in premium for a 52-day holding period. Based on my acquisition price: $149 / $11,700 = 1.27% absolute return. Since this return is over a 52-day period, I will annualize it to make comparisons to other expiry dates easier: (0.84% / 52) * 365 = 8.90% annualized return. Not terrible for a call on a stock that is also paying a small dividend. But can I do better? I could do these 2 calculations 21 times and get the answer for each row, but why don’t I let MarketXLS do most of the work for me? Good idea!

MarketXLS Can Help

Options Scanner

Here’s how to do it: open an excel workbook, type in the ticker and select that cell, and navigate to the MarketXLS section on the ribbon. Click on Utilities and select Option Scanner from the dropdown menu.

In about 2 seconds, this screen appears.

Option Scanner
MarketXLS Option Scanner Results

 

I’m going to filter the list a little bit. I will choose Calls in the Calls or Puts dropdown. And I will click on the Edit Filter button (bottom right) to set the strike price range from $135 to $145. 

filter editor for option scanner
MarketXLS Option Scanner Filter Editor

And then I’ll click Send these to Excel. That part will take about 90 seconds, so I’m gonna go refill my coffee.

OK. Back now. And here are the results which populated a new tab on the same spreadsheet.

The Analysis

It resulted 94 rows (I didn’t filter on expiration dates) and here is what the first few rows look like.

option chain

To do a proper analysis, I need to add 3 columns, and then enter some simple Excel formulas:

  • Days to expiry: (expiry date minus today)
  • Return: last price* divided by my acquisition cost per share of $117.70 
  • Annualized Return (value in the Return column divided by # of days to expiry) * 365

*Some may prefer to use the bid or ask price rather than the last price for the option. Bid and ask prices can be pulled into your spreadsheet easily; but the last price is automatically there, so I’ll just use that one.

Here’s what it looks like with those columns added, and I went ahead and sorted by annualized return (largest to smallest) because that is the next step:

option chain with calculated fields

As expected, the best annualized returns are for the $135 strike price. That strike is closest to current price and thus more likely to be exceeded; so the option buyers are willing to pay more premium for that likelihood. Now that I think about it, I’m much more comfortable with a $140 strike price, so let’s find the first time $140 appears in the strike column.

Chaching! It looks like the 19Nov$140 contract pays a very acceptable 8.38% annualized return. But, that expiry date is 6 months away and a lot can happen to impact the share price in that length of time. So let’s look at ones with fewer days to expiry. 

Continuing to scan down the list, the 15Oct and 17Sept expiries pay 7.81% and 7.39% annualized returns, respectively. For covered calls, I average about 5.9%, so getting more than 7% is definitely OK with me. I think I’ll sell the 15Oct$140 call for about $360 premium. 

option chain

After the Trade

I will monitor this option position carefully and look for opportunities to buy it back early and cheaply. Or, if it gets in trouble (share price creeps above $140), I might roll it (buy back this option and sell another one for a higher strike, further into the future, for a net credit on premium). Or I can just let the shares go and be happy enough with my profit. This is the reason I really love selling options…I can create income in a variety of market conditions, with very little risk. Yay!

But there are some risks with this strategy. One risk occurs if the share price declines substantially before the expiration. If you had not sold the call, you might be inclined to sell your shares before price declines further; but you are contractually obligated to hold the shares thru expiry. You could buy back the call, but this is often expensive. The other significant risk occurs if the share price shoots up like a rocket. For example, if AAPL price increases to $160 or so, I am still obligated to sell at $140. I’ve capped my potential profit. But, in general those risks are manageable and are minimized if you select the correct strike price.

PS – once you go through this process the first time, you can save your spreadsheet. The next time you want to find the best covered call, paste the MarketXLS results into the first 15 columns of your “template”, click Refresh All on the MarketXLS ribbon,  and let the formulas in the last 3 columns do their work automatically. No need to add them every time. Turn on your filters, sort, and voila! You will be on your way to making great decisions when you sell covered calls.

Disclaimer

None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person.
The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.
The article is written to help users collect the required information from various sources deemed to be an authority in their content. The trademarks, if any, are the property of their owners, and no representations are made. All trademarks referenced are the property of their respective owners. Other trademarks and trade names may be used in this document to refer to either the entity claiming the marks and names or their products. MarketXLS disclaims any proprietary interest in trademarks and trade names other than its own or affiliation with the trademark owner.

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی psg سایت شرط بندی جام جهانی شرط بندی جام جهانی 2026 سایت شرط بندی جام جهانی 2026 بازی انفجار رایگان سایت انفجار ضریب بالا بهترین سایت شرط بندی فارسی شرط بندی بدون فیلتر شرط بندی بازی رولت شرط بندی پوکر شرط بندی مونتی شرط بندی سنگ کاغذ قیچی شرط بندی بلک جک کرش رویال بت پاسور شرط شرط بندی تخته نرد آنلاین انفجار 2 بت شرط بندی بازی اسلات شرط بندی بازی پوپ سایت سامان بت ریور پوکر 2024 سایت 4030bet ورود به بازی انفجار دنس بت شرط بندی انفجار دنس آموزش بازی پوکر سایت شرط بندی 123 بهترین شرط بندی بهترین سایت شرط بندی انفجار اپلیکیشن بازی انفجار دانلود بازی انفجار انفجار بازی ربات بازی انفجار کازینو آنلاین ایرانی انفجار پولساز ورود به بازی انفجار بازی انفجار با شارژ 10 تومن سایت bet betyek وان ایکس برو آدرس سایت بت یک سایت دوست دختر اونلی فنز فارسی پیدا کردن دوست دختر ورود به ریور پوکر پدرام مختاری پویان مختاری نازنین همدانی مونتیگو داوود هزینه بیوگرافی آیسان اسلامی بیوگرافی دنیا جهانبخت سایت رسمی حسین تهی بیوگرافی کوروش وانتونز سایت آرتا وانتونز رها وانتونز بیوگرافی ربکا قادری سحر قریشی بیوگرافی تتلو بیوگرافی مهدی طارمی الناز شاکردوست سایت عادل فردوسی پور بیوگرافی نیلی افشار بیوگرافی محمدرضا گلزار سایت armin2afm بیوگرافی شادمهر عقیلی بیوگرافی سردارآزمون بیوگرافی علیرضا بیرانوند بیوگرافی رامین رضاییان وریا غفوری بیوگرافی علی دایی بیوگرافی پوریا پوتک مدگل سایت حصین بیوگرافی صدف طاهریان فرشاد سایلنت بیوگرافی آریا کئوکسر بیوگرافی sogang بیوگرافی میا پلیز بیوگرافی مهراد هیدن سایت رسمی سهراب ام جی بیوگرافی علیرضا جی جی بیوگرافی بهزاد لیتو اشکان فدایی بیوگرافی رضا پیشرو بیوگرافی گلشیفته بیوگرافی هیپ هاپولوژیست بیوگرافی سارن بیوگرافی آدام مرادی بیوگرافی محمد هلاکویی بیوگرافی علی حسنی سایت رسمی علی حسنی بیوگرافی ساسی خواننده بیوگرافی ابی باربد معصومی حسینی فایننس بیوگرافی امیرحسین نام آور بیوگرافی امین فردین بیوگرافی فرزاد وجیهی سایت سیب بت سایت jetbet آدرس جدید بت فوروارد وان ایکس بت سایت abt90 بازی انفجار سایت شرط بندی فاز بت بهترین سایت شرط بندی انفجار ورود به آلپاری آلپاری فارکس آدرس بروکر آلپاری بدون فیلتر ثبت نام در بروکر آلپاری فارسی صرافی کوکوین ربات فارکس بهترین سایت تتر

alexistogel toto online

bandar alexistogel

alexistogel bandar gacor

alexistogel link

alexistogel online

alexistogel bandar togel

link alternatif alexistogel

alexistogel

alexistogel

alexistogel

alexistogel daftar

alexistogel toto macau

alexistogel bandar macau

alexistogel slot

alexistogel agen slot

alexistogel

situs alexistogel

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel bandar slot

alexistogel

Alexistogel Toto Macau

alexistogel

bandar alexistogel

alexistogel slot

alexistogel link alternatif

alexistogel macau

alexistogel

alexistogel toto macau

slot alexistogel

alexistogel bandar togel

alexistogel

alexistogel rtp

alexistogel

alexistogel slot

alexistogel

alexistogel

alexistogel

alexistogel terpercaya

daftar alexistogel

alexistogel online

rtp alexistogel

alexistogel slot

alexistogel gacor

link alternatif alexistogel

alexistogel login

alexistogel

alexistogel slot dana

agen togel online

bandar togel online

alexistogel rtp

alexistogel slot

alexistogel daftar

alexistogel daftar

slot online dana

bandar togel slot

togel online terpercaya

slot pragmatic gacor

link situs slot resmi

situs slot online

link daftar togel slot

bandar slot gacor hari ini

bocoran pola slot

situs slot online

bandar slot online

bandar togel online

slot online terpercaya

togel slot online

slot deposit qris

agen slot online gacor

rtp live slot online

bandar slot online

bandar slot online gacor

agen slot online

daftar bandar togel slot

bandar togel online

togel slot hari ini

link alternatif togel slot

rtp slot online gacor

slot online gacor

situs slot gacor

rtp slot gacor

slot online gacor

tips slot maxwin

togel slot gacor

prediksi togel

game slot gacor

trik slot online

prediksi togel jitu

game slot online

togel online terpercaya

daftar togel slot online

bandar togel terpercaya

slot online gacor

trik slot bonus

prediksi togel online

rtp slot online

panduan togel online

RTP LIVE

Bandar Toto Macau

Situs Slot Gacor

bandarbola855 resmi

bandarbola855 gacor

bandarbola855 slot

link bandarbola855

bandarbola855 bola slot

bandarbola855 rtp

bandarbola855 slot online

bandarbola855 link

bandarbola855 bandar

bandarbola855 slot terpercaya

bandarbola855

bandarbola855 slot

bandarbola855 terpercaya

bandarbola855 online

slot bandarbola855

bandarbola855 slot

bandarbola855 daftar

bandarbola855 link

bandarbola855

bandarbola855

bandarbola855

bandarbola855 slot

bandarbola855

bandarbola855 rtp

bandarbola855

bandarbola855

bandarbola855

iosbet

iosbet

link iosbet

slot online iosbet

iosbet link login

slot iosbet

iosbet gacor

iosbet slot

iosbet

slot iosbet

agen iosbet

bandar iosbet

iosbet

iosbet link

bandar iosbet gacor

iosbet

iosbet

iosbet

iosbet

liatogel

bandar liatogel

login liatogel

live draw hk liatogel

liatogel slot online gacor

liatogel totomacau

liatogel link

slot gacor

daftar slot online

bandar slot dana

slot ovo

slot gopay