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.
how to get tick by tick data from google
thanks
Thanks
how to import that data to amibroker ?
Dear all ,
The google not updating 1 min tick data from today ? is there any problem with google server ?
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 ?
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
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…
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
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
Hi subbu
Custom Softwares are available in the market. But most of them are trial/paid version.
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
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
Hi
this link is good ,can you tell how to get date and time
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
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
i saw on the Google , finance API going to be deprecated on Oct-2012 then, will be above link work?
@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
Thanks for the reply.
please let me know – how i find gold /silver chart mcx in google finance or any other sites ?
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.
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
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
i start my time 9:15 to what i pass in ts
i want to after 9.15 intraday data so what should i pass in ts?
Dear Sir,
what does CTCP stands for in GetPrice. ?
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!!!
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… 🙂
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?
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]
Can I get Option Interest data for Nifty?
No Google Doesnt Provides Futures and Options Data
Thank you for your reply. Where can I get OI data like google finance? any idea? Please suggest.
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
Please note that the data is returned in CHLO format rather than OHLC immaterial of the order of parameters passed.
how add high ,low open with each row ?
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
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
list “v” as one of the parameters, like this:
https://www.google.com/finance/getprices?q=RELIANCE&x=NSE&i=60&p=5d&f=d,c,o,h,l,v&df=cpct&auto=1&ts=1266701290218
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
how to get real time nse data in json format
hi sir,
According to the above url, time is not displayed. could you please let me know to get the time ?
timestamp is in unix format you have to decode it. Google for unix timestamp format
how can download excel fromat
Google API is not available in Excel Format.
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
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.
can anybody api in excel format intraday back fill data
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
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
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
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.
Dear Anurag,
Please keep me in loop if you find any source for RT data.
John
[email protected]
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.
How to Calculate EMA of 5 days with this link http://www.google.com/finance/getprices?q=RELIANCE&x=NSE&i=36000&p=1d&f=d,c,o,h,l&df=cpct&auto=1&ts=126670129 (online)
How to get this data in json format?
I am using this url for Reliance data
http://www.google.com/finance/getprices?q=RELIANCE&x=NSE&i=60&p=1d&f=d,c,o,h,l&df=cpct&auto=1&ts=1431986400
I checked the open price and current prices. But seems not matching with existing open price, and don’t understand for which hour/time the values are.
Its unix time.
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.
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
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.
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
What is the code for getting 1 minute, 5 minutes or hourly data in google doc spreadsheet
Any idea on getting data for F&O STOCKS? ON NSE
Hi Rajendran,
I read in the above article that ts is start time and if we cut last 4 digits , we could get start day in seconds
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
Could you please let me know how to get the data from 11.30 instead of regular start time. Could you please guide me on this. How and what to change in ts. Requesting your help on this , please. Thanks
Sir,
I need MCX real time 1 minute data. It may be either paid or free. Please help me. My e-Mail id is
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
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.
Hi
I am looking for intraday data for MCX from 2007.
Kindly help and let me know from where I can get it
Thanks
Dear Rajandran,
These links are not working since yesterday bro. Either google or NSE changed something.
Google Intraday back fill is not working as of now as google has changed the path. Can you point to current working page?
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
oK. I FOUND IT…AFTER LITTLE RESEARCH …GOOGLE CHANGED url FROM
http://www.google.com/finance/getprices?q=
TO…
https://finance.google.com/finance/getprices?q=
ALL OTHER PARAMETERS ARE SAME…
EVEN SECURITY PROTOCOL IS CHANGED.
Thanks Satish for the valuable information
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
not working
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).
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,
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#?
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
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?
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.
The data from finance.google is not working since last 1 week. Do you have an alternate solution for this?
Yes. Confirm. Data from https://finance.google.com/finance is not working. Please share the solution if anybody finds it.
Even I am facing issues there. Google finance has stopped publishing data it seems.
Any other alternate source for this information ?
Yes it seems the free data service has been discontinued since last week. If there is alternate url, please share.
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.””
any place i can free minute nifty realtime data ?