Icon

01_​Stocks1 (Working one) 4.3

Stock Analysis: Automatic value prediction and alerting The input to this workflow is a list of stock symbols from Yahoo Finance. After some preprocessing to determine the date range, this information is sent to the pandas webreader library (through the Python Source node) to collect (near) realtime stock information. The information is sent to the modeling workflow (through the Call Workflow node) where feature creation, model estimation, and prediction takes place for each stock symbol. This workflow collects the predictions and the reliability of the model, and visually displays the results - the expected percentage change in value for each stock symbol. Note: To use this workflow you need to have Python and the following libraries installed on your machine: -pandas as pd -pandas-datareader -datetime
This section creates the workflow variables that are sent to the Python Source node
The workflow variables are sent to the Python Source node, which gathers historical data for each symbol. It can occur that data for a specific symbol is (temporarily) unavailable, in which case a value of -99 is returned. These cases are sent to the bottom port of the If Switch node and are filtered out after the Loop End node.
The predicted increased in stock value is sorted and exported to a plot and .csv files. When deployed on KNIME server, the Send Email node can be used to alert traders of potential interesting stock developments on a daily basis. Authentication is supported via workflow or node level credentials; connection security via STARTTLS and SSL are both supported.
Extract today's date
Create Date&Time Range
Deduct one day
Date&Time Shift
Prediction Cycle
Merge date variables with stock symbol
Merge Variables (deprecated)
Determine stock availability
Table Row to Variable Loop Start
Attach .csv file and plot of stock predictions to an e-mail
Send Email
Sort symbols by expected % increase
Sorter
Filter unavailable symbols
Rule-based Row Filter
Unavailable Symbols are set to -99
Set format for unavailable stocks
Loop End
Bar Chart (JavaScript)
Write daily predictions to a .csv
CSV Writer (deprecated)
Add predictions to history file
CSV Writer (deprecated)
+ RSI
Python Source (legacy)
End IF
IF Switch
Column Filter
Convert to workflow variables
Table Row to Variable (deprecated)
Decompose date to day, month and year
Extract Date&Time Fields (deprecated)
Export plot to a file
Image Writer (Port) (deprecated)
Insert a list of stock symbols
Table Creator

Nodes

Extensions

Links