How one can trade from Excel?

Trading
1

I get to know. one can trade from Excel sheet with auto generated signals, if it’s possible please explain how it work.with pi bridge with a strategy.

1 Like
2

It is possible to trade from excel with Excel macros program and can generate signals also can fire orders into pi with the help pi bridge , the complete socket documentation is available in q.zerodha.com/pi , “pi bridge documentation for programming” for detailed explanation with example

1 Like
3

In addition to what AlgoGeek mentioned, there are many Robo Trading platforms available which can read Buy/Sell signals from Excel sheet and fire it to your Trading terminal. Check out the list of these tools here.

If you want ready-made Excel sheets with Buy/Sell signals check out the below link:

http://tradingtuitions.com/category/categories/trading-excel-sheets/

1 Like
4

Hi,

Kite Connect for Excel that’ll let you analyse and trade from Excel sheets

Refer https://kite.trade/forum/discussion/852/kite-connect-for-excel-3rd-party-library

3 Likes
5

hi

i have one system that generates order in excel sheet. how can i fire directly to zerodha?

6

@AlgoGeek : Is KiteXL open and free of cost to use for all zerodha retail clients ?:confused:

7

HI, Is it possible to place basket order using excel?

8

@satyam_tomar

Yes, you can place basket order.

1 Like
9

@vijay407

Yes, KiteXL is free of cost for all Zerodha clients

1 Like
10

How can we fire orders using this KITEXL.I have gone though your website but couldnt figure out.

11

@sudheer_kumar

Just testing a Order Placement From Excel is very easy.
But building a Trading System within Excel using VBA requires lot of interest and hard work.
If you are Excel Pro with VBA Experience, You can build and deploy your trading system in just an hour.

Here how you start with…

  1. Get Kite Connect API Subsscription from Zerodha (Rs2000/pm)
  2. Download and Install KiteXL from HowUTrade
  3. Download the Sample Excel Sheet from HowuTrade.

This sample Excel Sheet has basic usage of KiteXL.
& for [quote=“sudheer_kumar, post:10, topic:6159, full:true”]
How can we fire orders using this KITEXL.I have gone though your website but couldnt figure out.
[/quote]

Its just like using sum Function.
We wrapped all order Functions in UDF, You just need to call the Function in the Cell when you want to place order.
For Example:- You want to place Order when cell value of C3 = "BUY"
In another, You can write formula like below…

=If(C3="BUY",PlaceRegularOrder("NSE", "ICICIBANK", "BUY", "MARKET", 10,"MIS", 0, 0, "DAY"),"NO SIGNAL")

Please refer the Docs which has details of all functions supported and required parameters.

4 Likes
12

Thanks a lot for the detailed info.

13

Bro, page not found

1 Like
14

@poorna_chandar,

Sample Excel Sheet is moved to the Zip File along with DLL files.
You can download from this link

1 Like
15

this link also not working, how connect zerodha api with excel to pass order from excel,

17

Can I enter my secret key/api key into the same Excel sheet and start using it for streaming live market data and place orders?
Or do I first have to buy license from HowUTrade ?