Firing order through Excel-zerodha

[muleshsoni]

Are you using Google Sheets by chance?

No bro Google sheets r very slow and delayed gud for positional trades not for realtime
i use only excel on my pc to connect to Nest

 

[muleshsoni]

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

Excel VBA is capable of all these codes no need of third party !!!
anyhow i never used this software
can u pls elaborate "just save it in a txt file with .ahk extension, n when u will run it" what this line means

 

[muleshsoni]

And most of all sending orders automatically is not the issue , strategy is the key
u need atleast one good strategy to automate

 

[monkeybusiness]

And most of all sending orders automatically is not the issue , strategy is the key
u need atleast one good strategy to automate

That's right, there are many strategies out there which can be back tested and applied, that's why I was asking for basic framework, not your strategy.

 

[trump]

small retail positions today

 

[monkeybusiness]

small retail positions today

Auto trade by Excel?

 

[muleshsoni]

That's right, there are many strategies out there which can be back tested and applied, that's why I was asking for basic framework, not your strategy.

basic framework means?? and bro i dont have any secret strategy it work on very common strategy like ORB FIBBO GAPS thats it
manually order placing was not possible so i developed this excel , i am still struggling to make it reliable

 

[Romeo1998]

Dear friend Muleshsoni,
the orderman utility was developed by the member TracerBullet using Autohotkey software
please have a look at this
http://www.traderji.com/community/threads/orderman-ordering-interface-for-now-amibroker.101281/

 

[monkeybusiness]

basic framework means?? and bro i dont have any secret strategy it work on very common strategy like ORB FIBBO GAPS thats it
manually order placing was not possible so i developed this excel , i am still struggling to make it reliable

VBA code that connects to Nest and manages orders.

 

[muleshsoni]

VBA code that connects to Nest and manages orders.

u dont need code to connect sheet
just right click on nest trader marketwatch > link to excel> select with headers
open excel and paste
and u r done !!!