Financial Applications using Excel Add-in Development in C/C++

最新推荐文章于 2021-06-10 10:58:03 发布
最新推荐文章于 2021-06-10 10:58:03 发布
阅读量783 收藏
点赞数
分类专栏： Excel 文章标签： excel vba performance reference features 出版
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/topmvp/article/details/3373423
版权
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。 http://blog.csdn.net/topmvp - topmvp

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 2007s 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++.

http://rapidshare.com/files/41251196/0470027975.zip
http://depositfiles.com/files/1155272
topmvp
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
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.
Modelling financial time series using GARCH-type models .pdf
10-09
Modelling financial time series using GARCH-type models with a skewed student distribution for the innovations
Excel在会计和财务中的应用（第二版）实例源文件和电子教案
02-26
Excel在会计和财务中的应用（第二版）实例源文件和电子教案
Financial Applications Using Excel Add-in development in C/C++
10-22
wiley finance: Financial Applications Using Excel Add-in development in C/C++ 的电子版
Excel在财务管理中的应用.iso (随书光盘)
08-11
总序 前言 第1章 用Excel 2007进行财务管理 1.1 Excel在会计和财务管理中的应用 1 1.1.1 Excel的功能特点 2 1.1.2 Excel在会计和财务管理中的应用 4 1.2 Excel 2007的安装和启动 6 1.2.1 系统配置 7 1.2.2 安装Excel 2007 7 1.2.3 启动Excel 2007 9 1.3 Excel 2007的操作界面 10 1.3.1 Office按钮 11 1.3.2 快速访问工具栏 11 1.3.3 功能选项卡区 13 1.3.4 数据编辑栏 13 1.3.5 工作表编辑区 14 1.3.6 工作表标签栏 14 1.3.7 状态栏 14 1.4 工作簿、工作表和单元格 15 1.4.1 工作簿 15 1.4.2 工作表 21 1.4.3 单元格 22 1.5 退出Excel 2007 27 第2章 创建标准的财务表格 2.1 数据输入 28 2.1.1 手工录入单元格数据 28 2.1.2 快速填充单元格数据 29 2.2 数据编辑 37 2.2.1 数据的复制和剪切 37 2.2.2 数据的查找和替换 39 2.2.3 撤销与恢复数据 42 2.3 数据的有效性 45 2.3.1 限制录入条件 45 2.3.2 圈释无效数据 48 2.4 数据的保护 49 2.4.1 保护工作簿 50 2.4.2 保护工作表 51 2.4.3 保护单元格 53 第3章 格式化财务表格 3.1 设置单元格格式 58 3.1.1 设置单元格字体格式 58 3.1.2 设置单元格数字格式 60 3.2 使用单元格样式 63 3.2.1 套用单元格样式 63 3.2.2 新建单元格样式 64 3.3 套用表格格式 67 3.3.1 使用自带的样式美化表格 68 3.3.2 新建表格样式 72 3.4 设置条件格式 75 3.4.1 突出显示单元格规则 76 3.4.2 项目选取规则 77 3.4.3 数据条 78 3.4.4 色阶 79 3.4.5 图标集 80 第4章 形象化财务数据 4.1 使用插图形象化财务数据 83 4.1.1 插入图像 83 4.1.2 使用形状 87 4.2 认识图表 93 4.2.1 图表的组成 93 4.2.2 图表的类型 94 4.3 用图表形象化财务数据 96 4.3.1 制作财务图表的流程 96 4.3.2 创建图表 97 4.3.3 编辑图表 102 第5章 财务数据汇总与分析 5.1 数据的排序 111 5.1.1 快速排序 112 5.1.2 自定义排序 113 5.2 数据的筛选 119 5.2.1 快速筛选 119 5.2.2 高级筛选 126 5.2.3 清除筛选 127 5.3 分类汇总 128 5.3.1 创建分类汇总 128 5.3.2 清除分类汇总 130 5.4 数据透视表 131 5.4.1 认识数据透视表 132 5.4.2 创建数据透视表 133 5.4.3 分析数据透视表 137 5.4.4 数据透视表的字段设置 139 5.4.5 数据透视表的布局 143 第6章 公式与函数 6.1 认识公式 149 6.2 使用公式 151 6.2.1 创建公式 151 6.2.2 编辑公式 153 6.2.3 公式中的常见错误 154 6.3 单元格的引用 156 6.3.1 相对引用和绝对引用 156 6.3.2 输入单元格引用 159 6.3.3 跨工作表单元格引用 160 6.3.4 跨工作簿单元格引用 162 6.4 认识函数 164 6.5 使用函数 165 6.6 常用函数的应用 166 6.7 财务管理常用函数的应用 183 6.7.1 折旧计算函数 183 6.7.2 货币时间价值的计算函数 191 6.7.3 投资决策中有关指标的计算 193 6.8 练习与提高 195 第7章 财务表格的打印设置 7.1 页面布局设置 197 7.1.1 打印方式设置 197 7.1.2 页边距设置 199 7.1.3 页眉页脚设置 200 7.1.4 分页设置 202 7.2 打印预览 205 7.3 打印表格 206 7.3.1 打印属性设置 206 7.3.2 打印区域设置 207 7.3.3 快速打印 208 7.4 练习与提高 209 第8章 Excel的高级应用 8.1 控件 215 8.2 宏 225 8.3 练习与提高 228 第9章 制作日常财务管理表格 9.1 差旅费报销单 231 9.1.1 目标分析 231 9.1.2 制作准备 232 9.1.3 操作步骤 232 9.2 员工月考勤表 246 9.2.1 目标分析 246 9.2.2 制作准备 247 9.2.3 操作步骤 248 9.3 工资表 261 9.3.1 目标分析 261 9.3.2 制作准备 261 9.3.3 操作步骤 262 9.4 本量利分析 271 9.4.1 目标分析 271 9.4.2 制作准备 271 9.4.3 操作步骤 272 第10章 企业日常会计核算 10.1 会计科目表 282 10.1.1 创建会计科目表 282 10.1.2 编辑会计科目表 287 10.2 会计凭证 290 10.2.1 制作记账凭证 290 10.2.2 记账凭证清单 293 10.3 会计账簿 297 10.3.1 日记账 298 10.3.2 分类账 303 10.3.3 科目汇总表 306 10.3.4 试算平衡表 308 10.4 会计报表 313 10.4.1 资产负债表 313 10.4.2 利润表 315 10.4.3 现金流量表 316 参考文献
在 Excel 中使用集算器 add-in
Raqsoft
06-10 1531
集算器支持Excel add-in接口，既可以在单元格调用集算器表达式，也可以在单元格或VBA中调用集算器脚本文件。 一、环境配置 应在windows操作系统下配置JDK、集算器、Excel，对于最常见的64位windows，三个软件的位数必须保持一致，即都是32位，或都是64位。 JDK 集算器自带JDK，如果本机原先没有JDK，则建议跳过本步骤，在下一步安装。如果本机的JDK可卸载，建议用JAVA或Windows官方提供的工具正常卸载，再进入下一步。 如果本机已安装JDK（1.8或以上版本），
Financial Applications Using Excel Add-in Development in C-C++,
01-17
Since the publication of the first edition of this book late in 2004, Microsoft have announced the release of Excel 2007 (version 12), one of the most important new releases since Excel 97 (version 8). For those developing add-ins in C and C++ so little changed between Excel 97 and Excel 2003 (version 11) that the entire first edition applied almost equally to versions 8, 9, 10 and 11. Excel 2007 introduces some important and longawaited changes that have a significant impact on the text of this book, which has been updated to reflect these new features. For the first time in many releases, the Excel team have updated parts of the C API interface to allow XLL add-in writers to take advantage of some of these new features. The three areas that have the biggest impact are the introduction of multi-threaded recalculation, a worksheet grid over 1,000 times larger than is supported in previous versions, and support in the C API for 32Kbyte Unicode strings. The implications for XLLs of these changes and others are fully explored in this edition. Beyond matters relating to Excel 2007, this edition adds a great deal of new material to the first. There is a much expanded section of Excel’s recalculation logic, intended to help you minimise calculation times and maximise control, as well as a new section that spcifically addresses optimisation of calculations, both in the add-in and in the workbook. The example C++ class described in the first edition that wraps the xloper data type has not only been enhanced to handle the new Excel 2007 data types but also to wrap calls to the C API as well. There is a new section relating to add-in design, covering issues such as good practice for the separation of interfaces, and techniques for controlling the propagation of errors through a workbook. There are numerous other small additions and modifications to the original text, not significant enough to warrant mention here. As you would expect, the known errors and omissions in the original text have also been fixed, although readers are asked to bear in mind that the writing constraints of such a book mean that bug-free can only ever be a goal not a promise where code samples are concerned. Beyond this, new material relates to a few practical applications. These tend to be those that are most relevant to the professional derivatives markets, but will I hope, still provide some useful insights for people outside this world. There is a little more about interpolation. The section relating to the Gaussian normal distribution is revised and now takes a more sensible Excel version-specific approach, which also serves as an example of backwards-compatible and version-aware add-in funtionality.
using-excel-business-financial-modelling-3rd
03-31
A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons o
Modelling financial time series using GARCH-type models.pdf
10-11
We show how the ARMA-Power GARCH model for the conditional mean and variance can be adapted to analyze times series data showing asymmetry.
反虚拟货币诈骗资料素材-Preventing-Financial-Crime-in-Cryptoassets
最新发布
07-10
反虚拟货币诈骗资料
Financial-Inclusion-State-in-East-Africa
03-13
东非金融包容性国家Finscope调查了2016年至2018年的数据分析。研究的问题是弄清楚我们如何才能预测哪些人最有可能在肯尼亚，乌干达，卢旺达和坦桑尼亚拥有或使用银行帐户。 由AUDREY IMALI描述金融包容性仍然是非洲...
Professional Financial Computing Using Excel and VBA 无水印原版pdf
12-29
Professional Financial Computing Using Excel and VBA 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载自网络，如有侵权，请联系上传者或...
Financial-Numerical-Recipes-in-VBA:将C ++算法转换为VBA
05-15
VBA中的财务数字食谱将C ++算法转换为VBA 奥德加德先生的原文，您可以在这里找到： : 但是，如果您希望使用VBA对财务应用程序进行编码，请检查此存储库。 该项目的一些优点是，您可以找到一种方法，而无需使用工作表...
Financial-Analysis-using-Hadoop-MapReduce:CSE587
05-09
使用Hadoop MapReduce的纳斯达克财务分析在布法罗市计算研究中心（CCR）的Hadoop环境中使用mapreduce来计算在纳斯达克上市的公司的股票波动率。 分析了在不同数据大小和节点数上实现的可伸缩性。...
Jumps-in-Financial-Markets:STATA-分析股价上涨
05-15
跳入金融市场本文使用的代码和数据：Corea，F.，Cervellati，EM（2015）。 “股票跳跃：分析传统和行为观点”。 风险治理与控制：金融市场与机构5（3）：15-25。
R Programming and Its Applications in Financial Mathematics-CRC(2017).pdf
04-06
vi < R Programming and Its Applications in Financial Mathematics divided the book into some parts. Section I of this book is devoted to statistical and time-series analysis, Section II covers the ...
https://www.kaggle.com/code/chenshuigao/china-financial-market-report-2022/edit
03-31
I'm sorry, as an AI language model, I do not have the ability to access external links, including the one you provided. Can you please provide me with the necessary information or context that you ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值