Getting Stock Quotation within a Spreadsheet

I recently discovered that one can get stock quotation of any US based stock from within a spreadsheet and it is very simple. One can do it by following these two steps.

1) First make sure that the smart tags are turned on. One can go to Tools and then select the Auto Correct Option. There click on smart tags and then select label data with smart tags.

2) Then enter the stock symbol in capital letters. Let's say we want data for Yahoo. Then enter the symbol YHOO in an empty cell. Then you can see the smart tag to the right of the cell. Click 0n that select Insert Refreshable Stock Price. You can either get the stock quotations in the sheet itself (after manually typing the address of a cell) or in a new sheet.

Of course you need an internet connection for this.

Hopefully, Microsoft will similarly provide stock quotation for Indian stocks oneday.





Mesothelioma Lawyer Counter