Tuesday, January 18, 2011

Processing the Deluge of Data Using Google Docs

Image captured 01-18-2011 - 3200+ stocks on NASDAQ - Apple highlighted

The thesis of this web site is that if the world is to prevail over the deluge of data then entirely new methods of displaying that data must be established.

Some of these methods may require huge data centers and exotic transmission methods. If, however, such methods are to be widely implemented and provide insight to large numbers of people, then at least at some level, the methods must be made accessible and understandable using readily available and inexpensive tools.

I am extremely happy to report that you can create highly insightful charts using Google Docs Spreadsheets that process many thousands of data points in near real-time.

Just as exciting is that the spreadsheets are not demos but display actual usable data. The data is is not delayed, the data arrives in a matter of seconds or so after the actual transaction.

The link below allows you to access three spreadsheets that in total provide you with the current movements of the 6,600+ stock on the three major US exchanges. You can just view a chart but you are really encouraged open up the spreadsheets and use these to create your own charts.

Link to source code: Jaanga GDocs on GitHub