Skip to main content

Historical Sheets

Historical Sheets replays a past trading day on the same spread sheets you use live. Pick a date, pick an instrument, and drag the time slider to see the butterfly, ratio, pulse and combo grids as they stood at any minute of that session.

ShowsPast-day versions of the live spread sheets, plus four day charts
LayoutCalendar and symbol list on the left; sheets or charts on the right; time slider at the bottom
Data1-minute archive; real bid and ask on some days, last traded price on others
InstrumentsNIFTY, NIFTY NEXT, BANKNIFTY, SENSEX, SENSEX NEXT, FINNIFTY, MIDCPNIFTY, BANKEX; GOLD, GOLDM, SILVER, SILVERM, CRUDEOIL, CRUDEOILM, NATURALGAS, NATGASMINI
HistoryEvery day in the archive is highlighted in the calendar
Open itquintalmind.com/analysis/historical-sheets

What you see​

The left panel has a month calendar. Days with archived data are highlighted and clickable; other days are not. Below it is a Charts / Equity / MCX switch and the symbol list for that market.

Equity shows the index sheets in the same row order you set for the live dashboard: combo butterfly, four-leg ratio, ratio (call and put), custom butterfly, butterfly (1:2:1) and pulse.

MCX shows MCX Butterfly, Cross Butterfly, Ratio (Call & Put) and Pulse (1:3:3:1) for the chosen commodity. Two extra pages sit in the sidebar: Future Calendar (futures of every commodity for that day) and Options Arbitrage.

Charts shows four panels for the whole day:

  • Synthetic Straddle, with a data interval from 1s to 5m, and the spot, call minus put, and synthetic spot values.
  • Skewness: the IV smile at the close of the session.
  • PCR (premium): total put premium ÷ total call premium over ATM ±10 strikes. The archive holds no open interest, so this ratio uses premiums.
  • Spot as a line.

At the bottom of the sheet views, the bar shows the date, a pricing chip and the Time slider. Real Bid/Ask means buy and sell use the archived best bid and ask at the start of each minute. LTP Pricing means no bid and ask was archived for that day, so buy and sell both use the minute's first trade.

How to use it​

  1. Sign in with your broker and open Historical Sheets, or go to Analysis.
  2. Choose Equity or MCX, then pick a symbol.
  3. Click a highlighted day in the calendar. The latest archived day loads first.
  4. Drag the Time slider to move through the session minute by minute.
  5. Switch to Charts to see the straddle, skew, PCR and spot for the whole day.

A link with a date and instrument in it (for example from the Bell Curves page) opens that exact day.

  • Butterfly prices: the live version of the butterfly grid.
  • Bell curves: typical spread values by straddle level, with links back to the days behind them.
  • Straddle chart: the live straddle and its history.

FAQ​

Where can I see NIFTY butterfly and ratio spread prices for a past date?​

On Quintal Mind's Historical Sheets. Pick a date in the calendar and the same sheets you use live are rebuilt for that day, one minute at a time.

How far back does the historical data go?​

The calendar highlights every day that is in the archive for the selected instrument. The MCX archive starts later than the index archive.

Are historical spread prices based on bid and ask or LTP?​

It depends on the day. A Real Bid/Ask chip means archived best bid and ask were used. An LTP Pricing chip means both buy and sell use the first trade of each minute.

Does it cover MCX commodities?​

Yes. GOLD, GOLDM, SILVER, SILVERM, CRUDEOIL, CRUDEOILM, NATURALGAS and NATGASMINI, with the futures calendar and options arbitrage pages as well.

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