Excel File Used in the Meeting - Please note this file is different than what is in the video. This is the file used in the meeting.

 

Excel is an excellent tool to learn how backtesting works. However, after watching the video and inspecting the Excel file above, one can see several drawbacks to using Excel

• It's easy to make errors during backtesting

• Testing strategies that use sophisticated rules or require data from numerous markets can be complicated and challenging to backtest

 

A better solution to excel is using a programming language. C++ and Python tend to be the most common languages used in Quantitative Finance. You can learn more about backtesting using Python by visiting the September 24th, 2018 meeting page.

 

During the meeting, we talked about prerequisites for graduate Quantitative Finance programs. You can find out more about those prerequisites on the Quantitative Skills page.