Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts MS

Status
Not open for further replies.
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Sir, I have check everything volume is not updating in 1 second refresh , here is screenshot of my tata steel quotation editor. View attachment 19216
 
Last edited:

josh1

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Sir, I have check everything volume is not updating in 1 second refresh , here is screenshot of my tata steel quotation editor.
Required snap of Nest Sheet of RTNest, MyCSVNest.txt, RTG3.format
 

guptak03

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Hello josh ji,

i am not getting proper volumes to Ami but excel sending other data properly ..:confused:

how to solve this problem??
 

josh1

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Sir, Here is what you requested
[
Volume is being pushed into Amibroker as seen in MyCSVNest.txt. As I said, change period to Daily, click on the candle for [the day and and see whether total volume matches with that in Nest.

Volume will be zero if there is no trade during one second. Or your excel is not fast enough to handle 1 second refresh. Remember, Excel does not get Real Time data when it is executing macro. We can program to skip quote if volume change is zero.
 
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.
 

lvgandhi

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Sir, I have check everything volume is not updating in 1 second refresh , here is screenshot of my tata steel quotation editor. View attachment 19216
I faced the same problem. Problem lies with RTD timer settings in excel. Please go through past posts (preferably one two months post). I have given a link to reset RTD default. Then you will get volume dat also for 1 min.
 
Last edited:
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Sir, may be my excel is not fast enough to handle 1 second refresh, I am using win-7 , core 2 duo processor with 2 GB RAM, and using excel 2007, Is there any way to improve my excel speed
 

guptak03

Well-Known Member
Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Hello josh ji,

i am not getting proper volumes to Ami but excel sending other data properly ..:confused:

how to solve this problem??
sir my system config is

Os windows 7pro 32 bit & 4gb Ram


and excel 10....

when i backfill it i will get proper volume data but not getting in real time, even i tried with 1sec refresh in excel but still problem not got solved .:confused:

[/URL]

Uploaded with ImageShack.us[/IMG]



[/URL]

Uploaded with ImageShack.us[/IMG]
 
Last edited:
Status
Not open for further replies.

Similar threads