Trading Databases

Compact desktop computer with a terminal window and coffee mug: setting up Python 3.14 on a Mac Mini

Setting Up a New Mac Mini with Python 3.14 using Homebrew

Mac Mini Python 3.14 setup with Homebrew, step by step: PATH fixes, the externally-managed-environment error, TA-Lib in a venv and the...
Rajandran R
6 min read
Winding roadmap with milestones leading to rising candlestick charts

Python Roadmap 2026 – A Strategic Guide for Traders and Investors

A Python roadmap for traders in 2026: core libraries, statistics, backtesting, OpenAlgo execution, SEBI static IP rules and a 12-month learning...
Rajandran R
6 min read
Real-time crypto dashboard fed by a fast database with streaming data

Building a Real-time Crypto Analytics Dashboard with QuestDB on Windows: A Step-by-Step Guide

Crypto trading never sleeps, and the markets move faster than most databases can keep up. If you’re serious about running a...
Rajandran R
5 min read

DuckDB Tutorial for Traders: A Python Guide

For traders dealing with large datasets, the ability to efficiently analyze and manipulate data is crucial. DuckDB is an in-memory, columnar...
Rajandran R
11 min read

Understanding AngelOne’s Tech Stack

AngelOne is one of India’s largest online stock brokerage firms. Behind its fast, reliable, and high-performance trading platform is a meticulously...
Rajandran R
5 min read

Understanding Zerodha’s Tech Stack

An outsider's deep dive into the Zerodha tech stack: Go, Python, Flutter, Vue.js, PostgreSQL, ClickHouse and self-hosted open source powering the...
Rajandran R
7 min read

OpenEngine – Building Your First Event-Driven Backtesting Engine: A Step-by-Step Research Note

Research note on building OpenEngine, an open source event driven backtesting engine for 1-min data with DuckDB and OpenAlgo PlaceOrder for...
Rajandran R
9 min read

Storing WebSocket Stock Market Tick Data in ClickHouse using Python

Store WebSocket tick data in ClickHouse using Python: a working Angel One script, batch inserts, 1-minute OHLC queries and 2026 library...
Rajandran R
19 min read

[Course] Designing a Stock Market Trading Dashboard App using Python

Build a stock market app using Python in four sessions: fetch data with yfinance, chart it with Plotly, add Flask logins...
Rajandran R
2 min read

Setting Up a Full-Stack Development Environment for Algorithmic Trading using Docker

Creating an efficient development environment for algorithmic trading requires a blend of modern tools and technologies. This guide will walk you...
Rajandran R
4 min read

How to Manage and Visualize Intraday Stock Market Data with SQLite Database – Python Tutorial

In this tutorial, we'll explore how to effectively manage and visualize intraday stock data using Python. We'll cover importing data from...
Rajandran R
3 min read

Backup your Amibroker EOD/Intraday Database in CSV Format

Amibroker export data to CSV: back up your whole EOD or intraday database with one AFL Scan, step by step, plus...
Rajandran R
4 min read