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.

  Bank-Level Security

  • Microsoft Authentication with end-to-end encryption
  • Credentials encrypted using your Microsoft identity
  • All communication over HTTPS/WSS secure protocols
  • Daily token rotation for added protection

  ⚡ Built for Performance

  • Intelligent caching reduces API calls by 75%
  • Single polling loop for 200+ formulas (99.5% resource reduction)
  • No Excel freezing or #BUSY states
  • Auto-reconnects after network interruption

    Free Plan

    • ✅ Real-time market data streaming via WebSocket
    • ✅ ZERODHA.SUBSCRIBE() custom function
    • ✅ 200+ simultaneous instrument subscriptions
    • ✅ Portfolio and positions viewing
    • ✅ All supported exchanges (NSE, BSE, NFO, MCX, etc.)

    Plans

    Free Plan

    ✅ Real-time data streaming • ✅ Custom functions • ✅ 200+ instruments • ✅ Portfolio viewing • ✅ All exchanges • ✅ 15+ data types

    Premium Plan

    ✅ Everything in Free • ✅ Order placement • ✅ Historical data • ✅ Market depth • ✅ Priority supportAPI Provider: Zerodha Kite Connect API

    • Data Format: Binary packets parsed to Excel-compatible values

    Why Choose TradingSheet?

    No App Switching: Keep your analysis, data, and trading in one place—Excel. Your familiar environment, now with live market data.

    Built for Scale: Whether you're tracking 10 stocks or 200, our architecture handles it smoothly without freezing Excel.

    Requirements

    • Platform: Excel 2016+ (Windows, Mac)
    • Account: Active Zerodha Kite trading account
    • API: Zerodha API credentials (free from kite.trade)
    • Auth: Microsoft account
    • Connection: Stable internet for WebSocket streaming

      1. Click "Get it now" to add TradingSheet to Excel
      2. Open Excel and click "Open TradingSheet" in the Home ribbon
      3. TradingSheet?

         ✓ No App Switching — Analysis, data, and trading in one place
         

         ✓ Built for Scale — Handles 200+ stocks without freezing Excel
         

         ✓ Trusted Data — Direct Zerodha WebSocket, same as Kite app
         

         ✓ Fully Customizable — Works with all Excel features
         

         ✓ Always Improving — Regular updates and new features

      4. 🐛 Bug Reports: Quick turnaround on issues
      5. 💡 Feature Requests: We listen to our users

    Req Started in 5 Minutes

    1. Click "Get it now" to install
    2. Open TradingSheet from Excel's Home ribbon
    3. Sign in with Microsoft account
    4. Enter Zerodha credentials (get free API keys from kite.trade)
    5. Start streaming live data!

    📧 Email: support@mcpchats.com
    

    📖 Full documentation included
    

    🎥 Video tutorials available

    Important

    API Compliance: Uses official Zerodha Kite Connect APIs. Access tokens expire daily at 6:00 AM IST—simply reconnect each day.

    Disclaimer: TradingSheet is independent and not affiliated with Zerodha Securities. Market data for informational purposes only. Always verify before trading.

    Privacy: Your credentials are encrypted and never shared with third parties.

    ---

    Ready to transform Excel into a trading terminal?

    Click "Get it now" to start streaming live market data today!