강의

멘토링

커뮤니티

BEST
Business & Marketing

/

Management

Building a stock price backtesting system using Python

This lecture is a comprehensive course that covers the entire process of stock backtesting using Python from start to finish.

(4.6) 14 reviews

266 learners

  • choi2505
Python
MySQL
Pandas
Anaconda
Visual Studio Code

Reviews from Early Learners

What you will gain after the course

  • You can go a little further with basic Python syntax.

  • Learn the basics of using MySQL and MySQL Workbench.

👩‍💻 From building a backtest database to writing a library !
Learn how to write and implement algorithms carefully .
👨‍💻

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 questions related 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)
  • Creating a GUI using QtDesigner
  • Packages used: pandas, Matplotlib, Mysql-connector-python, TA-lib, PyQt5

Expected Questions Q&A 🙋🏻‍♂️

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

Need to know before starting?

  • Basic Python Grammar

Hello
This is

취미로 얕게 넓은분야를 공부하는것을 좋아하는 대학생입니다!

Curriculum

All

56 lectures ∙ (13hr 59min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

14 reviews

4.6

14 reviews

  • junhoogle7966님의 프로필 이미지
    junhoogle7966

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    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.

    • domskl6135님의 프로필 이미지
      domskl6135

      Reviews 1

      Average Rating 5.0

      5

      21% enrolled

      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.

      • saintcode1087958님의 프로필 이미지
        saintcode1087958

        Reviews 2

        Average Rating 2.5

        4

        71% enrolled

        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.

        • persona12413200님의 프로필 이미지
          persona12413200

          Reviews 1

          Average Rating 3.0

          3

          100% enrolled

          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.

          • chlgnstjrdla4577
            Instructor

            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.

        • juyoungji6775님의 프로필 이미지
          juyoungji6775

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          I took this course because I wanted to build a backtest. I think it will be very helpful. Thank you.

          Similar courses

          Explore other courses in the same field!