Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]
Hi everyone,
this video shows how you can create your own finance database using Python and SQL.
This video is important as I might(!) use my own SQL databases in future trading strategies and I can refer to this video where I got my data from.
As said in the video if you are using MySQL / MS SQL Server / Postgres instead of the create engine function you need to create a schema. Let me know if you need support with that.
Please subscribe and like this video if this was helpful. Thank you very much in advance!
Python and SQL videos:
basics:
more importantly:
0:00 - 04:55 Getting and preparing the data with yfinance
04:55 - 06:50 Create the database engine (SQLITE! Please listen to my comments or read video description for other DB systems)
06:50 - 10:45 Transfer the data to the SQL database
10:45 - 11:20 Taking a look at the Database (SQLite browser is used)
11:20 - 14:01 Requesting data from the database
11 views
15
2
2 weeks ago 03:31:33 1
God’s Chosen Ones, 10 Life-Changing Signs of the Holy Spirit’s Presence | The Sacred Light
2 weeks ago 00:03:26 1
Pack Like a Pro: Ultra-Light, Space-Saving Packing Cubes for Stress-Free Travel! - YouTube
2 weeks ago 00:04:22 1
Real installation of container house / modular homes / sustainable home
2 weeks ago 11:29:01 1
Relaxing Music 🌸 Eliminate Negative Energy & Heal Your Heart ~ Perfect for Relaxation ♥️
3 weeks ago 00:07:27 1
Patchwork tutorial: beautiful quilt lessons beginners should try it sewing with simple strips
3 weeks ago 00:46:41 93
State of Play | February 12, 2025 [English]
4 weeks ago 00:09:44 1
Hot Beach Day in Zurich 4K-Switzerland Summer Hot Day 2024 HDR Flori Travel
4 weeks ago 03:00:00 3
ZEN GARDEN MUSIC: Japanese Melodies with Female Vocals and Relaxing Visuals
4 weeks ago 00:03:12 1
The “Turn Heads & Drop Jaws“ Maxi – Strapless, Sultry & Seriously Stunning! - YouTube