Interoperability: Software Tools and Applications in Finance with Excel, C# and C++ (The Wiley Finance Series) - Hardcover

Expand Excel functionality with a multi-language environment that works Interoperability Software Tools and Applications in Finance with Excel, C#, and C++ shows you how to create applications in a multi-language environment where interfacing with Excel plays a vital role. VBA is an important tool for Excel, and is incorporated here but it doesn't scale well for more complex applications, so a practical integration of C++ and C# is essential for creating increasingly sophisticated finance tools. This book walks you through the fundamentals, software, and applications, providing real-world examples with source code you can extend and apply in your own projects. You'll learn how to create automation and add-ins, integrate .NET, incorporate popular libraries, utilize replacement worksheet functions in C#, and much more as you expand Excel's capabilities and discover the superior functionality multi-language interoperability enables. Excel is indispensable in many financial applications, but difficulties arise when integrating quant code and formulating complex algorithms where C++ or C# is essential. This book shows you how to make these languages interact efficiently, accurately, and productively to create more effective solutions for todays finance world. * Create automation and COM add-ins with C# and C++ * Call VBA add-ins and handle multi-threaded components with Excel * Implement interpolators, pricers, and simulators in Excel * Integrate C++ STL, Boost, and other libraries Haphazard multi-language interfacing slows down results, causes numerous errors, and can require complete reworking when changes are made. Today's applications need to move at a steady pace, and developer time cannot be wasted on tedious integration and revision. Interoperability Software Tools and Applications in Finance with Excel, C#, and C++ provides a sound, concrete solution, making it a must-have resource for developers and quantitative finance specialists.

* This book addresses the problem of writing applications in a multi-language environment in which interfacing with Excel plays a vital role* The goal is to show how to write code in C#, C++ and VBA that is easy to use in combination with Excel* The book includes source code for all examples.