MCX Live Prices in Excel: Gold, Silver, Crude Oil Streaming Guide (2026)

Why MCX Data in Excel?

To get live MCX prices in Excel, install the MarketXLS India add-in, connect your Zerodha or Angel One account, and type a formula such as =mxlsIN.ZerodhaLast("GOLD26FEBFUT:MCX") (or =mxlsIN.AngelOneLast(...) for Angel One). The cell streams the last traded price for gold, silver, crude oil, natural gas, copper, or any other MCX futures or options contract while MCX is open. You need an active account with one of the two brokers; no coding is required.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

Broker terminals show live prices, but building a custom watchlist, running calculations across contracts, or tracking P&L there usually means copy-pasting numbers.

MCX Bhavcopy gives you end-of-day data. Fine for backtesting. Useless for live trading.

The Kite Connect API and Angel One SmartAPI can stream MCX data, but they require Python, WebSocket code, and server infrastructure. Most commodity traders are not developers.

MarketXLS India replaces that code with Excel formulas that stream MCX futures and options prices through your broker connection. No VBA or DDE links are needed.

---

Supported MCX Commodities

MarketXLS India streams live data for every commodity listed on MCX through your Zerodha or Angel One account. Here are the most popular contracts:

Precious Metals

Energy

Base Metals

Agricultural

---

Understanding MCX Symbol Format

MCX symbols follow a specific pattern. Understanding this lets you stream any contract, not just the ones listed above.

Futures Symbol Format

{COMMODITY}{YY}{MMM}FUT

Examples:

• GOLD26FEB + FUT = GOLD26FEBFUT (Gold February 2026 Futures)
• CRUDEOIL25SEP + FUT = CRUDEOIL25SEPFUT (Crude Oil September 2025 Futures)
• SILVER25DEC + FUT = SILVER25DECFUT (Silver December 2025 Futures)

Append :MCX to be explicit about the exchange: GOLD26FEBFUT:MCX

Options Symbol Format

MCX options use the standard MarketXLS options format:

@{COMMODITY}{YYMMDD}{C/P}{STRIKE x 1000, padded to 8 digits}

Examples:

• Gold 75000 CE expiring Feb 5, 2026: @GOLD260205C75000000
• Crude Oil 5700 CE expiring Feb 17, 2026: @CRUDEOIL260217C05700000
• Silver 90000 PE expiring Dec 5, 2025: @SILVER251205P90000000

You can also use the raw Zerodha symbol: CRUDEOIL26FEB5700CE:MCX

---

Step-by-Step Setup

Step 1: Install MarketXLS India

1. Open Excel (desktop or web)
2. Go to Insert > Get Add-ins
3. Search for MarketXLS India
4. Click Add and sign in with your MarketXLS India credentials

Step 2: Connect Your Broker

MarketXLS India works with both Zerodha and Angel One for MCX data.

For Zerodha:

1. Open the MarketXLS India sidebar in Excel
2. Click Connect Zerodha
3. Log in with your Zerodha credentials
4. Authorize the connection

For Angel One:

1. Open the MarketXLS India sidebar
2. Click Connect Angel One
3. Enter your Client ID, Password, API Key, and TOTP
4. Connection is established automatically

Once connected, you are ready to stream MCX data.

Step 3: Type Your First Formula

In any cell, type:

=mxlsIN.ZerodhaLast("GOLD26FEBFUT:MCX")

The cell will show "Loading..." briefly, then display the live gold futures price. It updates automatically as the market moves.

---

Available Data Points

Every MCX contract supports these streaming data points:

Replace SYMBOL with any MCX symbol like GOLD26FEBFUT:MCX or CRUDEOIL25SEPFUT:MCX.

---

Build a Live MCX Commodity Dashboard

Here is a practical commodity watchlist you can build in minutes.

Layout

Formulas (Row 2 — Gold)

C2: =mxlsIN.ZerodhaLast(B2)
D2: =mxlsIN.ZerodhaOpen(B2)
E2: =mxlsIN.ZerodhaHigh(B2)
F2: =mxlsIN.ZerodhaLow(B2)
G2: =IF(AND(ISNUMBER(C2),ISNUMBER(D2),D2<>0), (C2-D2)/D2*100, "")

