Google spreadsheet comes with functions that allow to populate spreadsheet columns with historical stock information. This information can then be plotted easily using motion chart gadget available within the spreadsheet.
The spreadsheet is shown below
Click on Bubble Chart option to see the Bubble motion chart.
OR
See the chart below
The web address of the Spreadsheet is here
You can make a copy of this spreadsheet to see how it was created.
The two main commands to create this spreadsheet are
=GoogleFinance("GOOG";"all"; "1/1/2008","4/24/2010";7) to get the historical stock data
and copying all the information from different sheets to the main sheet is done by using this command
=ImportRange("tNYLkOzp1dX9Lf35_1Ye9fw","Google!A2:G121")
The first input is the spreadsheet key that is located after the question mark in the web address of spreadsheet shown within the address bar of the web browser.
The moving bar chart is shown below
The screencast for the moving bubble chart is
Another screencast showing the moving bubble chart with trails
Firefox 3.5 could not handle the last plot. The motion became jerky and slow. The plot is done using Google Chrome
Some helpful information is available in this article:
"Visualising Financial Data In a Google Spreadsheet Motion Chart OUseful.Info, the blog" http://bit.ly/9A4Z87
No comments:
Post a Comment