Stock Trading App Tutorial [Part 00] - App Overview

Summary

In this new series, the creator plans to transform a technical screener app into a full-stack Python application, complete with a database, alerts, and automated trading features. The project will span roughly 12 parts, with each video accompanied by a written tutorial on the website. Topics will cover database design, SQL queries, Python integration, job scheduling, web dashboard creation, technical indicators with alternative libraries like Tulip, user authentication, trading UI, alerts, notifications, and server configuration for deployment. The aim is to empower viewers to build their own hosted web applications by the end of the series.

Takeaways

• 😀 The channel is starting a new series that will be the longest one ever, likely extending through the end of the month.
• 📝 The creator is working on improving their writing skills to provide full written tutorials for each video in the series.
• 💻 They have been developing the website further and setting up a WordPress instance to support the tutorial content.
• 🔢 The series is planned to be roughly 12 parts, focusing on enhancing a technical screener app into a full-stack Python application.
• 🌐 The app will include more features like deployment, database usage, alerts, notifications, and automatic trading capabilities.
• 📈 The tutorial will cover topics such as deploying the app on a cloud service like AWS for continuous operation and notifications.
• 📝 Articles will be posted on the website alongside each video, allowing viewers to follow along in written form and copy code snippets.
• 🔍 The series will revisit a previously built technical screener web app and expand its functionality.
• 🗓️ The first few videos will focus on database design and SQL, including migrating from CSV files to a relational database for easier management.
• 🛠️ Subsequent parts will delve into job scheduling, building a web dashboard, applying technical indicators, and user authentication.
• 📲 The series will also explore setting up alerts and notifications, and automating trades based on technical settings.

Q & A

What is the main focus of the new series the speaker is starting?

The new series will focus on developing a full-stack Python application by enhancing a technical screener app with more features and sophistication, including deployment, database setup, alerts, notifications, and automatic trading capabilities.

What is the speaker's plan for providing tutorials along with the video series?

The speaker plans to create a full written tutorial for every video in the series, which will be posted on the website alongside each video, allowing viewers to follow along in written form and copy and paste code snippets.

How many parts does the speaker anticipate the series to have?

The speaker anticipates the series to have roughly 12 parts, as per the current plan.

What is the first topic the speaker will cover in the series?

The first topic to be covered is database design and the process of porting CSV files into a relational database for easier management.

How does the speaker plan to handle the updating of data in the application?

The speaker plans to discuss job scheduling to automate the process of updating data. This will involve using Python scripts with cron jobs or Windows Scheduler to automatically fetch new price data and keep the database up to date.

What will the web dashboard front end allow users to do?

The web dashboard front end will allow users to browse price data, click around, drill down to specific symbols, apply multiple indicators, and have a more sophisticated user interface with improved layout and color.

How does the speaker plan to incorporate technical indicators into the application?

The speaker plans to use a SQL database instead of CSV files and will discuss how to use Pandas with SQL to query the database and return data into a Pandas DataFrame for analysis with technical indicators.

What library might the speaker use for technical screening instead of TA-Lib?

The speaker is considering using the Tulip Indicators library for technical screening, as it offers a wider range of indicators and may be more compatible with different operating systems.

What authentication features does the speaker plan to implement in the web application?

The speaker plans to implement user authentication to allow users to save preferences, screens, indicators, or settings tied to their user account, and also to secure the application for real trading functionalities.

How does the speaker intend to handle alerts and notifications within the application?

The speaker intends to set up alerts and notifications based on user account settings, which could involve sending email reports or SMS messages using services like Twilio when certain patterns or thresholds are met.

What server configurations does the speaker have experience with and will discuss?

The speaker has experience with virtual servers on Linode or DigitalOcean and has run a web application on Linux for over a decade. They will discuss how to get the application online using these platforms.

What is the speaker's vision for the future content of the channel?

The speaker envisions creating a polished, advanced course that builds upon the content from the channel, which would be a comprehensive guide to Python for traders, potentially offered on a platform like Teachable in the future.