In this video I am describing, how you can stream all currencies of Binance into your MSSQL Database. You will find out, how you can connect to MSSQL DB from Python, save there all your data and how you can then evaluate the data using MSSQL Server Management Studio.

To download this example, visit the following Website:
“https://github.com/TechDivisions/python-binance-stream-all-currencies-into-mssql-db”

– by Vladimir Heinz

— Hit that subscribe Button! —

Enjoy my videos!

Chapters:
00:00 – Intro
00:08 – Explanation – what we are going to do in this video
00:55 – Pasting Binance all coins list with prices into my Chrome browser console
01:33 – New project
02:21 – Python: Creating a python cron job / Python: schedule task
02:32 – Python: pip install schedule
02:45 – Python: Implementing Scheduling
03:21 – Python: urllib request
04:23 – Python: json decode
04:39 – Method for saving all the data – python db file creation
05:14 – Printing out amount of all currencies downloaded
05:37 – Importing database – “db” – file & calling method “save_all_data(data)”
05:49 – Call for the “start()” method; Python scheduler example reimplemented
06:27 – Summarization before starting Python Scheduler without saving data
06:56 – Start of the Python Scheduler example
07:31 – Creating a new database in Ms Sql / ms sql create database
08:27 – Creating a new table in Ms Sql database / ms sql create table
10:18 – Creating a new Ms Sql user; ms sql create user
11:38 – Solution for: Some of your configuration changes will not take effect until SQL Server is restarted
12:05 – Restarting the Ms Sql server in the Sql Server Configuration Manager
12:19 – Connecting to the Ms Sql database with a new user
12:40 – How to connect to Ms Sql Server through Python / python connect to sql server
14:11 – Implementing python connection through pyodbc / python pyodbc example
14:35 – Iterating through all data and saving them / python mssql insert multiple rows
16:10 – Summarization before starting Python Scheduler with saving data
16:33 – Trying out the python cron job example and saving all data to Ms Sql database
16:43 – Checking for new data in the database; / sql server management studio select query
17:03 – Ms sql count example
17:30 – Stopping Python cron job
17:39 – Querying only one currency / ms sql query specific data example
17:58 – Adding order by asc / ms sql order by date
18:34 – Querying other currencies
18:50 – Final advice – Scheduler to no less than 60s
19:25 – Summarization – how you can download data from Binance and upload to your Ms sql Database
19:38 – Where you can find all this Project – code on my Github
19:55 – Final thoughts
22:18 – Finish

#pythonbinance #mssql #binancestreamallcurrencies