Financial Applications using Excel Add-in Development in...
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £19.25
Trade in Financial Applications Using Excel Add-in Development in C/C++, 2nd Edition for an Amazon.co.uk gift card of up to £19.25, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
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.
From the Inside Flap
"If you′re looking to take advantage of the performance benefit from calling C/C++ code from Excel then this book should be the first and last one that you buy. For the second edition Steve has catalogued the changes needed to work with Excel 2007 and given new examples covering the SABR stochastic volatility model and CMS derivative pricing." – Dr. Mike Staunton, London Business School, Wilmott columnist
"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 Clew low, Principal, Lucama 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
Inside This Book
(Learn More)
Front Cover | Copyright | Table of Contents | Excerpt | Index
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
0 of 18 people found the following review helpful
Format:Hardcover
Excel developers can be divided into five general categories, based on their experience and knowledge of Excel and VBA.
1.The basic Excel user.
They start off using Excel worksheets as a handy place to store lists or perform simple repetitive calculations.
2.The Excel power user
They has a wide understanding of Excel's functionality.
3.The VBA developer
They makes extensive use of VBA code in his workbooks.
4.The Excel developer
They used to developing Applications using Excel VBA.
5.The professional Excel developer
They designs and develops robust, fast, easy to use, flexable, reusable, maintainable and secure Excel Applications, this is that book.
1.The basic Excel user.
They start off using Excel worksheets as a handy place to store lists or perform simple repetitive calculations.
2.The Excel power user
They has a wide understanding of Excel's functionality.
3.The VBA developer
They makes extensive use of VBA code in his workbooks.
4.The Excel developer
They used to developing Applications using Excel VBA.
5.The professional Excel developer
They designs and develops robust, fast, easy to use, flexable, reusable, maintainable and secure Excel Applications, this is that book.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
6 reviews
8 of 8 people found the following review helpful
Lots of content, but badly organized
13 Feb 2011
Format:Hardcover|Amazon Verified Purchase
It's a 500 page book plus thousands of lines of source code, so your answers are in there ... somewhere. But the whole product is painfully disorganized.
The source code does not provide an adequate solution to producing Excel add-ins, it is just too brittle, hard to modify/maintain, and confusing. There are 141 functions that read "if Excel 2007 do this, if Excel 2003 or before, do that..." which would all have to be re-written every time a new version of Excel comes out. Instead of working around the Microsoft SDK files, he changed them directly, so again you'd have to adjust them to a new version of Excel. One of the big problems with the code was the author's choice to make his "cpp_xloper" class the center of the project, which contains a huge amount of code for moving data around through Excel's xloper/xloper12 data structures, including overriding the += operator so it adds numbers and concatenates strings. This was a big mistake in my opinion because it's ALL unnecessary. You only need ONE function that needs to know anything about xlopers -- the one that converts the data to be sent to/received from the Excel C API. That should be the only function that even cares if you're in Excel 2007 or before. All of the rest of the code should be done in normal C/C++ data structures. That right there saves you about 90% of the work!!
A large portion of the book is devoted to explaining this approach and documenting the source code, so to the extent the source code is bad, so is the book.
To be fair, after two weeks of going through a couple thousand lines of spaghetti code, I was able to write a nice C++ wrapper that does everything I want. The information is in there ... somewhere.
The source code does not provide an adequate solution to producing Excel add-ins, it is just too brittle, hard to modify/maintain, and confusing. There are 141 functions that read "if Excel 2007 do this, if Excel 2003 or before, do that..." which would all have to be re-written every time a new version of Excel comes out. Instead of working around the Microsoft SDK files, he changed them directly, so again you'd have to adjust them to a new version of Excel. One of the big problems with the code was the author's choice to make his "cpp_xloper" class the center of the project, which contains a huge amount of code for moving data around through Excel's xloper/xloper12 data structures, including overriding the += operator so it adds numbers and concatenates strings. This was a big mistake in my opinion because it's ALL unnecessary. You only need ONE function that needs to know anything about xlopers -- the one that converts the data to be sent to/received from the Excel C API. That should be the only function that even cares if you're in Excel 2007 or before. All of the rest of the code should be done in normal C/C++ data structures. That right there saves you about 90% of the work!!
A large portion of the book is devoted to explaining this approach and documenting the source code, so to the extent the source code is bad, so is the book.
To be fair, after two weeks of going through a couple thousand lines of spaghetti code, I was able to write a nice C++ wrapper that does everything I want. The information is in there ... somewhere.
3 of 3 people found the following review helpful
Exactly what the title says it is
21 Jun 2009
Format:Hardcover|Amazon Verified Purchase
This book might qualify for the "Most Specific Title" award, but the book is exactly what it claims to be. A guide to developing financial applications using excel add-ins written in C/C++.
This book's target audience is someone familiar both with C/C++ as well as Excel -- not a beginner in either. Additionally, this book is not intended to be a reference for either the language or the application, but is instead a course in developing add-ins for Excel using C++. If this is what you're looking to do, this is the book you need.
This book's target audience is someone familiar both with C/C++ as well as Excel -- not a beginner in either. Additionally, this book is not intended to be a reference for either the language or the application, but is instead a course in developing add-ins for Excel using C++. If this is what you're looking to do, this is the book you need.
1 of 1 people found the following review helpful
Only choice
14 Mar 2009
Format:Hardcover
The book does not have any competition, does it? I am grateful to the author, but think that one could do a better job presenting the material.
If you have not heard of XLW, do try it out first.
If you have not heard of XLW, do try it out first.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Business, Finance & Law > Accounting > Financial
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Personal Finance & Online Banking
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
