Systemic Docs

Name	Type	Description
Price Data	floatarray	To compute the Cumulative Return (CR) trading indicator, the following price data inputs are used:

Name	Type	Description
Cumulative Return	floatarray	- Definition; The final value representing the total percentage change in the asset's price from the beginning of the period to the end, considering compounding effects.

A practical guide to using Cumulative Return (CR) for evaluating total investment performance, comparing strategies, and understanding compounding in both traditional and crypto markets.

Overview

Cumulative Return (CR) measures the total compounded return of an investment or strategy over a specified period. Unlike simple or periodic returns, CR captures the effect of compounding, providing a holistic view of performance. It is widely used by traders and investors to compare assets, strategies, and portfolios over time.

Why CR matters:

Total performance insight: Shows the true growth (or loss) of an investment, including compounding.
Strategy comparison: Enables apples-to-apples comparison of different assets or strategies over the same period.
Cross-asset utility: Used in stocks, ETFs, crypto, and portfolios.

Quick links:

How It Works

Cumulative Return is calculated by compounding the returns of each period, reflecting the total growth of an initial investment. It is not simply the sum of returns, but the product of (1 + each return), minus 1.

Formula

\text{Cumulative Return} = \prod_{i=1}^{n} (1 + r_i) - 1

Where $r_i$ is the return for period $i$ .

Alternatively, it can be calculated incrementally:

\text{CR}_t = (1 + r_1) \times (1 + r_2) \times \ldots \times (1 + r_t) - 1

Calculation Flow

flowchart TD
    Start --> PeriodicReturns
    PeriodicReturns --> AddOne
    AddOne --> MultiplyAll
    MultiplyAll --> SubtractOne
    SubtractOne --> CumulativeReturn
    Start[Initial Value]
    PeriodicReturns[Calculate Periodic Returns]
    AddOne[Add 1 to Each Return]
    MultiplyAll[Multiply All '1 + r_i']
    SubtractOne[Subtract 1]
    CumulativeReturn[Cumulative Return]

Missing Data

CR anchors once, at the first observed price in the series, and computes every slot independently against that same anchor:

Closed-market gaps (e.g. weekends) stay gaps. A missing input slot produces None in the output — never a carried-forward (stale) value, never a sentinel like 0.
No propagation. Because CR is a per-position ratio against a fixed anchor rather than a recursive or windowed computation, a gap never contaminates neighboring slots: the value the day after a gap is computed exactly as if the gap were not there.
Leading nulls don't poison the anchor. If the series opens with nulls, the anchor is the first observed price, not raw position 0 — those leading slots are None until the anchor is found.
Live mode. CR returns exactly one value for a live request: the most recent slot's CR, or None if that slot itself is a closed-market gap (the anchor is otherwise unaffected).

Interpretation and Use Cases

Typical Ranges

CR values: Can be negative (loss) or positive (gain). Expressed as a decimal or percent.
Longer periods: CR increases in magnitude (positive or negative) with time and volatility.

How to Interpret CR

Positive CR: Indicates net growth over the period. For example, a CR of 0.25 means a 25% total gain.
Negative CR: Indicates net loss. A CR of -0.40 means a 40% total loss from the starting value.
CR near zero: Suggests little net change, possibly due to high volatility but no clear trend.
CR and volatility: High volatility can result in a lower CR even if there are large up and down moves, due to the compounding effect of losses.

Practical Use Cases

Performance comparison: Compare the total return of two stocks, ETFs, or crypto assets over the same period to see which performed better, regardless of volatility or path.
Strategy evaluation: Assess the effectiveness of a trading algorithm or portfolio allocation by looking at the CR over a backtest or live period.
Drawdown and recovery analysis: Use CR to see how long it takes to recover from a drawdown. For example, after a 50% loss (CR = -0.5), a 100% gain is needed to break even.
Crypto compounding: In crypto, where returns can be highly volatile, CR helps reveal the true effect of compounding, especially when reinvesting staking or yield rewards.
Multi-asset portfolios: Use CR to compare the performance of a diversified portfolio versus individual assets or benchmarks.
Risk-adjusted review: Combine CR with volatility or drawdown metrics to understand if high returns came with excessive risk.

Edge Cases and Pitfalls

Large losses: After a large loss, it takes a much larger gain to recover (e.g., -50% requires +100% to break even).
Path dependency: The order of returns matters; two assets with the same average return can have very different CRs if their return paths differ.
Interim volatility: High volatility can erode CR even if the average return is positive.
Crypto vs. traditional assets: Crypto assets often show higher CRs (positive or negative) due to greater volatility and compounding effects.

Real-World Example: S&P 500 Cumulative Return (2020-2025)

The following chart shows the cumulative return of the S&P 500 (SPY ETF) from January 2020 through December 2025, including the COVID-19 crash, recovery, and subsequent growth. This illustrates how CR captures the total journey of an investment, including dramatic drawdowns and recoveries.

xychart-beta
    title "SPY Cumulative Return (2020-2025)"
    x-axis ["Jan20", "Apr20", "Jul20", "Oct20", "Jan21", "Apr21", "Jul21", "Oct21", "Jan22", "Apr22", "Jul22", "Oct22", "Jan23", "Apr23", "Jul23", "Oct23", "Jan24", "Apr24", "Jul24", "Oct24", "Dec24"]
    y-axis "Cumulative Return (%)" -20 --> 120
    line [0, -10, 1, -1, 15, 30, 36, 43, 48, 37, 28, 17, 26, 29, 42, 50, 62, 72, 80, 112, 114]

