5 sheets tagged with "visualization":

This spreadsheet was the winner of the second round of the Resolver One Spreadsheet Challenge, in February 2009.

I wanted to develop a program to enable everyone to carry out complex statistical analysis and stochastic modeling in Resolver One by harnessing the power of R.

In order to run complicated statistical analysis/modeling I use R (an open source clone of the powerful commercial language S-Plus). R is the most successful statistical library currently existing on the market. R has different powerful libraries for data mining, genetics, portfolio optimization, asset allocation, etc.

Although R is the strongest tool for statistical analysis, unlike SPSS it lacks an easy to use yet a powerful spreadsheet. On the other hand building a bridge between R and Resolver one is extremely difficult and involved a number of trial and errors and using Interop objects. By using the provided framework one can enjoy the power of all of the R libraries with the comfort and the power of Resolver One. The accompanying examples will help the reader to use similar strategies to solve complicated statistical problems and to develop exciting results and 2D/3D graphs using OpenGL capabilities and drawing. Users are able to develop fly-through 3D visualizations from Resolver One by using RGL library in R (see screenshot). I have made an effort to provide a complete framework with directions for how to write a program in this framework and how to do error handling between R and Resolver One. All the complex libraries are provided in binary format and users only need to call them from within their Resolver One. It will then enable them to use all the functionality of R inside their Resolver One spreadsheets and send them information successfully back and forth between these two programs.

The same component can be used to call SciLab functions (a clone of MATLAB, a scientific computing environment), using the same procedure provided in the article, users are able to use SciLab similar to the way they use R inside Resolver One.

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

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

Resolver One is a "mash-up" of a spreadsheet and an IDE -Wikipedia

Resolver One is supposed to be more powerful than a spreadsheet and more flexible than an IDE. In this entry we demonstrate how a sophisticated trading software can be developed in Resolver One quickly.

It can generate candlesticks, finance bars, and line plot. It simulates the value at risk with two methods. And can be connected to R for portfolio optimization

Please consult the ReadMe.pdf

Resolver One version 1.6 comes with ZedGraph installed by default. This, together with the expanded cells and image rendering in the grid allows you to create and display graphics using only formulae. Such images will automatically update in response to changes in the grid.

This spreadsheet is a simple example of this. It defines a single user code function which draws a histogram using ZedGraph and returns an image of it. This function is called on CellRanges in a formula - and an expanded cell is then used to display the entire image.

This is one of the sample spreadsheets that come with Resolver One.