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...
IMettPerfect, 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 - OK, use the same link. I've updated the file.
Best
D - By the way... EARLIER has nothing to do with any order. It's a function (which should not be used) that lets you access an outer row context. There are however better ways to do such an operation: VARiables.
Best
D