|
|
The biggest benefit is the ability to have a dynamically updated, customized financial spreadsheet accessible from anywhere (where there’s an Internet connection).
Nick also provided an example of how to use the Google Finance Functions in Google Spreadsheets:
* To insert the current volume of Google stock:
=GoogleFinance(“GOOG”; “volume”)
* To insert the current price of Google stock:
=GoogleFinance(“GOOG”) and =GoogleFinance(“GOOG”; “price”)
* Alternatively, the stock symbol and/or the attribute values can come from spreadsheet cells. For example, the function can be:
=GoogleFinance(A2, B1)
In this case, the attribute specified as a string in cell B1 would be returned for the stock symbol in cell A2.”
For further information on using the Google Finance functionality visit: http://docs.google.com/support/spreadsheets/bin/answer.py?answer=54198&hl=en
How do you add stocks from a specific stock exchange?
For instance, when I use the ticker symbol RDSA, I get the information from Royal Dutch Shell on the London stock exchange. However, I would like to have the information from Shell as traded in Amsterdam.
I would think it that using ‘ams:rdsa’ as ticker symbol would do the trick; but that doesn’t seem to work.
In general I think Google Finance doesn’t make it easy to choose information from specific stock exchanges.
I’m creating a watchlist. What is the function to enter the price of a stock on a certain date. For example I want the cell to reflect the price of GOOG on 1/2/2008