Displaying Stock Quotes on Google Docs
Finance June 27th. 2008, 11:02am
At the beginning of this month, NASDAQ announced that now they provide real-time stock quotes to Google (and some other media companies). Three weeks later, New York Stock Exchange (NYSE) also announced that now they provide real-time stock quotes to Google (and CNBC). Real-time stock quotes used to be quite expensive to subscribe. The standard stock quotes are normally 15 – 20 minutes delay.
Today, I am going to share how to use Google Finance function to display stock quotes on Google Docs. Since both NYSE and NASDAQ provide real-time stock quote, we can now create a document on Google Docs that shows real-time stock price. See also example of my stocks basket above.
How can we do that? It’s pretty straightforward.
- Create a new spreadsheet on Google Docs.
- Type in ‘=GoogleFinance("‘ followed by the stock ticker. For example, you can type ‘=GoogleFinance"GOOG")‘ to display the real-time stock price of Google.
