I am trying to get last stock price quote for a cell, I've tried several different formula so far, but cant get the numbers to just show up in respective cells. Any advice is appreciated.
I tried this
HOV http://in.finance.yahoo.com/q?s=HOV.NS http://in.finance.yahoo.com/q?s=A1.NS
mro http://in.finance.yahoo.com/q?s=mro.NS http://in.finance.yahoo.com/q?s=A2.NS
xom http://in.finance.yahoo.com/q?s=xom.NS http://in.finance.yahoo.com/q?s=A3.NS
A4 http://in.finance.yahoo.com/q?s=A4.NS http://in.finance.yahoo.com/q?s=hov.NS
A5 http://in.finance.yahoo.com/q?s=A5.NS http://us.finance.yahoo.com/q?s=hov.NS
A6 http://in.finance.yahoo.com/q?s=A6.NS http://finance.yahoo.com/q?s=hov
A7 http://in.finance.yahoo.com/q?s=A7.NS #NAME?
A8 http://in.finance.yahoo.com/q?s=A8.NS http://in.finance.yahoo.com/q?s=A8.NS
A9 http://in.finance.yahoo.com/q?s=A9.NS http://in.finance.yahoo.com/q?s=A9.NS
A10 http://in.finance.yahoo.com/q?s=A10.NS http://in.finance.yahoo.com/q?s=A10.NS
as well as this
=StockQuote(A2)
Bookmarks