Aaaaaand we’re back for our third Just KNIME It! season!
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?
We cannot wait to see your solutions! You always keep us on our toes!
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.
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. Let us know if you have any problems!
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.
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.
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.
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.
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
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. 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!
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.
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😁
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.
Aaaaaand we’re back for our third Just KNIME It! season! 
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? 
We cannot wait to see your solutions! You always keep us on our toes! 
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. 
Let us know if you have any problems!
