Financial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel developer.Excel is the industry standard for financial modelling, providing a number of ways for users to extend the functionality of their own add-ins, including VBA and C/C++. This is the only complete how-to guide and reference book for the creation of high performance add-ins for Excel in C and C++ for users in the finance industry. Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It also covers the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD-ROM. The impact of Excel 2007's multi-threaded workbook calculations and large grids on add-in development are fully explored. Financial Applications using Excel Add-in Development in C/C++ features:
* Extensive example codes in VBA, C and C++, explaining all the ways in which a developer can achieve their objectives.
* Example projects that demonstrate, from start to finish, the potential of Excel when powerful add-ins can be easily developed.
* Develops the readers understanding of the relative strengths and weaknesses of developing add-ins for Excel in VBA versus C/C++.
* A CD-ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.
"Financial Applications using Excel Add-in Development in C/C++ is the definitive how-to guide adn reference for developers looking to create high-performance applications in Excel using C and C++. The book provides a practical, detailed, and lucid treatment of the Excel C API and XLL add-in development, with a particular emphasis on developing worksheet functions. Author Steve Dalton does a masterful job of sharing his many years of expertise, tackling the subject with detailed information, abundant best practice, and numerous practical examples. I would highly recommend this book to any serious Excel developer." - David Gainer, Group Program Manager, Microsoft Excel
Produkt-Info
Reihe
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Höhe: 24.4 cm
Breite: 16.8 cm
Dicke: 3.8 cm
Gewicht
ISBN-13
978-0-470-02797-4 (9780470027974)
Schweitzer Klassifikation
STEVE DALTON is currently head of interest rate options at GFI in London. Steve has a degree in mathematics from Queen Mary College, University of London, and over 20 years experience in interest rate derivatives and IT. He pioneered the use of real-time spreadsheets in the mid 1980s for arbitrage and derivatives pricing. He founded Eigensys Ltd in the late 1980s, which specialises in software and consultancy in this field and in the use of Excel for demanding real-time applications.
Autor*in
Eignesys Ltd., London, UK
Preface to Second Edition.
Preface to First Edition.
Acknowledgements for the First Edition.
Acknowledgements for the Second Edition.
1 Introduction.
2 Excel Functionality.
3 UsingVBA.
4 Creating a 32-bit Windows (Win32) DLL Using Visual C++ 6.0 or Visual Studio.NET.
5 Turning DLLs into XLLs: The Add-in Manager Interface.
6 Passing Data Between Excel and the DLL.
7 Memory Management.
8 Accessing Excel Functionality using the C API.
9 Miscellaneous Topics.
10 Example Add-ins and Financial Applications.
Appendix 1. Contents of the CD ROM.
Related Reading.
Web Links and Other Resources.
Index.
