Hello, this is my workflow for this challenge.
I’m using a moving average for 20 days and export the last 20 days percentage variation for every company.
Then all csv are imported to see which company stock is gaining the most (wihtin 20 days).
Hello, this is my workflow for this challenge.
I’m using a moving average for 20 days and export the last 20 days percentage variation for every company.
Then all csv are imported to see which company stock is gaining the most (wihtin 20 days).
Yay! JKI is back!
Here is my solution… quick and dirty… and late.
I built a data app/component that allows you to explore the 20-day moving average data.
basic approach was to use the 20-day moving average of the close value.
Date selection widget let’s you select the day you want to evaluate.
The table lists all companies and the Close for the selected date and corresponding 20-day moving average for that day. Company cells are colored by the trend for stock value (ie when value > 20-day ave, cell is green).
The scatter plot (generic javascript view with Plotly code) is displayed when a company is selected from the table. It displays the Open and Close curves for the date selected and the 19 preceding days and 20-Day Moving average threshold for the date selected.
Enjoy!
Hi @RBre! Thanks for your contribution and welcome aboard! Hope this challenge was insightful for you.
I was wondering where you were! hahaha Welcome aboard!
My answer to the challenge. Took inspiration from the other folks and developed a dashboard with trends. Users can select dates and company of interest.
Link at >> S3C1 - trends in stock prices
Workflows
Dashboard
Is yet on time to publish a solution?
Hi @elimisael ,
Yes, you can still publish the solution
Thanks,
Sanket
Hello,
@kowisoft Well done on this solution. Is there a possibility to develop it further by allowing the option to choose the ‘company’ from a list sorted in alphabetical order? Sorter ?
Thanks
Br
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.