Excel Add in Development in C C++ Applications in Finance

Product Description

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 VB. C/C++. Excel Add-in Development in C/C++ - Applications for Finance is a 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. Author Steve Dalton explains how to apply Excel add-ins to financial applications with many examples given throughout the book. It covers the relative strengths and weaknesses of developing add-ins for Excel in VB versus C/C++.

"This book is for anyone who wants to do any application development in Excel. Even for an old hand at Excel development such as myself, a brief skim through reveals valuable nuggets of information. Delving deeper into the text, richer veins are easily found. This book is destined to become an essential reference on Excel development."
Dr. Les Clewlow, Principal, Lacima Group Ltd.

"Programming Excel add-ins using the C API can be complex and difficult. Steve has done a masterful job of demystifying the process. After reading this book you'll be creating XLLs for all purposes with complete confidence. Highly recommended."
Rob Bovey, MCSE, MCSD, Excel MVP, President, Application Professionals
Product Details

* Amazon Sales Rank: #832520 in Books
* Published on: 2004-12-15
* Original language: English
* Number of items: 1
* Binding: Hardcover
* 422 pages

Editorial Reviews

Review
"Programming Excel add-ins using the C API can be complex and difficult. Steve has done a masterful job of demystifying the process. After reading this book you'll be creating XLLs for all purposes with complete confidence. Highly recommended."--Rob Bovey, MCSE, MCSD, Excel MVP, President, Application Professionals

"This book is for anyone who wants to do any application development in Excel. Even for an old hand at Excel development such as myself, a brief skim through reveals valuable nuggets of information. Delving deeper into the text, richer veins are easily found. This book is destined to become an essential reference on Excel development."--Dr. Les Clewlow, Principal, Lacima Group Ltd.

From the Back Cover
Excel Add-in Development in C/C++: Applications in Finance 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 VB. 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 VB versus C/C++, and provides comprehensive code, workbooks and example projects on the accompanying CD-ROM. Excel Add-in Development in C/C++ features:

* Extensive example codes in VB, 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 VB versus C/C++.
* A CD-ROM with several thousand lines of example code, numerous workbooks, and a number of complete example projects.

About the Author
STEVE DALTON is currently head of Exotic Options at Collins Stewart Tullett plc in London. Steve has almost 20 years of experience working in the fields of interest rate derivatives and IT. With a background in mathematics and computing, 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.
Customer Reviews

Not received the product1
I have not even received the product yet. How am I to write a review!

ONLY book detailed on the Excel C API5
This is the ONLY book that is written exclusively for the Excel C API. It is well written but the reader needs to have basic C knowledge first. Development of XLLs in C++ is a topic not well documented in litertaure except for the MSDN website which has an archived section on the Excel 97 SDK. In any case, the CD code that comes with the book helps a lot. For a quick start to build your own programs you may use some interface classes and headers from the CD.

Several quants purchase a separate software XLL+ for developing the Excel XLLs, but even the software is a series of headers and cpp files made easy. And when it comes to more complicated development like dialog or menus, the book is a useful reference.

learn to use the C/C++ API for Excel4
In this book you get detailed examples of how to access and extend the functionality within Excel. It is clearly a hands on programmer's book. The languages in which you can do this are C and C++.

Microsoft has provided a rich API in these languages, with which you can get at many objects within the spreadsheet. Like a reference to the currently active cell. Or a list of all open Excel documents. Or finding the formula of a cell, returned as text. Or trapping various events, like a recalculation or a window selection or a keyboard action.

As the book's title suggests, many of the examples are taken from finance. Apropos, given that this is a spreadsheet we're looking at. But the methods given can be applied in any context that you need Excel for.