Authorized NSE, BSE & MCX

Real-Time Market Data
Streaming Inside Your Sheets.

Live market data streaming straight into your spreadsheet — under 50ms, our servers to your cell (typical, excluding your own network). Analytics and historical insights included.

bolt
No Refresh
Data arrives on its own
speed
Always Streaming
NIFTY 50 and every other symbol
monitoring
Live Streaming
Every update the exchange sends
workspace.truedata.in/sheets
LIVE
query_stats
OI Analytics
PCR • Greeks
acute
Works In Your Sheet
No add-in or bridge required
network_node
No Polling
Updates are pushed to you
space_dashboard Ready-to-Use

Quick Templates

Pre-built spreadsheet templates designed for options trading, OI analysis, and chart visualization.

MaxPain Sheet
description
MaxPain Sheet
public Public Template
open_in_new
Nifty OI Trader
description
Nifty OI Trader
public Public Template
open_in_new
Sheet With Chart
description
Sheet With Chart
public Public Template
open_in_new
TrueData Sample
description
TrueData_Sample
public Public Template
open_in_new
Watchlist
description
Watchlist
public Public Template
open_in_new
compare Developer & Trader Friendly

In-Built Scripting Engine

Build custom algorithms, listen to live WebSockets, fetch historical option chains, and automate your spreadsheet workflows logically.

bolt
Real-Time Event Handlers

Listen to every update the exchange sends, 1m/5m OHLCV bars, Bid/Ask quotes & live Option Greeks instantly with TD.on().

sync
Lifecycle Management

Clean startup and shutdown with TD.onStart & TD.onStop to prevent memory leaks and orphan streams.

grid_view
High-Speed Sheet Read/Write

Non-blocking async spreadsheet control using TD.Sheet.setCellRange and getCell.

data_object
Option Chain & Historical REST APIs

Fetch past bars, top gainers, and full option chains with Greeks in a single async call.

Script Engine
const SYMBOLS = ["RELIANCE"];
let symbolMap = {}, currentRow = 2;

// 1. Listen to real-time 1-min OHLCV bars
TD.on("bar1min", async (data) => {
  const symName = symbolMap[data[0]] || data[0];
  await TD.Sheet.setCellRange("A" + currentRow, [
    symName, data[1], parseFloat(data[2]), parseFloat(data[5])
  ]);
  currentRow++;
});

// 2. Start hook - subscribe symbols & write headers
TD.onStart = async () => {
  await TD.Sheet.setCellRange("A1", ["Symbol", "Time", "Open", "Close"]);
  const res = await TD.Feed.addSymbols(SYMBOLS);
  if (res.success) symbolMap[res.symbollist[0][1]] = res.symbollist[0][0];
};

// 3. Stop hook - Clean up subscriptions
TD.onStop = async () => await TD.Feed.removeSymbols(SYMBOLS);
const SYMBOL = "NIFTY"; // Mapped index display name
const EXPIRY = "07-07-2026";

TD.onStart = async () => {
  // One-shot fetch option chain with live Greeks
  const data = await TD.OptionChain.getOptionChainWithGreeks({
    symbol: SYMBOL,
    expiry: EXPIRY
  });

  if (data.records && data.records.length > 0) {
    for (let i = 0; i < data.records.length; i++) {
      await TD.Sheet.setCellRange("A" + (i + 1), data.records[i]);
    }
    TD.log("Option Chain with Greeks successfully loaded!");
  }
};
const SYMBOLS = ["NIFTY 50", "RELIANCE"];

// Listen to live tick stream
TD.on("tick", (data) => {
  const ltp = parseFloat(data[2]);
  TD.log("LTP Update: " + ltp);
});

TD.onStart = async () => {
  await TD.Feed.addSymbols(SYMBOLS);
};

TD.onStop = async () => {
  await TD.Feed.removeSymbols(SYMBOLS);
};

verified Powerful Features

Everything You Need
for Professional Trading

Real-time streaming, derivatives analytics, built-in formulas
and enterprise-grade market data — all inside a powerful spreadsheet.

link
Live

Automated Option Chains

Live option chains that update automatically without manual refresh.

  • check Live Option Sheets
  • check Auto Updating Streams
workspace.truedata.in/sheets
LIVE
analytics
Derivatives
OI & PCR Analytics

Analyze derivatives with powerful Open Interest and Put Call Ratio tools.

PCR
Bullish
Strike-wise OI
OI Build-up
workspace.truedata.in/sheets
LIVE
calculate
Greeks
IV & Greeks

Access complete real-time derivatives analytics metrics inside sheets.

IV Delta Gamma Theta Vega Rho
workspace.truedata.in/sheets
LIVE
show_chart
Interactive
Live Charts

Interactive real-time charts directly inside your workflow processes.

workspace.truedata.in/sheets
LIVE
sensors
Live Market Data
Live Data Features

Every quote streams automatically with real-time updates.

  • check Live Streaming Quotes
  • check Live Volume Updates
  • check Row-by-Row Bar Streaming
  • check Live OI Updates
  • check Live Bid / Ask Updates
