4 sheets tagged with "csv":

Importing CSV Files Using the Cell Formula Property

Resolver One doesn't currently support importing from CSV files out of the box. Resolver One version 1.4 allows you to set data in the grid using the Formula property on cells. This spreadsheet is a tool to import CSV files into Resolver One.

Click the button on the 'Import' spreadsheet and select the CSV file to import. After importing, the contents of the file will be in the 'Data' worksheet and you can delete the user code and save the spreadsheet with a new name.

As well as being a useful tool this spreadsheet provides examples of using the cell Formula property plus using the OpenFileDialog and MessageBox (Windows Forms) dialogs from user code.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.

13 March 2009. Tagged with csv, Formula, resolverhacks, UI

Yahoo financial data feed

Use Resolver One to download current data from the Yahoo Financial data feeds and parse it with a reader. The values are stored using the .Formula property so that data can be looked at offline.

17 March 2009. Tagged with button, csv, DataFeed, finance, Formula, headers, ModelSideScripting, sample, yahoo

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

Timetric Time Series and Resolver One

Timetric is a website and web service for storing, searching, graphing and publishing the world's statistical data. It stores data as time series and lets you view graphs of the data plus manipulate and combine them in lots of interesting ways.

As well as making a huge amount of public data available you can also push your own data sets to Timetric and use their services to analyse them.

This example demonstrates the potential of using Resolver One as a client to interact with Timetric's services. You can fetch and view a chart of individual datasets and search their large bank of statistics.

As well as accessing Timetric this sample shows:

* Using the Python Oauth library from IronPython
* Working with the Timetric API
* Fetching and parsing CSV files
* Accessing an opensearch API
* Parsing XML (the Atom format responses to search queries)
* Drawing charts with ZedGraph
* Creating and selecting worksheets from button handlers
* Using MessageBox dialogs from user code

The download includes documentation on how to use it and how it works.

13 May 2009. Tagged with chart, csv, oauth, timetric, xml

<< Resolver Exchange