TradingSheet - Real-Time Market Data in Excel

Transform Excel into a powerful trading terminal. Stream live prices from Zerodha Kite, analyze portfolios, and make data-driven decisions—all without leaving Excel.

Perfect For

Active Traders — Monitor 200+ instruments with live updates every 2 seconds

Portfolio Managers — Track holdings, positions, and real-time P&L

Financial Analysts — Build dashboards with live data feeding your models

Day Traders — Access portfolio, orders, and market depth without app switching

Algo Traders — Integrate real-time data into Excel-based strategies

Key Features

🔴 Real-Time Market Data

WebSocket-powered live streaming delivers instant market updates without freezing Excel.

Updates every 2 seconds across all cells

Handles 200+ instruments simultaneously

Auto-reconnects on network interruptions

Zero lag, zero Excel freezing

📊 Powerful Custom Functions

Stream live data into any cell with =ZERODHA.SUBSCRIBE(symbol, exchange, type)

15+ Data Types: LTP, OHLC, Volume, Buy/Sell Qty, Open Interest, Timestamps, and more.

Example: =ZERODHA.SUBSCRIBE("RELIANCE", "NSE", "ltp")

📈 All Major Exchanges

NSE • BSE • NFO • BFO • MCX • CDS • NCO • NSEIX

Trade equities, F&O, commodities, currencies, and indices—all in one platform.

💼 Portfolio & Position Management

One-click access to your complete Zerodha portfolio and open positions, inserted directly into Excel with live updates.

Get Portfolio: View all holdings with quantity, avg price, current value, and P&L

Get Positions: See intraday positions with product type, buy/sell price, and current P&L

Live Updates: Add custom functions to portfolio tables for auto-refreshing prices

Calculated Columns: Build custom formulas for P&L %, ROI, target prices, and more

Multi-Portfolio Tracking: Compare multiple accounts or strategies side-by-side

Management

One-click import of holdings and positions with live P&L tracking.

directly from Excel.

Pre-formatted tables for bulk order entry

Submit multiple orders with one click

Real-time order status updates via WebSocket

Supports Market, Limit, SL, and SL-M orders
📉 Historical Data Download (Premium)
Access historical market data for backtesting strategies and technical analysis.
(Premium)
Download OHLC data for backtesting and technical analysis. Multiple timeframes from 1-minute to daily candles.
🔍 Market Depth & Stock Details
View top 5 bid/ask levels, company info, circuit limits, and corporate actions.
Your data and credentials are protected with bank-level security.
- Microsoft Authentication: Secure sign-in with your Microsoft account
- End-to-End Encryption: API credentials encrypted using your Microsoft identity
- No Plain-Text Storage: Keys are never stored unencrypted
- HTTPS/WSS: All communication uses secure protocols
- Daily Token Rotation: Access tokens expire daily for added security
- Local Storage: Your data stays on your device and our secure Azure backend
⚡ Performance & Reliability
Built from the ground up for speed and stability, even with hundreds of formulas.

TradingSheet: Realtime Exchange Terminal (India)

por DATAPULS AI SERVICES PRIVATE LIMITED