Firing order through Excel-zerodha

[sudheer.167]

Hi all,
I want to automate the execution of orders for Gap strategy using excel.My broker is Zerodha.How can we do this?Any pointers?

Note:I want the excel to scan the top 2 stocks which gapped up the most (open price higher than yesterdays high).I can set the no of shares manually myself but i want to order to be executed from excel)

 

[muleshsoni]

yep VBA code can do it easily

 

[trump]

yep VBA code can do it easily

Can you share the excel sheet or logic?plz

 

[muleshsoni]

Thanx for liking bro
In my excel I predefined conditions like ORB,FIBBO,VOLUME AND OI with addition to pro gaps and regular gaps with SL and TGTs.

Orders can be NRML ,MIS ,BO or CO as per the firing conditions.

 

[monkeybusiness]

Thanx for liking bro
In my excel I predefined conditions like ORB,FIBBO,VOLUME AND OI with addition to pro gaps and regular gaps with SL and TGTs.

Orders can be NRML ,MIS ,BO or CO as per the firing conditions.

Hi,
you are doing it via kite api, or directly through nest trader?
what is cost? if possible share VBA code without your trading logic/triggers, just plain vanila code that connects to nest and fires BO/CO orders.

 

[muleshsoni]

Hi,
you are doing it via kite api, or directly through nest trader?
what is cost? if possible share VBA code without your trading logic/triggers, just plain vanila code that connects to nest and fires BO/CO orders.

i am doing directly with Nest trader not experimented with kite yet..
there is no cost bro as data coming from nest, no third party
logic is when ur trade triggers on some logic u need to create an txt/csv and fire thru basket
BO/Co orders i only use when i need to fire single order as it takes 3-4 sec to execute and hence cant be fired in bulk

 

[monkeybusiness]

i am doing directly with Nest trader not experimented with kite yet..
there is no cost bro as data coming from nest, no third party
logic is when ur trade triggers on some logic u need to create an txt/csv and fire thru basket

Great, can you share step by step process of doing it via nest,
also basic VBA code ( I understand your trading logic is proprietary ),
code that links to nest and manages trade.

 

[muleshsoni]

step 1 first get quotes in excel by "link to excel" function
step2 once u get ohlc data , filter and build ur strategy (entry,exit,sl, tgt)
step3 get order format by creating a dummy order in basket
step4 arrange cells according to format
step5 Export cells data to csv/txt
step6 fire

note: chk out shorucut manager if necessary configure it by exporting it and modify and again import and save!!!
and use it to automate..

 

[monkeybusiness]

"muleshsoni, post: 1255386, member: 158382"]
step 1 first get quotes in excel by "link to excel" function : Understood
step2 once u get ohlc data , filter and build ur strategy (entry,exit,sl, tgt) : Understood
step3 get order format by creating a dummy order in basket: Please explain
step4 arrange cells according to format : Understood
step5 Export cells data to csv/txt : understood
step6 fire : please explain

note: chk out shortcut manager if necessary configure it by exporting it and modify and again import and save!!! : in nest?
and use it to automate..

 

[Romeo1998]

Dear friend monkeybusiness,
i am also trying different ways to automate nest to ami
I m currently working with autohotkey and autoit softwares
here is a very simple code
just save it in a txt file with .ahk extension, n when u will run it
it will fire orders in nest if nest is running or else it will show a msg if nest is not running
i use TAB key to fill all the boxes when we press F1 or F2

note --- f4 focuses on marketwatch, f6 gets snap quote, f1 gets buy order box, then press tab 5 times, fill quantity n then press enter n buy order will be sent on market price
all these shortcuts r given in help file of autohotkey software
here is the code for it

IfWinExist, Welcome
{
WinActivate ; use the window found above

Send {F4}
Send {F6}
Send {F1}
Send 40
Send {Tab 5}
Send {Enter}

;  Send !{F4 2}

}
else
MsgBox, 1, Error, NEST is not running

what i m trying to do is, i save this as a .ahk file on my pc, n then with shellexecute in amibroker , point to this file n fire orders
still have a lot of work to be done