Cumulative product / multiply

[ack22]

Nevermind - I see another post which answers the question:

Cumulative product for a random walk

I have a dataset in QuestDB with daily returns for a stock, starting at $100. I want to calculate the cumulative product of the returns to simulate the stock’s price path (random walk). The daily returns are stored in a table called daily_returns. Here’s a sample of the relevant columns: Date Daily Return (%) 2024-09-05 2.00 2024-09-06 -1.00 2024-09-07 1.50 2024-09-08 -3.00 2024-09-09 2.50 2024-09-10 1.00 2024-09-11 -2.00 2024-09-12 1.50 I’m trying to calculate the cum…