Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies] finance base

by eqreBORN



Bonjour à tous, cette vidéo montre comment créer votre propre base de données financière en utilisant Python et SQL. Cette vidéo est importante car je pourrais (!) Utiliser mes propres bases de données SQL dans les futures stratégies de trading et je peux me référer à cette vidéo d’où j’ai obtenu mes données. Comme indiqué dans la vidéo, si vous utilisez MySQL / MS SQL Server / Postgres au lieu de la fonction de création de moteur, vous devez créer un schéma. Faites-moi savoir si vous avez besoin d’aide pour cela. N’hésitez pas à vous abonner et à liker cette vidéo si cela vous a été utile. Merci beaucoup d’avance! Vidéos Python et SQL : bases : plus important : 0:00 – 04:55 Obtenir et préparer les données avec yfinance 04:55 – 06:50 Créer le moteur de base de données (SQLITE ! Veuillez écouter mes commentaires ou lire la description de la vidéo pour d’autres bases de données systèmes) 06:50 – 10:45 Transférer les données vers la base de données SQL 10:45 – 11:20 Consulter la base de données (le navigateur SQLite est utilisé) 11:20 – 14:01 Demander des données à partir de la base de données

READ  Découvrir la finance décentralisée (DeFi) avec Marc Zeller - Alyra l'école blockchain finance décentralisée

Table of Contents

READ  (vidéo n°1) Finance comportementale : les principes finance comportementale

Images related to the topic finance base

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

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

Search related to the topic Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]

#Create #Finance #DataBase #Python #amp #SQL #perfect #backtesting #trading #strategies
Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]
finance base
Vous pouvez trouver plus d’informations utiles ici: voir plus ici
Vous pouvez trouver plus d’informations utiles ici: voir plus ici

You may also like

18 comments

Shubham GUPTA 06/12/2021 - 4:27 Chiều

Name error: name 'symbols' is not defined

What to do with this error

Reply
Joel Neves 06/12/2021 - 4:27 Chiều

I love your videos, they are being really helpful to me! What IDE are you using on this one? I loved this color theme.

Reply
Manny P 06/12/2021 - 4:27 Chiều

Thank you, very informative! Just subscribed to your channel.

Reply
Srikanth Venkataswamy 06/12/2021 - 4:27 Chiều

Great.. I was planning to have a algo trading bot using this. Can have one such video

Reply
Anthony 06/12/2021 - 4:27 Chiều

The video was very helpful. Can you also guide as how to update the database later on

Reply
harshad bhirud 06/12/2021 - 4:27 Chiều

fantastic work . I do have some question though.
1> How to update data daily basis?
2> is there way we can fetch NSE option chain.

Reply
Kumar Lavanya 06/12/2021 - 4:27 Chiều

excellent tutorial. Thanks for your good work. Can you please guide me on how to update the database every day with the latest price?

Reply
sconnell194 06/12/2021 - 4:27 Chiều

👍

Reply
Dulle88 06/12/2021 - 4:27 Chiều

Thanks also for this awesome tutorial. Liked and commented however already subscribed before.
Downloading such histories is usually needed for trading system development. What still also happens to pros is they forget about the survivor bias. The effect should not be underestimated! Could you make a tutorial on how to create a survivor bias free database (which may not be so easy as some old tickers are meanwhile delistet from YF and other sources). And further you could show the difference in resaults between survivor bias free data and "the easy way data" with the index' current constituents.

Reply
Digital Jitender 06/12/2021 - 4:27 Chiều

def TOSQL(frames,symbols,engine):

for frame,symbol in zip(frames,symbols):

frame.to_sql(symbol,engine,index=False) showing error in this part invalid syntex
pls check

Reply
Mohammed Berrezoug 06/12/2021 - 4:27 Chiều

Very nice and good explanation thank you.
How can we daily update the same db.

Reply
Bhav S 06/12/2021 - 4:27 Chiều

You have some great videos on your channel could you do a full end to end project of algorithmic trading from scratch so we can see the workflow behind it including backtesting and connecting to metatrader 4 (MT4) if you could involve some machine learning / deep learning in this even better.

Reply
Aditya Shinde 06/12/2021 - 4:27 Chiều

Bro I'm from India this was really helpful , Thanks alot bro

Reply
CK CK 06/12/2021 - 4:27 Chiều

Great job. Go on

Reply
VeioooOOO 06/12/2021 - 4:27 Chiều

Your work is awesome. You provide true quality content. Thank you

Reply
rraul 06/12/2021 - 4:27 Chiều

Thanks and good Sunday!

Reply
Digital Jitender 06/12/2021 - 4:27 Chiều

great video sir, pls extend this series by adding some indicator or can we use it in live market , or run any strategy in live market

Reply
alexryderr 06/12/2021 - 4:27 Chiều

Awesome work!
What do you think is the main advantage of storing dfs into SQL databases instead of csv, Excel etc.?
Really looking forward to more Python / SQL combination!

Reply

Leave a Comment