Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]
Автор: Algovibes
Загружено: 2021-04-11
Просмотров: 38512
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.
Get the Notebook/Source code by becoming a Tier-2 Channel member:
/ @algovibes
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:
• How to connect Python with a SQL database ...
more importantly:
• Pandas Dataframes and SQL [How to write da...
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
![Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]](https://i.ytimg.com/vi/5bUn-D4eL4k/maxresdefault.jpg)
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![SQL Tutorial [MySQL] for BEGINNERS in under ONE hour](https://image.4k-video.ru/id-video/eB9byZhy3xA)
![How to Manage a Database with Python, Pandas & SQL - UPDATE a DB professionally [DO NOT SKIP THIS!]](https://image.4k-video.ru/id-video/WqXknI1kql8)
![How To Build a Trading Strategy in Python [SHORT TERM REVERSAL] - Backtest included](https://image.4k-video.ru/id-video/xpP048vfNrg)
![Как подключить Python к базе данных SQL [SQLITE] | идеально для новичков](https://image.4k-video.ru/id-video/pU53JUhSnkY)
![Введение в BACKTRADER [библиотека торговых стратегий для тестирования на истории для Python]](https://image.4k-video.ru/id-video/pt4auu_ZPm4)
