Read Me First
!Options - The Black-Scholes Option Pricing Model Add-In for Excel
Unregistered Version 1.6
by Ray Steele Notice: This program is Shareware! You may evaluate if for a period of no more than 30 days. After this time you must either register (read REGISTERING below) or remove it from your system. Failure to comply with this condition is a violation of United States and international copyright law. This program is fully functional but you will sleep better if you register. Please register if you use !Options.
TABLE OF CONTENTS
1) 2) 3) 4) 5) 6) 7) What is !Options? What do I need to use !Options? Tell me more about what !Options does! How do I install !Options? What if I like !Options? How do I register !Options? What if I have question about !Options?
1) What is !Options? !Options is an Excel shareware add-in that adds functionality for Black-Scholes calls, puts (using put-call parity), call delta (hedge ratio), and determines the implied standard deviation of a call. They are available through function wizard (under All or Financial) with simple on-line help. 2) What do I need? You will need Microsoft Excel 5.0 (or higher) for Windows and a little finance knowledge. #NAME? 3) Tell me more about what !Options does! The unregistered shareware version adds four (4) functions and a help file to Excel. All of these functions are in full, uncrippled form. They are...
BS_CALL - Syntax: BS_CALL(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the theoretical price of a European call option BS_CSTD - Syntax: BS_CSTD(STOCK, EXERCISE, DAYS, RISKFREE, CALL_PRICE) Calculates the implied standard deviation of a European call option BS_CDELTA - Syntax: BS_CDELTA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the delta (hedge ratio) of European call option BS_PUT - Syntax: BS_PUT(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the theoretical price of a European put option
Function Wizard: Note: If you are unfamiliar with the function wizard, it is worth learning. It is NOT the fastest way to write formulas, but it is painless. Click on the button that looks like the one above, for a list of the functions. The Black-Scholes functions are available under "all" and "financial". Select the one you want and click on the help button for on line help. (Alternatively, you may select Insert - Function to do the same thing) When you register, you will receive !Options 2.0. It adds several functions to the aforementioned list. Additional functions in the registered version of !Options follow.
Page 1
Read Me First
BS_CGAMMA - Syntax: BS_CGAMMA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the gamma of a European call BS_CTHETA - Syntax: BS_CTHETA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the theta of a European call BS_CVEGA - Syntax: BS_CVEGA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the vega of a European call BS_CRHO - Syntax: BS_CRHO(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the rho of a European call BS_PSTD - Syntax: BS_PSTD(STOCK, EXERCISE, DAYS, RISKFREE, PUT_PRICE) Calculates the implied standard deviation of a European put BS_PDELTA - Syntax: BS_PDELTA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the delta (hedge ratio) of a European put BS_PGAMMA - Syntax: BS_PGAMMA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the gamma of a European put BS_PTHETA - Syntax: BS_PTHETA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the theta of a European put BS_PVEGA - Syntax: BS_PVEGA(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the vega of a European put BS_PRHO - Syntax: BS_PRHO(STOCK, EXERCISE, DAYS, RISKFREE, STDDEV) Calculates the rho of a European put
It also has context sensitive online help.
4) How do I install !Options? In the interest of simplicity I have not included an install program. You get three files in the shareware version. You are currently reading the following file which should be kept for registration. D:\Docstoc\Working\pdf\[26c55072-f018-4f80-9431-4f33212b4326.xls]Read Me First You should copy the !options.xla file to the following directory… #NAME? You should copy the !options.hlp file to the following directory… #NAME?
Installation Instructions
1. Copy the files above to the appropriate subdirectories. 2. Run Microsoft Excel 3. On the Tools menu, select Add-Ins. 4. Check the !Options by Ray Steele checkbox. 5. Click OK. 6) You may now use the functions like any others. 5) What if I like !Options? If you use the program for more than 30 days, see #6 REGISTERING. You will receive additional functions and context sensitive help. 6. How do I register !Options?
Page 2
Read Me First
Fill out the form on the "Registration Form" sheet and return it with your payment. You may choose to receive the registered version electronically or through snail mail. There is no additional charge for electronic transfer. Pricing: $25 US = single registration (for delivery via e-mail or FTP) $30 US = single registration (snail mail delivery within US) $35 US = single registration (snail mail delivery outside of US) Multi-user discount available upon request. Make checks or money orders payable to: Ray Steele 100 Park West Drive #2G-10 Lansing, MI 48917 7) What if I have question about !Options? For problems, questions, or suggestions please try one of the following 1) Go to the !Options homepage for FAQs, http://pilot.msu.edu/user/steelera/faqs.html 2) send e-mail to the following address steelera@pilot.msu.edu 3) send snail mail to: Ray Steele 100 Park West Drive #2G-10 Lansing, MI 48917
Page 3
Registration Form
Register !Options
Name: ______________________________________________________________________
Company:
______________________________________________________________________
Address line 1:
______________________________________________________________________
Address line 2:
______________________________________________________________________
e-mail:
______________________________________________________________________
Attachment Encoding: (circle one)
UUENCODE
BINHEX
MIME
NONE
FTP address:
______________________________________________________________________
Pricing: $25 US = single registration (for delivery via e-mail or FTP) $30 US = single registration (snail mail delivery within US) $35 US = single registration (snail mail delivery outside of US) Multi-user discount available upon request.
Amount enclosed: ______________________________________________________________________
Disk format:
3.5"
5.25"
Signature: ______________________________________________________________________
Send your check or money order with completed form to: Ray Steele 100 Park West Drive #2G-10 Lansing, MI 48917