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