随书光盘下载。包含各章的Excel文件。
Content
Each chapter of the book includes its own set of Excel files, which are contained in sub-directories named according to the chapter in which the file is described. These are arranged in the sub-directories Chapter 1 through Chapter 13. The Excel file for the Appendix is in the sub-directory Appendix, and the Excel files that contain option prices on IBM Inc. and Intel Corporation are in the sub-directory name Yahoo.
All of the option pricing and volatility models covered in this book are implemented using VBA. The contents of each Excel file appear as a figure in the book, so this is exactly what users will see when they open the files. Users can use the Excel files as template, and substitute their own data into the spreadsheet to generate their own option prices and volatility calculations.
The VBA functions can be accessed from the VBA Editor in Excel. The VBA functions are not password protected, so it is possible for them to be modified by the user. Please note, however, that doing so may introduce errors and produce results that are inaccurate. It is recommended that users familiarize themselves with VBA before attempting to change any of the VBA functions contained on the CD-ROM.
While using the files requires no programming experience or knowledge of VBA, some knowledge of Excel is recommended. The Appendix provides a brief introduction to VBA, for those readers with no prior programming experience.
Most of the graphs in the book are produced using the VBA functions contained on the CD-ROM. These graphs are contained in the Excel files also. Please note that the graphs are linked to the data contained in the files, so changing data values will alter the appearance of the graphs.