Lets build it in Excel. The first thing to do is to get historical financial data into Excel using the STOCKHISTORY function.
1. Enter "Start date" in cell K8 and the date 12/1/2015 in cell L8.
2. Enter "End date" in cell K9 and the date 4/30/2021 in cell L9.
3. Next, we need to define the ticker symbols for the currencies, for that enter EUR, USD, JPY and GBP in cells K11, L11, M11 and N11 respectively. The worksheet should look like this: