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
Data and tools
4 pages carry this tag.
Concept Guides
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
Related topics: Valuation, DCF, Relative valuation, Cost of capital, Financial statements, Cash flow, Earnings quality, Red flags