Copy the formulas down for rows 3-6. Every cell references column B, so just change the contract symbol in column B to track any MCX commodity.

Add Conditional Formatting

• Select column G (Change %)
• Apply Green fill for values > 0
• Apply Red fill for values < 0

You now have a live, colour-coded MCX commodity dashboard.

---

MCX Options Trading in Excel

Track MCX commodity options alongside futures for a complete derivatives view.

Example: Crude Oil Options

This gives you a live options chain for crude oil, which MCX Bhavcopy (end-of-day settlement prices) does not provide.

---

MCX vs Bhavcopy: Why Live Data Wins

Bhavcopy is useful for end-of-day record keeping. For active trading decisions, you need live data.

---

Zerodha vs Angel One for MCX Data

Both brokers are supported. Here is how they compare for MCX commodity streaming:

Recommendation: Use whichever broker you already have an account with. Both deliver the same MCX data through MarketXLS India.

---

Practical Use Cases

1. Gold-Silver Ratio Tracker

The gold-silver ratio tells you how many ounces of silver it takes to buy one ounce of gold. It is a popular indicator for precious metals traders.

Gold LTP:    =mxlsIN.ZerodhaLast("GOLD26FEBFUT:MCX")
Silver LTP:  =mxlsIN.ZerodhaLast("SILVER25DECFUT:MCX")
Ratio:       =B1/B2

2. Crude Oil Spread Monitor

Track the spread between different crude oil contract months for calendar spread trading.

Near Month:  =mxlsIN.ZerodhaLast("CRUDEOIL25SEPFUT:MCX")
Far Month:   =mxlsIN.ZerodhaLast("CRUDEOIL25OCTFUT:MCX")
Spread:      =B1-B2

3. Multi-Commodity P&L Tracker

Enter the Lot Size column as a number (the multiplier that converts a price move into rupees per lot), not as text, or the P&L formula returns an error.

Your P&L updates live as prices move. No manual refresh needed.

---

Tips for MCX Trading in Excel

1. Use the :MCX suffix — While many MCX symbols work without the suffix, adding :MCX ensures the symbol resolves to the commodity exchange and not an equity with a similar name.

2. Update contract symbols on expiry — MCX futures expire monthly or bi-monthly. When your current contract expires, update the symbol in your spreadsheet to the next month's contract.

3. MCX trading hours differ from equity — MCX commodities trade from 9:00 AM to 11:30 PM IST (Monday-Friday). Your Excel data will stream during these hours.

4. Start with the most liquid contracts — Gold, Silver, Crude Oil, and Natural Gas have the highest volumes. These will have the tightest spreads and most reliable streaming data.

---

Frequently Asked Questions

Can I get MCX data without a broker account?

No. MarketXLS India streams data through your broker's WebSocket connection (Zerodha Kite or Angel One SmartAPI). You need an active trading account with either broker.

Is there a limit on how many MCX symbols I can stream?

Zerodha supports up to 3,000 instruments per session. Angel One supports up to 1,000 per WebSocket connection. For a typical commodity watchlist of 10-20 contracts, you will never hit this limit.

Does MCX data work on Excel Online (web)?

Yes. MarketXLS India works on Excel desktop (Windows/Mac) and Excel Online through Office 365. The streaming formulas are identical.

Can I export MCX data to CSV?

Yes. Once the data is streaming in Excel, use File > Save As > CSV to export a snapshot. For automated CSV exports, you can combine MarketXLS formulas with Excel's built-in macro recorder to save at intervals.

What about MCX historical data?

This guide covers live streaming. For historical MCX OHLCV data, MarketXLS provides separate historical data functions. Check the MarketXLS India documentation for details.

How much does it cost?

Streaming covers NSE, BSE, and MCX through your broker connection. Visit marketxls.in/pricing for current plans.

---

Get Started

1. Subscribe to MarketXLS India
2. Install the Excel add-in
3. Connect your Zerodha or Angel One account
4. Start streaming MCX commodity prices

Every formula in this guide works the moment you connect your broker. No setup scripts, no API keys to manage, no server to maintain.

Related Guides:

• Angel One SmartAPI Integration Guide
• Zerodha Excel Integration Guide
• Intraday Trading Dashboard in Excel
• Get Nifty Futures Live Data in Excel