Storing and Retrieving Tick Data using MySQL and Python
We want that a single table should store the price values of multiple instrument tokens. So, we will create a table that will have four columns: id (auto increment) time…
Posted inPython
Storing Live Zerodha WebSocket Ticks into MySQL Database
Let us see the WebSocket function [crayon-6922bfbaf0bfe593465079/]
Posted inMySQL
How to change your MySQL root Password
There will come a time when you would want to change your MySQL password. There could be many reasons why you would want to do that: Your password has been…
Posted inMySQL
Creating MySQL Table to store Tick Data
It is better to create a MySQL table beforehand, to store the incoming tick data. I will name the table 'sample'. [crayon-6922bfbaf1044378353827/] This was successful. Now we have a table…
Posted inPython
Retrieving Tick Data from Zerodha in Python
The tick data that you receive from Zerodha looks like this: [crayon-6922bfbaf136b298765595/] For the sake of convenience, I have included just two instruments (scrips), you can include upto 3,000 instruments.…
Posted inPython
Collecting live data into your MySQL database
Step 1 : Import the necessary modules [crayon-6922bfbaf15f4917680342/] Step 2 : Write the code to make database connection [crayon-6922bfbaf15fc947570580/] Step 3 : Write the code to insert live data into…
Posted inPython
Retrieving live data from MySQL Database
In one of my posts, I have mentioned how to collect live data into your MySQL database. In this post, I'll explain you how to retireve this live data from…
Posted inUncategorized
Python Requests
The first job is to install 'requests'. Use pip to do this. Creating the response object For this, you will have to import to request module first. [crayon-6922bfbaf1a9a764646505/] Now, we…
Posted inUncategorized
MySQL
MySQL Connector Cursor To open it from CMD Step 1 : Windows Key + Run Step 2 : cd C:\Program Files\MySQL\MySQL Server 8.0\bin Step 3 : mysql -u root -p…