Google Realtime Intraday Backfill Data

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 Manshi RT and 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

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.

Related Readings and Observations

Rajandran R

Rajandran is a trading strategy designer and founder of Marketcalls, a hugely popular trading site since 2007 and one of the most intelligent blog in the world to share knowledge on Technical Analysis, Trading systems & Trading strategies. More From Rajandran R »

44 comments… add one

  • suman raj December 10, 2010, 11:44 am

    how to get tick by tick data from google

    thanks

    Reply
  • nagu December 11, 2010, 12:41 pm

    Thanks
    how to import that data to amibroker ?

    Reply
  • manoj February 16, 2011, 5:17 pm

    Dear all ,

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

    Reply
  • rahul April 23, 2011, 5:39 pm

    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 ?

    Reply
  • CT April 25, 2011, 9:47 pm

    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

    Reply
  • SK April 28, 2011, 3:25 pm

    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…

    Reply
  • Jayesh May 18, 2011, 4:38 am

    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

    Reply
  • Siva May 31, 2011, 12:30 pm

    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

    Reply
    • Rajandran R May 31, 2011, 5:52 pm

      Hi subbu
      Custom Softwares are available in the market. But most of them are trial/paid version.

      Reply
  • siva June 1, 2011, 8:55 pm

    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

    Reply
  • Siva July 8, 2011, 8:34 am

    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

    Reply
  • sri March 13, 2012, 7:16 pm

    Hi
    this link is good ,can you tell how to get date and time

    Reply
  • Kushal April 20, 2012, 6:08 pm

    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

    Reply
    • Rajandran R April 22, 2012, 6:36 pm

      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

      Reply
  • Milind Karpe May 4, 2012, 3:49 pm

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

    Reply
    • Rajandran R May 4, 2012, 5:40 pm

      @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

      Reply
  • Milind Karpe May 4, 2012, 5:54 pm

    Thanks for the reply.

    Reply
  • b ljoshi May 20, 2012, 12:57 pm

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

    Reply
  • Mark May 28, 2012, 10:23 am

    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.

    Reply
  • Prahalad Das July 11, 2012, 9:57 pm

    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

    Reply
  • RIDDHI July 20, 2012, 3:12 pm

    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

    Reply
  • chirag September 21, 2012, 12:16 pm

    i start my time 9:15 to what i pass in ts

    Reply
  • chirag September 21, 2012, 12:19 pm

    i want to after 9.15 intraday data so what should i pass in ts?

    Reply
  • praxis October 1, 2012, 7:06 pm

    Dear Sir,

    what does CTCP stands for in GetPrice. ?

    Reply
  • Pratik October 29, 2012, 2:12 pm

    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!!!

    Reply
  • Market_Timer December 6, 2012, 9:39 am

    I’ve tried the google option for 15 days by hour and I can only get 5 days of hourly data? Am I missing someting… I use the following string when trying to get hourly data…

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

    it doesn’t work for some reason… I’m puzzled… (I’m not a programmer by trade… :)

    Reply
  • Vijay February 16, 2013, 9:40 pm

    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?

    Reply
  • vasudevan March 4, 2013, 12:39 am

    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 sarangeet@gmail.com

    Reply
  • radhakrishnan March 12, 2013, 12:28 pm

    Can I get Option Interest data for Nifty?

    Reply
    • Rajandran R March 12, 2013, 1:50 pm

      No Google Doesnt Provides Futures and Options Data

      Reply
  • radhakrishnan March 12, 2013, 4:56 pm

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

    Reply
  • Arpan April 27, 2013, 3:40 pm

    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

    Reply
  • Keerthi May 23, 2013, 3:28 am

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

    Reply
  • mahesh July 1, 2013, 5:28 pm

    how add high ,low open with each row ?

    Reply
  • Taylor October 22, 2013, 9:57 am

    I’m getting some bugs when I try to do this. I’ve asked the question on stackoverflow, but nobody seems to know how to help me out. Any advice?

    http://stackoverflow.com/questions/19471021/downloading-intraday-stock-data-from-google-with-r

    Reply
  • John November 22, 2013, 4:01 pm

    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

    Reply
  • Omprakash December 18, 2013, 5:25 pm

    how to get real time nse data in json format

    Reply
  • balu January 2, 2014, 1:28 am

    hi sir,

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

    Reply
    • Rajandran R January 2, 2014, 9:05 am

      timestamp is in unix format you have to decode it. Google for unix timestamp format

      Reply
  • mahesh February 28, 2014, 3:47 pm

    how can download excel fromat

    Reply
    • Rajandran R February 28, 2014, 4:30 pm

      Google API is not available in Excel Format.

      Reply
  • Mahesh p.v March 1, 2014, 12:57 pm

    can anybody api in excel format intraday back fill data

    Reply

Leave a Comment

Follow Us

Recommend on Google

About the Author

    • Rajandran is a Market Analyst and founder of Marketcalls, one of the most intelligent blog in the world to share knowledge on Technical Analysis, Trading systems & Trading strategies.