Real Time Stock quotes in MS Excel?
How to get the real time stock quotes in MS Excel. I am looking for stocks listed in Sensex and Nifty of India
You can open any webpage in Excel. I’m not sure about where Indian quotes are listed but I have worked with macros that open finance.yahoo.com pages and place the values into a master sheet.
Sub openStockquotes()
for tickercounter = 1 to 1000
workbooks.open "http://finance.yahoo.com/q?s=" & cells(tickercounter,1)
‘Move info into master page.
activeworkbook.close
next
end sub
Comments
About Author
Jeffrey C March 12th
You can open any webpage in Excel. I’m not sure about where Indian quotes are listed but I have worked with macros that open finance.yahoo.com pages and place the values into a master sheet.
Sub openStockquotes()
for tickercounter = 1 to 1000
workbooks.open "http://finance.yahoo.com/q?s=" & cells(tickercounter,1)
‘Move info into master page.
activeworkbook.close
next
end sub
References :
Add Yours
YOU