Google Finance's Stock Quote Display
Google Finance's stock quote display shows live data for the selected company - or rather is shows nearly live data, the stock quotes are actually 15 minutes behind real time; but here's the nice touch - the stock quote is automatically updated every few minutes.
The stock quote screen contains the key things that any would be investor might want to know:
the (almost) live stock quotethe day's open, high and lowsthe amount of change since the stock market's openThe page also displays a chart showing the historical stock quotes for the company - as well as a lot of information, everything from a list of related companies to the age of the chairman of the board.Comparing Stock Quotes with Google Finance
The stock quotes of more that one company can be viewed on the stock quote chart - and for this an 'Add' button is included on the chart itself.
Google Finance's Historical Stock Quotes
The current stock price can only be viewed - it can't be downloaded - which is fine for many people, but programmers or anyone wanting to do any in-depth analysis will need to turn to Google Finance's historical data.
Google Finance's stock quotes are accessible via the Historical Prices link - which, when clicked on, shows a years worth of stock quotes (only for the main company selected - not for any comparisons). The page also contains two date boxes so that more or less data can be displayed.
The historical data can also be downloaded as a csv (comma separated variable) file and it's this, of course, that's of particular interest to any programmers or analysts.
Downloading Google Finance's Historical Prices
If Google Finance's historical stock quotes are to be used in Microsoft Excel or OpenOffice.org Calc then the data can be loaded into a spreadsheet by clicking on 'Download to spreadsheet'; however, the URL behind that link can be accessed directly by any programmer for use in their own applications.
The csv file can be accessed directly by adding a few variables to the Google Finance historical data URL; these are:
q (the symbol for the market and company)startdate (with the format month+day,year)endate (again with the format month+day,year)output (which will be csv)So, the url will be something like:
http://finance.google.co.uk/finance/historical?
q=LON:VOD&startdate=Oct+1,2008&enddate=Oct+9,2008&output=csv
This url can used by the programmer in a number of different ways, for example:
download the csv file with wget and use AWK to format itread the data as a stream within a PHP scriptConclusion
Google Finance is still in Beta mode - which is to say that Google Finance has been tested by its developers and it's now up to World to do the same; well this is one application that's well worth the time to test - whether the tester is a financial analyst or an application developer, everyone will benefit from this powerful product.
Additional Reading
Using Yahoo! Financial Stock Quotes
An Introduction to AWK
Accessing Yahoo! Finance from PHP
