Percentage change between days

[stjernvd]

Hi All,

I would like to calculate the percentage change in the script between stock value on different days.

Here is my original data:

What would be a good expression for doing this? I tried this expression but it doesn't work:

FirstSortedValue(Day,Stock Value) - Above(FirstSortedValue(Day,Stock Value) / Above(FirstSortedValue(Day,Stock Value)

Does this make sense?

[maxgro]

in script or in chart?

if in chart what's the expression for 2nd column (stock value)?

[stjernvd]

Stock Value is just a number...no expression for it...same with day...the data above is from my excel file...

I want to edit it in the script if possible..to load the percentage change of stock value from day to day as 'growth rate'....

[maxgro · Accepted solution]

like this?

source:     // replace with your data

load

  date(makedate(2015) + rowno() -1) as Day,

  floor(rand()*10) as Value

AutoGenerate

  365;

final:

load

  Day,

  Value,

  Peek(Value) as PrevValue,

  (Value - Peek(Value)) / Peek(Value) as Change%

Resident source

order by Day;

[stjernvd]

Yes thank you very much!

[maxgro]

I think you can do that in chart too; if sum(val) is expression, and the chart is day ordered, above(sum(val))