Cumulative product / multiply

[ack22]

Hi,

Is there a support for math functions like exp, ln, log, etc.? I need to compute a cumulative product for applying corporate actions (splits) on raw prices. Also, is there a way to create dynamics views? Would need to create a view which returns corporate action adjusted prices.

Any pointers?

Thanks.

[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…