Icon

Financial Time Series Project Workflow

Input

Time alignment + imputation

Transformations + outliers + plots

Decomposition + stationarity evidence

Forecast models (Holt + HW + ARIMA + ML)

Evaluation + exports + config log

Financial Time Series Project

  • Loads daily FDS stock prices, sorts by date, and keeps only Date + Close.

  • Forces a continuous daily timeline (creates a daily calendar), then left-joins prices onto it and fills missing Close values (LOCF) so the timeline is complete.

  • Builds key time-series transforms: LogPrice and LogReturn (a differenced/log-return series).

  • Flags extreme return moves using a 20-day rolling z-score and visualizes price, returns, and outliers.

  • Provides stationarity evidence with ACF/PACF before and after transformation (LogPrice vs LogReturn), plus ACF/PACF tables, ADF test results, and a decomposition plot (trend/seasonal/residual).

  • Trains and evaluates 4 forecasting approaches on a sequential 80/20 hold-out (most recent 20%):
    Holt, Holt-Winters, ARIMA (AIC grid search), and Tree Ensemble ML.

    • Selects the ML look-back window in a data-driven way using sequential validation on candidate windows 5, 10, 20, 40, and 60, then uses the selected look-back for final testing.

  • Produces a final comparison table, MAE/RMSE scores, and exports: cleaned data, predictions, model parameters, and a combined configuration log (manual + auto params).

Full Documentation

Optimizing ML Lookback Parameter

Exports + Config Log

Evaluation

OBS Only
Row Filter
5
Python Script
Tree Ensemble Predictor (Regression)
Table Partitioner
Table Partitioner
10
Python Script
Table Partitioner
Tree Ensemble Learner (Regression)
Numeric Scorer
Tree Ensemble Predictor (Regression)
Numeric Scorer
Table Partitioner
Numeric Scorer
Tree Ensemble Predictor (Regression)
Tree Ensemble Learner (Regression)
Table Partitioner
20
Python Script
Tree Ensemble Learner (Regression)
Table Partitioner
Read FDS_daily.csv
CSV Reader
Parse Date
String to Date&Time
Sort by Date(Past to Present)
Sorter
Only Date + Close
Column Filter
Min & Max Date
GroupBy
Column Renamer
Turn Min & Max Date into Flow Vars
Table Row to Variable
Column Renamer
Only Date & ML Prediction
Column Filter
Tree Ensemble Learner (Regression)
Tree Ensemble Predictor (Regression)
Score ARIMA (MAE/RMSE)
Numeric Scorer
Get Best RMSE
Row Filter
Score ML (MAE/RMSE)
Numeric Scorer
Final Comparison
Joiner
Score HW (MAE/RMSE)
Numeric Scorer
Table Row to Variable
Actual vs. Model
Line Plot
Clean Daily Data
CSV Writer
Model Predictions
Excel Writer
Params + Config Log
Concatenate
Config Log
Excel Writer
Model Parameters
Excel Writer
Config Log
Table Creator
Daily Calendar
Date&Time Range Creator
ACF/PACF Log Return Table
Table View
Calendar + Close
Joiner
ACF/PACF Log Return
Line Plot
ACF/PACF Log Price Table
Table View
ACF/PACF Log Price
Line Plot
Score Holt (MAE/RMSE)
Numeric Scorer
Resort by Date
Sorter
Drop Missing Date Rows
Rule-based Row Filter
Column Filter
Price (Close)
Line Plot
RowID
Drop Overflow RowID
Rule-based Row Filter
Domain for Outlier Flag
Domain Calculator
Outlier = RedOk = Blue
Color Manager
Log Return
Line Plot
Log Return Outliers
Scatter Plot
ACF Log Price
Autocorrelation Plot (Labs)
ACF Log Return
Autocorrelation Plot (Labs)
Color Appender
ADF Results + p Value
Table View
Stats 80/20
Table Partitioner
Decompose + ADF
Python Script
Decomposition
Line Plot
ML 80/20
Table Partitioner
Holt + Holt-Winters + ARIMA Forecast + Params
Python Script
ML Feature Table
Python Script
Numeric Scorer
Table Partitioner
Table Partitioner
Tree Ensemble Predictor (Regression)
Tree Ensemble Predictor (Regression)
Table Partitioner
Tree Ensemble Learner (Regression)
40
Python Script
Table Partitioner
Numeric Scorer
60
Python Script
Constant Value Column Appender
Constant Value Column Appender
Tree Ensemble Learner (Regression)
Constant Value Column Appender
Concatenate
Impute Close (Prev Value)
Missing Value
Rank RMSE
Sorter
Constant Value Column Appender
Constant Value Column Appender
Log Return
Math Formula
Rolling Mean/SD(20 Days)
Moving Aggregator
Log Price
Math Formula
Row Filter
Lag Log Price
Lag Column
OutlierFlag
Rule Engine
DayType(OBS/IMPUTED)
Rule Engine
Column Renamer
Z-Score(20 Days)
Math Formula

Nodes

Extensions

Links