What else can I do with COM?
On changing the values of N, we can see that the values from our custom-defined functions changes on the fly. This makes it possible for dynamic computations of securities, or even real-time numerical pricing, when connected to a market data feed, where values such as S0 or K are changing every second.
The COM server components are separated from each other. Using Python, we can change the implementation of the COM server using the Python modules, such as NumPy or SciPy, to achieve certain aspects of numerical pricing without relying too much on Excel's built-in functions. This also means that we can interchange and interface components that are not related to Excel. The COM model simply provides a transparent bridge between these components and Excel.
