Uploaded by Siamak.
Generating Sparklines from real time financial information with Resolver one and Google finance API
Sparklines are the greatest inventions of Professor Edward Tufte (statistician and Professor Emeritus of statistics at Yale University), a Sparkline is a proper tool to visualize financial information in a very small space. Sparklines are tiny informative graphs that can be inserted in financial reports.
Sparkline tools are available for MS-Excel. Our code generates sparklines from financial information in Resolver One; these sparklines can then be inserted in-line with texts in financial reports.
In our code, we read Google closing price from an API provided by Google finance, this API provides us with a CSV stream that we can load into Resolver One. We can additionally change the date range for the data stream from within Resolver One.
The code should work right out of the box and there is no need to download any additional package, it calls GDI+ functions and it should be very easy to modify and customize
This model has been created for Resolver One, an advanced spreadsheet.
You can download Resolver One here.