Custom Spread

The Custom Spread sheet lets you design your own 2 to 6 leg option spread and see its live price at every strike around the ATM (at-the-money) strike. You set each leg once; the sheet slides the whole structure across the chain and prices it from the live bid and ask of every leg.

Shows	Net buy and sell price of a spread you define
Legs	2 to 6; each leg has its own BUY/SELL, CE/PE, offset and quantity
Rows	21 anchor strikes around the ATM strike
Expiries	Per-leg expiry on NIFTY and SENSEX (two nearest expiries); one expiry on other indices
Pricing	Live bid and ask of every leg; buy and sell values
Instruments	NIFTY, BANKNIFTY, SENSEX, FINNIFTY, MIDCPNIFTY, BANKEX
Updates	Streams live during market hours
Open it	quintalmind.com/sheets

What a cell means

Each row is an anchor strike A. Each leg has a signed offset in points from that anchor. The leg's strike is:

• CE leg: A + offset, rounded up to the strike grid
• PE leg: A + offset, rounded down to the strike grid

The two columns are:

• Buy (open the spread as you set it) = sum of (bid × qty) on SELL legs − sum of (ask × qty) on BUY legs
• Sell (the reverse trade) = sum of (bid × qty) on BUY legs − sum of (ask × qty) on SELL legs

Both are money received minus money paid: a positive number is a net credit and a negative number is a net debit. A cell where a leg's strike is not on the chain is marked as missing.

Example (illustrative): with legs BUY 1 CE +0, SELL 2 CE +200 on NIFTY, the row 24000 prices Buy 1 call at 24000 and Sell 2 calls at 24200.

How to use it

1. Sign in with your broker and turn on Custom Spread in Profile → Sheet layout. It is off by default.
2. Open Sheets, pick a symbol, and click the CUSTOM SPREAD header to open it.
3. Pick the number of Legs (2 to 6).
4. For each leg (L1, L2 ...), click BUY/SELL and CE/PE to switch them, and use − and + to set the Offset (in steps of the strike gap) and the Qty (1 or more).
5. On NIFTY and SENSEX, an Expiry column appears. Set a leg to the second expiry to build a calendar or diagonal spread.
6. Read the Buy and Sell columns. Click a cell to see the exact legs, Margin and Qty / 1 Cr.
7. Double-click a cell to mark it.

Related

• Four-leg ratio spread is a fixed four-leg structure with ready-made tables.
• Iron condor and iron butterfly prices a common four-leg credit structure.
• Settings covers Profile and the sheet layout.

FAQ

Can I price my own multi-leg option spread live on Nifty?

Yes. The Custom Spread sheet lets you define 2 to 6 legs, each with its own side, CE or PE, offset and quantity, and shows the live price of that spread at 21 strikes.

How do I turn on the Custom Spread sheet?

It is off by default. Turn it on in Profile, Sheet layout, then open the CUSTOM SPREAD section on the Sheets page.

Can the legs be on different expiries?

On NIFTY and SENSEX, yes. Each leg can use one of the two nearest expiries, so you can build calendar and diagonal spreads. Other indices use one expiry.