Full Technical Index

Comprehensive directory of all video lessons, codebases, and financial models.

Excel: Finance & Ops

Amortization Tables PMT Loan Calculations NPER / Loan Payoff NPV, IRR & ROI One-Way Data Tables Two-Way Data Tables VLOOKUP Essentials Pivot Table Intro Optimization w/ Solver Transportation Networks Portfolio Optimization Portfolio Variance Reinvesting Dividends Value at Risk (VaR) Option Valuation (MCS)

Python Ecosystem

Streamlit Web Apps OOP Foundations Algo Trading Intro Mean Reversion Logic Alpha Vantage API EOD Historical Data API Data Analysis Workflow MCS with Python NumPy Basics NumPy Financial Pandas DataFrames Rolling Methods Pipenv Environments Matplotlib Viz Reading CSV Files

Stats & SQL

MySQL

Basic Queries Schema Design Joins (Inner/Outer) Subqueries ERD Diagrams

Statistics

Confidence Intervals Correlation Analysis Descriptive Stats T-Test Functions Linear Regression Scatter Plot Interpretation

Specialized Tools