2 sheets tagged with "stock price":

In-cell visualization and graphing using simple ASCII graphs

In-cell visualization and graphing using simple ASCII graphs

Resolver One doesn't support showing images in cells and you need to open new image worksheets in order to see them

but it is sometimes crucial to see data and graph side by side

this is my solution to this problem for stock prices

this code gets live data from Google finance API then visualizes the data using ASCII codes in it's "Graph" column

it is very handy for me and wanted to share it with others

03 April 2009. Tagged with api, competition, csv files, google finance, graphs, stock price, visualization

Generating Sparklines from real time financial information with Resolver one and Google finance API

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

07 April 2009. Tagged with api, competition, csv, excel, financial information, google finance, sparklines, stock price, visualization

<< Resolver Exchange