Concept Guide
Excel Modeling Conventions
A financial model is only as useful as it is understandable, auditable, and error-resistant.
8 min readRead more
Excel conventions, Python, SQL, and where to find Indian market data.
4 guides. Read in order, or jump to what you need.
A financial model is only as useful as it is understandable, auditable, and error-resistant.
Python has become the dominant language for quantitative finance, data analysis, and financial automation.
Financial databases are large, structured, and relational, multiple tables linked together by common keys (company ID, period, instrument identifier).
Good analysis starts with good data. For Indian markets, the data landscape is fragmented, primary sources (exchange filings, regulatory databases, RBI, MCA) are authoritative but require navigation.