Every update the exchange sends. Live.
workspace.truedata.in/sheets
LIVE

compare Feature Comparison

Why Traditional Sheets Fall Short

See why active traders switch from traditional spreadsheets to TrueData's streaming infrastructure.

Features
Sheets by TrueData
Microsoft Excel Microsoft Excel
Google Sheets Google Sheets
Data Updates Streaming updates RTD/DDE push via a local add-in Refreshes on a schedule or recalculation
Performance under load Designed for continuous market feeds Depends on your desktop machine Subject to Google API quotas
Real-time latency Streaming, no refresh required Excel RTD: requires a local desktop bridge and a funded broker account Fetched via API calls, not a persistent stream
Option Greeks support Live Greeks engine
Data Freshness Updates as the exchange sends them Set by the add-in refresh interval Set by the trigger interval
Streaming Updates Continuous streaming Via RTD add-in Via scheduled API calls
Update Speed No refresh, no polling Set by the add-in refresh rate Set by the API provider
Live Bar Streaming Fully Supported
Automated Option Chains Automated & Live
Open Interest (OI) Real-time OI Via RTD add-in Depends on the API used
PCR Analytics Built-in Engine Requires custom Apps Script
IV & Greeks Real-time IV Requires custom Apps Script
Exchange Coverage NSE • BSE • MCX Depends on provider Depends on provider
Enterprise Reliability Enterprise Grade Depends on your setup Depends on Provider
Built for Traders Purpose Built General-purpose spreadsheet Requires Apps Script
bolt
Real Streaming

Receive every update the exchange sends — no manual refresh, no polling.

equalizer
Built for Professional Traders

Purpose-built for market analysis, trading workflows and advanced spreadsheets.

speed
Enterprise Performance

Reliable infrastructure with ultra-fast updates and exchange-authorized market data.

workspace_premium Plan Breakdown

Free vs Real-Time Plan

Start free with basic delayed data, or upgrade to unlock real-time streaming tick data, options chains, and historical backtests.

Free Plan
Standard Access
  • check_circle 10 MB Storage
  • check_circle Delayed Market Data
  • cancel Live Bar Streaming
  • cancel Option Chain & Greeks
RECOMMENDED
Upgrade to Real-Time
Unlock Full Power

Everything in Free, plus complete real-time market access and automated execution tools:

check_circle Live Bar Streaming
check_circle Historical Data
check_circle Downloads & Exports
check_circle Option Chain Analytics
check_circle Broker Integration
check_circle AI Assistant (Unlimited)
MIGRATION Already on TrueData Velocity? Your login works here.
Switch to Sheets arrow_forward
verified Exchange Authorized

Built on Exchange-Authorized Data

Since 2014

Exchange-authorized data vendor

NSE • BSE • MCX

Exchange Coverage

No Refresh / No Polling

Data arrives on its own

verified Performance Highlights

Smarter Data. Faster
Decisions. Better Trades.

Built for professional traders and analysts who need reliable, real-time market data directly inside spreadsheets.

Speed
Real-time streaming updates

Market data arrives as the exchange sends it — no refresh, no polling.

Excel
Way Faster than Excel RTD

Faster refresh speed with streaming data instead of traditional RTD updates.

Streaming
Live Bar Streaming

Stream live bars directly inside your spreadsheet without manual refresh.

Enterprise
Enterprise Reliability

Stable infrastructure trusted by active traders and professionals.

Analytics
OI & PCR Analytics

Instantly monitor Open Interest and Put-Call Ratio across strikes.

Automation
Automated Option Chains

Option chains update automatically as market prices change.

Derivatives
IV & Greeks

Access implied volatility and option Greeks in real time.

Live Updates
Every Update the Exchange Sends
trending_up NIFTY 50 Updates – 4 times in 1 second

compare Frequently Asked Questions

Got Questions?

Everything you need to know about Sheets by TrueData.

Sheets by TrueData provides exchange-authorized real-time market data for NSE, BSE and MCX.

Market data streams continuously — under 50ms from our servers to your cell (typical, excluding your own network). No refresh, no polling.

Yes. You get automated Option Chains, Open Interest, PCR Analytics, IV, Greeks and other derivatives data.

Yes. Access Financials, Ratios, Corporate Data and other Fundamental information directly inside your spreadsheet.

Yes. Start with a free trial and explore all the powerful features before choosing a plan.

No. Sheets by TrueData works inside a familiar spreadsheet environment while also providing advanced formulas and scripting capabilities for power users.
Start Today

Ready to Experience
Real-Time Market Data?

Join professional traders and analysts using Sheets by TrueData for lightning-fast streaming market data, advanced analytics and a powerful spreadsheet experience.

Exchange Authorized
NSE • BSE • MCX
Always Streaming
No refresh, no polling
Enterprise Ready
Secure & Reliable
Free Trial
No Credit Card Required
check Real-Time Streaming

Every update the exchange sends, delivered as it arrives.

check Advanced Analytics

OI, PCR, IV, Greeks and Fundamental Data.

check Built for Professionals

Everything you need in one powerful workspace.