Real Time DATA in Amibroker for Free

By | March 10, 2010 2:36 pm

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

54 thoughts on “Real Time DATA in Amibroker for Free

  1. kavin

    “not enough data available. to plot any chart at least 3 data bars are needed, but there are only 2 bars in nifty.”.. sir, can you help me in rectifying this error?

    Reply
  2. suresh shah

    Dear sir, as per your suggested steps i did and getting the data but only EOD and not intraday Can u tell me where i have done the mistake? thanks

    Reply
  3. lalit

    Hi Sir,

    i did everything my data is updating but chart is not updating,its coming like not enough data available at least 3 bars needed.can you help me,i would really appreciate.

    Best Regards

    Lalit Singh

    HAPPY & PROSPEROUS NEW YEAR.

    Reply
  4. chandulal

    Sir,
    I want to use ChartNexus for EOD analysis but after downloading, it downloads 3 years data of nse and bse but not showing anywhere so how can i sort out this problem and use charts in proper way. Please help me regarding this
    Thank u sir…..

    Reply
    1. Bramesh Post author

      Dear Sir,

      On Your left hand side you will see a Drop down arrow which shows US market click on it and select nse you will see all NSE stocks

      Rgds,
      Bramesh

      Reply
  5. raj

    Dear Mr. Raja,
    The data from Data feeder by stock live is 15 min. delayed, so be careful if you are taking trades based on it.
    regards.

    Reply
  6. raja

    Dear Sir,
    THANK YOU FOR YOUR INFORMATION AND HELPFUL READINGS HERE.

    I APPRECIATE YOUR WORK. I TRIED YOUR METHOD WITH DATA FEEDER FROM STOCK LIVE. I ASSUME THAT IT IS REAL TIME WITHOUT DELAY. I MAKE MY TRADE WITH THE HELP OF THE CHARTS ONLY. BUT YOU MENTIONED ABOUT LEVELS IN BETWEEN.
    WHERE WILL I GET THE LEVELS. PLS. REPLY

    Reply
  7. Anil

    Sir,

    I have metastock, can you help me to get RT charts hourly time frame.

    If not how to get Nifty hourly quotes at the endof day.

    thanks
    Anil Chunamari

    Reply
  8. Kev

    HI Bramesh.

    I have followed your guide, I got to the end and imported a NSE list, but no tickers were imported into the database.

    My real question is this.Am I able using this guide to get RT data of other markets, such as EUR/USD, Dow Jones, Gold etc from Yahoo.

    If so where can I get a ticker list? Also in this system is there no backfill?????

    Thanks for your help

    Reply
  9. S.R.Joshi

    Hi
    I am unable to format the file. Where it is. Iget EOD data. Not RT.
    Any suggestions

    Reply
  10. Trilok Singh

    Hi, Sir
    Thank u 4 ur quick response. I am totaly novoice now. I understood little bit the trick u have given.
    Plz confirm one thing if I buy when I see d green signal according to 21 EMA after 10-15 minutes of market opening, and put the stop loss accordingly. And sell when I see d red signal wd stop loss.
    I m sure above query will make u laught.
    I am a gr8 fane of u bcz of ur gr8 attitude towards helping others,

    plz send me one message of ur availabe time & day dt I can call u if u want plz.

    Thanks & Regards
    Trilok

    Reply
    1. Bramesh Post author

      Dear Trilokji,

      Never take a trade based on charts only You always need to have a system which gives u tgt before hand especially for intraday trades

      Rgds,
      Bramesh

      Reply
  11. Trilok

    Dear sir, I have opened your website and follow the rules as you have stated there.
    According to your rules at 21 EMA, buy at green, sell at red.
    I did the same and I am losing money.
    What I am doing wrong. I am happy at I purchase 2 lots and get the overall benifit 700-1000 at entra day basis.

    What I am doing wrong. I have reviwed other blogs that most of the people enrned enought while in green and red signal.
    Please let me know what I am doing wrong.

    plz sir plz sir.

    Reply
    1. Bramesh Post author

      Hi Trilokji,

      You should always use levels with Charts.

      If you are doing intra day trading than before market hours have levels to Buy,Sell and Sl and charts should be used to execute your trades.

      For eg. we had the following levels to trade yesterday in Nifty

      Buy at/above 5494.515625 Targets: 5510.305969 5528.874805 5547.474875 5566.10618 5584.768719

      Sell at/below: 5476 Targets: 5460.244383 5441.782031 5423.350945 5404.951125 5386.58257
      1 2 3 4 5
      Stoploss Buy: 5476
      Stoploss Sell: 5494.515625

      and we used the charts to confirm the trades based on 21 EMA strategy.

      Always trade based on Levels and charts your accuracy will improve.

      Rgds,
      Bramesh

      Reply
  12. kuldeep

    Derar bramesh,

    after following ur process when i have loaded data in ami broker it gave Error

    Not enough data available.
    to plot chart at lest 3 data bars needed,but htere are only one bar in ^NSEI .
    So can u suggest me what is problem there?

    Reply
    1. Bramesh Post author

      Dear Sir,

      You Need data from at least 3 BArs or 3 Candles to get the Charts.

      Give me a Call@09985711341 i can explain you.There are good s/w avilable than amibroker these days.

      Rgds,
      Bramesh

      Reply
      1. ashutosh

        Respected Sir,
        Wud u like to post the names of softwares besides Ami(here only) so that other traders may benefited?
        One more qstn, for Amibroker or Amiquotes, shud i go for subscription or yet free versions are available? If available then how can i download it.
        Hope u help.
        Regards & Thanking u.
        ~Ashu .

        Reply
        1. Bramesh Post author

          I use Chart nexus for EOD analysis..

          I do not use Amibroker so will not be able to comment on your query..

          Rgds,
          Bramesh

          Reply
  13. JITENDRA SINGH

    SIR/MADAM
    I AM SUCESSFUL REAL TIME DATA FROM YAHOO BUT I CAN NOT LOAD CHARTS FOR AMBIBROKER FROM AMBIQUOTE TO AMBIBROKER.
    PLEASE GIVE ME PROPER SOLUTION.
    JITENDRA SINHG

    Reply
    1. bramesh Post author

      if ur using pirated version u will not be able to use amiquote with amibroker.

      U have to use data dumb to get the hourly data.EOD data u can get from bhavcopy

      Reply
  14. manohara

    Hi
    Bramesh,

    I have fallowed the procedure and I am able to get one minuet real time data with out any third 3rd party plug in.

    But the main problem is I am able to get only 8 symbols.
    So my request is how to get more than 8 symbols say 200 symbols. If you aware of it plese help me.

    Thanks in advance
    By
    Mano
    ____________________________________________________________________________

    Reply
  15. Ankur

    How can we get tick data from somewhere or yahoo after market to study. Can somebody provide pointer then would be really grateful.

    Reply
  16. Harihara sudhan

    I managed to get the data from yahoo as per your instruction, but I could not save the data.Next day I got only the blank screen.kindly help me. i am using trail version of amibroker which is possible to save ur yahoo data?

    Reply
    1. bramesh Post author

      Hi,

      Data will not be saved you have to use some data dump for intra day from service provider

      Rgds

      Reply
  17. Harihara sudhan

    sir I managed to get the data from yahoo as per your instruction,but I could not save the data.Next day I got only the blank screen.please help me.

    Reply
  18. Harihara sudhan

    sir I managed to get the data from yahoo as per your instruction,but I could not save the data.Next day I got only the blank screen.please help me

    Reply
  19. Harihara sudhan

    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

    Sir we dont understand the above said paragraph. pls help us to proceed would be so important for getting data from yahoo.

    Reply
  20. jordi

    Hi

    I followed the steps described here and all worked fine, so thank you, bramesh.

    I also have to say that I’m not logged in to yahoo finance and it downloads 1 minute data all the same. I did logg in the first time, but since then I’v been working without the log in.

    But now to my question. Has anyone written an AFL for volume correction and is willing to share it?

    Thanks in advance.

    Reply
  21. sagar

    hello,

    I have followed all reuired steps and on amiquot it shows imported as well i have made the necessary changes to the formats as well but it still does not update the quotes, can you please help.

    Reply
  22. sagar

    hello sir when i click on amiquotes green button it attempts to download but shows a failed status nect to the script

    Reply
    1. bramesh Post author

      Hi Sagar,

      I do not have an online tutorial for this.But steps are quiet elaborate.

      Rgds,
      Bramesh

      Reply
  23. sagar

    Hello,

    This is useful as i just have realized that manshi rt is going to take fees as subscription and not give free data which is provided free of cost by yahoo anyways, so i am going to use this technique and lets see what happens, do have an online tutorial for this as well.

    Reply
  24. Om Prakash

    Dear Brameshji,
    Eveything is fine in regards to RT Data but in amiquote i dont fine nse symbols when i tried to load.

    How can we include the nse symbols?

    Regards
    Om Prakash

    Reply

Leave a Reply