Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

Google Realtime Intraday Backfill Data

1 min read

How to get the realtime intraday backfill data?

Many of us know that google provides 15 day intraday 1min backfill. But where is the source how the softwares like volume digger getting those backfill data?

The below link gives the realtime backfill data which most of the softwares are probably using it as a source for realtime datafeed
[wp_ad_camp_5]

 
http://www.google.com/finance/getprices?q=RELIANCE&x=NSE&i=60&p=5d&f=d,c,o,h,l&df=cpct&auto=1&ts=1266701290218

where

q= stock symbol on Google finance
x= exchange symbol
i= interval (here 60 means 60 sec (1 minute interval))
p= no of period(here 5d denotes 5 days of data)
f= parameters (day, close, open, high and low)
df= difference (cpct is may be in % change )
auto =1,
ts = time start… if you cut the last 4 digits…the rest gives the start day in seconds

you can choose your own set of value depending upon your need.

The following link gives the 1 min Realtime data for Nifty

http://www.google.com/finance/getprices?q=.NSEI&x=NSE&i=60&p=15d&f=d,o,h,l,c,v

Using the above explanation we can build any formats(1min,5min, 15min,hourly) of real time data and can be use as a backfill
to feed charting softwares like Amibroker, Metastock, Ninja Trader etc

To get 1 min Data

http://www.google.com/finance/getprices?q=CIPLA&x=NSE&i=60&p=15d&f=d,o,h,l,c,v

To get 5 min Data

http://www.google.com/finance/getprices?q=CIPLA&x=NSE&i=300&p=15d&f=d,o,h,l,c,v

to get 15 min Data
http://www.google.com/finance/getprices?q=CIPLA&x=NSE&i=900&p=15d&f=d,o,h,l,c,v

to get Hourly Data
http://www.google.com/finance/getprices?q=CIPLA&x=NSE&i=3600&p=15d&f=d,o,h,l,c,v

want to know how to and from where to fetch intraday realtimedata feed using yahoo finance. Here is the link where the yahoo finance offers real time data updates in realtime in csv format at free of cost.

Rajandran R Telecom Engineer turned Full-time Derivative Trader. Mostly Trading Nifty, Banknifty, USDINR and High Liquid Stock Derivatives. Trading the Markets Since 2006 onwards. Using Market Profile and Orderflow for more than a decade. Designed and published 100+ open source trading systems on various trading tools. Strongly believe that market understanding and robust trading frameworks are the key to the trading success. Writing about Markets, Trading System Design, Market Sentiment, Trading Softwares & Trading Nuances since 2007 onwards. Author of Marketcalls.in)

How Geopolitical Tensions Impact Stock Markets: A Closer Look

Geopolitical tensions have always had a significant influence on the global economy, particularly on stock markets. Investors, both individual and institutional, closely monitor these...
Rajandran R
2 min read

What Traders/Investors need to know about Hypodermic Needle Theory

The Hypodermic Needle Theory, also known as the Magic Bullet Theory, is a communication theory that suggests that media messages are injected directly into...
Rajandran R
2 min read

What is a Margin Call? What is the impact…

A margin call is a demand from a broker or a financial institution that an investor deposit more money or securities into their margin...
Rajandran R
1 min read