Key observations:

COVID Crash (March 2020): CR dropped to approximately -10%, reflecting the rapid market selloff
Recovery: By October 2020, CR had recovered to nearly break-even
Bull Run (2021): CR climbed steadily, reaching ~48% by January 2022
2022 Bear Market: CR declined from 48% to ~17% by October 2022
2023-2025 Rally: CR surged past 100%, ending at approximately 114%

💡 Key Insight: Despite experiencing multiple significant drawdowns (COVID crash, 2022 bear market), the long-term investor holding SPY from January 2020 to December 2025 would have more than doubled their investment. This demonstrates the power of compounding and the importance of a long-term perspective.

Example: Comparing Two Assets

Asset A: +5%, -2%, +3% over 3 periods
Asset B: +2%, +2%, +2% over 3 periods
Cumulative Return A: $(1.05) \times (0.98) \times (1.03) - 1 \approx 0.058$ or 5.8%
Cumulative Return B: $(1.02)^3 - 1 \approx 0.061$ or 6.1%
Interpretation: Even though Asset A had a higher single-period gain, Asset B's steady returns led to a higher CR due to lower volatility and compounding.

Decision Flow Example

flowchart TD
    S[Select Asset or Strategy] --> A[Calculate Periodic Returns]
    A --> B[Compute Cumulative Return]
    B --> C{Compare to Benchmark or Peers}
    C -->|Higher| D[Outperformance]
    C -->|Lower| E[Underperformance]

Data Notes & Practical Usage

Frequency: CR can be calculated on any timeframe (daily, weekly, monthly, etc.).
Data quality: Requires accurate, continuous price data; missing data can distort results.
Compounding: CR reflects compounding; large losses require larger gains to recover.
Pitfalls: CR does not account for risk, volatility, or interim drawdowns—use with other metrics for a full picture.

Implementation & Backtesting Notes

Data hygiene: Ensure no missing or erroneous price data; align timeframes for fair comparison.
Parameter tuning: For strategies, test CR over multiple periods and market regimes.
Risk management: Combine CR with drawdown, volatility, and Sharpe ratio for robust evaluation.
Backtesting: Avoid look-ahead bias; use only data available at each point in time.

Data Alignment in Systemic

When using the Cumulative Return module with inputs from other modules of different frequencies, Systemic automatically aligns the data through upsampling and padding:

Upsampling: Lower-frequency price data is repeated to match higher-frequency data
Padding: Shorter series are extended by repeating the last available value

Important consideration: Since CR is calculated from price changes, repeated values (from upsampling or padding) produce zero returns for those periods. This can dilute the apparent volatility but does not affect the final cumulative return value, only the intermediate path.

For best results, ensure your price data frequency matches your analysis needs before connecting to the CR module.

Comparison: Cumulative Return vs. Other Return Metrics

Metric	Formula	Best For	Practical Implications
Cumulative Return	$\prod (1 + r_i) - 1$	Total compounded performance	Captures compounding, best for long-term or multi-period analysis. Used for comparing strategies, funds, or assets over the same period.
Simple Return	$\frac{P_{end} - P_{start}}{P_{start}}$	One-period or non-compounded	Ignores compounding, only valid for a single period. Not suitable for multi-period or volatile returns.
Log Return	$\sum \ln(1 + r_i)$	Statistical analysis, normality	Useful for risk modeling, portfolio theory, and when returns are small. Log returns are time-additive and preferred in quantitative finance.
Annualized Return	$(1 + CR)^{1/n} - 1$	Comparing across timeframes	Normalizes returns to a yearly basis, allowing fair comparison of assets or strategies with different holding periods.

When to use each:

Cumulative Return: Use for total performance over a period, especially when compounding matters (e.g., multi-year investments, strategy backtests). It is the most intuitive for end-to-end growth.
Simple Return: Use for single-period or non-compounded analysis (e.g., daily or monthly snapshot). Not suitable for multi-period or volatile assets.
Log Return: Use for statistical modeling, risk analysis, or when working with continuous compounding. Log returns are additive over time and preferred in quantitative finance for their mathematical properties.
Annualized Return: Use to compare investments or strategies with different timeframes or holding periods. It allows you to see what the average yearly return would be if the performance continued at the same rate.

Practical Example:

If you want to compare a 3-year crypto strategy to a 1-year stock investment, use annualized return for a fair comparison, but use cumulative return to see the total growth over each period.
For risk modeling or portfolio optimization, use log returns to ensure additivity and normality assumptions hold.

Glossary

Cumulative Return (CR): Total compounded return over a period
Periodic Return: Return for a single period (e.g., day, month)
Compounding: Earning returns on both initial capital and prior gains
Drawdown: Peak-to-trough decline in value
Benchmark: Standard for comparison (e.g., S&P 500, BTC)
Backtesting: Simulating a strategy on historical data

References and Further Reading

For best results, use Cumulative Return alongside risk and drawdown metrics, and always backtest your strategy before live trading.

Cumulative Return

Inputs

Outputs