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