|
Free ebooks
 Free programing ebooks C/C++ Financial Applications using Excel Add-in Development in C/C++(2nd Edition)
|
 Chapter 2 Excel FunctionalityBasic things that you need to know about Excel, data types, terminology, recalculation logic and so on. Knowing these things is an important prerequisite to understanding subsequent chapters. Chapter 3 Using VBA Basic things about using VBA: creating commands and functions;accessing DLL functions via VB; VB data types; arrays and user-defined data structures, and how to pass them to DLLs and return them to Excel. Chapter 4 Creating a 32-bit Windows (Win32) DLL Using Visual C++ 6.0 How to create a simple Win32 DLL, in VC or VC++ .NET, and export the functions so they can be accessed by VB, for example. Lays the foundation for the creation of XLLs – DLLs whose functions can be accessed directly by Excel. Chapter 5 Turning DLLs into XLLs: The Add-in Manager Interface How to turn a DLL into an add-in that Excel can load using the add-in manager: an XLL. The functions that Excel needs to find in the DLL. How to make DLL functions accessible directly from the worksheet. Chapter 6 Passing Data between Excel and the DLL The data structures used by the Excel C API. Converting between these data structures and C/C++ data types. Getting data from and returning data to Excel. Chapter 7 Memory Management Stack limitations and how to avoid memory leaks and crashes. Communication between Excel and the DLL regarding responsibility for memory release. Chapter 8 Accessing Excel Functionality Using the C API The C interface equivalent of the XLM macro language and how to use it in a DLL. Information about some of the more useful functions and their parameters. Working with named ranges, menus, toolbars and C API dialogs. Trapping events within a DLL. Chapter 9 Miscellaneous Topics Timing function execution speed. A brief look at how to access Excel’s objects and their methods and properties using IDispatch and COM. Keeping track of cells. Multi-tasking,multi-threading and asynchronous calls into a DLL add-in. Setting up timed calls to commands. Add-in design. Performance optimisation. Chapter 10 Example Add-ins and Financial Applications Examples that show how the previous chapters can be applied to financial applications such as, for example, Monte Carlo simulation, a stochastic volatility model, and constant maturity swap (CMS) derivative pricing. Download ebook on c++:Financial Applications using Excel Add-in Development in C/C++(2nd Edition)
|
