Icon

Challenge 1 - Trends in Stock Prices (JKISeason3-1)

- Almost uniform- All end on same data- Few start late- Cound and Unique Countr of data values match- No duplicate values Some stocks have a slightly offset trading date.That results in an non uniform 20 day window. Solution- Get min / max of date- Loop over min date recursively- add 19 days (start day +19 = 20)- Overwrite min date by new shifted date- +1 to new overwritten min date- determine loop stop- reiterate Method #2, using GroupBy, only used out ofcuriosity and for personal training. Check Interactive View--> Most right columns after histogram Check Interactive View Node 1Node 2UniqueCompaniesCompany toIndustry mappingCheck datauniformity perDateFirst Close Valueper CompanyTOPCompanies onlyBOTTOMTrading PeriodAddCompany DetailsTOPCompaniesBOTTOMMarket DataMethod #2Method #1TOP - Upwards TrendMean > InitialClosign ValueBOTTOM - Downwards TrendMean <= IInitialClosign Value CSV Reader String to Date&Time GroupBy Table Creator GroupBy Generate harmonizedTrading Period GroupBy Column Splitter Create Columns for SplittingWinners from Loosers Value Lookup Calculate and addMarket Performance Column Splitter GroubBy Methodusing simple Mean Simple ExponentialMoving Average Company & Market Statistics withStock Development Categorizations Rule-basedRow Splitter Stock & Markets - Almost uniform- All end on same data- Few start late- Cound and Unique Countr of data values match- No duplicate values Some stocks have a slightly offset trading date.That results in an non uniform 20 day window. Solution- Get min / max of date- Loop over min date recursively- add 19 days (start day +19 = 20)- Overwrite min date by new shifted date- +1 to new overwritten min date- determine loop stop- reiterate Method #2, using GroupBy, only used out ofcuriosity and for personal training. Check Interactive View--> Most right columns after histogram Check Interactive View Node 1Node 2UniqueCompaniesCompany toIndustry mappingCheck datauniformity perDateFirst Close Valueper CompanyTOPCompanies onlyBOTTOMTrading PeriodAddCompany DetailsTOPCompaniesBOTTOMMarket DataMethod #2Method #1TOP - Upwards TrendMean > InitialClosign ValueBOTTOM - Downwards TrendMean <= IInitialClosign Value CSV Reader String to Date&Time GroupBy Table Creator GroupBy Generate harmonizedTrading Period GroupBy Column Splitter Create Columns for SplittingWinners from Loosers Value Lookup Calculate and addMarket Performance Column Splitter GroubBy Methodusing simple Mean Simple ExponentialMoving Average Company & Market Statistics withStock Development Categorizations Rule-basedRow Splitter Stock & Markets

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: Mike Wiegand
Created at: 2024-05-15
On NodePit since: 2024-05-22
Last update: 2024-09-16
Created with KNIME version: v5.2.4
Tags: JKISeason3-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!