Icon

JustKnimeIt2 - Challenge 01

Just Knime It 2 - Challenge 01: 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?

You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of USdollar 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 theexchange rates of the currencies and visualize them, Which currencies had the highest positive/negative correlation? Whichcurrencies were not correlated, or had a low correlation? USE NODE VIEW ANSWERS:Highest Positive - DTCHGUS x GERMDUSHighest Negative - AUSTRUS x JAPYNUSLowest Correlation (closest to zero) -CDNDLUS x GERMDUS Read Currency Exchange DataConvert to DateCalculates Linear Correlation Coefficients for each pair of Exchange RatesSort Coefficients to identify highest andlowestHighest NegativeReplace Missing ValuesMethod Chosen - Linear InterpolationHighest PositiveLowest Correlation Table Reader String to Date&Time Linear Correlation Sorter Scatter Plot Missing Value Scatter Plot Scatter Plot You are doing research on trading and different currencies and one of your tasks is to compare the daily exchange rates of USdollar 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 theexchange rates of the currencies and visualize them, Which currencies had the highest positive/negative correlation? Whichcurrencies were not correlated, or had a low correlation? USE NODE VIEW ANSWERS:Highest Positive - DTCHGUS x GERMDUSHighest Negative - AUSTRUS x JAPYNUSLowest Correlation (closest to zero) -CDNDLUS x GERMDUS Read Currency Exchange DataConvert to DateCalculates Linear Correlation Coefficients for each pair of Exchange RatesSort Coefficients to identify highest andlowestHighest NegativeReplace Missing ValuesMethod Chosen - Linear InterpolationHighest PositiveLowest CorrelationTable Reader String to Date&Time Linear Correlation Sorter Scatter Plot Missing Value Scatter Plot Scatter Plot

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: faber
Created at: 2023-04-03
On NodePit since: 2023-04-04
Last update: 2024-11-21
Created with KNIME version: v4.7.2
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!