Get ODIN Diet Market Watch Data To Amibroker Without any software

#1
Get ODIN Diet Market Watch Data To Amibroker Without any software


[This post is copied from another site, I am asking for AMI BROKER settings]

"'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 unrevealed amibroker'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 type 500000. 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 AMI BROKER.]''

[Could anybody please HELP me in AMI BOKER SETTINGS via AMMYY / TEAM VIEWER ????? ] my AMI Broker isnt showing these options..
 
#3
Is there any way to send buy or sell signals to ODIN.

I mean based on afl the system generates buy or sell signals in amibroker and automatically buy on ODIN platform.

Thanks
 
#4
1> Select the scrip you want then go to Market>Market movement>Market movement (derivatives) or simply press CTRL+F12 for Derivatives and Market movement (Equity) or simply press SHIFT+F12 for Equity

2> you may/will see a box opening asking for different settings just put 1 minute time interval and hit ok

3> another window will open showing you time,open,high,low,close,volume,value,ATP

4> Right click in that box and select copy

5> Now Open one more blank workbook in ms excel and there click on cell A1 and right click it and select paste

6> you will see the data from the market movement pasted to excel. now add 2 blank columns before time column by click right clicking A which is on the top of the column and selecting Insert

7> Delete columns Value and ATP

8> now type ticker in a1 which is blank and date in b1 which is blank. type your ticker name which should be exactly the same in amibroker in cell a2 and date which is current date in b2. fill the entire columns A and B with Ticker and Date till the line where the other data ends

9> now right click the C column which is time in 12 hour format and select format cells

10> in format cells box under tab Numbers select time and in type select 13:30:55 ie the 24 hour format. now click ok. you will see the time in 24 hour format

11> save this workbook as csv.

12> do this for other scrips

13> now in amibroker go to file>import wizard click pick files button. select the file/files you just created. then hit next button

14> in column 1 select ticker, column 2 select dmy,mdy,ymd as per the date you have manually typed in excel i use dmy format, column 3 time, column 4 open,column 5 high column 6 low,column 7 close. select more columns and in column 8 select volume. for columns 9,10,11,12 select skip. now hit next button

15> now hit finish button


YOUR DATA HAS BEEN BACKFILLED
 

Similar threads