What is Kite Connect?

Kite Connect is a robust trading platform that provides HTTP/JSON APIs, enabling users to craft their own trading platforms. It is designed to handle a high volume of data and orders, with capabilities to process over 10 million orders per day, manage more than 500 million HTTP requests daily, and handle in excess of 30 million market data ticks per second.

As a service, Kite Connect is particularly beneficial for startups, offering them the tools necessary to build investment and trading platforms. It allows real-time order execution, portfolio management, and live market data streaming. Moreover, Kite Connect integrates seamlessly with Zerodha, expanding its utility and ease of use.

In terms of data usage, Kite Connect's live market data can be utilized to create candles for analysis on trading apps, enhancing user experience and providing insightful analysis capabilities. Developers can access Kite Connect using various programming languages including Python, Java, PHP, NodeJS, and C#, thanks to its compatibility with different SDKs and API clients.

Kite Connect Plugins for Excel

Analyze and Trade with Excel

The Kite Connect Excel plugin, also known as KiteXL, is a third-party library that allows users to analyze and trade directly from Excel sheets. By leveraging the plugin, users can integrate market analysis and trading into their familiar Excel environment.

Real-Time Data Streaming

While KiteXL does not provide a QuotesReceivedEvent or use a websocket for streaming quotes, it does feature a Real-Time Data (RTD) server for Excel. This enables the plugin to offer real-time market data within the Excel sheets for effective decision-making.

Order Management Capabilities

Users can utilize KiteXL to place, modify, and cancel orders, just like they would on a standard trading terminal. The plugin also supports the placement of basket orders for efficient order execution.

Visual Basic Integration

The Kite Connect Excel plugin is compatible with Visual Basic 6, allowing for additional customization and automation of tasks using VBA (Visual Basic for Applications).

Limitations and Best Practices

It is important to note that KiteXL does not support the retrieval of historical data and does not provide real-time order book and trade book updates. Users are also advised to avoid embedding the api_secret in mobile or client-side applications and to never expose the access_token publicly. KiteXL is intended for personal use and illustrates how to use the KiteXL library effectively within Excel.

Conditional Order Placement

With KiteXL, users have the flexibility to place orders based on specific conditions, utilizing the plugin's capabilities to automate and streamline trading strategies directly within Excel.

Common Use Cases

• K

  
  Real-time trading and analysis directly from Excel sheets
• K

  
  Automated order placement and management using VBA macros
• K

  
  Subscription to real-time quotes for symbols and position conversion within Excel
• K

  
  Custom automation of trading strategies by setting conditions for buying and selling
• K

  
  Monitoring and analysis of trade book and order book directly from Excel

Frequently Asked Questions

How do I place an order using the Kite Connect plugin for Excel?

You can place an order by using the specific Excel function syntax provided by the plugin. This can be done directly from an Excel cell, allowing for regular, bracket orders (BO), cover orders (CO), and after-market orders (AMO). Once the order is placed, the OrderId is returned in the cell itself.

Can I get real-time market quotes using the Kite Connect plugin for Excel?

Yes, the plugin allows you to subscribe to real-time quotes by adding the symbols in a similar way to a market watch. You can use the plugin's functions to receive updates directly in the Excel sheet.

Is it possible to view and manage my trading positions using the plugin?

Yes, the plugin includes a Positions sheet where you can track real-time updates of your positions. However, manual interaction may be required to refresh and update the information.

How do I handle errors like 'Invalid Checksum' when using the plugin?

The 'Invalid Checksum' error can be resolved by closing all Excel sheets, attempting to log in again, and opening Excel as an administrator. If the issue persists, restarting the system may also be necessary.

What should I do to start using the Kite Connect plugin for Excel?

To start using the plugin, you need to input your API key and secret into the dashboard sheet of the provided sample Excel sheet (KiteXL.xlsm) and enable macros. Make sure to pass these credentials securely, especially if distributing apps to others.