Icon

Challenge 1 - Comparing exchange rates

Comparing exchange rates

You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998. The data contains some missing values due to public holidays on weekdays, which you should handle first using a strategy of your choice. After that, you should calculate the correlations between the exchange rates of the currencies and visualize them, Which currencies had the highest positive/negative correlation? Which currencies were not correlated, or had a low correlation?

The highest positive correlation was between the Swiss, German, and Dutch currencies. The highest negative correlation was between the Australian and Japanese currencies. The correlation was closest to zero between the Canadian currency and Dutch/German currencies.
Challenge 1: Comparing Exchange Rates

Level: Easy

Description: You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998. The data contains some missing values due to public holidays on weekdays, which you should handle first using a strategy of your choice. After that, you should calculate the correlations between the exchange rates of the currencies and visualize them, Which currencies had the highest positive/negative correlation? Which currencies were not correlated, or had a low correlation?

Dataset:Exchange Rates Data

Linear Correlation
US dollar rates
Table Reader
Replace missing values with previous days' valuea (no change while the stock market was closed)
Missing Value
Visualize linear correlations between currencies
Heatmap (JavaScript) (legacy)

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: daria.liakh
Created at: 2022-08-11
On NodePit since: 2026-05-05
Last update: 2026-05-05
Created with KNIME version: v5.11.0
Tags: time seriesjustknimeitcorrelationmissing data imputationeasyJKISeason2-1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!