
1. Re: How to calculate a value over time given a parameter and daily percentage changes
Shinichiro Murakami Nov 6, 2018 10:36 PM (in response to Kendrix Lima)Try
previous_value([Parameter])*(1+min([Daily Return]))
Thanks,
Shin

prev_value_SM_10.5.twbx 47.0 KB


2. Re: How to calculate a value over time given a parameter and daily percentage changes
Kendrix Lima Nov 7, 2018 9:31 PM (in response to Shinichiro Murakami)Hi Shin! Thanks that worked perfectly!
Only now I have a new problem. I'd ideally like to also display the average value to allow for the comparison of different stocks over time.
I was thinking of using a formula such as { FIXED [Date]: AVG(previous_value([parameter]) * (1 + MIN([Daily Return])))} but I'm running into an error that level of detail expressions can't contain table calculations. Is there any fix around this?

3. Re: How to calculate a value over time given a parameter and daily percentage changes
Shinichiro Murakami Nov 7, 2018 9:51 PM (in response to Kendrix Lima)Means this?
I don't have data, but you need to set table calculation appropriately based on your table structure.
(Without data, It cannot be clarified)
If this helped, could you mark my answer as "correct" to close the thread, not from inbox, but from original post.
Thanks,
Shin

prev_value_SM_10.5_v2.twbx 48.1 KB
