Stage 1 (2024) “Data King”


This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2024, Stage 1 (January 26-29).

Case description:

You have been provided with a large dataset containing daily FX rate fluctuations data for the major currency pairs1. The dataset has been deliberately selected to contain more than 1 million entries, which is more rows than Excel can handle. If you just load the data file into Excel, it will only show you the first 1,048,575 entries (+1 row of column headers). This will be enough to answer Part 1 questions. However, to answer Part 2 questions, you will need to load the data in a different way (hint: try using Power Query).

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with Dataset
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold