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