You may find the following workbooks useful.

Many of these workbooks contain VBA. See the notes at the foot of this list setting out how to change the security settings of your excel to enable the VBA to work.

You may need to enable the Analysis Toolpack (Tools -> Add-Ins).

We are developing excel based trade evaluation systems. Some of the workbooks listed here use simple VBA. If you have problems running the sheets try lowering the Macro security level in Excel. You can do this by going to Tools, Options, Security, Macro Security, and set the level to low. The workbooks are freely available for you to download and use. We hope that you find them both interesting and useful. We believe they are accurate but please remember that you use them at your own risk. Most of the sheets simply take manual input but some require a DDE link from a data provider to function as intended. Where commission is shown the rates are those of Fyshe Horton Finney Ltd.