Yah000 to Amibroker Utility needed

shivangaggarwal · #1 20th May 2008, 01:59 PM

Hello frnds..

Kindly help with any utility or any thread by which i can import real time Nifty Spot data from yah0000 finance to amibroker... or any other suggestion in this regard wud be highly appreciated..

Thanks a lot

hitesh · #2 25th May 2008, 12:30 PM

This will help you.

http://www.traderji.com/data-feeds/1...amibroker.html

Apple · #3 1st June 2008, 06:07 PM

Quote:

Originally Posted by shivangaggarwal

Hello frnds..

Kindly help with any utility or any thread by which i can import real time Nifty Spot data from yah0000 finance to amibroker... or any other suggestion in this regard wud be highly appreciated..

Thanks a lot

Hi,
I am pasting bellow Hetal's earliar post.

Hello Everyone,

This is the way I take free REALTime Data from yah00 ( free of any 3rd party progs or plugins) only with amiquote and amibroker.

VERY VERY IMP FIRST YOU TAKE A FULL BACKUP OF YOUR AMIBROKER DIRECTORY . This is very important.

We now start with the operation Realtime yah00 Free

First the basics to get it clear so that u should also understand what we are doing ok

You all must have used amiquote earlier with yah00 current. If u take nse yah00 symbols as tls files and load it in amibroker u get data from yah00 but till now it was delayed even if are logged in yah00

But the recent amiquote has an option to allow yah00 cookies after u are logged in yah00 finance so that was an hidden additional feature which many didn’t took it seriously but it is the same thing what other softwares made here in INDIA which many are using it for realtime data from yah00 to ami. They all say one thing first log in with ur id at yah00 finance to get rt data . Here we also have to log in yah00 finace and keep logged to get rt data with amiquote ok

Now what happens when u run amiquote & what type of data it gets which we use it for realtime basis

1ST yah00 DON’T GIVE DATA LESS THAN 1 MINUTE BECAUSE IT DOESN’T HAVE TIMESTAMP LESS THAN A MINUTE.
SECONDLY IT DOESN’T GIVES U Indian makt hours in the time stamp so how can we have that in amiroker.
Over to that

1st make a new database in amibroker as amitry as per below given method
keep base time interval as tick
then in intraday settings
select 24 hours
time 9:30 to 15:30
select exchange time/ local ( I have yet to see the differencr in this feature)
then in the below given box timeshift write 10
now after u click on ok
u have to click on create so an empty database is created
BUT AFTER U DO THAT U HAVE TO SAVE THIS EMPTY DATBASE SO THAT THE TIMESHIFT IS RECORDED IN IT.
After u do close ami and reopen and load this amitry database
Then click from file menu database settings
And go to intraday settings and recheck that the 10 which we have put in the time shift box is intact If it shows as 0 read zero change it to 10 and again save the database Now it will be fixed.

Actually with 10 we would be ahead by some 30 minutes with ref to our mkt time. We
At present cant do anything because the time shift as taken my amibroker can only take in hours it does not take minutes .

I think Only Tomaz can help it because if he wants he can allow hours & minutes.

Normally the time shift should be in 30 mins slab. I don’t know why it is kept as only hours. Anyway we have to bear with this BUG after all we are going to get free data in RT mode ok
Now very imp part
How amiquote gets data from yah00 afterlogged in
The file which amiquote gets is 1 or more files depending on the symbols u have in ur tls file
But that is the input for amibroker to put the data in amibroker chart ok

"ABB.NS","ABB LTD.",3730.20,"4/13/2007","6:00am",+77.30,3669.00,3755.00,3623.00,7755 4
"ACC.NS","ASSOCIATED CEMENT",749.95,"4/13/2007","6:00am",+23.60,729.85,750.00,726.00,822345
"ALBK.NS","ALLAHABAD BANK",73.05,"4/13/2007","6:00am",+0.95,70.20,73.80,70.20,111529
"ALOKTEXT.NS","ALOK INDUSTRIES L",59.05,"4/13/2007","6:00am",+0.20,55.00,60.00,55.00,81295

ok and with what is this data updated I mean .format file the name of the format file is aqd.format which u can change it to .txt file and load it in notepad
It looks like this
# AmiQuote daily download format (.AQD extension)
# Revision 1.1 (previous version had missing Date_MDY field)
# Revision 1.2 (added $STRICT 1)
$FORMAT Ticker,FullName,Close,Date_MDY,Skip,Skip,Open,High ,Low,Volume
$SKIPLINES 0
$SEPARATOR ,
$DEBUG 1
$AUTOADD 1
$CONT 1
$GROUP 254
$BREAKONERR 0
$STRICT 1

We have to change this as below to put in the realtime data from yah00 to amibroker with out any 3 rd party progs
SO here is the modified aqd.format for rt data

