I want to know, how can i integrate MS Excel with Zerodha Kite. I already know that there is a fee associated with it and i need to add credit to my account and create an app. what i need to know is, how can we transfer data to excel. What are the prerequisites and how they are done in simple plain english . I understand that there are Jargons like API, Kite connect account, VBA. Thanks in advance
Zerodha provide execution platform for managing your orders(buy,sell view marketdata-live/historical data in any form as you wish). For this they provide a tool called API which is similar to zerodha kite ,It has similar functionalities as Kite webapp but it requires at least basic knowledge of any one of the supporting languages to start working with.
There are developers available but if you give your requirement someone in this forum might help you out.
Thanks for replying, Please Answer the following questions so that i can get started. Q1: Can i use MS Excel and VBA to connect with Zerodha API, if yes then where is the required documentation. Please send me the link. Q2: As i was searching i found that HowYouTrade has developed some application which can connect with zerodha account, can we use that to connect to Excel, so that i can trade from MS Excel. Here is the link for that app. https://codeadvisor.in/trading-apps/. Your help is much appreciated. Thanks
Last Question: Lets say i get the API access from zerodha, can i create an Excel application using VBA to connect to Zerodha API, if yes than thats all i wanted to know so that i can build my own application.
VBA knowledge is must to build Trading system in Excel.
We already have sample excel platform built with KiteNet (.Net Library) and Kite API. This sample excel platform is as good as Traditional Trading Platform with Market Watch, Admin Positions, Order Windows etc.
One can simply build their trading system on the sample excel workbook or build their own from the scratch.
Zerodha provide execution platform for managing your orders(buy,sell view marketdata-live/historical data in any form as you wish).
For this they provide a tool called API which is similar to zerodha kite ,It has similar functionalities as Kite webapp but it requires at least basic knowledge of any one of the supporting languages to start working with.
There are developers available but if you give your requirement someone in this forum might help you out.
Q1: Can i use MS Excel and VBA to connect with Zerodha API, if yes then where is the required documentation. Please send me the link.
Q2: As i was searching i found that HowYouTrade has developed some application which can connect with zerodha account, can we use that to connect to Excel, so that i can trade from MS Excel. Here is the link for that app. https://codeadvisor.in/trading-apps/.
Your help is much appreciated. Thanks
VBA knowledge is must to build Trading system in Excel.
We already have sample excel platform built with KiteNet (.Net Library) and Kite API.
This sample excel platform is as good as Traditional Trading Platform with Market Watch, Admin Positions, Order Windows etc.
One can simply build their trading system on the sample excel workbook or build their own from the scratch.
Below links may help you to get started;
https://howutrade.in/docs/kitenet/html/Introduction.htm
DLL & Excel Sample Download : https://codeadvisor.in/trading-apps (see end of page)
https://codeadvisor.in/article-categories/kitenet/
https://codeadvisor.in/knowledge-base/simple-example-place-order-microsoft-excel/
1: Workbook Connections dialog box;
2: Creating an Office Data Connection (ODC) file (.odc);
3: Refresh external data connection.
For detailed information about these above mentioned ways , check out this link:
http://www.repairmsexcel.com/blog/excel-workbook-connections