本在线课程将演示如何使用 MS Excel 构建自动点差交易模型。系统捕获任何类型的证券对之间的价格差 - 指数、股票、期货、期权、LEAP、货币。该系统使用三个经过验证的技术指标 - 指数移动平均线、百分比价格振荡器 （PPO） 和 Donchian 通道 - 在利润可能最大时捕获点差移动。包括瑞士法郎-日元期货、纳斯达克-标准普尔500指数和10年期美国5年期国库券的三种点差策略。系统经过优化，可与每日或每小时数据一起使用，但可随时使用。将展示如何使用 DDE 链接构建数据 "hub"或使用来自雅虎财务或其他来源的免费 .csv 数据文件运行模型。还包括一个完整的回溯测试模型 - 只需导入历史数据，并查看所选点差策略的统计和图形结果。 你得到的： 一个巨大的 3- in-1 值！ - 在线课程，介绍如何构建和操作模型 PLUS VBA 代码和常见问题部分 - 使用电子信号QLink和雅虎金融将价格导入Excel的详细说明 - MS Excel 中预构建的背测试模型，包含图表和交易统计信息 - 在线访问课程材料 好处 - 将 Excel、VBA、公式和数据源集成到有利可图的交易工具中 - 获取适用于任何 Excel 建模项目的知识 - 通过消除经常性软件成本节省资金 - 在几秒钟内计算多个点差对的买入/卖出信号 技术要求 - Windows 的 Ms Excel - 5Mb 磁盘空间 - 您所选时间间隔上的日期-时间-关闭价格数据 - （可选） Excel 的 DDE 数据导入链接
版本历史记录
- 版本 v1 发布于 2004-12-01
软件信息
- 软件分类： 业务 > 投资工具
- 发布者： Financial-edu.com
- 许可： 免费试用
- 价格： $89.95
- 版本： 1
- 适用平台： windows
终端用户许可协议
END USER LICENSE AGREEMENT for Building an Automated Spread Trading System in Excel Copyright 2000-2007 Financial-edu.com COPYRIGHT NOTICE: This course, including the text, trading model system logic, images, computer files, product descriptions, and other accompanying material is protected by U.S. and international copyright laws. No reproduction or distribution of any sort is permitted without the express written consent of Financial-edu.com. All rights reserved. SINGLE USER LICENSE; USE OF COURSE MATERIALS: Your purchase provides you with a single user license to use the course materials for your own personal use only. The files, formulas, code, formats, and layouts of the files are copyrighted material and may not be distributed in any way, including in modified form. Your single user license allows you to incorporate this information into your own trading or analysis models, software, spreadsheets, or derivative works, however any distribution or resale of these derivative works incorporating our content in original or modified form outside of your own personal use requires a further written license. USE OF LOGIN AND PASSWORD: Your access login and password is for your own use only -- any sharing of your login information will result in billing you the full amount for each additional user detected. Your respect of our intellectual property rights is important in making this product a useful resource. We thank you for your consideration! ACCEPTANCE OF LICENSE AGREEMENT: You automatically accept and agree to obey the terms of this LICENSE AGREEMENT by logging into the online course content or viewing, saving, or storing any course materials, including text, trading model system logic, images, computer files, and other accompanying material. Due to the electronic nature of the course content, this acceptance is automatic and cannot be revoked by you, in whole or part.