Authorized NSE, BSE & MCX
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.
Pre-built spreadsheet templates designed for options trading, OI analysis, and chart visualization.





Build custom algorithms, listen to live WebSockets, fetch historical option chains, and automate your spreadsheet workflows logically.
Listen to every update the exchange sends, 1m/5m OHLCV bars, Bid/Ask quotes & live Option Greeks instantly with TD.on().
Clean startup and shutdown with TD.onStart & TD.onStop to prevent memory leaks and orphan streams.
Non-blocking async spreadsheet control using TD.Sheet.setCellRange and getCell.
Fetch past bars, top gainers, and full option chains with Greeks in a single async call.
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);
};
Real-time streaming, derivatives analytics, built-in formulas
and enterprise-grade market data — all inside a powerful spreadsheet.
Live option chains that update automatically without manual refresh.
Analyze derivatives with powerful Open Interest and Put Call Ratio tools.
Access complete real-time derivatives analytics metrics inside sheets.
Interactive real-time charts directly inside your workflow processes.
Every quote streams automatically with real-time updates.
See why active traders switch from traditional spreadsheets to TrueData's streaming infrastructure.
| Features |
|
|
|
|---|---|---|---|
| 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 |
Receive every update the exchange sends — no manual refresh, no polling.
Purpose-built for market analysis, trading workflows and advanced spreadsheets.
Reliable infrastructure with ultra-fast updates and exchange-authorized market data.
Start free with basic delayed data, or upgrade to unlock real-time streaming tick data, options chains, and historical backtests.
Everything in Free, plus complete real-time market access and automated execution tools:
Exchange-authorized data vendor
Exchange Coverage
Data arrives on its own
Built for professional traders and analysts who need reliable, real-time market data directly inside spreadsheets.
Market data arrives as the exchange sends it — no refresh, no polling.
Faster refresh speed with streaming data instead of traditional RTD updates.
Stream live bars directly inside your spreadsheet without manual refresh.
Stable infrastructure trusted by active traders and professionals.
Instantly monitor Open Interest and Put-Call Ratio across strikes.
Option chains update automatically as market prices change.
Access implied volatility and option Greeks in real time.
Everything you need to know about Sheets by TrueData.
Join professional traders and analysts using Sheets by TrueData for lightning-fast streaming market data, advanced analytics and a powerful spreadsheet experience.
Every update the exchange sends, delivered as it arrives.
OI, PCR, IV, Greeks and Fundamental Data.
Everything you need in one powerful workspace.