Icon

JKISeason3-1_​tomljh

Trends in Stock Prices

Level: Easy

Description: You work in finance and one of your clients wants to understand the value of different company stocks over time. Given a dataset of stock prices, you decide to use simple moving averages (window length = 20) to tackle this task. What companies have an upward trend for the most recent data? And what companies have a downward trend?

Author: Thor Landstrom

Dataset: Stock Data in the KNIME Community Hub

Remember to upload your solution with tag JKISeason3-1 to your public space on the KNIME Community Hub. To increase the visibility of your solution, also post it to this challenge thread on the KNIME Forum.

Data preprocessing Visualization Read stock datastock_details_5_years.csvDate Time Format Conversion-5: 00 indicates in the West Fifth Zonegroup by CompanyDelete some columns:DividendsStock SplitsLag = 20window periodCalculate the cumulative growth rate of stock price during the window periodRecent trends CSV Reader String to Date&Time Group Loop Start Column Filter Lag Column Math Formula Rule Engine Loop End Display stock price Data preprocessing Visualization Read stock datastock_details_5_years.csvDate Time Format Conversion-5: 00 indicates in the West Fifth Zonegroup by CompanyDelete some columns:DividendsStock SplitsLag = 20window periodCalculate the cumulative growth rate of stock price during the window periodRecent trends CSV Reader String to Date&Time Group Loop Start Column Filter Lag Column Math Formula Rule Engine Loop End Display stock price

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: Admin
Created at: 2024-05-15
On NodePit since: 2024-05-21
Last update: 2024-11-13
Created with KNIME version: v5.2.3
Tags: JKISeason3-1echarts

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

Try NodePit Runner!