You can go a little further with basic Python syntax.
Learn the basics of using MySQL and MySQL Workbench.
👩💻Frombuilding a backtest database to writing a library! Learnhow to write and implement algorithmscarefully .👨💻
Lecture Introduction 📝
In this lecture, we'll use Python to build a backtest database and create a backtest library that allows you to backtest your own algorithms. (This isn't an algorithm lecture on buy and sell signals!)
As you'll see in the section on creating buy and sell signals, there's a lot more to consider when developing a trading algorithm than you might think. While there are certainly many excellent packages for backtesting, achieving a high degree of freedom requires developing your own backtesting program or possessing a significant understanding of backtesting libraries. For that reason, I've created my own backtesting program to ensure that after taking this course, you can implement everything you imagined.
Above all, I hope that after taking the course, you will learn to treat your own data critically !
What you will learn in this course ✏️
In this lecture...
1 Learn basic SQL statements while building your own database (MySQL) .
2 I think those who have just finished learning Python will feel more confident in Python if they listen to this! (The course is structured so that you can take it even after completing only the basic Python grammar .)
3. I hope that as you take the course with me, you will learn that although writing an algorithm that performs backtesting may seem simpler than you think, there are many things to consider.
4 Learn how to create a basic GUI using Python, and how to use matplotlib, pandas, and mysql-connector-python .
Lecture Features 💡
The lectures were written with a focus on practical training as much as possible, and the entire lecture is organically connected, so I hope you will follow along and proceed.
Please check before taking the class! ✔️
We are sorry, but we are unable to answer questionsrelated to the lecture . Please take this into consideration when purchasing.
Lecture Preview 📖
In total, we create two GUIs (graphical user interfaces).
• The program below updates our MySQL database.
• The program below is a program that performs backtesting.
Tools covered here 🧰
Anaconda manages Python and virtual environments
MySQL and MySQL Workbench
Visual Studio Code
Xing API, Dev Center (ebest Investment & Securities)
Q. How much weight is given to trading algorithms in the course? A. This course will focus almost entirely on trading algorithms. Its purpose is to teach beginners how to build a stock price database and how to write a backtesting program.
Q. Can I immediately apply my own backtesting algorithm after taking the course? A. It depends on your level of understanding, but I personally believe that if you fully understand this lecture, you'll be able to begin backtesting your own algorithm. However, as I've repeatedly emphasized throughout the lecture, even simple-looking trading algorithms require considerable attention to detail when actually developing a program.
Q. Is it okay to follow the lecture even if I don't have a high level of understanding of Python syntax? A. Yes, I tried to cover the basic grammar so that as many people as possible can understand it, and I also organized the parts that may be confusing since I just finished learning Python grammar.
Recommended for these people
Who is this course right for?
For those who have just finished learning Python grammar and are at a loss as to what to do
For those who want to start backtesting with Python
This is the best lecture.
If you really want to implement backtesting with a high degree of freedom,
I highly recommend that you take this lecture.
Even those who are new to Python or MySQL can take this course. I vaguely know Python and have never used MySQL, but I was able to complete the course by following what the instructor taught me.
For those who feel the limitations of backtesting with Excel,
I think this lecture will be the answer.
Lastly, I would like to thank the instructor for providing such a high-quality lecture at such a low price.
Related Content When I first tried to study on my own, I was really overwhelmed, but this lecture helped me a lot by teaching me step by step from the basics. In particular, the lecture was structured so that I could just follow along in a sequential manner, so I think I learned more easily. This is a highly recommended lecture.
It was a good lecture that I did not feel difficult even though I was a student of a certain age. The instructor tried to explain it very easily overall and tried hard to make the diction accurate. The only regret was that the screen was too large to see the code when recording the video, and the question feedback was not satisfactory, so I gave it a score of one star. However, other than other environmental issues, it was great to lay the foundation for backtesting. I hope that in the future, you will develop content that provides good feedback in a more detailed video environment, and if the lecture is released, I will 100% teach it.
The lecture content seems good.
The text is too small and the lack of code sharing makes learning difficult.
Most other lectures and books share code, which is unfortunate.
If I can't run the lecture while following it, I have to look at the instructor's code and figure out what I wrote wrong, but I have to go back and look at the lecture every time. In particular, it's especially hard to find the previous lectures.
I saw that someone else requested code sharing, but it was difficult because of code leaks... It's hard to agree. Or if the lectures were edited more conveniently... I don't think there would be such requests... It's unfortunate.
Still, since this is a necessary lecture, I will persevere and listen diligently.
I'm sorry. Since this is the first lecture I've recorded, I think there are many shortcomings. If I record a lecture next time, I'll share the code and record it in a larger font.