Forum Discussion
IMett
Helper III
Helper IIIScaling time series data based on starting date value
Hi all, I'm struggling with a probably relatively easy problem: I have time series data (e.g. stock prices) with 3 variables: date, stock name (Aktie) and value. In this example I have ju...
IMettHelper III
Helper IIIPerfect, thanks a lot!
I have one more question about the same use case:
We also want to display the difference (absolute or in percent) between the value on the current date and the value on the previous available date.
I tried to work with the EARLIER function, but it seems to require an ordered column and I don't know how to create one if there are several stocks in the dataset.
I think they've blocked my account here (or will be soon), so I might not be able to craft the solution quickly enough.
Sorry but it's the admin of this site that's to blame.
Best
D
Sorry but it's the admin of this site that's to blame.
Best
D