Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M
http://vijaynifty.blogspot.in/2012/09/get-odin-diet-market-watch-data-to.html
Get ODIN Diet Market Watch Data To Amibroker Without any software
HELLO FRIENDS/FELLOW TRADERS
It's a real agony of a trader to get live data as there are many vendors providing data @ a cost which is quite high and some do provide data @ very low cost which is not that reliable.
So for a long time i was looking for a in between route which after a long struggle i found out
All of you must be aware of AmiBroker and Diet ODIN
I have seen many ppl asking questions about how to import diet odin market watch data to amibroker. Here is the mystery unrevealedamibroker's DDE plugin and Microsoft excel
REQUIREMENTS
1> Amibroker
2> Diet Odin with Open in MS-Excel feature enabled by your broker(just right click any scrip and u should see open in ms-excel option. click that and it should open Arbitrage.xls in ms-excel with your scrips and live data). Not all brokers enable this feature. im a sub broker so i got it enabled easily
3> MOST IMPORTANT PATIENCE.
BENIFITS
1> 100% FREE Intraday Data
2> NO DELAY. Things happen in seconds in stock/futures market so what is the use of data that comes after the move is already gone.
3> More RELIABLE than YAHOO,GOOGLE
4> Realtime Data
5> Get Intraday Data for NSE-CASH, NSE-FUTURES, BSE CASH, CURRENCY, MCX, NCDEX
DRAW BACKS
1> Tedious configuration
2> Tedious Backfill
STEPS
EXCEL SETTINGS
1> Login to you diet odin and open the desired market watch
2> Right click in the market watch and select open in ms-excel
3> Small box appears asking for select sheet. select sheet1
4> A file named Arbitrage.xls will open with all the scripts/futures/options and u will see the rates changing.this is your source we need to purify this as we don't need most of the data.
5> We just need LAST TRADED PRICE AND LAST TRADED QUANTITY
6> i use office 2007. create a new blank workbook by clicking the office button and then new and then select blank workbook and then click create button
7> A blank workbook opens with name book1
8> click Cell A1 and type the name of the scrip you want here i will use example of commodity market. the steps will be same for any other market.
9> In A1 we type Gold in Cell A2 we type Silver in cell A3 we type CrudeOil
10> Now select Cell B1which is next to Gold and type = then go to Arbitrage.xls and select the column which corresponds to gold's last traded price and hit enter. now ur blank workbook will show golds last traded price besides Gold which u manually typed and it will keep on changing as per the trade. when u double click the cell u will see something like =[Arbitrage.xls]Sheet1!$L$18. this means for me the gold last traded price is on Cell L18
11> Do the same for rest of the symbols. here is how my excel file looks Screenshot
12> Now select Cell C1which is next to gold last traded price and then type = then go to Arbitrage.xls and select the column which corresponds to gold last traded quantity and hit enter.now ur blank workbook will show golds last traded price and last traded quantity and it will keep on changing as per the trade. when u double click the cell u will see something like =[Arbitrage.xls]Sheet1!$K$18. this means for me the gold last traded price is on Cell K18
13> Do the same for rest of the symbols. here is how my excel file looks Screenshot
14> Delete sheet2 and sheet3 to avoid confusion from the blank workbook
15> Rename Sheet1 to MCX as we are fetching mcx data and now save this workbook to ur desired location and name it MCX.xlsx
16> Now select cell B1which is gold last traded price and then go to formulas menu there u will see define name. click that and a box will appear saying new name type Gold_lt in name field and click ok
17> Now select cell C1which is gold last traded quantity and then go to formulas menu there u will see define name. click that and a box will appear saying new name type Gold_vol in name field and click ok
18> Repeat the above steps of all the symbols. now click the name manager button and u should see something like this Screenshot. once ur done save the file MCX.xlsx
AMIBROKER SETTINGS
19> Open AmiBroker and create a new tick database. in Data Source select DDE universal Data Plugin. in number of bars type500000. now hit ok button
20> Select Symbols>New in amibroker and type Gold in enter new symbol name box and click ok. REMEMBER THE SYMBOL NAMES ARE SENSITIVE. TYPE THE NAMES EXACTLY THE SAME WHAT YOU HAVE TYPED IN MCX.XLSX A1 A2 CELLS
21> Now go to File>database settings and hit configure button. Configure DDE plugin box will open.Select generic2 {Ticker}!{Field} in preset. type Excel in DDE Server. type MCX!{Ticker}_lt in Last field. type MCX!{Ticker}_vol in last size field. your dde settings should look like this Screenshot
22> Click Ok button on Configure DDE plugin box.and click ok button on database settings box. and now u will see in bottom right hand corner of amibroker as CONN WRITTEN IN GREEN and also the charts will be updating real time with tick data
CONGRATS WE HAVE SUCCESSFULLY MANAGED TO LINK ODIN DIET MARKET WATCH TO AMIBROKER.
