Home Page

BondCalc Windows Screens

All calculations and report formatting will be in APL+Win, and will reside in an ActiveX server that Excel VBA will call. All data, defaults and parameters will be stored in Access (see file discussion).

At the current time, APL+Win is only available in 32-bit, which requires a 32-bit Excel to work with. A 64-bit version of APL is under development. Hopefully it will be available before BondCalc's target completion of June 2021. BondCalc development to be done: write in VBA all of the data edits and initial variable prep, implement iGrid for grid-type input, write imports, get APL to read from Access for auxiliary data, get APL to calculate securities and return reports, improve organization of parameters and overrides on forms, and finally, produce graphs, which will be generated by Excel and written to GraphSheets in a new WorkBook, and then displayed in UserForms.

See list of changes from the DOS version.

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 (including all sub-screens 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 Utilities Go to Parameters 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 Utilities Go to Parameters 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 Utilities Go to Parameters Go to Viewer Go to Help

I wanted to have no visible sheet, but Excel requires there be one 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. Pressing the Clear button also clears the buttons and redisplays the splash screen messages.

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