Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

Exploring Yahoo Realtime Data Feed

53 sec read

Here is an everyone’s question. How to and from where to fetch intraday realtimedata feed. Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost.

http://chartapi.finance.yahoo.com/instrument/1.0/<span style="color: #0000ff;">^nsei</span>/chartdata;type=quote;<span style="color: #ff0000;">range=1d</span>/csv/

 
Where the ^nsei denotes the yahoo finance symbol for Nifty


For Example by replacing ^nsei with the ACC.NS(yahoo finance symbol for ACC we could be able to get the realtime intraday data for yahoo feed in csv format(1 min data). Where the Yahoo finance symbol for nse stocks can be found from Yahoo Symbol Lookup

http://chartapi.finance.yahoo.com/instrument/1.0/ACC.NS/chartdata;type=quote;range=1d/csv/

and range=1d denotes intraday data feed and range=5d denotes past 5days data feed

The below link give the realtime data feed for past 5days which could be used as a source to backfill your chart for the past 5 days.

http://chartapi.finance.yahoo.com/instrument/1.0/ACC.NS/chartdata;type=quote;range=5d/csv/

Just those who have little stuff with .Net programming could decode this csv data Plus writing few lines of Amibroker Dll Plugin will make you able to feed these free real time data into your amibroker software at free of cost which most of the traders are wasting time in paying for a realtime software

Will do some more Reverse Engineering about the real time feed fetching some time later on

Rajandran R Founder of Marketcalls and Co-Founder Algomojo. Full-Time Derivative Trader. Expert in Designing Trading Systems (Amibroker, Ninjatrader, Metatrader, Python, Pinescript). Trading the markets since 2006. Mentoring Traders on Trading System Designing, Market Profile, Orderflow and Trade Automation.

How to Install Amibroker and Ninjatrader on MacBook Air

This is a routine question we get from Mac users and in this tutorial, we will be learning how to install Windows 11 inside...
Rajandran R
49 sec read

What is Algomojo – Smart Order Execution Module for…

Smart Order Module brings a 100% end-to-end automated trading solution for Amibroker users to automate their trading ideas with a simple plug-and-play module. Traders...
Rajandran R
26 min read

Virtual Trade Simulator Module Version 1.0 – Amibroker AFL…

Thought of launching a simple and user-friendly Virtual Trade Simulator to study/test your inner intuition before practicing in the live markets. Virtual Trade Simulator...
Rajandran R
3 min read

85 Replies to “Exploring Yahoo Realtime Data Feed”

  1. Sir,
    Good information. If you could do little more research and provide us the net program information and the amibroker formula,it would be great!

  2. Dear Rajandran Bhai,

    Greetings! I was just flipping through the pages of your site when I found this. Very interesting indeed. However, could you find a way to download the data from the NSE Java Chart . This would be the last word for collating purposes, as the serious pros don’t trust their DSPs alone.

    Thanks

    Javed

  3. Hello Rajandran sir, i want ami broker realtime charts with buy/sell signals. which apply to my pc? pls help me.

  4. Great article! But how do I get the file? I tried data socket, but the link does not work. Do i need to parse the HTML? I would really apprecaite help here.

    1. Yeah, Bryan I think HTML parsing is the only way to read a csv feed. The above said link works only for backfill purpose
      i guess. And for real time tick data you should use some other source

  5. Sir,
    Bhagwan ki kripa hamesha aap aur aap ki family par barasti rahe. Sir U R the person who aLways help other without any …….. I have no word s. But thanks always sir. God bless U and yr family.
    ALways yours,
    chandu

    1. Thanks Chandu, the real reason is if iam not going to do that then some one else will claim the credit for the same.
      This is an open source world.

  6. with the ami borker trial version is it possible to have a good real time software. but a free alternative i am tring with fchartse with chartsdata and manshi rt. it is some what succesfull but backfilling is a problem for both. if any developer can concentrate on fchartse

  7. Hello,

    I agree with the fact that we should not be paying for data which is freely available and we do need to reverse engineer a way to get those softwares customised and unlocked for us. I mean they just gives us yahoo data which anyways is free for us. Is there a software that can give me realtime data for free without any limitations

  8. is amibroker trial version (my version crossed 30 days) can be used for perfect realtime charting.
    i have seen that in case of eod data does not stored but heard that real time charting possible with previous data also stored. i am not technical for software., pls inform and what free data real time downloader can be used for my practice

  9. i am new to amibroker learning abcd. i have only a trial verssion of amibroker which already expired but with chartsdata(by loganathon, a real time data feed) it is working. i am testing it but cant under stand is it lagging or not. there r some minor faults of missing some minutes and some time not proper back fill etc.
    another thing can any one help how i can change moving avarage overlays,like there is sma of 15,45,100 but i want ema of 5,20,34
    how to do that.and how to bring stocastic in lower window in place of macd and how to edit parameter. pls help.

  10. Hi raja, is it possible to get 1 min data from yahoo..Pls advise. ichecked with changing the range for the given link. but its not working.Pls help..Thanks in advance..

  11. For nse real time data from yahoo use the given below link:
    http://download.finance.yahoo.com/d/quotes.csv?s=YHOO+GOOG+MSFT&f=sl1d1t1c1hgvbap2

    Depends on you Internet browser setting, you maybe asked to save the results into a filename call “quotes.csv” or the follow page will appear in your browser.

    “YHOO”,14.8188,”6/22/2009″,”1:20pm”,-0.9812,15.61,14.80,13944065,14.81,14.82,”-6.21%”
    “GOOG”,402.25,”6/22/2009″,”1:20pm”,-17.84,417.49,402.11,2399141,402.14,402.27,”-4.25%”
    “MSFT”,23.359,”6/22/2009″,”1:20pm”,-0.711,23.95,23.32,36595084,23.35,23.36,”-2.95%”

    The URL starts with a base URL and then adds parameters and values after a question mark (?).

    http://quote.yahoo.com/d/quotes.csv? – The default URL to get the information
    ‘s=’ – Append a bunch of stock symbols separated by “+” after this
    & – to join the string
    ‘f=’ – Append a bunch of special tags after this with no spaces in between

    The following are special tags provided by Yahoo finance:
    a Ask a2 Average Daily Volume a5 Ask Size
    b Bid b2 Ask (Real-time) b3 Bid (Real-time)
    b4 Book Value b6 Bid Size c Change & Percent Change
    c1 Change c3 Commission c6 Change (Real-time)
    c8 After Hours Change (Real-time) d Dividend/Share d1 Last Trade Date
    d2 Trade Date e Earnings/Share e1 Error Indication (returned for symbol changed / invalid)
    e7 EPS Estimate Current Year e8 EPS Estimate Next Year e9 EPS Estimate Next Quarter
    f6 Float Shares g Day’s Low h Day’s High
    j 52-week Low k 52-week High g1 Holdings Gain Percent
    g3 Annualized Gain g4 Holdings Gain g5 Holdings Gain Percent (Real-time)
    g6 Holdings Gain (Real-time) i More Info i5 Order Book (Real-time)
    j1 Market Capitalization j3 Market Cap (Real-time) j4 EBITDA
    j5 Change From 52-week Low j6 Percent Change From 52-week Low k1 Last Trade (Real-time) With Time
    k2 Change Percent (Real-time) k3 Last Trade Size k4 Change From 52-week High
    k5 Percebt Change From 52-week High l Last Trade (With Time) l1 Last Trade (Price Only)
    l2 High Limit l3 Low Limit m Day’s Range
    m2 Day’s Range (Real-time) m3 50-day Moving Average m4 200-day Moving Average
    m5 Change From 200-day Moving Average m6 Percent Change From 200-day Moving Average m7 Change From 50-day Moving Average
    m8 Percent Change From 50-day Moving Average n Name n4 Notes
    o Open p Previous Close p1 Price Paid
    p2 Change in Percent p5 Price/Sales p6 Price/Book
    q Ex-Dividend Date r P/E Ratio r1 Dividend Pay Date
    r2 P/E Ratio (Real-time) r5 PEG Ratio r6 Price/EPS Estimate Current Year
    r7 Price/EPS Estimate Next Year s Symbol s1 Shares Owned
    s7 Short Ratio t1 Last Trade Time t6 Trade Links
    t7 Ticker Trend t8 1 yr Target Price v Volume/td>
    v1 Holdings Value v7 Holdings Value (Real-time)/td> w 52-week Range
    w1 Day’s Value Change w4 Day’s Value Change (Real-time) x Stock Exchange
    y Dividend Yield

  12. I have been looking for few days..for this link of CSV.Thank you very much.You have greatly helped me.I am grateful to you.

  13. Sir ,

    You are really great . Being a genius scientist , you are sharing with all. Gog will always shower blessing on you and your family.

    Sir , would you please throw light on how to download nse live data from google in csv form. We all will be thankfull.

  14. Hello sir,

    Thanks for introducing this to us. treasure of information. i tried to open nsei from google for 60 mins. am getting the following. i want the data to come from 9.15 till 3.30 which i tried to change market_open_minute as 549 and MARKET_CLOSE_MINUTE as 920 and also the columns to appear as date,open,high,low,close,volume. I also need guidance as how to convert the first column of date to say 9.30,10.30 and so on. I have attached the same below of 21/12/2010 data. kindly help me on the same.

    Ravi

    —– 21/12/2010 ^nsei hrly data from google——

    EXCHANGE%3DNSE
    MARKET_OPEN_MINUTE=540
    MARKET_CLOSE_MINUTE=930
    INTERVAL=3600
    COLUMNS=DATE,CLOSE,HIGH,LOW,OPEN,VOLUME
    DATA=
    TIMEZONE_OFFSET=330
    a1292905800,5995.5,5996.9,5960.4,5960.4,0
    1,5995.5,5998.45,5986,5995.75,0
    2,5983.45,6006.5,5982.1,5995.4,0
    3,5995.9,5997.8,5981.95,5983.45,0
    4,5985,5998.55,5979.15,5995.9,0
    5,5999.8,6002.05,5983.7,5984.9,0
    6,6000.65,6007.4,5994.05,6000,0

  15. @kartheek

    pls let me know how to get it from yahoo site and to backfill into amibroker 5.2. I tried with google. But still don’t know how to import to amibroker. Pls guide me if you know.

    Thanks

    Ravi

  16. Sir,
    will u provide help me how to use your NRTR and counter trend reversal system in free charting utilities like fcharts or chartnexus or ninjatrader. And please can u help me how to configure and install that indicator in them.
    Thanks in advance.
    Waiting for your reply.

  17. Hi All
    Extracting Yahoo RT data from .net is little easy stuff. but after that the real problem arises.

    1. without logging in to yahoo you will get 15 min delayed data.
    2. Handling Time i.e. Yahoo data server is in US and RT data comes with US timing………
    3. DayLight Saving………..Problem…
    4. Handling the volume….. as you will get whole day volume even in RT.

    Pleaase check all these things before starting your programming.

    Google Provides 15 day 1 min Backfill…….. reliable one

    as per my knowledge RT data from Google is restricted.

    To make you people little Comfortable I coded this.(RT from Yahoo, Backfill From google, BSE, NSE Bhav, and more…….)

    Visit : Feeds-plus.blogspot.com

    Dont think I am marketing here. Earlier even I too searched for free stuff. when I coded and worked for more than 6 months on this I found that it needs some little, a small, at least reward for my work. So I made it paid. Thats only 2000/- per year.

    I made it paid because I want to make the same feeds available for Metastock also but for metastock I need Metalib which costs me some amount so……

    Please check out the utility…

    Regards
    Santosh Sharma

    1. Hi Santosh,

      I am looking for yahoo realtime data for world indices, S&P(US market) for Metastock Pro 11(not e-signal broadcast). Is it possible to provide this through your program.

      Regards,
      Suresh

  18. hi RR,
    From that url we get data in that how to calculate data and time values.
    Regards
    sudhakara

  19. hi kartheek and Rajandran

    thank grt topic

    how to get last 1 year tick by tick data (ieod) on yahoo finance

    plz help me

  20. wonderful article… will help a lot

    can v download all nse scrips….
    what will be the google finance symbol for M&M and AREVAT&D ?

  21. MR.RAHUL
    DOWNLOAD DATADOWNLOADER FROM http://WWW.VOLUMEDIGGER.COM WHICH IS FREE
    AND THEN EDIT THE FILE NAMED GOOGLEINTRADAY AND TYPE “M&M,NSE” AND “AREVAT&D,NSE” ONE IN EACH LINE.REMEMBER TO INCLUDE COMMA BEFORE NSE IN EVERY SCRIP NAME.THEN SAVE AND START DATADOWNLOADER.
    Eg TATASTEEL,NSE
    M&M,NSE

  22. Hi,

    Is there any option in any softwarware can give,intraday stock list in Nse, to make trading decision

    Presently nse tamelight is available without technicals……

    Scrip Price RSI MACD EMA(5) EMA(10) EMA(15) Vloume in Milloin Graph
    ACC XXXX xx X X X X 1.Mi Small pic
    XXX XXXX XX X X X X x XXXXXX

    The above said output has to come every 10 mins or 15 mins of time. We may can add some more additional data if required.

    need some prgramming with some sort of analyst.

    the out put can be come in excel file.

    With regards

    Dharmasekar.B
    With getting the intraday feed the output has to come like this…. based on this , i hope we can make 70- 85 % of success

    With reagrds

  23. The yahoo feed seem to 15 mins delayed even after logging into Yahoo. Why so? How to get rid of that ?

  24. How do i get rid of the irritating logos of facebook, twitter and google off the face of teh charts.

    Is it possible for me to draw trend lines on the chart.

  25. Pingback: Quora
  26. DEAR ALL,

    KINDLY NOTE …. ONLY INDEXES ARE REAL TIME ON YAHOO…ALL STOCK QUOTES ARE DELAYED BY ABOUT 15 MINS !!!!!…. AFTER ALL EXCHANGE GETS LOT OF MONEY BY SELLING THE FEED. U CANT GET ANY REAL TIME FEED, NOT OFFICIALLY. INDICES ARE FINE, THEY GIVE OVER ALL MARKET DIRECTION AND NO ONE TRADES DIRECTLY THE INDICES. ALL DERIVATIVES, INCLUDING INDEX DERIVATIVES’ QUOTES ARE DELAYED.

    KINDLY NOTE !!

  27. Hi sir…
    how to download the bid and ask prices from google financial data in csv format?

  28. dear Rajendra yours is the best stock market site that i have ever come a crossed .my day doesn’t start unless i log it at least once in the morning,it has every thing that trader wants to have. pl.keep it up.

  29. Hi…

    Could you please provide me some suggestions on how to get intraday stock data at 5 minute interval in a csv format

  30. thank you rajendran Sir for your valuable inputs , i have just come across a site called feeddropper.com which gives realtime data for nsecash, future, selected options, mcx, ncdex, forex, comex, with intraday backfill and historical backfill and rates are too cheap approx 500 rs p.m for all and secondly apart from amibroker and metastock they have also connectores with ninja trader…i hope this might solve many of the fellow traders problem

  31. globaldatafeeds.in charges a minimum of Rs1650 per month for real-time data from NSE. My doubt is if i buy amibroker and buy their data feed can i convert the data in to ascii format in real time. I know C++/C#. Is it possible to use the amibroker sdk and convert the data?

  32. Hi raja sir,
    I dont know anything about stock marker .i need to know stock market to create a new site. where can i get full datatils about stock market ,stock datas , stock graphs

  33. Hi sir, How to feed mcx data to amibroker.. I’m new to mcx trading and amibroker too.. How to feed mcx data i don’t know.. please help me

  34. Dear Mr. Rajendran,
    I am able to right click and copy the best 5 BID/ASK data from the “Market Picture” window in Diet ODIN. Since the data is available in Clipboard, I can paste it in Excel and analyse. My question is, is there a way to get this data without right clicking? Hope you could help.
    Warm regards
    Ravi

    1. @Ravi,

      The Top 5 Best Bid/Ask data is called Level 2 Data. Normally Brokers provide in Trading terminals. Apart from that its tough to get it anywhere else.

      1. Dear Mr. Rajendran,
        Thanks for your prompt response. As you rightly said, many brokers in India provide this data through their ODIN Diet terminals. I’m using one such service from RKGlobal. There, I can see Level 2 data for a scrip of my choice by using the “F5″ key. A ” Market Picture’ window appears and the data is there for you to see as well as copy (by right click menu). My question to you was, is there a direct way of copying that data from the ‘Market Picture’ window (using scripts etc..)??
        Thanks for your time..
        Regards
        Ravi

  35. Hullo Rajendran

    I have two questions

    1) Do you know how to parse the timestamp on this API? When I query using http://chartapi.finance.yahoo.com/instrument/1.0/goog/chartdata;type=quote;range=1d/csv/

    I get results like
    1405085400,572.5187,572.5187,571.4200,572.1500,41300
    1405085519,573.1150,573.2400,572.5100,572.5200,9300
    1405085520,572.5607,573.1200,572.1150,573.1200,20300
    1405085639,573.2000,573.3000,572.7000,572.8000,15800

    I know the first column is the timestamp. So if I try to convert 1405085400 to a Date object, I get a date in 1970 and not today’s date.

    B) Do you know how to vary the interval for the results? I am interested in only hourly data and this might be too many results for me.

    Thanks
    -Venu

    1. You have to get subscribed directly from the exchange. There are no other options because of the costing of tick data 75,000 per of data and for researchers in college/PG it is 12,000 per year of data. Later you have to put tons of effort in formatting the encoded data into your required format.
      And the storage it requires are unimaginable.

  36. If I want to build my own intraday 5 min price capture, using Excel: Where can I go to get (even if 15min delay) current price, Hi, Low, Close, Volume (important) ? I would use Excel to schedule, capture and push to Db. Great information and thanks for all your help and love for the market. Yes name pun intended.

  37. Respected Sir,
    Here, Girish S B. Sir I would like to have Eod, Weekly, Monthly data feed only sir with 7 Years data , Where can i get this sir, I have licensed AmiBroker Professional 6.0 32 bit.

    Thank you sir.

  38. Respected Rajandran Sir,

    I have gone through recently of your previous posts.

    ” 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. ”

    Could you please provide this AFL as I am very week in software writing.

    Thanking you,

  39. Sir, I am in Tamilnadu, Coimbatore. I need every days gold market details (open, high, low, close & volume) from market opening in 5 Minutes gap. How i download in excel spread sheet.

  40. sir
    i am from thanjavur, tamilnadu, i need to know how to get free data on nse and bse share for intraday and positional trading. and how to feed the data with the amibroker with buy and sell singals with your free supertrend indicator, please reply for that sir

  41. sir
    how to feed this data in amibroker trail version, i have no knowledge on .net like this, so please guide me how to feed this data in amibroker

  42. hello sir,
    great work.. using info from your post i am using yahoo chartapi to get realtime stock data, i need your help with one problem i have, is there any way we can get list of all the symbol lookups for all stocks listed on chartapi.yahoo.finance.

    regrads
    Rajbir Singh

  43. Yahoo finance API is not available anymore. I have moved to MarketXLS after this change, much more reliable data.

Leave a Reply

Get Notifications, Alerts on Market Updates, Trading Tools, Automation & More