Excel Add-in Development in C/C++: Applications in Finance

最新推荐文章于 2019-06-29 17:13:01 发布
原创 最新推荐文章于 2019-06-29 17:13:01 发布 · 1.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#excel #reference #application #performance #vb #出版

本书介绍如何使用C/C++为Excel开发高性能插件，适用于金融行业。书中提供了多种实例，对比了VB与C/C++开发插件的优缺点。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.youkuaiyun.com/topmvp - topmvp
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
http://rapidshare.com/files/19775826/N0470024690.rar
Financial Applications Using Excel Add-in Development in C/C++
06-09
This book is intended to provide the reader with a guide to the issues involved with creating powerful and reliable add-ins for Excel. With years of use, many people build up the experience and understanding needed to create custom functions for Excel in C and C++. However, given the very limited books and resources available, this can be a largely trial-and-error process. The motivation in writing this book is to create something I wish I had had through the years: a coherent explanation of the relevant technology, what steps to follow, what pitfalls to avoid, and a good reference guide. With these things at your side, writing C/C++ DLL and XLL resources can be almost as easy as writing them in Visual Basic, but yields the enormous performance benefit of compiled C/C++ and the Excel C API. In setting goals for this book, I was particularly inspired by two excellent books that I have grown to admire more and more over the years, as they have repeatedly proven their worth; The C Programming Language (Kernighan and Ritchie) and Numerical Recipes in C (Press, Teukolsky, Vetterling and Flannery), albeit that the style of C-coding of the latter can be somewhat dense. If this book achieves a fraction of the usefulness of either of these then you will, I hope, be happy to own it and I will be happy to have written it. This book is intended for anyone with at least solid C and/or C++ foundation skills, a good working knowledge of Excel, a little experience with VBA (though not necessary) and the need to make Excel do things it doesn’t really want to do, or do them faster, more cleanly, more flexibly. A reasonable grasp of basic software development concepts and techniques is assumed. (Section 1.1 Typographical and code conventions used in this book, on page 1, provides more detail of the coding style of the examples given.) The example add-in project included on the CD ROM is intended to demonstrate some of the most important or difficult concepts described in the book, as well as the possibilities that are opened up when you can really play with Excel. These reflect my professional background in the financial markets, although if you are not of that world, you should still find that the techniques described are very widely applicable. There is an enormous amount of material that could have been included in a book on this subject that has either been pared down to the briefest of coverage or omitted completely. I fully accept that there will be those who, perhaps rightly, feel that certain things should have been covered in a book that boasts such a title, and I can only apologise. Any future editions will, I hope, provide an opportunity to rectify the most heinous and unpopular of these shortcomings.
Financial Applications Using Excel Add-in development in C/C++
10-22
wiley finance: Financial Applications Using Excel Add-in development in C/C++ 的电子版
Financial Applications using Excel Add-in Development in C/C++
TopMVP
11-25 875
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.youkuaiyun.com/topmvp - topmvpFinancial Applications using Excel Add-in Development in C/C++ is a must-buy book for any serious Excel devel
Excel Addin 插件开发指南
03-29
Excel Addin 开发指南 Excel.Add.in.Development.in.C.and.C.Plus.Plus.pdf
使用C/C++开发Excel插件：金融应用实战
"本书《Excel Add-in Development in C/C++ Applications in Finance》是 Wiley Finance Series 系列中的一本，作者 Steve Dalton。该书详细介绍了如何在金融领域使用 C/C++ 开发 Excel 插件，旨在帮助读者掌握利用...
C/C++开发Excel插件实战：金融应用
"Excel Add-in Development in C/C++ - Applications in Finance" 是一本由 Steve Dalton 撰写的书籍，旨在为读者提供创建强大且可靠的Excel插件的指南。本书聚焦于使用C和C++开发Excel自定义函数时可能遇到的问题，...
MATLAB's Optimization Applications in Finance: A Detailed Case Study on Portfolio Optimization
# 1. An Overview of MATLAB's Application in Financial Optimization MATLAB, as a powerful numerical computing and scientific ... In the field of financial optimization, the scope of MATLAB's applications
Office add-in 开发之 Excel 2003的Add-in开发
weixin_34341229的博客
06-29 670
Excel add-in是继承Extensibility.IDTExtensibility2接口，基于Excel Object Model的实现对Excel对象的操作，MSDN上有详细的讲解....这里只是说一下如何进入迅速进入编程状态，然后在该状态下，思考Excel add-in开发的一些可扩展，或者更好的一些应用，我做了一个PPT，放在这里，大家可以看看。 VSTO 2005有两个模板，...
Excel Add-in Development
01-17
Email (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on www.wileyeurope.com or www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency Ltd, 90 Tottenham Court Road, London W1T 4LP, UK, without the permission in writing of the Publisher. Requests to the Publisher should be addressed to the Permissions Department, John Wiley & Sons Ltd, The Atrium, Southern Gate, Chichester, West Sussex PO19 8SQ, England, or emailed to permreq@wiley.co.uk, or faxed to (+44) 1243 770620. Designations used by companies to distinguish their products are often claimed as trademarks. All brand names and product names used in this book are trade names, service marks, trademarks or registered trademarks of their respective owners. The Publisher is not associated with any product or vendor mentioned in this book. This publication is designed to provide accurate and authoritative information in regard to the subject matter covered. It is sold on the understanding that the Publisher is not engaged in rendering professional services. If professional advice or other expert assistance is required, the services of a competent professional should be sought
使用c++开发excel插件(第1章 准备知识)
cjsycyl的专栏
11-26 3601
http://blog.youkuaiyun.com/wxy6285/article/details/3255424 我们目前最常见的几个excel的版本是Excel 97/2000/2002/2003/2007，本书提到的所有例子都是在Excel2003环境中的。它们虽然版本不同但是大多数接口并没什么区别。而且我们使用的是excel的开发包，所以只要开发包不变。当然我们这里所有的版本都是指在32-
EXCEL ADDIN 学习（一）
mozhenqi的博客
08-18 7880
EXCEL ADDIN 学习一、加载项简介Office提供了多种用于扩展Office应用程序功能的模式，常见的 1、Office 自动化程序(Automation Executables) 2、Office加载项(COM or Excel Add-In) 3、Office文档代码或模板(Code Behind an Office Document or Template) 4、Office 智能标签
实战Excel Add-in的三种玩法
weixin_34159110的博客
11-27 712
作者：陈希章 发表于 2017年11月26日前言这个系列文章应该有一阵子没有更新了，原因是一如既往的多，但是根本所在是我对于某些章节其实还没有完全想好怎么写，尤其是对于Office Add-in这块 —— 到底是要每个都去单独写一遍，还是有其他什么好的写法会对读者更有帮助？正如我在 这篇文章 分享的一些关于写作的个人经验那样，我为此颇费了一些心思琢磨，直到最近才做出了一个选择：我将不拘泥于每个应用...
C++电子书
iteye_9857的博客
04-03 412
C++ [url=http://www.xxstudy.com/content/sams-teach-yourself-c-one-hour-day-6th-edition]Sams Teach Yourself C++ in One Hour a Day 6th Edition [/url] [url=http://www.xxstudy.com/content/computing-nu...
浅谈Excel开发：四 Excel 自定义函数
weixin_30394333的博客
08-19 1846
我们知道，Excel中有很多内置的函数，比如求和，求平均，字符串操作函数，金融函数等等。在有些时候，结合业务要求，这些函数可能不能满足我们的需求，比如我想要一个函数能够从WebService上获取某只股票的最新价；我想要一个函数能够获取当前的天气情况，这些需求我们可以通过编写Excel自定义函数(User Define Function ,UDF )来实现，这样，在Excel中直...
Excel AddIn 开发（一）
tpriwwq的专栏
04-30 9492
在这个小项目之前从来没有
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值