Skip to main content

Live Ratio Spread Prices

The Ratio sheet shows the live net price of 1:N call and put ratio spreads across the option chain. Each row is a strike, each column is the distance to the second leg, and every cell has a buy value and a sell value worked out from live bid and ask.

ShowsNet credit or debit of 1:N call and put ratio spreads
GridRows = centre strike, columns = offset in points (e.g. 50 to 300 on NIFTY by default)
Ratio1:0.5 to 1:10 in steps of 0.5, set separately for calls (CE) and puts (PE)
PricingLive bid and ask of both legs; buy and sell values, per 1 centre lot
InstrumentsNIFTY, BANKNIFTY, SENSEX, FINNIFTY, MIDCPNIFTY, BANKEX; current and next NIFTY and SENSEX expiries
UpdatesStreams live during market hours
Open itquintalmind.com/sheets

What a cell means​

A ratio spread has two legs: one lot at the row strike (the centre) and N lots further out of the money. For a cell at strike K, offset D and ratio 1:N:

CALL RATIO table

  • Buy value: Buy 1 call at K, Sell N calls at K + D = N × bid(K + D) − ask(K)
  • Sell value: Sell 1 call at K, Buy N calls at K + D = bid(K) − N × ask(K + D)

PUT RATIO table

  • Buy value: Buy 1 put at K, Sell N puts at K − D = N × bid(K − D) − ask(K)
  • Sell value: Sell 1 put at K, Buy N puts at K − D = bid(K) − N × ask(K − D)

Both columns use the same sign: money received minus money paid. A positive number is a net credit and a negative number is a net debit. Values are for one lot of the centre strike, so 1:2.5 means 2.5 lots on the far leg for each centre lot.

Example (illustrative numbers): on a 1:2 call ratio, if the K call ask is 100 and the K + D call bid is 45, the buy value is 2 × 45 − 100 = −10, a 10-point debit.

The call table shows more strikes above the spot, and the put table more strikes below it. The ATM (at-the-money) row, the strike nearest the spot price, is highlighted.

Try it1:N ratio spread (buy value legs)Illustrative NIFTY strikes, gap 50
Table
  1. Buy 124000CE
  2. Sell 224200CE
2400024200

Value of these legs at expiry across spot prices, in points, before premiums. It shows the shape of the structure only; the live sheet shows the actual net price.

How to use it​

  1. Sign in with your broker and open Sheets, then pick a symbol in the left panel.
  2. Find the RATIO section. Use the Range: steppers to set the smallest and largest offset column.
  3. Use CE: and PE: with − and + to set the ratio for the call and put tables. The table titles change to, for example, CALL RATIO (1:3).
  4. Use the ↑ and ↓ arrows on each table to move the strike window up or down.
  5. Click a cell to see its two legs, Margin, Qty / 1 Cr and Charges (RT) (round-trip charges). From there you can Create Alert or Show Chart for an intraday chart of that spread.
  6. Double-click a cell to mark it.
  7. Choose Buy, Sell or Buy + Sell columns for this sheet in Profile → Sheet layout.
Broker basket

If you signed in with Zerodha, Alice Blue or FYERS, the leg popup also shows Buy and Sell buttons that open the legs as a basket on your broker's own page. Quintal Mind does not place the order.

The same Ratio sheet is also available for MCX commodities. See MCX option sheets.

FAQ​

Where can I see live Nifty ratio spread prices?​

On the Quintal Mind Sheets page, in the RATIO section. It shows a call ratio table and a put ratio table, with one row per strike and one column per distance between the legs.

Which ratios can I use?​

Any 1:N ratio from 1:0.5 to 1:10, in steps of 0.5. The call and put tables each have their own ratio.

What does a positive ratio spread value mean?​

Both columns show money received minus money paid. A positive value is a net credit and a negative value is a net debit, for one lot of the centre strike.

Are the prices based on LTP?​

No. Every value uses the live bid and ask of each leg, so it reflects the price you would get crossing the spread.

Quintal Mind shows market data and analytics for information only. Nothing here is investment advice, and Quintal Mind does not place orders.

Last updated on