Home Page

BondCalc Windows Screens

All calculations and report formatting will be in APL, and will reside in an ActiveX server that VBA will call. All data, defaults and parameters will be stored in Access (see file discussion). Graphs will generated by Excel and written to GraphSheets in a new WorkBook and displayed in UserForms.

I will update this section as new forms are developed. This will become the marketing documentation of the system. All relevant buttons will eventually become links (especially the Menu Buttons and Helps), hovering over ComboBoxes will display the choices, and clicking on report menu entries will pop up sample reports.


Everything is reached from this toolbar. This toolbar remains visible irrespective of the activated workbook, and is fully function at all times. Click on a toolbar button below to see those screens.

toolbar Go to Settlement Date Go to Securities Go to Portfolios Go to Compare Portfolios Go to Databases Go to Parameters Go to Utilities Go to Help

The button for the viewer will appear and disappear, based on whether there is something to be viewed.

toolbar2 Go to Settlement Date Go to Securities Go to Portfolios Go to Compare Portfolios Go to Databases Go to Parameters Go to Utilities Go to Viewer Go to Help

After everything else is done, I will convert over the Swaps section.

toolbar3 Go to Settlement Date Go to Securities Go to Portfolios Go to Compare Portfolios Go to Databases Go to Parameters Go to Utilities Go to Viewer Go to Help

I wanted to have no visible sheet, but Excel requires there be one sheet visible. Now that I have one, I've embraced it. As you can see, I've got it quite minimal. Not even a cursor. Just a minimal splash screen. It will be used for returning the processing errors. A lot better than at the end of the report. When in displaying errors mode, three buttons will appear: (1) to put contents into the Clipboard, (2) put into Notepad, (3) and to clear. Clearing also clears the buttons and redisplays these messages.

home-screen Go to Settlement Date Go to Securities Go to Portfolios Go to Compare Portfolios Go to Databases Go to Parameters Go to Utilities Go to Help