Myvideo

Guest

Login

Create your own Finance DataBase with Python & SQL perfect for backtesting trading strategies

Uploaded By: Myvideo
11 views
0
0 votes
0

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

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later