Icon

Just KNIME It S02 _​ CH01 _​ 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?

Author: @alinebessa


DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.

Just KNIME It - Season2 - Challenge01: Comparing Exchange Rates 1) Handle missing values 2) Visualize linearcorrelations challenge 01datasetDate formatfill gaps w. selected parameter (double click on component: available: mean, median, binned mode)...requires one Date formated columncomputes statistical imputation based on week day diferentials by columnupper: imputed valueslower: differentials(-1) 0/00visualize exchange rates correlation values ...select normalized z-scorevalues or day differentialsQC sort dateseries Table Reader String to Date&Time Statistical ImputationGrouped by Week Day Exchange RatesCorrelation Sorter Just KNIME It - Season2 - Challenge01: Comparing Exchange Rates 1) Handle missing values 2) Visualize linearcorrelations challenge 01datasetDate formatfill gaps w. selected parameter (double click on component: available: mean, median, binned mode)...requires one Date formated columncomputes statistical imputation based on week day diferentials by columnupper: imputed valueslower: differentials(-1) 0/00visualize exchange rates correlation values ...select normalized z-scorevalues or day differentialsQC sort dateseries Table Reader String to Date&Time Statistical ImputationGrouped by Week Day Exchange RatesCorrelation Sorter

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: gabeg
Created at: 2023-03-29
On NodePit since: 2023-04-04
Last update: 2024-11-04
Created with KNIME version: v4.7.1
Tags: JKISeason2-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!