In this section, we are concerned with building the server component of the COM interface. We will first take a look at the prerequisites for building the server components using Python. Then, we will proceed to build an option pricing the COM server using some of the topics we covered in Chapter 4, Numerical Procedures.
The COM interface is an industry standard by Microsoft; therefore, the following software is required to complete this tutorial:
Microsoft Windows XP operating system or later
Microsoft Excel 2003 or later
Python 2.7 or later with SciPy and NumPy packages
The
pythoncommodule
The
pythoncom module contains Python extensions for Microsoft Windows. The files are available freely as pywin32 on SourceForge at http://sourceforge.net/projects/pywin32/files/. To download the executable file, navigate to the pywin32 folder, and select the latest available build. Download the installer executable that is compatible with your...