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.
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.
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