Icon

20230403_​Pikairos_​JustKnimeIt_​Season2_​Challenge1_​ComparingExchangeRates

Challenge 01: Comparing Exchange Rates

This workflow compares the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998.
Linear interpolation has been used to fill in missing values in the data.
The data can be visualized in linear, normalized or logarithmic format using a selection widget.
The linear correlation between the different exchange rates has been calculated and displayed in an interactive heat map.

Which currencies had the highest positive/negative correlation?
- Highest positive correlation between Germany, Switzerland and Denmark with values between 0.98 and 0.99
- Highest negative correlation between Australia and Japan at around -0.6

Which currencies were not correlated, or had a low correlation?
- No correlation between Canada and Germany with a value of 0.0015

Challenge 01: Comparing Exchange RatesThis workflow compares the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998.Linear interpolation has been used to fill in missing values in the data.The data can be visualized in linear, normalized or logarithmic format using a selection widget.The linear correlation between the different exchange rates has been calculated and displayed in an interactive heat map. Which currencies had the highest positive/negative correlation? - Highest positive correlation between Germany, Switzerland and Denmark with values between 0.98 and 0.99 - Highest negative correlation between Australia and Japan at around -0.6Which currencies were not correlated, or had a low correlation? - No correlation between Canada and Germany with a value of 0.0015 ExchangeRate DataConvertString Date toDate TypeLinear Interpolationof MissingValuesSelect Whether toDisplay Linear, Normalizedor Logarithmic Data Table Reader String to Date&Time Missing Value Calculate Correlation ForBoth Raw and Normalized Data Challenge 01: Comparing Exchange RatesThis workflow compares the daily exchange rates of US dollar vs 8 other currencies from 1980 to 1998.Linear interpolation has been used to fill in missing values in the data.The data can be visualized in linear, normalized or logarithmic format using a selection widget.The linear correlation between the different exchange rates has been calculated and displayed in an interactive heat map. Which currencies had the highest positive/negative correlation? - Highest positive correlation between Germany, Switzerland and Denmark with values between 0.98 and 0.99 - Highest negative correlation between Australia and Japan at around -0.6Which currencies were not correlated, or had a low correlation? - No correlation between Canada and Germany with a value of 0.0015 ExchangeRate DataConvertString Date toDate TypeLinear Interpolationof MissingValuesSelect Whether toDisplay Linear, Normalizedor Logarithmic Data Table Reader String to Date&Time Missing Value Calculate Correlation ForBoth Raw and Normalized Data

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: LAMBERT
Created at: 2023-03-29
On NodePit since: 2023-04-03
Last update: 2024-04-27
Created with KNIME version: v4.7.2
Tags: JKISeason2-1Line Plot (Labs)Linear CorrelationRefresh Button WidgetSingle Selection WidgetHeatmap (Labs)Rule Engine VariableCase SwitchNormalizer

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

Try NodePit Runner!