本在线课程将演示如何使用 MS Excel 构建长期部门资金轮换模型。Microsoft 的可视化基本 （VBA） 语言与 Excel 的用户界面、公式和计算功能一起使用，以提供强大而灵活的投资工具。使用经典的市场经济学家的部门旋转模型，有几个改进，消除了时间基金转换的猜测。该模型包含三个经过验证的技术指标- 相对强度、移动平均交叉和移动平均斜率，以确定最有可能提供长期利润的部门基金。可用于任何共同基金、指数基金、SPDR、ETF、未来或其他指数证券，以将资本分配给最有利可图的行业。使用每周.csv数据文件，从雅虎金融免费，或自动DDE数据链接，如果需要。只需每周运行一次系统，即可做出投资决策。还包括一个预构建的Excel回溯测试模型，允许您测试多达10种不同的基金与购买和持有超过10年。 你得到的： 一个巨大的 4- in-1 值！ - 在线课程，展示如何构建和操作模型 - 关于从eSignalQLink和雅虎金融将价格导入Excel的详细说明 - MS Excel 中预构建的背测试模型，包含图表和交易统计信息 - 直接在线访问课程材料 好处 - 将 Excel、VBA、公式和数据源集成到有利可图的交易工具中 - 获取适用于任何 Excel 建模项目的知识 - 消除经常性软件成本 - 在几秒钟内计算数百只基金的买入/卖出信号 技术要求 - Windows 的 Ms Excel - 1Mb 磁盘空间 - 每周收盘基金价格数据 - （可选） Excel 的 DDE 数据导入链接
版本历史记录
- 版本 v2 发布于 2010-03-30
软件信息
- 软件分类： 业务 > 投资工具
- 发布者： Financial-edu.com
- 许可： 免费试用
- 价格： $89.95
- 版本： 2
- 适用平台： windows
终端用户许可协议
END USER LICENSE AGREEMENT for Building an Automated Sector Fund System in Excel Copyright 2000-2010 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.