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

XUV-500

Well-Known Member
#1
Hi,
Firstly I DON'T require data in Excel from trading terminals and feeed to charting s/w using excel.
Members have posted such wonderful utilties.

Mine requirement - i prepare watchlist of stock in excel and enter in some of them at appropriate times.
Now is it possible to daily update closing price in that excel ? I seen some excels where data is pulled from NSE using macros, especially in options.

Well it will be good if it can updated couple times during trading hours.

Can some one guide me in this.
 

XUV-500

Well-Known Member
#4
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 :)
can u pls prepare such sheet? say fetching data for reliance equity
pls...
 

XUV-500

Well-Known Member
#6
thanks Pakatil, u have made nice graphs. But my requirement is simple.
I just want to see how much a scrip is +/- from my buy price. I can do it either by viewing charts one by one OR i can make a excel and feed daily CMP ....which i want to automate
 

XUV-500

Well-Known Member
#8
reliance cash data.....
refresh duration??
i will be fetching data from yahoo finance is that ok??:)
yes...cash data.
Any source from which i can get reasonably reliable figures.

I don't want auto refresh as it's EOD. Well ,but at times i wish to check 3-4 times in a day.
 

Similar threads