Icon

Challenge 1 - Trends in Stock Prices

Challenge 1: Trends in Stock Prices

Level: Easy

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?

Challenge 1: 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?


Very simple solution: manually filter for the company you are interested in and execute the rest of the workflow.

Solution should just be the line plot view. For 'Google', the most recent data shows the SMA on a uptrend.

Slightly more complex solution: a data app with a widget to filter for the company you are interested in. The line plot gets automatically re-executed every time a new company is selected.
CSV Reader
We only wantdate and close price
Column Filter
convert Dateto date time
String to Date&Time
sort by date from oldestto most recent
Sorter
Get company names
20 window length
Moving Average
Visualize results
Line Plot
Filter for 'Google'as an example
Row Filter
CSV Reader
Visualize company stock prices

Nodes

Extensions

Links