Realtime data from NOW Realtime NOW,, NEST NEST,, ZERODHA Trader Trader TO Excel AMIBROKER,, FCHARTS, AMIBROKER 1Preface............... 1Preface..... ..................... ..................... ..................... ..................... ..................... ..................... ................................................ ...................................... 2 2System Re Requirement quirements.......... s..................... ..................... ..................... ..................... ................................................... ......................................... 2 3Setup................. 3Setup....... ..................... ..................... ..................... ...................... ..................... ..................... ..................... ..................... ............................ ................. 3 4Setup for AmiBro AmiBroker ker Users-.... Users-............... ..................... ..................... ...................... ................................................. ...................................... 3 5G!!"#G RA$ !"% &A!A '& !( )*$..............................................................4 +#S#(, #est!raer !o )*$ / R!#(,................................................................4 0Gettin Reatime 'ee to A%"Broker........................................................................+ Reatime R eatime fee to '*arts... '*arts................. ........................ ..................... ..................... ..................... ..................... .............................. .................... + Back.................. Back...... ...................... ..................... ..................... ..................... ..................... ..................... ..................... ..................... ............................ .................0 0 6Back 7it #(,Back.... #(,Back............... ..................... ..................... ..................... ..................... ..................... ..................... ...................... ........... 0 18Back 7it #(,9SBack #(,9SBack............. ........................ ..................... ..................... .............................................. ................................... 13 11!rou:eso 11! rou:esootin....... otin.................. ..................... ..................... ..................... ..................... ..................... ....................................... ............................. 14
1
Preface 1. !is utiity 7as oriinay e;eope to fee rea time quotes from #(, <#eat on ,e:= to Ami:roker an istri:ute it freey 7it source coe. After usin it for some perio> it 7as reaise tat 7it some furter coin> it can :e use to fee rea time quotes from #S!> (&"#> !rae !ier> Gooe an ?aoo to cartin appications ike Ami:roker> 'carts @tstaker an %etastock aso. !is utiity 7as uprae to ;arious ;ersions. an no7 it as :ecome sta:e. 2. !e utiity i;es R! quotes in Ami from te time you cick on- Start. "t oes not i;e R! from :einnin of te ay. So start R! an ten open :ack. *opy ata upto te time you oe in into Back. ,en :acks 7arns you> sa;e ata:ase an o :ack. ?our ata 7i :e current. 3. ?ou o not a;e to recor any ece macro. 4. Since you are reain tis> it means you a;e o7noae te ip e containin te utiity an etracte it. !is ep e is accompanie :y foo7in es. Use te es appropriate for your setup. 1 2 3 4 5 +
2
R!#(,.sm / Rea time fee from #S#(, R!#est.sm / Rea time fee from #est #o7Back.sm / Back from #(,#est !raer #o79S:ack.sm - Back from #(,#est !raer 9oury StatisticsC,ap #est3.format / !is e is use :y Ami:roker to import :ack ata R!G3.format/ !is e is use :y Ami:roker to import rea time ata
System Requirements 1. %inimum requirement is ce 2880 / 32 :it an ,ino7s )P or a:o;e. 2. !este on ,ino7s )P an ,ino7s 2883 +4 Ser;er> ,ino7s > ,ino7s 0. 3. If you get N/A in RTNOW/Nest after ‘Link to !ce"# $ %or t&ose '&o are using 'in(o's ) an( a*o+e, insta""ing e!ce", Ami*roker an( NST-or NOW in 0 (ri+e fo"(ers a""o's one to start 1rograms as norma" user an( get (ata fee( 'it& 2os& uti"ities 'it& out a(min 1ri+i"eges.
In norma" insta""ation, 04Program %i"es fo"(er is use(. T&at nee(s a(min 1ri+i"eges to access. -Origina""y Poste( *y "+gan(&i. 5ou 'i"" &a+e to o1en Nest Tra(er as 'e"" as !ce" as a(ministrator. To o1en t&em as a(ministrator, Rig&t/"ick on t&ese 1rograms an( t&en c"ick on Run as6. A"ternate"y, c"ick on Pro1erties. In t&e Pro1erties (ia"og *o!, c"ick t&e om1ati*i"ity ta*. se"ect t&e$ Run T&is Program As An A(ministrator c&eck *o!, an( t&en c"ick O7. See *e"o' site for (etai"s. &tt10//tec&net.microsoft.com/en$us/maga8ine/9:3;):<.as1! &tt10//'''.sna1&o'.com/:=:3/make$1rograms$run$as$a(ministrator$*y$ (efau"t$in$'in(o's$) 4. %or NOW/Nest Tra(er >sers $ (S may :e +4 :it :ut %S(Dce must :e 32 :it. +4 :it %S (Dce oes not support R!& function as yet. "t 7i not 7ork unti %icrosoft ena:es R!&.
3
Setu1 1. !ere are t7o staes in;o;e in ettin rea time carts 7it tis utiity. 'irst - Gettin te reatime fee from !rain soft7are or Gooe?aoo to ce. Secon - Gettin te reatime fee from ce to *artin soft7are. 2. 'ies of type E.sm can :e kept any7ere in a separate foer. 9o7e;er> " recommen keepin tem 7ere;er your !rain Soft7areappication resies. Users of #(, sou mo;e tem to *FProram 'ies#(, or *FProram 'ies <+=#(, epenin upon your ;ersion of 7ino7s. Users of #est !raer sou mo;e tem to *FProram 'ies(mnesys or *FProram 'ies <+=(mnesys epenin upon your ;ersion of 7ino7s. Users of !rae !ier sou mo;e tem to *FProram 'ies!rae!ier 3. 'ies of type E.format < #est3.format an R!G3.format = sou :e mo;e to H?ourPattoAmi:rokerformat foerH since Ami:roker requires tem tere.
4. (pen ce. *ick on te (Dce icon on top eft 5. *ick on !ce" O1tions$ Trust enter $ Truste( Locations $ A(( Ne' Location an i;e te pat of foer 7ere your !rain Soft7are resies. Aso i;e te pat of foer 7ere you kept te E.sm es. 'or eampe> if you a;e kept te ece es on HesktopR!#(,H foer> ten incue tat foer in truste oactions. !is 7ay> ece 7i open te .sm e 7it macros ena:e. (ter7ise> you 7i a;e to ena:e macros e;ery time.
4
Setu1 for Ami?roker >sers$
1. Before tryin anytin in AmiBroker> create ne7 ata:ase e.. *FAmiBrokerR!ata. 2. Gi;e ata:ase foer pat to create ata:ase. !ereafter> o a te settins as so7n a:o;e. !ose 7o 7ant to com:ine (& ata sou ceck aainst -Ao7 mie (&"ntraay ata in "ntraay settins. 3. @oTO Too"s Preferences$o settings in 1references as s&o'n *e"o'.
5
@TTIN@ RAL TI ATA % TO BL
+
NSNOW/ NestTra(er To BL C RTNOW 1. Request your Broker to acti;ate R!& feature for your account. "f R!& is not acti;ate> you 7i et IR!& attri:ute not icenseI error...... <. A"'ays o1en a11"ications in t&is or(er ;. NOW or Nest <. RTNOW or RTNest 3. "f you open ece rst> you 7i see J#A in a ces :ecause it cannot n reference quotations. :. (pen #(, - K Rit cick "n market 7atc> reposition coumns (R et te foo7in coumnsTra(ing Sym*o" D Last Tra(e( Time D Last Tra(e( Price D Eo"ume Tra(e( To(ay DO1en Interest D Sym*o" 5. (rer of te coumns is not important. 9o7e;er> if you keep te same orer> it 7i :ecome con;enient to paste in ce. +. Sa;e te coumns.
0. Seect te scrips you 7ant in %arket7atc :y SiftLcick . Rit *ick %arket7atc an na;iate to M$ink to ceN . See ure :eo7-
6. *ick A "tems or seecte items. 18.Paste in R!#(,.sm in *e A0 in te Seet IR!&I. ;;. 5ou 'i"" see Rea"time fee( in !ce". T&e 1rices an( time 'i"" *e c&anging. ;<. $ink te ces in Seet M#(,N (R M#estN to te appropriate ces in seet MR!&N . o not c&ange or(er of t&e Fe"(s in S&eet GNo'Hor GNestH e"se you 'i"" not get "i+e c&arts in Ami?roker. ;3. ?ou are free to aeetecane te scrips i;en in oriina Seet once you are comforta:e 7it it. >sers s&ou"( note t&at Nifty S1ot (ata is not a+ai"a*"e in NSNOW. 14.Some times> reatime fee stops 7en ce Seet is tinkere 7it. Oust sa;e te :ook> cose ece an reopen. R! fee 7i start. 15.#S #(, seems to a;e a imit of 55 scrips at a time. 9ence you 7i et error in #(, if you ecee tat num:er an R! fee 7i not start for ecess scrips. 1+.&o not cane te orer of coumns. 'or ease of inkin> keep te orer of coumns same in #(, or #S! !RA&R. 10.?ou can aeete coumns if you 7is. ?ou 7i a;e to eit te R!G3.format e. 9o7e;er rst four coumns are manatary. 1.*eck te ata:ase pat in ce B1. "f your ata:ase is at a ierent ocation> enter tat in ce B1. "n my case> it is on 9 ri;e.
0
@etting Rea"time %ee( to AI?roker 1. (nce you start ettin reatime quotes in ce> net step is to et tem in AmiBroker an see te carts mo;in. ?our source can :e any of #(,> (in. !rae !ier> ?aoo or Gooe. %eto of feein ata to AmiBroker is simiar. 9ere is a snapsot of R!#(,.sm. <. If you insta""e( RA (ri+e, t&en gi+e ri+e Letter in e"" ?< ot&er 'ise "ea+e it *"ank . If you are not sure '&at is RA ri+e, kee1 t&is Fe"( *"ank 3. @i+e 5our4ata*ase4Pat& in ce"" ?;. :. "ick on GStart RT ataH. =. Ami?roker S&ou"( o1en automatica""y an( you 'i"" see "i+e c&arts mo+ing
Rea"time fee( to %&arts.......... 1. '*arts is anoter appication for stock cartin. !ere are t7o ;ersions of tis appication. 1. '*artS is free for a users an 2. '*artPR( is pai ;ersions. " a use te free ;ersion a:out t7o years ao. " foun some iscrepancies in 7eeky carts. !at is 7y an aso :ecause " a money to spen> " :out AmiBroker. " instae te atest free ;ersion a:out a mont ao. "t seems to a;e impro;e a ot an ae some eceent faciities in t7o years. #e7 !raers are a;ise to use tis appication. 'cartS is ;ery easy for intraay carts. 2. A te es of type E.sm 7ork out of te :o 7it '*9AR!S te free cartin soft7are. 3. !ose 7o are not ettin $ast !rae time in ata fee<iet (&"#= 7i a;e to cick on IStart R! &ataI to et current time. A oters Qust a;e to start ata fee appication ike #(, or #S! an et reatime fee to '*artS. 4. (pen #(, or #est or 7ic e;er soft7are 5. (pen R!#(,R!#estR!GooeR!?aooR!(&"#R!!ier.sm 7ice;er you 7ant an ceck 7eter rates are canin.
6. *ick on Re $ist an "t 7i so7 te name of ece e. 18.*oumn settins as i;en in te imae. !ey are sef epanatory. 11.1st &ata Ro7 in our case is 0. ;<. "ick on GStartG. 5ou can see one minute *ars getting u1(ate( "i+e in %&arts.
?ackF"".........
6
?ackF"" 'it& NOW?ackF"" 1. Appro. 15 ays 1 min. (9$* ata is a;aia:e from #(,#est pus#est !raer. !ese can :e use for 'n( an ine. " am not a7are 7at is oere :y !rae !ier. Users of !! 7i a;e to epore. 2. 'or *as scrips> &ata &o7noaer :y Ooyeep can :e sti use. "t can o7noa 18 ays 1 min. (9$* ata from Gooe. Goo for :uk :ack.(peratin "nstructions 3. "f you 7ant to a;e :ack from #o7> acti;ate te M$aunc PusN Raio Button. $oin in to #o7. ?ou a;e to :e reister on (mnesys #estpus porta. 4. Rit *ick on any of te scrips or press SiftLP - seect Puin commans / Seect Pus *art.
5. "f #est Pus as not starte> foo7in 7ino7 7i open. $oin into #est Pus. +. #est pus 7i start an intraay cart 7i :e seen. "f cart oes not appear> repeat pre;ious step. 0. *ick on te cart an seect &ata !a:e or press *trL&.
. &ata 7ino7 7i open. !is contains intraay ata of ast fteen ays. *ick on any ro7. Press *trLA to seect a ro7s.
6. A ro7s 7i :ecome :ue. Press *trL* to copy ata.
18.(pen separate instance of %Sce :y cickin on Start - Prorams in ,ino7s an ten open #o7Back.sm from 'ie -- open %enu in ce. &o not open :y ou:e-cick on te e. *ick on te %asters Seet. *orrect te &ata:ase Pat in ce *1 to ?our&ata:asePat. Sa;e e.
11.Go to te Seet1. Press *trLC into ce A1 of Seet1. "f *ooumn B so7s JJJJJJ instea of ate> increase its 7it an you 7i see ate time. ?ou are reay to :ack ata.
12.See imae :eo7. $ook at te *oumn B> ce reconise ate time an rit aine it. "f it is eft aine> tere may :e pro:em.
13. *ick on te Pus :utton I*ick me to :ackI. 14. A pop-up 7ino7 7i 7arn you to sa;e ata:ase if Reatime fee is runnin. Go to AmiBroker an sa;e ata:ase :y *ickin on 'ie an ten on Sa;e &ata:ase. !ereafter> come :ack in #o7Back an cick on ( or press nter. 15. Anoter Pop-up 7ino7 7i ask you 7eter you 7ant to spit &ate an !ime into separate coumns. *ick on I?esI if tey are com:ine an I#oI if ce as areay put tem in separate coumns. 1+. Back 7i :e one an you 7i et messae I&ata importeI. 10. &o not sa;e canes to te e 7en cosin. 1. ?ou can use Aias in Scrip info to :ack correct scrips
16.?ou can *ane Scrip #ame in R!#est 7ie inkin to #est seet so tat it matces 7it name in &ata &o7noaer. " a;e i;en sampe formuae in R!#est for tat. See a formuae. 28. Use simpe n repace for scrips 7ere name oes not matc.
18 ?ackF"" 'it& NOWS?ackF""
1. !is e is use to :ack current ayTs ata from 9oury statistics of #(, or C,ap statisticks from #est.
2. !e 7oe process 7i take a:out 18 secons for eac scrip. "t can :e use for 'n( scrips for upto 18 scrips an more if you o not et fatiue :y pressin *trLP an *trL&. 'or *as scrips or for :uk :ack> you may use &ata &o7noaer :y Ooyeep tat i;es 18 ays ata from Gooe. 3. #oteF "f scrip name in #estPus is ierent tan your scrip name> you 7i a;e to mere te t7o scrips in AmiBroker to interate te ata. 'or eampe in my case #ifty future 7i :e :acke as #"'!??%%%'U!. So after runnin #(,Back " n a ne7 scrip #"'!?12%A?'U! in te ata:ase. " a;e to mere #"'!? 7it #"'!?12%A?'U! in AmiBroker. !is can :e one from Sym:o-%ere menu of AmiBroker. !aret is #"'!? an mre 7it #"'!?12%A!'U!. (;er7rite &upicate @uotes. 4. ,orkin in ce on oter appications 7ie reatime fee is runnin.... 5. ?ou 7i a;e to open separate instance of ce from Start--Prorams-%S(Dce--ce. o not open any e :y ou:e cickin on it.
11 Trou*"es&ooting
;. I am not too goo( in com1uter re"ate( stu9, 1"ease &e"1 me. ?ou nee not :e oo in computers to foo7 tis. 'oo7 a te instructions. "f you o not unerstan any instruction> ask me. Sorry> " cannot o spoon feein. Pease ep yoursef rst an tereafter " 7i ep you. <. I (i( e+eryt&ing as 1er instructions *ut I am not getting c&arts. P"ease &e"1. ,at o you mean :y tat. " cannot ep you 7it one ine information. *eck 7eter you foo7e a te steps as i;en. Gi;e me te eact step 7ere you are not ettin esire resuts an ask specic question. 3. ?ackF"" is not &a11ening. ,at o you mean :y tat. " cannot ep you ike tat. *eck 7eter you foo7e a te steps as i;en an ask specic question. ?ou o ata:ase settin ony once. Be sure tat you i;e same ata:ase pat to R! utiity an Back utiity. :. icrosoft +isua" *asic Run $Time error J: notin can :e one. . In RTBBBB.!"sm t&e rates are c&anging. Sym*o"s a11ear in AI?oker *ut I am not getting c&arts. !is in most cases occurs ue to incorrect ate settin. &ate format sou :e mmyyyy. iter correct ate format of your P* in reiona settins or open R!G3.format e an cane &ateV&%? to &ateV%&? in W'ormat ine. !at e sou :e in A%"Broker'ormat foer ). Ami?roker (oes not o1en automatica""y '&en I c"ick on GStartH.
?our macros may not :e ena:e> ena:e it. ,en you open R!.sm> ece asks you 7eter macros sou :e ena:e. Aso copy R!.sm in to your !rain proram foer an o !rust *enter Settins. . W&en I c"ick on start RT (ata, Ami?roker o1ens u1, *ut *"ank an( no sym*o"s in it. It gi+es me an error0 formu"a F"e not foun( or em1ty$ no c&art to (is1"ay. *opy R!G3.format an #est3.format e into IformatsI foer :eo7 AmiBroker. :roker.ne7carts / !is e is create :y Ami:roker in your ata:ase foer. 'ie containin references :et7een cart ayouts an formua es use. "f you eete it you 7i see Iformua e empty or can not :e founI in your carts :ecause reference :et7een cart "& an formua is ost. ?ou 7i #(! o7e;er ose your formuas :ecause formuas are separate. ?ou 7i :e a:e to reinsert tem into your carts. K. I got a message from nest tra(er t&at Mscri1 RT attri*ute is not "icense(M !is means you are not ao7e take i;e quotes. *ontact your :roker an te im to acti;ate R!& feature for your account. #otin can :e one :efore tat. ;. Ami*roker (oes not o1en correct (ata*ase. +ery time I &a+e to c&oose (ata fo"(er '&ere 1ast (ata is sa+e( QQQQQQQQQQQQQQQ !is means you a;e not i;en correct ata:ase pat. (pen ata:ase settins of correct ata:ase an i;e te same pat in R!.sm. ;;. Run time error ) 1at& not foun(, '&en aske( to (e*ug, fo""o'ing "ine is &ig&"ig&te( Set a fs.*reate!et'ie<'ie#ame> !rue= H9ere 7e create te e %y*SC.cs; ?ou a;e to keep ce B2 empty if you a;e not instae RA% &isk. (ter7ise you are :oun to et tat error. "f it is empty> ten try to create foer MR!N on *F ri;e manuay. ?ou can aso i;e some pat teir to create temporary e. ;<. Run time error ;: -If you 'ork in anot&er !ce" *ook '&i"e getting Rea" time ata %ee( !is error occurs 7en you open anoter spreaseet from te same instance. &o not open anoter spreaseet from same instance or :y ou:e-cickin on it. "f you 7ant to 7ork in anoter ce :ook 7ie ettin Rea time &ata 'eeX (pen ce :y cickin Start-Prorams-%icrosoft (Dce-ce2880. !en *ick on (Dce "con an open anoter spreaseet from tat instance. ;3. Run$time error J$<;:)<:)) -))e Automation error. T&e s1eciFe( mo(u"e cou"( not *e foun( !is error occurs 7en some &$$s in 7ino7s are unreistere. !is is so;e :y reisterin te &$$ moue in ,ino7s. !ry ,ino7s -K Run comman> Ysystem32scrrun. an press nter.
typeF
res;r32
Y7inir
;:. I am getting N/A in RTNOW/RTNest after (oing Link to !ce". ; ?ou i not rea System Requirements . Pease rea it fuy an foo7 in toto.
;=. I get error saying "imit e!cee(e( in RTNo'/RTNest !is 7i in;aria:y appen if you a scrips urin runtime. ,ene;er you a scrips> you 7i a;e to cose a apps an restart. !at is a :u 7it #est#(,. ;. Ami*roker &angs '&i"e c"osing/t&ro's e!ce1tion error *ose Ami:roker irecty after sa;in an ten cose R!#est 7it7itout sa;in> tis sequence is 7orkin 7e 7itout ea;in any instance or process of Ami. ;). I cannot o1en any ot&er !ce" s&eet '&i"e RT!!!.!"sm is running. y c&arts get messe( u1. A7ays open ce in a ne7 instance :y cickin on StartZProrams / %icrosoft (Dce- ce. !ereafter you can open your esire 7orkseet an 7ork in it. ;. RTNest/RTNo' &angs '&i"e c"osing. I &a+e to c"ose it *y tr"A"te" an( en( 1rocess. Some times I "oose my (ata in Ami*roker. A7ays cose appications in re;erse orer of openin. !at is Ami:roker / R!#o7R!#estR!(inR!!ier / #est#o7[!(in!!. Sa;e Ami:roker &ata:ase 7ie cosin.