# AmiQuote daily download format (.AQD extension)
# Revision 1.1 (previous version had missing Date_MDY field)
# Revision 1.2 (added $STRICT 1)
# Revised for RT data from yah00 in Rt mode
$FORMAT Ticker,FullName,Close,Date_MDY,Time,Skip,Skip,Skip ,Skip,Volume
$SKIPLINES 0
$SEPARATOR ,
$DEBUG 1
$AUTOADD 1
$CONT 1
$GROUP 254
$BREAKONERR 0
$STRICT 1

copy this above and save it to format dir as aqd.format.rt for time being
ok now change the old filename aqd.format to aqd.format.eod
and again rename our newly mad aqd.format.rt to aqd.format

Now close all progs esp amibroker & amiquote
Before our Indian mkt starts at 9:55
We have to 1st log in yah00 finance
Then start amibroker and load amitry database ( u can use any name I have used it as amitry ok)
Then fire up Amiquote and load the nse yah00 symbol.tls
And select yah00 current and click the green so that it starts running also select the
Autoimport box and put 1 in run every one minute

This is the secret to get FREE RT DATA IN RT MODE IN AMIBROKER.

ONLY THING IS yah00 DON’T GIVE BARWISE VOLS
SO U HAVE TO MAKE AN AFL FOR VOLUME TO DEDUCT THE PREVIOUS BARS VOLUME FROM CURRENT AR VOLUME TO GET THE TRUE BAR WISE VOLUME
My SUGGESTION IS TO USE ANY TIMEFRAME GREATER THAN 3 MINUTE BARS TO GET A REAL TRUE PICTURE

The only thing I would request Tomaz here again and I think this the 3rd time I have made this request to make the timeshift atleast in half hour 30 mins slabs than the current 1 hour slabs

Even in windows reginal settings the time slabs are in 30 mins
All the credit here goes to Tomaz for his recent feature addition in amiquiote to allow recognize yah00 cookies.
This whole game is based on yah00 cookies after u are logged in yah00 finance…

Happy Trading with Free Rt data

Hetal

Thank's to Hetal.
Anyone need my help contact me at
apple2008jan11 @ G M A I L dot com

tulika · #4 9th June 2008, 07:22 AM

Quote:

Originally Posted by apple

hi,
I Am Pasting Bellow hetal's Earliar Post.

hello Everyone,

This Is The Way I Take Free Realtime Data From Yah00 ( Free Of Any 3rd Party Progs Or Plugins) Only With Amiquote And Amibroker.

Very Very Imp First You Take A Full Backup Of Your Amibroker Directory . This Is Very Important.

We Now Start With The Operation Realtime Yah00 Free

First The Basics To Get It Clear So That U Should Also Understand What We Are Doing Ok

You All Must Have Used Amiquote Earlier With Yah00 Current. If U Take Nse Yah00 Symbols As Tls Files And Load It In Amibroker U Get Data From Yah00 But Till Now It Was Delayed Even If Are Logged In Yah00

But The Recent Amiquote Has An Option To Allow Yah00 Cookies After U Are Logged In Yah00 Finance So That Was An Hidden Additional Feature Which Many Didn’t Took It Seriously But It Is The Same Thing What Other Softwares Made Here In India Which Many Are Using It For Realtime Data From Yah00 To Ami. They All Say One Thing First Log In With Ur Id At Yah00 Finance To Get Rt Data . Here We Also Have To Log In Yah00 Finace And Keep Logged To Get Rt Data With Amiquote Ok

Now What Happens When U Run Amiquote & What Type Of Data It Gets Which We Use It For Realtime Basis

1st Yah00 Don’t Give Data Less Than 1 Minute Because It Doesn’t Have Timestamp Less Than A Minute.
Secondly It Doesn’t Gives U Indian Makt Hours In The Time Stamp So How Can We Have That In Amiroker.
Over To That

1st Make A New Database In Amibroker As Amitry As Per Below Given Method
Keep Base Time Interval As Tick
Then In Intraday Settings
Select 24 Hours
Time 9:30 To 15:30
Select Exchange Time/ Local ( I Have Yet To See The Differencr In This Feature)
Then In The Below Given Box Timeshift Write 10
Now After U Click On Ok
U Have To Click On Create So An Empty Database Is Created
But After U Do That U Have To Save This Empty Datbase So That The Timeshift Is Recorded In It.
After U Do Close Ami And Reopen And Load This Amitry Database
Then Click From File Menu Database Settings
And Go To Intraday Settings And Recheck That The 10 Which We Have Put In The Time Shift Box Is Intact If It Shows As 0 Read Zero Change It To 10 And Again Save The Database Now It Will Be Fixed.

Actually With 10 We Would Be Ahead By Some 30 Minutes With Ref To Our Mkt Time. We
At Present Cant Do Anything Because The Time Shift As Taken My Amibroker Can Only Take In Hours It Does Not Take Minutes .

