Posts Tagged ‘spreadsheet’

Monitoring Portfolio with Google Docs

February 15th, 2010

A couple of people have asked us, how we setup a live result of this stock picks contest. The answer is using Google Docs. It’s a very service from Google; where you can connect a spreadsheet to “real-time” stock quotes from Google Finance. We write “real-time” in quotes because some stock quotes are delayed up to 20 minutes, for example the ones from Canadian stock exchanges.

You can do a lot of things with this feature, for example:

  • Monitor your stock picks (just like we do).
  • Compare your stock picks to well-known index, such as Dow Jones Industrial Average, S&P 500 or Nasdaq.
  • Build your portfolio and monitor its performance.

How can we do all those things? The only thing you need is an account at Google Docs. Once you have an account, login to your account and create a new spreadsheet.

google_docs1

Next, go to any cell and type “=GoogleFinance(symbol)”. Type it without quotes. For example, if you want to get the current stock prices of Google, you can type “=GoogleFinance(“GOOG”)”).

google_docs2

There are a couple of attributes you can add, such as opening price, market capitalization, and many more. We’ll discuss them in our future postings.

Switch to our mobile site