Icon

Financial Time Series Project Workflow

Input

Time alignment + imputation

Transformations + outliers + plots

Decomposition + stationarity evidence

Forecast models (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 3 forecasting approaches on a sequential 80/20 hold-out (most recent 20%):
    Holt-Winters, ARIMA (AIC grid search), and Tree Ensemble ML (look-back = 20).

  • 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

Resort by Date
Sorter
OBS Only
Row Filter
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-Winters + ARIMA Forecast + Params
Python Script
ML Feature Table(Lookback 20)
Python Script
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
Score ML (MAE/RMSE)
Numeric Scorer
Final Comparison
Joiner
Score HW (MAE/RMSE)
Numeric Scorer
Actual vs. Model
Line Plot
Clean Daily Data
CSV Writer
Model Predictions
Excel Writer
Params + Config Log
Concatenate
Impute Close (Prev Value)
Missing Value
Config Log
Excel Writer
Model Parameters
Excel Writer
Config Log
Table Creator
Daily Calendar
Date&Time Range Creator
Log Return
Math Formula
ACF/PACF Log Return Table
Table View
Calendar + Close
Joiner
Rolling Mean/SD(20 Days)
Moving Aggregator
ACF/PACF Log Return
Line Plot
Log Price
Math Formula
ACF/PACF Log Price Table
Table View
Lag Log Price
Lag Column
ACF/PACF Log Price
Line Plot
OutlierFlag
Rule Engine
DayType(OBS/IMPUTED)
Rule Engine
Column Renamer
Z-Score(20 Days)
Math Formula

Nodes

Extensions

Links