Getting real time stock quotes from google finance / yahoo finance in excel

Hi guys:

I have been using excel for a long time. But when it comes to programming and VBAs, I would say I am a novice. I am clear about what I want to do, but don't know how to go about it. I will appreciate help from the more learned and experts on the forum....

Have a look at the following links:

The below link gives the realtime backfill data

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

Using the above explanation we can build any formats (1min, 5min, 15min, 60 min) of real time data and can be use as a backfill

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 60 min Data
http://www.google.com/finance/getpri...&f=d,o,h,l,c,v

Here is the link where the yahoo finance offers real time data updates in realtime in csv format.

I am trying to create a sheet so that I have to key in the scrip name in cell A1 and the duration (1 min / 5 min / 15 min / 60 min) in cell B1.

I would need exactly 500 datapoints whether 1 min / 5 min / 15 min / 60 min.

Then using VBA (which I want someone to design and help me) I should be able to get the data in Excel format on realtime basis..... the above links give the data in CSV...

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

The most important aspect is getting the data in excel and have it updated on realtime basis….

Can this be managed????

Thanks & Regards,
Navin Agrawal
[email protected]

The OP has opened a new thread here: http://www.excelforum.com/excel-prog...-to-excel.html

Thread Closed