Data and tools

    Excel conventions, Python, SQL, and where to find Indian market data.

    4 guides. Read in order, or jump to what you need.

    Concept Guide

    Excel modeling conventions

    The conventions that make a financial model easy to audit: colour coding, no hard-coded numbers, a clear structure, error checks and documentation.

    8 min readRead more
    Concept Guide

    Python for finance (pandas, yfinance, numpy)

    Python for financial analysis: pandas, numpy, matplotlib and yfinance, vectorised calculations, storing data in Parquet, and notebooks versus scripts.

    9 min readRead more
    Concept Guide

    SQL for finance data

    SQL for financial databases: filtering, aggregations, joins, window functions for growth and running totals, CTEs and query optimisation.

    8 min readRead more
    Concept Guide

    Where to find Indian markets data

    Where to find Indian market data: exchange filings, SEBI, RBI DBIE, MCA21 and GSTN, plus aggregators such as Screener and Tijori, and their limits.

    7 min readRead more