indiTraders - Forum for the Active Indian Trader  

Go Back   indiTraders - Forum for the Active Indian Trader > Tools > Data

Data Share Data & Discuss Data Sources

DPonline
Reply
 
Bookmark and Share LinkBack (1) Thread Tools Display Modes
  #121 (permalink)  
Old 03-12-2015, 06:58 PM
saravanan b saravanan b is offline
Newbie
 
Join Date: Dec 2015
Posts: 1
Thanks: 1
Thanked 1 Time in 1 Post
saravanan b is on a distinguished road
Default

Originally Posted by rohitb View Post
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 AMIBROKER.

NEXT SESSION I WILL SHOW HOW TO BACKFILL IN MY WAY FROM ODIN TO AMIBROKER

mr rohitb i did that as you said but i select my mcx symbol in amibroker screen the following sentence appears how would i resolve please give a solution.
thank you
b.saravanan.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to saravanan b For This Useful Post:
Reply

indiTraders - Forum for the Active Indian Trader > Tools > Data


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


LinkBacks (?)
LinkBack to this Thread: http://www.inditraders.com/data/6308-get-odin-diet-market-watch-data-amibroker-without-any-software.html
Posted By For Type Date
Yahoo! Groups This thread Refback 13-09-2013 01:33 AM

DPonline

All times are GMT +5.5. The time now is 10:05 AM.


vBulletin Copyright by vBulletin

Content Relevant URLs by vBSEO 3.3.2