I Think Only Tomaz Can Help It Because If He Wants He Can Allow Hours & Minutes.

Normally The Time Shift Should Be In 30 Mins Slab. I Don’t Know Why It Is Kept As Only Hours. Anyway We Have To Bear With This Bug After All We Are Going To Get Free Data In Rt Mode Ok
Now Very Imp Part
How Amiquote Gets Data From Yah00 Afterlogged In
The File Which Amiquote Gets Is 1 Or More Files Depending On The Symbols U Have In Ur Tls File
But That Is The Input For Amibroker To Put The Data In Amibroker Chart Ok

"abb.ns","abb Ltd.",3730.20,"4/13/2007","6:00am",+77.30,3669.00,3755.00,3623.00,7755 4
"acc.ns","associated Cement",749.95,"4/13/2007","6:00am",+23.60,729.85,750.00,726.00,822345
"albk.ns","allahabad Bank",73.05,"4/13/2007","6:00am",+0.95,70.20,73.80,70.20,111529
"aloktext.ns","alok Industries L",59.05,"4/13/2007","6:00am",+0.20,55.00,60.00,55.00,81295

Ok And With What Is This Data Updated I Mean .format File The Name Of The Format File Is Aqd.format Which U Can Change It To .txt File And Load It In Notepad
It Looks Like This
# Amiquote Daily Download Format (.aqd Extension)
# Revision 1.1 (previous Version Had Missing Date_mdy Field)
# Revision 1.2 (added $strict 1)
$format Ticker,fullname,close,date_mdy,skip,skip,open,high ,low,volume
$skiplines 0
$separator ,
$debug 1
$autoadd 1
$cont 1
$group 254
$breakonerr 0
$strict 1

We Have To Change This As Below To Put In The Realtime Data From Yah00 To Amibroker With Out Any 3 Rd Party Progs
So Here Is The Modified Aqd.format For Rt Data

# Amiquote Daily Download Format (.aqd Extension)
# Revision 1.1 (previous Version Had Missing Date_mdy Field)
# Revision 1.2 (added $strict 1)
# Revised For Rt Data From Yah00 In Rt Mode
$format Ticker,fullname,close,date_mdy,time,skip,skip,skip ,skip,volume
$skiplines 0
$separator ,
$debug 1
$autoadd 1
$cont 1
$group 254
$breakonerr 0
$strict 1

Copy This Above And Save It To Format Dir As Aqd.format.rt For Time Being
Ok Now Change The Old Filename Aqd.format To Aqd.format.eod
And Again Rename Our Newly Mad Aqd.format.rt To Aqd.format

Now Close All Progs Esp Amibroker & Amiquote
Before Our Indian Mkt Starts At 9:55
We Have To 1st Log In Yah00 Finance
Then Start Amibroker And Load Amitry Database ( U Can Use Any Name I Have Used It As Amitry Ok)
Then Fire Up Amiquote And Load The Nse Yah00 Symbol.tls
And Select Yah00 Current And Click The Green So That It Starts Running Also Select The
Autoimport Box And Put 1 In Run Every One Minute

This Is The Secret To Get Free Rt Data In Rt Mode In Amibroker.

Only Thing Is Yah00 Don’t Give Barwise Vols
So U Have To Make An Afl For Volume To Deduct The Previous Bars Volume From Current Ar Volume To Get The True Bar Wise Volume
My Suggestion Is To Use Any Timeframe Greater Than 3 Minute Bars To Get A Real True Picture

The Only Thing I Would Request Tomaz Here Again And I Think This The 3rd Time I Have Made This Request To Make The Timeshift Atleast In Half Hour 30 Mins Slabs Than The Current 1 Hour Slabs

Even In Windows Reginal Settings The Time Slabs Are In 30 Mins
All The Credit Here Goes To Tomaz For His Recent Feature Addition In Amiquiote To Allow Recognize Yah00 Cookies.
This Whole Game Is Based On Yah00 Cookies After U Are Logged In Yah00 Finance…

Happy Trading With Free Rt Data

Hetal

Thank's To Hetal.
Anyone Need My Help Contact Me At
Apple2008jan11 @ G M A I L Dot Com

Tried My Best But Cud Not Get Any Success.. Will Be Highly Obliged If You Please Help Me Configure The Settings
Thanks
Tulika

Apple · #5 9th June 2008, 07:29 AM

Hi, Tulika

Please post your Mail ID or Contact me At
Apple2008jan11 @ G M A I L Dot Com

pasha · #6 19th June 2008, 01:51 PM

While trying it, I found that Amiquote creates a new file "3IINFOTEC.NS_AIAENG.NS.aqd" in the Amiquote directory.
It seems to keep updating this file with price data instead of updating the files in the database.

The problem appears to be how to configure Amiquote to upate the database that Amibroker is reading from.

Or maybe Amibroker needs to be configured to read the .aqd file and update the individual files?