The Indissoluble – Page 2 – A personal knowledge base

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…

The Indissoluble April 29, 2025

Python

Storing Live Zerodha WebSocket Ticks into MySQL Database

Let us see the WebSocket function [crayon-6922b20a32e0c329526179/]

The Indissoluble April 26, 2025

MySQL

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…

The Indissoluble April 26, 2025

MySQL

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-6922b20a3325c806585939/] This was successful. Now we have a table…

The Indissoluble April 21, 2025

Python

Retrieving Tick Data from Zerodha in Python

The tick data that you receive from Zerodha looks like this: [crayon-6922b20a334a5852752799/] For the sake of convenience, I have included just two instruments (scrips), you can include upto 3,000 instruments.…

The Indissoluble April 21, 2025

Python

Collecting live data into your MySQL database

Step 1 : Import the necessary modules [crayon-6922b20a336cc923636231/] Step 2 : Write the code to make database connection [crayon-6922b20a336d4614441417/] Step 3 : Write the code to insert live data into…

The Indissoluble April 19, 2025

Python

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…

The Indissoluble April 19, 2025

Python

iloc

Suppose you have a dataframe as the one given below: let us call this dataframe 'var' What would you do, if you want to extract the data from the first…

The Indissoluble April 18, 2025

Uncategorized

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-6922b20a33b57658208757/] Now, we…

The Indissoluble April 17, 2025

Uncategorized

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…

The Indissoluble April 16, 2025