// the find
areed1192/sigma_coding_youtube
This is a collection of all the code that can be found on my YouTube channel Sigma Coding.
A YouTube tutorial companion repo covering Python, VBA, JavaScript, M Language, and T-SQL — primarily aimed at Windows/Office power users who want to automate Excel, Outlook, Word, and call financial APIs from Python. It's companion code to watch alongside videos, not a library you'd install or depend on.
The Win32COM coverage is unusually thorough — controlling Office applications from Python via COM is a legitimate and underserved topic that most tutorials skip. The VBA section covers the full Office suite including Access, Publisher, and PowerPoint, not just the usual Excel-only content. The finance angle (TD Ameritrade streaming, SEC EDGAR scraping, machine learning on stock data) gives it a coherent audience rather than being random tutorial soup. T-SQL making API requests and reading Excel files is genuinely useful for SQL Server shops that don't want to leave the database layer.
Dead in the water since March 2022 — TD Ameritrade API no longer exists (acquired and shut down), so a significant chunk of the finance examples simply don't work anymore. No requirements files, environment setup instructions, or dependency pinning anywhere in the Python code, which means getting any of the notebooks running requires archaeology. The repo is a flat dump of video companion files with no tests, no abstractions, and no reusable library surface — useful while watching the video, not useful as reference material afterward. Jupyter notebooks with no cell outputs means you can't tell at a glance if the code even ran successfully.