Excel Files & Links


Excel Files From Ray M. Steele

!Options - The Option Pricing Add-in for Excel (shareware)

This add-in is my best work (for pulic use) so far. It add Black-Scholes (with Merton dividend adjustment) option pricing to Excel 5.0 and up. Price functions for both calls and puts, all their "greeks", as well as functions to compute the implied volatility of the options. It even has a help file for a more user friendly attitude. You can get more information and download a non-full featured version from the !Options Home page.

Selection Recalculation

This add-in allows you to recalulate only a pre-selected portion of your spreadsheet. Highlight the area, click on the right mouse button and select Selection Recalc. Great time saver for those times when you have a spreadsheet so large that you set the calculation to manual, yet want to recalulate a portion of the spreadsheet.

Calendar Workbook

This workbook has two calendars. Input the year for the annual or month and year for the monthly and print. Alway have a calendar close at hand

Simultaneous Equation Template

This workbook uses array function and matrix math to solve up to 10 linear simultaneous equations. Also included is a smaller sheet that solves only 4 equations, but without he clutter.


Excel Links - file downloads, information, and erratica


Go to Ray Steele's Home Page