indiTraders - Forum for the Active Indian Trader  

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

Data Share Data & Discuss Data Sources

Reply
 
Bookmark and Share LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 15-03-2012, 09:44 PM
rohitb rohitb is offline
Regular
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 57 Times in 18 Posts
rohitb is on a distinguished road
Default 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 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

Last edited by rohitb; 15-03-2012 at 11:34 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 19 Users Say Thank You to rohitb For This Useful Post:
  #2 (permalink)  
Old 15-03-2012, 10:56 PM
smarttrade smarttrade is offline
Regular
 
Join Date: Jun 2010
Posts: 98
Thanks: 121
Thanked 96 Times in 46 Posts
smarttrade will become famous soon enoughsmarttrade will become famous soon enough
Thumbs up

Dear rohitb sir,


Thanks for your information . I am Waiting for this for a Long.. time.. .
Now I have Sucessfully Configured Odin-Excel-Amibroker as per Mentioned above your Steps .

But Unfortunately now Mcx Market was closed .

So I couldnt Check Rt Data Updation. Once Again Thanks a Lot for your help .

Last edited by smarttrade; 16-03-2012 at 12:02 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to smarttrade For This Useful Post:
  #3 (permalink)  
Old 15-03-2012, 11:38 PM
rohitb rohitb is offline
Regular
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 57 Times in 18 Posts
rohitb is on a distinguished road
Default

Originally Posted by smarttrade View Post
Thanks for your information. Can you explain how to import RT data from excel to Amibroker ?


THE ABOVE PROCEDURE IS FOR IMPORTING EXCEL DATA TO AMIBROKER

MAY BE IM NOT ABLE TO UNDERSTAND UR REQUIREMENTS SO PLS DESCRIBE IN DETAILS ABOUT UR EXCEL FILE
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to rohitb For This Useful Post:
  #4 (permalink)  
Old 16-03-2012, 12:05 AM
alex alex is offline
indiTraders VIP
 
Join Date: Mar 2009
Location: Mumbai
Posts: 4,928
Thanks: 14,925
Thanked 13,314 Times in 4,262 Posts
alex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond repute
alex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond repute
Default

Originally Posted by rohitb View Post
THE ABOVE PROCEDURE IS FOR IMPORTING EXCEL DATA TO AMIBROKER

MAY BE IM NOT ABLE TO UNDERSTAND UR REQUIREMENTS SO PLS DESCRIBE IN DETAILS ABOUT UR EXCEL FILE

I think you covered the part of getting data in to excel with the desired format. But now we have the data in excel then how to connect that data to amibroker using DDE plugin?
__________________
The essence of mathematics is not to make simple things complicated, but to make complicated things simple.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 16-03-2012, 08:00 AM
rohitb rohitb is offline
Regular
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 57 Times in 18 Posts
rohitb is on a distinguished road
Default

Originally Posted by alex View Post
I think you covered the part of getting data in to excel with the desired format. But now we have the data in excel then how to connect that data to amibroker using DDE plugin?


Dear alex pls read the entire post steps for configuring excel and amibroker both are given
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 16-03-2012, 10:11 AM
alex alex is offline
indiTraders VIP
 
Join Date: Mar 2009
Location: Mumbai
Posts: 4,928
Thanks: 14,925
Thanked 13,314 Times in 4,262 Posts
alex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond repute
alex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond reputealex has a reputation beyond repute
Default

Originally Posted by rohitb View Post
Dear alex pls read the entire post steps for configuring excel and amibroker both are given

Oh I apologize, I didn't see that part before..Thanks a lot
__________________
The essence of mathematics is not to make simple things complicated, but to make complicated things simple.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 16-03-2012, 10:55 AM
smarttrade smarttrade is offline
Regular
 
Join Date: Jun 2010
Posts: 98
Thanks: 121
Thanked 96 Times in 46 Posts
smarttrade will become famous soon enoughsmarttrade will become famous soon enough
Default

Dear rohitb Sir,
Now I checked, Real Time Odin Data Updated Correctly in Amibroker . Can you tell me Backfill Method from Odin ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 16-03-2012, 04:11 PM
Sunshine's Avatar
Sunshine Sunshine is offline
indiTraders VIP
 
Join Date: Oct 2009
Posts: 2,524
Thanks: 6,181
Thanked 4,431 Times in 1,976 Posts
Sunshine has a reputation beyond repute
Sunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond reputeSunshine has a reputation beyond repute
Default

Waiting for this for a longtime.
Thanks for this useful info.
As Smarttrade asked anyway to backfill ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 16-03-2012, 09:36 PM
sr114's Avatar
sr114 sr114 is offline
Regulars
 
Join Date: Aug 2010
Location: INDIA
Posts: 347
Thanks: 364
Thanked 638 Times in 240 Posts
sr114 is a jewel in the roughsr114 is a jewel in the roughsr114 is a jewel in the roughsr114 is a jewel in the roughsr114 is a jewel in the roughsr114 is a jewel in the roughsr114 is a jewel in the rough
Default

RohitB

hi, how to get the Diet ODIN market watch in excel ? rather how to get the arbitrage.xls file?

have we to contact our broker for the permission?
in that case, what request we have to make to the broker?

i am asking this as i could not make the xls file.

regards
sr114
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 16-03-2012, 09:46 PM
rohitb rohitb is offline
Regular
 
Join Date: Jan 2010
Posts: 33
Thanks: 0
Thanked 57 Times in 18 Posts
rohitb is on a distinguished road
Default

Originally Posted by sr114 View Post
RohitB

hi, how to get the Diet ODIN market watch in excel ? rather how to get the arbitrage.xls file?

have we to contact our broker for the permission?
in that case, what request we have to make to the broker?

i am asking this as i could not make the xls file.

regards
sr114

you will have to contact your broker to enable the open in ms excel feature in your diet odin
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
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


All times are GMT +5.5. The time now is 03:38 AM.


vBulletin Copyright by vBulletin

Content Relevant URLs by vBSEO 3.3.2