|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/automated-trading-excel/
课程评论：没有评论
**课程名：** 使用 Excel 创建你自己的自动化股票交易机器人！ **课程概述：** 本课程将教你如何在最流行的电子表格软件 Excel 中构建交易自动化。在 Excel 中，你可以实现无限的可能，你的创造力是唯一的限制！课程围绕学习 **Visual Basic for Applications (VBA)** 展开，我们将以我为交易设计的简化系统 **Ranger1.0** 为例，展示如何构建你自己的交易自动化。每位学员都可以下载 Ranger1.0 的副本供自己使用。 课程结束后，你将： * 理解 Ranger1.0 的运行代码，并能够根据自己的想法对其进行定制。 * 掌握使用 VBA 从零开始构建自己的自动化交易系统的能力。 * 学会自动化订单生命周期，构建定时器，播放声音，记录实时数据，进行回测，甚至构建一个决策 AI。 * 了解如何设置 Interactive Brokers 账户，配置 Excel API，以及使用模拟“纸上”交易账户进行交易。 **课程重点：** * **核心技术：** Visual Basic for Applications (VBA) * **应用领域：** 自动化股票交易（亦可扩展至期货、货币、期权、债券交易，但课程不详细涵盖） * **关键功能：** 订单生命周期自动化，定时器，声音播放，实时数据记录，回测，AI 决策 * **实践操作：** 提供 Ranger1.0 交易系统供学员使用和学习，指导设置 Interactive Brokers 账户和 Excel API，进行模拟交易。 * **面向人群：** 即使是编程新手，也能通过本课程入门 VBA。 **最终目标：** 让你具备独立构建自定义自动化交易系统的知识和技能，实现你对交易自动化的所有设想。
In this course you will learn how to build trading automation in Excel, the most popular spreadsheet software on the market. In Excel, there are no limits to what you can build! You are limited only by your imagination! The course is built around learning Visual Basic for applications (VBA) and we'll be examining a simplified version of the system I built for trading called Ranger1.0. We'll use this system as an example to show you how to build your own automation. Every student will be able to download a copy of Ranger1.0 for their own use. By the end of the course you will understand the code that runs Ranger1.0 and be able to customize it to fit your ideas. You will also be able to use what you've learned to build your own automated system from the ground up, if that's what you choose to do. The focus of this course is on trading stocks. It is possible to trade futures, currencies, options, and bonds through Ranger1.0, but examples on how to trade these are not covered in detail. However, by the end of this course you will have enough knowledge in Visual Basic to be able to create your own custom automation to trade whatever you want however you want!The sky is the limit! With excel you really can build just about anything you can imagine. This course will get you started using Visual Basic, even if you've never written any code before. You will learn how to automate the order life cycle, how to build timers, play sounds, record live data, do backtesting, and even how to build a decision making AI!Finally, I will guide you through everything you need to know to set up an account with Interactive Brokers, how to set up the Excel API, and how to trade using a simulated "Paper" trading account. An Interactive Brokers account is required to receive live streaming data and to send orders, but even if you do not have an account, I will show you how to get historical data for excel that you can do backtesting on right away!
