2 sheets tagged with "button":

The workbook is a simple sheet that allows a user to enter the parameters of a share trade. They can then click on a button, and the details are written to a database.

The code is structured in three layers: a general database access layer, a "business" layer that knows how to translate from concepts that make sense in the application domain (such as stock symbols and prices) into database commands, and then a UI layer that interfaces between the spreadsheet and the business layer.

The database access layer is a simple bit of generic IronPython in the pre-constants user code. It uses the .NET API to execute a non-query SQL statement against a database, the latter being specified by an ODBC connection string.

See the documentation page (the More Information link) for the kind of database this spreadsheet expects to work with.

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.