Put Ratio Back-Spread

Options are an important derivative class which allow traders to take positions and generate profits with limited amount of risks. Traders going long on options have to pay a premium whereas those going short/ writing the option charge premium. Apart from this there are multiple option trading strategies which enable traders to further reduce their downside risk and increase the chances of profit making based on different scenarios. The Put Ratio Back-Spread is a net premium credit strategy that involves selling put options at a higher strike price and buying a higher number of put options at a lower strike price of the same underlying stock. Maximum returns will be received when the stock falls below the OTM strike price. The ATM/ITM short put option will expire with a negative intrinsic value fetching the trader loss while the OTM long option will expire in a big profit. The overall value will be as per the pay of matrix
Put Ratio Back-Spread - MarketXLS

Created by: Nikita

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
I use MarketXLS to manage my personal portfolio. I can easily pull in stock quotes, betas, and dividends. I also like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance, Penn State University

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

I can now concentrate on manipulating financial data, valuing stocks and making investment decisions, rather than hacking around with VBA or copying and pasting data from websites.

Samir Khan

InvestExcel.net

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year.

Kirubakaran K.

Investment Professional

I Love My MarketXLS. The market speaks to you when you know how to listen. With MarketXLS, the market truly does speak. Patterns emerge. Pricing behavior becomes clearer.

Don Zelezny

Entrepreneur & Options Trader

Meet The Ultimate Excel Solution for Investors

Live Streaming Prices in your Excel
All historical (intraday) data in your Excel
Real time option greeks and analytics in your Excel
Leading data service for Investment Managers, RIAs, Asset Managers
Easy to use with formulas and pre-made sheets