Hi everyone,
In this one we are automating the process of getting buying signals based on technical indicators. In specific we are updating the MySQL database and sending ourselves mails containing those signals. In the end we are using cronjobs to automate the process. You need to define a proper time for the execution. I would guess midnight is a good way.

Alternative cron syntax for midnight would be: @daily
More information:
https://crontab.guru/#

An excellent video on understanding and setting up gmail for smtp:
https://www.youtube.com/watch?v=JRCJ6RtE3xU&t=706s

I guess that’s for now the final part but I will do similar topics when covering cloud stuff in the near future. I hope you enjoyed the series! :-)

#Python #Stocks #Trading

Disclaimer: This video is not an investment advice and is for educational and entertainment purposes only.

0:00 - 01:01 Intro
01:01 - 03:05 Recap Recommender class
03:05 - 07:03 Updating the DB - Get the current max date
07:03 - 12:30 Updating the DB - Update method
12:30 - 15:39 Setting up Mail for mailing (smtplib)
15:39 - 17:00 Important and necessary changes to the recommend method
17:00 - 18:57 Sending out the mail (gmail)
18:57 - 19:58 Checking mail inbox 📥
19:58 - 22:30 Automatization - Transforming notebook to .py file and necessary amendments
22:30 - 26:24 Automatization - Cronjob to automate the execution of the python file
26:24 - 26:50 Removing cronjobs
26:50 - 27:26 Final remarks

#python