Icon

Big Data Term Project

AMD Cleaning Data and Quality Check

S&P500 Cleaning Data and Quality Check

NVDIA Cleaning Data and Quality Check

Return

Assign the Period

Get Out of S&P500

Standard Deviation

Calculate |t-value|

Get Back In S&P500

Standard Deviation

Calculate |t-value|

p-value

p-value

JoinerColumn FilterColumn mergerString to NumberMissing ValueTimestamp
Clean the Data
CSV Reader
CSV Reader
CSV Reader
CSV Reader
3 year before out
Date&Time-based Row Filter
|t-value|
Math Formula
Quality check
Evaluate Data Quality
3 year after got out
Date&Time-based Row Filter
Find T-Value
Add mission value on day off and find simple return of S&P 500
Calculate Return
Integrate AMD and S&P 500 data (price, return, volume)
Joiner
3 year before Re-enter
Date&Time-based Row Filter
Find T-Value
Add mission value on day off and find simple return of AMD
Calculate Return
3 year before out
Date&Time-based Row Filter
Degree of freedom
Column Filter
3 year after re-enter
Date&Time-based Row Filter
|t-value|
Math Formula
Add mission value on day off and find simple return of NVDIA
Calculate Return
3 year after got out
Date&Time-based Row Filter
Sharpe ratio
Column Filter
STDEV
Find T-Value
Stdev
Column Filter
|t-value|
Math Formula
STDEV
Degree of freedom
Column Filter
Joiner
Stdev
Column Filter
P_Value
JoinerColumn mergerColumn FilterMissing ValueTimestamp
Clean the Data
Sharpe ratio
Column Filter
P_Value
|t-value|
Math Formula
P_Value
Find T-Value
P_Value
STDEV
Degree of freedom
Column Filter
3 year after re-enter
Date&Time-based Row Filter
Stdev
Column Filter
3 year before Re-enter
Date&Time-based Row Filter
Sharpe ratio
Column Filter
Joiner
Joiner
Compare MA(return) of AMD, NVDA and S&P 500 3 years before out and after out
Visualization
STDEV
Joiner
Compare MA(return) of AMD, NVDA and S&P 500 3 years before re-enter and after re-enter
Visualization
Sharpe ratio
Column Filter
JoinerColumn FilterColumn mergerString to NumberMissing ValueTimestamp
Clean the Data
CSV Reader
CSV Reader
CSV Reader
Quality check
Evaluate Data Quality
CSV Reader
Stdev
Column Filter
CSV Reader
Degree of freedom
Column Filter
Quality check
Evaluate Data Quality

Nodes

Extensions

Links