Working with Cells
Every value on a Quintal Mind sheet is a live spread price. Clicking a cell shows what is behind that price: the legs, the margin, the charges, an intraday chart, an alert form and a broker basket.
| Shows | Legs, margin, charges, intraday chart, alerts and marks for any sheet cell |
| Layout | Popup next to the cell; full-screen chart; docked panel for combo cells |
| Pricing | The cell's live bid/ask value; chart uses 1-minute candles of each leg |
| Instruments | All index and MCX option sheets |
| Updates | Popup values follow the live sheet |
| History | Chart lookback of 1, 5 or 7 days for equity and up to 30 days for MCX |
| Open it | quintalmind.com/sheets |
What you see
Single click: the leg popup
A single click opens a popup on the cell with:
- Legs: each leg as BUY or SELL, quantity, strike and CE/PE.
- Margin for the basket and Qty / 1 Cr, which is how many of this spread ₹1 crore of margin covers.
- Charges (RT): round-trip statutory charges in points, worked out from the rates in your Profile.
- Create Alert, Show Chart and, for some brokers, Buy / Sell.
Show Chart: the legs chart
Show Chart opens a full-screen chart of the spread's net price. It adds up the 1-minute candles of each leg, with a plus sign for sold legs and a minus sign for bought legs. It shows Min, Live and Max. Pick an Interval (1m, 5m, 15m, 1h, 1d) and a Lookback (1d, 5d, 7d for equity; up to 30d for MCX).
Double click: marks
Double-click a cell to mark it with a highlight so you can watch it. Double-click again to remove the mark. Marks are saved to your account.
Create Alert
Create Alert opens a form without leaving the sheet:
- Strike Specific watches this exact contract. ATM Based follows the same position relative to ATM (at-the-money) as spot moves.
- Falls below or Rises above a level. Live fills in the current value.
- + Add lowest straddle condition adds a second condition joined with AND.
- One-shot pauses the alert after it fires once.
Broker basket Buy / Sell
If you signed in with Zerodha, Alice Blue or FYERS, the popup shows one Buy and one Sell button. Buy sends the legs as listed. Sell reverses every leg. The legs open as a basket on your broker's own page, where you can check them and place the order. Quintal Mind places no orders. With other sign-ins, the buttons do not appear.
Export to Greeksoft
Combo butterfly popups and the combo panel have Export to Greeksoft. It downloads a basket CSV that Greeksoft can load, with your IDs from Profile → Greeksoft account filled in. A basket can have 1 to 6 legs.
Combo analysis panel
Clicking a combo butterfly cell also opens a panel on the right. It shows:
- BUY and SELL values, Mid, Quoted width and Expiry in.
- Legs & LTP with each leg's bid and ask.
- Payoff at expiry with breakevens and Open in Payoff.
- Historical (NET or WINGS; 1D, 5D, 1M, ALL).
- Fair value · flat vol, Position greeks, OI at the six strikes, Across this column and Z-score & distribution.
Bell curve overlay
The bell-curve button in the left panel (or Bell curve overlay in the profile menu) compares live NIFTY and NIFTY NEXT combo cells with historical bell-curve data at a similar straddle level. Set Δ in steps of 5 to shift the straddle level being tracked, then press Apply. Press Clear to turn it off.
How to use it
- Sign in with your broker at quintalmind.com and open Sheets.
- Click any value once to open its popup.
- Click Show Chart, Create Alert or a broker button.
- Double-click a value to mark it.
Related
- Alerts and Telegram covers managing alerts and getting them on Telegram.
- Combo butterfly explains the combo cells.
- Settings sets charges, Greeksoft IDs and the sheet layout.
FAQ
How do I see the legs and margin of a spread on Quintal Mind?
Click the cell once. A popup lists every leg with its buy or sell side, quantity, strike and option type, along with the margin and the round-trip charges.
Can I chart a spread price for the whole day?
Yes. Click Show Chart in the cell popup. It plots the net price of all legs with 1m to 1d bars, and you can look back 1, 5 or 7 days for equity and up to 30 days for MCX.
Does Quintal Mind place orders?
No. If you signed in with Zerodha, Alice Blue or FYERS, the Buy and Sell buttons open the legs as a basket on your broker's own page. You review and place the order there.
How do I export a combo to Greeksoft?
Save your Greeksoft client and account IDs in Profile, then click Export to Greeksoft in a combo popup or the combo panel. It downloads a basket CSV with your IDs filled in.
Quintal Mind shows market data and analytics for information only. Nothing here is investment advice, and Quintal Mind does not place orders.