How to fetch NSE EOD data in Excel...macro

[Gandhar.]

thanks.... hope u will not mind if i ask further...if required
I never tried it...slow learner

ask....

 

[Gandhar.]

hey added 4 months historical data
it will also auto update every day
new file's link = http://goo.gl/CG9iwd

 

[XUV-500]

ask....

i tried fetching data for another scrip. But noted that in ur relaince sheet, CMP is not coming.
Look , u can see all things except CMP or today's close.
Am i missing something ?

 

[Gandhar.]

i tried fetching data for another scrip. But noted that in ur relaince sheet, CMP is not coming.
Look , u can see all things except CMP or today's close.
Am i missing something ?

okay added that also
u want that sheet also but before that tell and what need to be added which i have forgot??
did u get the data for other scrips?

 

[XUV-500]

okay added that also
u want that sheet also but before that tell and what need to be added which i have forgot??
did u get the data for other scrips?

i just wanted Current market price only

 

[Gandhar.]

i just wanted Current market price only

baki sab kuch nikal du?

 

[XUV-500]

baki sab kuch nikal du?

neki aur puch puch :thumb:

 

[Gandhar.]

neki aur puch puch :thumb:

matlab??

 

[XUV-500]

goto data tab --> select from web --> insert web address -->select content which u want --> click import --> in properties select the time which u want to auto refresh and all other options
simple

i am doing all same thing from yahoo finace, but while selecting content it do not give YELLOW arrow for selecting CMP.
For other fileds like prev close/open/ bid etc, it shows yellow arrow.

I want to learn procedure

 

[XUV-500]

matlab??

means YES...remove other info except Currrent market price.

Neki aur puch puch...means u are doing the same ie. thing i wanted and still asking whether to do or not