Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]
Автор: Algovibes
Загружено: 2021-04-11
Просмотров: 38570
Описание:
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://imager.clipsaver.ru/5bUn-D4eL4k/max.jpg)
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
![SQL Tutorial [MySQL] for BEGINNERS in under ONE hour](https://imager.clipsaver.ru/eB9byZhy3xA/max.jpg)
![Trading strategy and Backtest with Python & SQL [MOMENTUM in the INDIAN stock market]](https://imager.clipsaver.ru/YIsKSQh1xpY/max.jpg)
![How to Manage a Database with Python, Pandas & SQL - UPDATE a DB professionally [DO NOT SKIP THIS!]](https://imager.clipsaver.ru/WqXknI1kql8/max.jpg)
![Как подключить Python к базе данных SQL [SQLITE] | идеально для новичков](https://imager.clipsaver.ru/pU53JUhSnkY/max.jpg)
![Trading strategy and Backtest in Python [Momentum of ALL S&P 500 stocks]](https://imager.clipsaver.ru/5W_Lpz1ZuTI/max.jpg)
