Solutions to "Just KNIME It!" Challenge 1 - Season 3

:boom: Aaaaaand we’re back for our third Just KNIME It! season! :boom:

:chart_with_upwards_trend: Let’s kick off this season with an easy challenge on finance: how do stock prices vary for different companies over time? For which ones do we see a recent upward trend in prices? And how about downward trends? :chart_with_downwards_trend:

:star_struck: We cannot wait to see your solutions! You always keep us on our toes! :smiling_face_with_three_hearts:

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason3-1.

:sos: Need help with tags? To add tag JKISeason3-1 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :slight_smile: Let us know if you have any problems!

12 Likes

Hi @alinebessa :wave: :slightly_smiling_face:

Tonight, I have already created a solution for the ‘Just KNIME It!’ Challenge 1 - Season 3, which can be accessed through this link,

10 Likes

Hi all and @alinebessa :slight_smile:

Here is my solution:

I found this quite interesting and one thing I have learned (or discovered) is to aggregate strings into a set (for a single selection configuration).

Within my solution I have a dashboard component (Comparing Stock Prices) which you first double click to configure the 2 companies to compare and then right click and open views to see the two charts.

Not sure if this counts as a solution as I basically let the user decide which 2 companies to compare.

10 Likes

Hi @alinebessa

This was a fun challenge. Using a cluster analysis, I tried to visualize the stock market prices of the various companies, bases on a moving average window of 20 days. Red is the lowest realized price in this period, green is the highest realized price. The number of clusters is arbitrary and a matter of trying what best suits the issue.

12 Likes

Hola, es mi primera vez particpando de estos retos, aqui mi solucion

9 Likes

I created a dashboard to look at the data. Fun challenge!

11 Likes

Thanks for joining our community! :smiley:

4 Likes

Here’s my solution. Two charts - w/ & w/o trendlines. I’ve also added a related workflow which downloads a list of of ticker prices from Yahoo Finance.

9 Likes

Hi all and @alinebessa.
Here is my proposed solution:

I have created two types of dashboards.

The first one allows you to plot data for multiple companies on a single plot.
Additionally, you can modify the window length and apply range filters.

The second dashboard is created using Python View Node. It enables you to overlay a moving average chart onto a candlestick plot. The candlestick plot is generated using Plotly, allowing you to execute the script within the bundled environment.

14 Likes

Link to my solution : Season 3 Challenge 1 – KNIME Community Hub

  • Added a upload file component, so that you can upload any stocks file on your computer (that has date, company name and closing price) can be visualized using this workflow.

  • Ability to choose time frame and company of choice

Happy KNIMEing :slight_smile:

16 Likes

Here my solution for this challenge: just decision upward/downward…

13 Likes

Hi all, here is my solution:

10 Likes

Hi all,
This is my solution.

13 Likes

Is it at the Easy level, right?
I participated in a private study group, sparked by JKISeason3. Thank you for this great opportunity.
#BD勉協会
https://x.com/KDBenkyo

Here is my solution:

9 Likes

Here is my solution. To find upward and downward trends, I calculated the RSI (relative strength index) for each company. RSI was calculated based on a moving average period of 20. I then sorted each company if RSI was greater than 70 (trending up) or below 40 (trending down). Excited to finally participate in my first Just KNIME It challenge! :slight_smile:

7 Likes

I have uploaded the revised workflow with two new functions (v1.1.0).

First, a Calender filter was added to the Line Plot Dashboard.

Second, a new dashboard was added to check recent trends.
You can easily change the duration on the dashboard and check plot of the selected company.

7 Likes

Hello everyone,
Here is my solution. It’s similar to @jm1950sjr 's.
You can see a price trend of your chosen company by looking at Increase(%) on the table, line and barchart. Thank you.

10 Likes

Hello everyone, this is my first experience participating in the JustKNIMEIt Challenge. I feel that this workflow is still very lacking. I did the best I could. I also haven’t been able to create a dashboard in KNIME, so I made a basic one for now😁

7 Likes

Hi all, here is my solution.
I used not only moving avarage node but also liner regression learner node to attempt to identify trends using the coefficient amount of change over the most recent 20 days.

7 Likes

My take on Season 3’s 1st challenge .

7 Likes