本線上課程將演示如何使用 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.