Hi friends:
Can someone help me on this one to get the continuous & realtime update output in excel?
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/getpri...=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/getpri...&f=d,o,h,l,c,v
To get 1 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
To get 5 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
to get 15 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v
to get Hourly Data
http://www.google.com/finance/getpri...&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.
I am trying to create a sheet so that I have to key in the scrip name (Any stock or index which has a code on Google Finance / Yahoo Finance) in cell A1 and the duration (1 min / 5 min / 15 min / 1 hour) in cell B1. The number of data-points should be limited to a maximum of 500.
Then using VBA (which I want help from someone on the forum) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV... This is the most important part.... getting the data in excel on an on-going basis, one row below the other....
When we reach the 501st datapoint, the entire data set should move one row up.... Thus the original 2nd datapoint should become the 1st datapoint and the 501st will be the 500th.... and so on.... hence, at any given point of time, there should be 500 datapoints.....
Finally the file should be designed in a way so that if I want real-time data for 50 - 100 stocks simultaneously, I should be able to get it.....
Thanks & Regards,
Bookmarks