Hi
I want to calculate/simulate a data to analysis price difference, my data set in picture,
left is my data set, right table is that i want to produce
Process like this
LOOP
find DIFF > 100 and get PAR and _time value
get BTC value 5 minutes after, and set BTC as BTC_last
get difference BTC_last - PAR
Until data finished
For example
find DIFF> 100
time: 00:02:58 PAR:1655
get 5 minutes after BTC: 1800 as BTC_last
get difference BTC_last - PAR = 1800 -1655 = 145 and continue
like this
find DIFF> 100
time: 00:09:58 PAR:1610
get 5 minutes after BTC: 1510 as BTC_last
get difference BTC_last - PAR = 1510 -1610 = -100
and so on?
How can i produce this process, given in right table using splunk?
... View more