86 Replies to “Google Realtime Intraday Backfill Data”

  1. Dear all ,

    The google not updating 1 min tick data from today ? is there any problem with google server ?

  2. 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 ?

  3. Dear Sir,

    Thank you for your wonderfull and lucid posts.

    Appreciate if you can give the link where to find the procedure
    for feeding real time google data to Amibroker.

    I have been scanning each of your page from last and have reached up to 176 but still not found the same…

    However during this scanning I have come across many posts which have
    truly enlightened me.

    I have downloaded Motivewave but find that it is slow and the data
    does not auto upload (at least today), one has to manually refresh the page to get the latest quotes and charts.

    Please let us know how to feed google downloaded as per above post to Amibroker (manually or auto)..

    Best regards,
    CT

  4. Hi,

    Thanx for the info on how to get RT NSE data from google. Looking for a small utility which can feed this data into Amibroker RT. If someone can use his programming knowledge to write this utility, will be really helpful…

  5. Hi everyone,
    Myself Software developer I can get rtdata to be imported automatically but I do not have much idea about Amibroker and where data required to be copied or how it functions.
    Jay Shah

  6. Sir,

    I have installed AMIBroker and downloaded the Google 1min / 5min data but how to append this data to Amibroker database without being using ASCII Import.

    Is there any software or method exist so that once the data is downloaded it can be appended to the database.

    Thanks,
    Siva

  7. HI Rajendran,

    Thanks for the reply.

    I have downloaded the google finance one min data, could you please explain me how to converthe Google timestam to date and time in excel.

    Thanks,

    Siva

  8. What is the Google Finance symbol for M&M / ArevaT&D / Cox&Kings. Because, I am unable to download intraday data for these scrips. Mainly the scrips that contains the & symbol.

    Pls help me .

    Thanks,
    Siva

  9. reading the above post and comments… …

    i have one question…. does the google backfill data is only used for other softwares…

    i want to make charts in ASP.NET based on historical data… can google backfill data help me in any way….

    has any one done this before?? help will be really appreciated…

    Regards
    Kushal

    1. many are using this data for their backfill.

      1)Manshi
      2)Volume Digger
      3)MDP
      4)TDI

      Many are in the list its big to mention all their names

  10. i saw on the Google , finance API going to be deprecated on Oct-2012 then, will be above link work?

    1. @Milind Karpe

      I too seen that message. I think API is different from the JSON datafeed. Still Iam not sure will the link cease to exit working or not after Oct 2012

  11. please let me know – how i find gold /silver chart mcx in google finance or any other sites ?

  12. Stupid question,
    How do I interpret the date? Also seems that the smallest interval is 8sec but the data is the same as i=10. Also what is the time difference between lines? Sorry if these questions are seem simple, and thanks for the help.

  13. Hello Rajandran Sir,

    I have found that many companies are selling historical quotes of “FUTURE OF INDIVIDUAL STOCK” ; I think they must be bluffing as it could be approximation but for sure not authentic one.

    As future quote would have 3MONTHS contract for each stock on a given day, so which means they have to store 3 data points for every minute. If we take option into view the scenario becomes even complicated.
    SO MY WILD GUESS is that; they are bluffing about having historical data of “f&o” quotes.

    SIR, if you have seen these historical F&O from these acclaimed data provider ? Please let me know your view or your experience with historical F&O quotes.

    With Best Regards,
    – Prahalad Das

  14. i help this all link but gold is not show in google finance so how can i get gold realtime close in csv formet plase help me

  15. Rajandran Sir,

    I am New to this Real Time Data Feed….But sir Can u tell me How to get 1 Minute Data for Nifty futures into Excel…Since i take My positions Based on Futures Price & Not on Spot…Google Finance & Yahoo Shows Spot Price…Thank you in Advance…Please Help Sir!!!

  16. Hi,
    Is there a way to get this data in real time to excel? Just to calculate real time PL of futures positions.

    Is MCX, NSE CDS futures real time data available?

  17. I need a program to be developed by you to get realtime data feeds from my odin terminal to excel file. I will pay the cost
    Can you develop?
    Contact my email id [email protected]

  18. Thank you for your reply. Where can I get OI data like google finance? any idea? Please suggest.

  19. I ‘ve used Google Finance to download realtime data. But what I want from datafeed is last 1 minute data, for ex. if there is a data of 1 whole day which is around 374 lines, I just want last 1 line and not all the lines. Or is it possible to extract a particular time line (i.e. 12.30 minute) from Google finance. I mean olny one line and not the full data from 9.15 to 12.30

  20. Please note that the data is returned in CHLO format rather than OHLC immaterial of the order of parameters passed.

  21. Hi, Where to get the volume information. The link mentioned gives only the price data but no volume information. Please guide us where we can get volume information similar to price information for intraday

    Thanks-JOHN

      1. Hi
        Is there a way to download only the particular day’s data. If i mention 3 days it will give the data for 3 days of intraday data. But what if I want only the day before yesterday’s data? Is there any way to download something like intraday data for only one day of any previous days by giving the dates? Any help would be appreacited

  22. hi sir,

    According to the above url, time is not displayed. could you please let me know to get the time ?

      1. Is there a way to generate a bhavcopy of all nse stocks for today(current day) at particular time say 3.00pm. basically i need open,high,low,close,vol of all nse stocks around 3pm. ie it should have the open, high,low,close and volume of that day till 3pm.
        Pls tell me if there is a way. thank you in advance

        1. John,
          Bhavcopy is generated by NSEindia website. If you need to get the OHLC values around 3p.m one way is to get the realtime data for NSE Cash market and other way is to get the data from your trading terminal like NEST or ODIN or NSENOW.

    1. hello rajendran,
      I need a small help in creating a simple afl in amibroker for my requirement. Idont know writing afl language, I found 3/10 oscillator afl from net.
      _SECTION_BEGIN(“My 3/10 Osc”);
      m=MA(Close,3)-MA(Close,10);
      Plot( m, “My 3/10 Osc”, colorRed );
      s=MA(m,16);
      Plot(s,”Signal”,colorBlue);
      Plot(0,””,colorWhite,styleDashed);
      _SECTION_END();

      My requirement is:
      1. afl should be able to help in scanning and exploring list of stocks that had positive and negative crossover. witth heading ” cross over” and results as ” positive crossover” “negative cross over”
      2.There should be an option to find out where the previous cross over occurred. Was it above zero line or below zero line. In scanning and exploring results I would like to have two column displaced with “previous cross over” as heading and results as “above zero line” “below zero line”
      3. I want create a green arrow in positive cross over and red arrow in negative cross over in chart.

      It would be of great help if you could write it for me. I hope it would not take more than a minute for you.

      Thank you very much in advance

  23. Hello Rajendran,
    Where can I get the information of Circuit limits of different stocks. say if I want to find out all NSE stocks that are with 20% circuit limit, where can I see. Checking each and every stock seperate is tedious and getting to know after hitting 20% upper circuit limit is missing a rally. Please let me know if you have any idea. Thanks
    -JOhn

  24. Rajenran,
    Can you please tell me the afl to scan 50 DMA
    and also please guide me on which parameter do i need to change to scan for 30 DMA/100DMA/200DMA from the afl of 50DMA afl. It would be really great if you could reply as early as possible. Thanks

  25. I think something weird happens when I change the interval parameter in the query. If you notice the last entry, the OHLC values remain the same even after changing the interval. I don’t see why this should be like that.

    Maybe I am not able to understand the exact meaning of column one.

    Also I need Real Time feed. How do i get that done? Do you guys sell “just” the real time data. I don’t need a software. I just need a csv/excel file.

  26. Hello Sir..
    Your code is help for intraday backfill successfullythanks for that.But i want another one code, that is back fill for only last 5minute (one minutedata).pl help me.

  27. Hi Very useful information
    Using the above link we shall get realtime JSON format data
    I have requirement to get OHLC data from one start date to end date in JSON format(Not in csv) .Can you suggest a link or API to get this info.

  28. hi rajendra
    thanks for all the wonderful research and help provided here.

    i want intraday data of mostly all nse stocks. live
    can u suggest how to avail it

    as no vendor is providind all stocks1

  29. Hi Rajandran,,
    Thanx for sharing this info. For trading I am using Trade Tiger. They are providing data (for all intraday periods) but it is tedious job to import that into amibroker manually. So I was searching for live intraday data provider. There are companies which provide this data but reliability is poor and also are very costly.

    Using above info I developed dot net software to download data from google and import in amibroker. I am downloading 5 mins data for my favourite 30 scrips. I am a intraday tarder and I work only on 15 min candles. All my trading strategies include 15 min candles. So even google is providing delayed data it is not affecting my trading strategies and decision making. [Sometimes I miss opportunites due to delayed data. but you know that there are always plenty of opportunities.]

    Last one year I am using this system to download data from google and only 2-3 times I was unable to download because of server problems otherwise it is working fine. So I am vey happy and really satisfied by GOOGLE data. and credit goes to you MR. Rajandran.

    Thanx once again and GOOGLE ki Jai HO.

    1. satish patil can u share that software with us as being a small trader we cant afford realtime data from service provider if possible plz share with me

  30. Sir,

    I need MCX real time 1 minute data. It may be either paid or free. Please help me. My e-Mail id is

  31. sir,
    instead of single stocks symbols at a time, is there any way to get data for ALL STOCK SYMBOLS simultaneously
    pl
    thanks

    DR.SR.RAMESH
    dated 14 june,2017

  32. HI,

    CAN I GET OPTIONS AND FUTURES DATA OF INDIVIDUAL STOCKS USING ABOVE CODING. I WANT DATA WITH ONE MINUTE FREQUENCY WITH ALL THE DETAILS LIKE OPEN, CLOSE, PRICE, VOLUME TIME ETC.

  33. Hi
    I am looking for intraday data for MCX from 2007.
    Kindly help and let me know from where I can get it

    Thanks

  34. Google Intraday back fill is not working as of now as google has changed the path. Can you point to current working page?

  35. Hi !!! Rajendran,

    More than a year I am downloading 5mins data using dot net software with following link for aboy 50 scrips. There was no problem at all . I never experienced any server problems. But today I am not able to get this delayed data.

    http://www.google.com/finance/getprices?q=CIPLA&x=NSE&i=300&p=15d&f=d,o,h,l,c,v

    Today on 14-seo-2017 when I use above link google is sending me to daily link.

    Can u please check whether this is a server problem or google stopped providing support.

    Thanx

  36. looks like google finance query string format got change today, could anyone please update it if you know what is the change. Thanks in advance

  37. GOOGLE API “getprices” is NO more fetching intraday data (say 5 minute or 15 minute or 30 minute or 60 minute …). It is only fetching data in 1day interval irrespective of interval you set (say i=300 or 900 or 1800 or 3600).

  38. Dear Mr. Rajendran,
    Backfill from Google for intraday of all nse and bse scripts not working from data downloader since 14 sept17. Can u plz look an alternative way on urgent basis.

    you will be appreciated if provide your contact number.
    Thanks,

  39. Hi,
    I am using the google api “http://www.google.com/finance/getprices?q=A&p=2d&f=d,c,h,l,o,v” for quotes. While testing I got the error as “The remote server returned an error: (503) Server Unavailable.”. Seems they have certain limit to hit their service. Any idea how to fix this in C#?

  40. Hi Rajandran,

    I need 3 years hourly data for mcx. Can you please suggest some source from where I can get it. I am ok with paid sources as long as the charges are reasonable.
    This will really help me a lot.
    Thanks in advance

    Subhojit

  41. Does any site provide Futures intraday data with 5-10-15… minute interval? Google provide for equities however if any any one know where to get for Futures?

  42. Dear Sir,

    What should be the value of ts if I want to retrieve the intradays (only 1 day) of the 8th of January 2018 9:00am. 1515402000 ?
    When I do that the values are always ending by the current date… I don’t understand how it works.

  43. The data from finance.google is not working since last 1 week. Do you have an alternate solution for this?

    1. Even I am facing issues there. Google finance has stopped publishing data it seems.

      Any other alternate source for this information ?

  44. Yes it seems the free data service has been discontinued since last week. If there is alternate url, please share.

  45. hi == “http://finance.google.com/finance/getprices?q=WIPRO&x=NSE&i=900&p=2d&f=d,o,h,l,c,v” this command is nor working please look at.i got this message “”We’re sorry…
    … but your computer or network may be sending automated queries. To protect our users, we can’t process your request right now.

    See Google Help for more information.””

Leave a Reply

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