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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access