Covered Puts – What They Are & How You Can Profit From Them (Marketxls Options Data)

In this article, we are going to demonstrate what a covered put is, when you would use it, and how MarketXLS can help you in applying the strategy.

What are Covered Puts?

A covered put is a bearish investment strategy. You would usually consider applying it when you expect that a stock price might fall, yet you are not too bearish on the stock.

At the time of writing this article – in the midst of the coronavirus pandemic, this strategy is all the more relevant. Maybe you estimate that there is still potential for the market to go down, but you are wary of taking a short position due to the market’s unpredictability. Applying the covered put strategy is a way to reduce risk.

Applying the covered put strategy involves making two separate trades:

  1. short selling the selected stock and
  2. selling an “out of the money” put option on the same stock.

How to Perform a Covered Put Using MarketXLS

Let us see how we would apply the strategy on Microsoft (MSFT) shares.

Step 1.

Using the well-known MarketXLS function =Last(“MSFT“) I see that, at the time of writing the article, a MSFT share last traded at $163.49.

Step 2.

Next, I need to import the MSFT options data into an Excel sheet. You can do this by selecting a cell inside the spreadsheet, in which you have entered the ticker MSFT, and then selecting “Get Option Chains” from the “Utilities” drop-down menu in the MarketXLS tab in your Excel ribbon. We need to select “Option Chain Out of The Money”. (Note: to access options data, you will need the additional QuoteMedia data subscription.)

covered put instructions - get option chains from utilities of MarketXLS

This will import 27 columns of options data into your spreadsheet. For the purpose of this article, I have hidden the columns which we won’t be using at this time.

Step 3.

The resulting overview looks like this:

MarketXLS - filter put options in Excel

Step 4.

I would suggest adding the Excel “filter” buttons to column headers so that we can focus exclusively on the put options and to be able to sort them as desired. We want to make some money by selling a put option on MSFT, so I will sort the filtered put options from the most expensive one to the cheapest one. Top results now look something like this:

Excel - sort put options by most expensive to the cheapest

If you are new to options, you may need to be informed that, while option prices are depicted as prices for 1 option for 1 underlying security (in this case, a MSFT share), options are traded in lots of 100. So, the latest price of $28.65 for the option at the top of our list, @MSFT  220916P00160000, means that you can sell a lot of 100 of these options and receive a premium of $2,865.

The strike price for these options sits at $160, very close to the latest MSFT stock price.

The reason why anyone would buy this put option is that, for them, it represents a guarantee that, whatever happens, they will be able to sell their MSFT shares for at least $160 per share, and they have this guarantee until September 16th, 2022, which is the expiration date.

Step 5.

For our example explanation of the covered put strategy, we don’t want to be tied in the option contract for so long. Filtering the above table further, to only show us only options which expire in the next three months, I get the following list.  The option contract that I selected is marked blue.

MarketXLS Covered Put example strategy

How Taking a Short Position in the Options Contract Looks

By taking a short position in the options contract @MSFT  200619P00150000, we can immediately receive a $695 premium ($6.95 per option * 100 options in a lot). To complete the covered put setup, we need to short sell 100 MSFT shares, for $16,349. This results in our net cash position at:

$695 + $16,349 = $17,044

What have we accomplished with this setup and how much do we stand to lose or gain?

  1. In our bearish strategy, we have reduced the risk from the stock price increasing

Loss or Gain?

Not considering the broker fees which your real-life trades inevitably incur and which you need to take into consideration, selling this put option moves our break-even point to MSFT share price of $170.44. This is because even though we have entered a short stock position, by selling MSFT at $163.49 per share, we have already received the option premium of $6.95 per option.

As long as MSFT stock price remains below $170.44, our net cash result for these trades remains positive. Even if the stock price climbs to, say, $180 per share by the expiration date, June 19th, 2020, our loss will be lower than if we did not enter the options trade, as shown below.

Without the option trade, short selling 100 shares:

$16,349 (initial cash position from shorting MSFT) – $18,000 (closing the short position at a loss) = -$1,651

With the option trade, covered put strategy, short selling 100 shares:

$16,349 (initial cash position from shorting MSFT) + $695 (received options premium) – $18,000 (closing the short position at a loss) = -$956.

Assuming that our assumption pans out, we have received additional income

Keep in mind that our estimate for MSFT shares, which prompted us to enter the covered put strategy, was moderately bearish. We expect the stock to fall a few dollars per share, not to lose 20% or more of its value.

By shorting the share at $163.49 and selling a put with a $150 strike price, our potential income maxes out if the options expire at the money, with MSFT trading at $150 per share.

If MSFT shares fall to $140, for example, we will not fully benefit from our short position initiated at $163.49 per share, because the option which we sold will expire in the money and we will be forced to buy the stock back for $150 per share. This will be fully clear if we examine three potential scenarios.

Our Covered Put Example – The Bottom Line

Scenario 1 – option expires out of the money, with MSFT trading at $155 per share

$16,349 (initial cash position from shorting MSFT) – $15,500 (closing the short position if we wish) + $695 (received options premium) = $1,544

In this case, we have made a net $1,544 from the trade, which is $695 more than if we only shorted the stock, without selling the put options.

Scenario 2 – option expires at the money, with MSFT trading at $150 per share

$16,349 (initial cash position from shorting MSFT) – $15,000 (closing the short position if we wish) + $695 (received options premium) = $2,044

This is our maximum possible profit, with the described covered put setup.

Scenario 3 – option expires in the money, with MSFT trading at $140 per share

$16,349 (initial cash position from shorting MSFT) – $14,000 (closing the short position if we wish) + $695 (received options premium) – $1,000 (holder exercises his options, resulting in this loss for us, as the option expired $10 above the market price for the stock = $2,044

Scenarios 2 and 3 show us why this strategy is applied when we are only moderately bearish on the stock. If the stock price falls below the option strike price, it would have been better for us if we had not sold the put option. But in any other case, received option premium provides considerable additional income for the trader.

Three Things to Consider Before You Implement this Investment Strategy

  1. Unlike potential income which maxes out as described above, there is no limit to possible losses if the stock price shoots up. To protect against that threat, you may consider a stop-loss order on your short sale.
  2. Broker commissions were omitted in the model. Therefore, you will see slightly lower profits than in this theoretical example, and your break-even point will be slightly below $170.44 for a MSFT share.
  3. Our example uses only last closing prices, both for options and stock prices. Using MarketXLS with QuoteMedia data subscription enables you to monitor bid and ask prices for both stocks and options in real-time.
Verelq News |
16.04.2024

alexistogel macau

alexistogel

link alexistogel

situs alexistogel

alexistogel rtp

situs alexistogel

link alternatif alexistogel

alexistogel gacor

bandar alexistogel

alexistogel

alexistogel

alexistogel terpercaya

alexistogel gacor

alexistogel

alexistogel 4d

alexistogel

alexistogel

alexistogel gacor

alexistogel terpercaya

agen togel online

link alexistogel

alexistogel toto

alexistogel

alexistogel rtp

situs alexistogel

bandar alexistogel

alexistogel

link alexistogel

alexistogel

alexistogel togel slot

alexistogel

alexistogel online

alexistogel

alexistogel gampang menang

alexistogel 4d

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

slot gacor alexistogel

Alexistogel

Alexistogel

Alexistogel

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی 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

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