Real Time DATA in Amibroker for Free
10 March 2010 259 views 4 Comments
Hi All,
This is the way I take free REAL Time Data from yahoo ( 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 Yahoo Free
You all must have used amiquote earlier with yahoo current. If u take nse yahoo symbols as tls files and load it in amibroker u get data from yahoo but till now it was delayed even if are logged in yahoo
But the recent amiquote has an option to allow yahoo cookies after u are logged in yahoo 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 yahoo to ami. They all say one thing first log in with ur id at yahoo finance to get rt data . Here we also have to log in yahoo finace and keep logged to get RT data with amiquote.
Now what happens when u run amiquote & what type of data it gets which we use it for realtime basis
1. Yahoo Don’t Give Data Less Than 1 Minute because it doesn’t have time stamp less than a minute.
Make a new database in amibroker as amitry as per below given method:
a) Keep base time interval as tick.
b) Then in intraday settings
1.Select 24 hours
2.Time 8:30 to 15:30
3.Select exchange time/ local
4.Then in the below given box timeshift write 10
5.Now Click on OK
6.EMPTY DB is CREATED.
AFTER THAT SAVE THIS EMPTY DATABASE SO THAT THE TIME SHIFT IS RECORDED IN IT.
c) Close Amibroker and reopen and load amitry database
d) Click from file menu database settings
e) 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.
How amiquote gets data from yahoo after logged:
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,77554
“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
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 yahoo 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 yahoo 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
Now change the old filename aqd.format to aqd.format.eod
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:00
We have to 1st log in yahoo finance
Then start amibroker and load amitry database.
Then fire up Amiquote and load the nse yahoo symbol.tls
And select yahoo 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 YAHOO 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 TIME FRAME GREATER THAN 3 MINUTE BARS TO GET A REAL TRUE PICTURE
This whole game is based on yahoo cookies after u are logged in yahoo finance…
Happy Trading with Free RT DATA