MCX Bhavcopy
Download the day's file from MCX, then drop it below to see futures, open interest, put-call ratio and max pain by commodity.
Processed in your browser. The file is not uploaded and BhaavBrief does not keep it.
How to get the file
- Open the Bhavcopy page on the MCX website (Market Data, then Bhavcopy).
- Choose the date, and the date-wise or commodity-wise view. MCX says data is available from November 2003.
- Download the file and drop it into the viewer above. Files with an .xls extension work exactly as downloaded.
What is in the file
| Column | Meaning |
|---|---|
| Date | The trading date. A bhavcopy file covers one date. |
| Instrument Name | FUTCOM: commodity futures. OPTFUT: options on commodity futures. FUTIDX: index futures. OPTIDX: index options. |
| Symbol | The commodity or index code, such as GOLD, CRUDEOIL or SILVERM. |
| Expiry Date | When the contract expires, written like 30SEP2026. |
| Option Type | CE for a call, PE for a put. A dash for futures. |
| Strike Price | The option strike. Zero for futures. |
| Open, High, Low | The session's prices. Contracts that did not trade have these blank. |
| Close | The contract's closing price. |
| Previous Close | The prior session's close. |
| Volume(Lots) | Contracts traded, in lots. |
| Volume(In 000's) | Volume in thousands of the contract's own unit (KGS, GRMS, BBL, mmBtu and so on). |
| Value(Lacs) | Value in lakh, as reported. On option rows it can be far larger than the premium paid, so do not add option and futures values together. |
| Open Interest(Lots) | Lots still open at the end of the day. |
What you can read from one day's file
- Where open interest sits: the strikes and expiries holding the most open contracts.
- Put-call ratio: how put open interest compares with call open interest for an expiry.
- Max pain: the strike where option writers would pay out least, given that day's open interest.
- Rollover: how open interest is spread across near and far expiries of a commodity.
- What actually traded: which contracts had volume, out of the many that are listed.
Change in open interest, and any trend, needs files from two or more days. This page describes data; it is not a recommendation to buy or sell.
Questions
What is the MCX bhavcopy?
The bhavcopy is the exchange's end-of-day file for one trading date. It lists every futures and options contract with its open, high, low, close, previous close, volume, value and open interest.
Where do I download the MCX bhavcopy?
On the MCX website under Market Data, then Bhavcopy. Pick a date and view it by date or by commodity; MCX says data is available from November 2003. Load the file you download into the viewer above to analyse it.
Does the viewer upload or store my file?
No. The file is read inside your browser and is not sent to BhaavBrief or anyone else. Close the tab and it is gone.
Why does the file have so many rows?
It lists every listed contract, including option strikes that did not trade. In the files we checked, fewer than one row in ten had any volume or open interest, so the viewer hides the rest unless you ask for them.
Why are volumes in different units?
Volume is given in lots and also in thousands of each contract's own unit, such as kilograms, barrels or mmBtu. Volumes of different commodities are not comparable, so the viewer never adds them together.
Can I see the change in open interest from this file?
Not from a single file: it holds one day only and has no open-interest change column. Compare the open interest of two consecutive days to see how positions moved.
For live numbers, see the MCX option chain, put-call ratio, max pain and open interest.
BhaavBrief is not affiliated with MCX. The viewer reads a file you provide; it does not host or republish exchange data.