How to connect Zerodha Kite to excel?

Short Answer

As Zerodha Kite is a mobile platform, you cannot connect it directly to Excel. To do so you will have to use Zerodha Pi, which is a web platform that runs on your PC. You can connect Pi to excel by following some basic steps.

Detailed Answer

Zerodha Kite

Zerodha is India’s largest Stockbroker formed in 2010. It has the largest client base of 25 lakh active clients and is one of the fastest-growing stockbroking platforms in India.

Kite is the mobile application provided by Zerodha. Kite is one of the most advanced mobile platform in which you can trade and invest in stocks, options, futures as well commodities. Kite is provided for free to every individual who has an account in Zerodha. There are no extra charges for the platform.

How to connect Zerodha Kite to Excel?

As Kite is a Mobile application that runs on a smartphone, you cannot directly connect the platform to Excel. To connect your Zerodha account in Excel, you will have to use the Pi platform. Zerodha Pi is an application that runs on a PC and you can export and import your data directly on Excel.

You can export stock data as well as your profit and loss reports to Excel using Zerodha Pi. To do so, you will have to download the application, log in to it using your ID & Password. Once you do so, you will have to select all the files that you want to export and click “Ctrl+E”. With this, you can directly connect Pi to an Excel sheet.

Once to carry out the steps, an excel file will automatically open with all the data in it. You can use it to do whatever you like to do with the data.

Tagged With: zerodha kitekitekite to excelzerodha pi
Ask your query and our expert community would be happy to help
Discussion (0)
Related FAQs

How to add all Nifty 50 stocks in Zerodha Kite?

Zerodha is Indias largest discount broker in terms of the trading volume. Here you can create your own wishlist on the Kite application. The kite application is the trading terminal provided by Zerodha which is free to all its clients. The following steps can be followed to add the stocks to your watchlist.

How to place BTST order in Zerodha Kite?

For placing a BTST order via Zerodha Kite, the process is quite simple. You can follow the same steps as to how you might place an order on Zerodha Kite. However, when you buy or purchase a stock, you will have to select the “CNC product type” option in the buy order popup.

What is IOC in Zerodha Kite?

IOC simply stand for Immediate Or Cancel (IOC) orders. As you get more and more familiar with trading terms and slang, you might realize that each term is supposed to be linked with others, which form this sort of conjoined strategies. These strategies are usually what result in successful trading, rather than speculation.

How to add money to Zerodha using UPI?

Adding money to Zerodha using UPI is the most commonly used method and is the most popular among the other methods. It is totally free and can be done with the help of any UPI application like Google Pay or BHIM UPI. This process can be done seamlessly with the help of Zerodha's web application as well as the mobile application- "KITE".

How to apply IPO in Zerodha? Buy IPO Online

If you are a Zerodha customer, you can apply for IPO online through Zerodha Console (Zerodha Back-office). The process for applying an IPO process has been explained in detail above. Here are few other answers to important queries that you may want to learn.

How to withdraw money from Zerodha Trading Account?

To withdraw money from your Zerodha trading account, you need to place a withdrawal request by logging into Zerodha Console. Withdrawal of money is completely free. As per regulations, the withdrawal money will be credited only to the bank account which is mapped with Zerodha.

Is Paytm Money better than Zerodha?

You wish to know if Paytm Money is better that Zerodha or it's the other way round. Zerodha being a leading discount broker in India has been there for overe a decade now. While Paytm Money already established in mutual fund investment arena, but a fairly new entrant in stock broking industry. So, let's compare the features and discuss few details on each of them.

What is NFO in Zerodha? How to invest in it?

NFO in Zerodha is the abbreviation of "New Fund Offer". It refers to the introductory offer of a scheme by an AMC (Asset management company). An NFO is raised when a fund is launched and this will help the firm to raise capital for purchasing securities. 

How to Check IPO allotment in Zerodha?

There are many ways to check the IPO allotment status but Zerodha doesn't provide this facility on their website. To check the allotment status you can visit the website of the registrar of the IPO, for example, Link Intime, Karvy. With the help of a PAN number, you can easily check the status.

What is MIS and CNC in Zerodha? Product Codes Explained

You might have come across these product codes: MIS and CNC. Ever wondered, what they mean? Here you'll learn what is MIS and CNC in context to stock trading in context to Zerodha and other stock brokers in general.