Appologies for incomplete link - Realtime and intraday data from google & yahoo finance

Hello friends:

I had goofed up the last time and erraneously pasted incomplete links, due to which all of you must have got "Incomplete URL" error....

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. Let me know if any of you can help me....

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

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/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 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 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????

Appologies once again.... Thanks in advance....

Cheers,

Yahoo finance URL:

http://www.marketcalls.in/amibroker/...data-feed.html

Hi everyone:

This project is extremely urgent and important for me.... Any help will be highly appreciated...

Cheers,