Welcome to StratCamp:

The #1 Intro to Coding Program
for Finance Professionals


  • Python, SQL, Excel, VBA, Data Engineering, Data Viz, Linux, etc
  • Weekly drip-course with topics in computer science focused on the finance industry taught by Mark Ross, former VP on Morgan Stanley's Trading Desk
  • Each module includes a bonus finance lecture and a homework assignment dedicated towards the content of that module. Homework solutions will be provided in the following week.
  • Access our private Slack channel to post questions where other students and a dedicated TA will engage with you.
  • TA will host weekly sessions to discuss any questions you might have regarding the course material or homework
Go To Course Syllabus

Contact Mark to Learn More

Have a course instructor reach out to answer any questions you might have about the program.

Financial Applications

Each module is paired with applications tailored specifically for the finance industry

Python. SQL. VBA.

StratCamp covers all major coding languages and topics used in banking and hedge funds

Career Advancement

StratCamp equips you with the skills needed to advance your career in finance.

No coding background?
StratCamp has your back.

Many of our students with no previous coding experience, are now working at top investment banks and hedge funds!

Register for StratCamp

StratCamp Course Syllabus

Objective: Introductory comprehensive training in programming, database management, data analysis, and technological tools as applied in finance for banks and hedge funds.

Module 1: Introduction to Python for Finance

Duration: 6 Weeks

  • Week 1-2: Python Basics
    • Environment Setup (Jupyter Notebook, Linux, VS Code, Git)
    • Introduction to Python
    • Variables, Data Types, and Operations
    • Control Flow: Conditions and Loops
    • Basic Data Structures: Lists, Tuples, Sets, Dictionaries
    • String Manipulation
  • Week 3-4: Intermediate Python
    • User Defined Functions
    • Using Visual Studios
    • Modules
    • List Comprehensions
    • Handling Exceptions
    • Working with Files
    • Linux 101
  • Week 5-6: Applied Python in Finance
    • Introduction to NumPy and Pandas
    • Basic Financial Analysis
    • Time Series Data Handling
    • Introduction to APIs and Data Acquisition

Tools Covered: Jupyter Notebook, VS Code, Linux

Bonus Financial Model: Intro to Pricing Financial Derivatives

Module 2: SQL for Financial Data Management

Duration: 6 Weeks

  • Week 1-2: SQL Basics
    • MySQL Setup
    • Table Design Protocol 
    • Database Fundamentals
    • Basic SQL Syntax
    • Queries, Sorting, and Filtering Data
    • IfNull & Coalesce
    • Case When
    • Functions & Group By
  • Week 3-4: Intermediate SQL
    • Database Schema
    • Keys & Table Creation
    • Indices and Performance Tuning
    • Data Management
    • Views
    • Aggregation and Summarization
    • Joins
    • Unions
  • Week 5-6: Advanced SQL for Finance
    • Subqueries
    • Common Table Expressions
    • Temp Tables
    • Windows Functions
    • Advanced Syntax
    • Stored Procedures and Automation

Tools Covered: MySQL Workbench, Autosys Jobs

Bonus Financial Model: Exchange-Transform-Load Trading Data

Module 3: Excel for Financial Modeling

Duration: 2 Weeks

  • Week 1: Basics of Excel in Finance
    • Spreadsheet Management
    • Formulas and Functions
    • Compounding Interest Rates
    • Discount Factors
    • Bond Pricing
  • Week 2: Advanced Excel Techniques
    • Advanced Lookups
    • Text Manipulation
    • Data Validation and What-If Analysis
    • PivotTables and Advanced Graphing
    • Filter Formulas

Tools Covered: Microsoft Excel

Bonus Financial Model: Historical Value at Risk

Module 4: Automation with VBA

Duration: 4 Weeks

  • Week 1-2: Introduction to VBA
    • Basics of VBA Programming
    • Data Structures
    • Loops & Conditional Statements
    • Working with Excel Objects & Ranges
    • Error Handling
    • Debugging Techniques
  • Week 3-4: Advanced VBA
    • Automating Repetitive Tasks
    • Events
    • UserForms and Controls
    • Dictionaries
    • File Handling
    • Object Oriented Programming
    • Portfolio of Derivatives

Tools Covered: Microsoft Excel VBA Editor

Bonus Financial Model: Black Scholes & Binomial Asset Pricing Model

Module 5: Advanced Python for Finance

Duration: 2 Weeks

  • Week 1: Code Efficiency
    • Logging
    • Generator Expressions
    • Concurrency
    • Multi-Threading
    • Multi-Processing
  • Week 2: Object-Oriented Programming
    • Core Principles & Introduction
    • Stock Portfolio with Encapsulation
    • Decorators
    • Advanced OOP Techniques
    • Best Practices & Code Organization

Tools Covered: VS Code, Jupyter Notebook, Various Python Libraries

Bonus Financial ModelSending Price Updates via Email

Module 6: Data Visualization in Finance

Duration: 3 Weeks

  • Week 1: Python
    • Connecting to MySQL
    • Plotly
    • MatPlotLib
  • Week 2: Excel VBA
    • Connecting to MySQL
    • How to Handle Raw Data
    • Parameters
    • VBA Macros
    • Automating Report Generation & Exporting to PDF
  • Week 3: Tableau
    • Connecting to MySQL
    • Joining Tables
    • Creating Basic Visualizations

Tools Covered: Python, Excel VBA, Tableau

StratCamp Case Study:
Building a Mock Trading Dataset in Python

 

Additional Tools and Skills:
Throughout the program, participants will gain familiarity with Linux, Virtual Machines, Jupyter Notebook, and various Integrated Development Environments (IDEs) essential for a successful career in finance technology.

Enforced Learning:
The program will include weekly assignments, module-end projects, and a case study to apply all the learned skills in a comprehensive financial analysis or trading strategy.

Certification:
Participants will receive a certificate upon successful completion of the program, demonstrating their proficiency in coding and technology as applied in the finance sector.

This syllabus is designed to be both rigorous and practical, with a strong emphasis on the applications of each skill in the financial industry, preparing participants for immediate and impactful contributions in their future roles.

Register for StratCamp