Stock Charts - EOD & Intraday

I have two queries, on fetching web based data, as described in attached excel file.

Queries are primarily about fetching and plotting:

1. EOD data
2. Intraday data

Hope someone will attach relevant VBA macros in the attached sheet.

I am currently using Excel 2003 and this query is about charting indian stock index.

In anticipation of a positive reply.

reg
ketan

Even one/ part solution to either one of the two problems will do...

1. EOD data
2. Intraday data

if anyone wants to share a thought or throw in an idea, it shd help...