Nothing entered.
use the following code :
input: testing_variable(avgprice of data1), printswitch(0);
value1=testing_variable-average(testing_variable,10);
if printswitch=1 then print(file("c:\avgprice_testing.txt")," Date : ",date, ". Time ",time_s," testing_variable = ", testing_variable, " average(testing_variable,10) = ", average(testing_variable,10), " difference = ", value1);
value1 is avgprice of data1 minus average(avgprice of data1,10),
the file shows that the value of value1 is wrong :
Date : 1111117.00. Time 90300.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.68 difference = 0.39
Date : 1111117.00. Time 90400.00 testing_variable = 1227.19 average(testing_variable,10) = 1227.59 difference = -0.28
Date : 1111117.00. Time 90500.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.58 difference = -0.14
Date : 1111117.00. Time 90600.00 testing_variable = 1227.38 average(testing_variable,10) = 1227.58 difference = 0.17
Date : 1111117.00. Time 90700.00 testing_variable = 1227.38 average(testing_variable,10) = 1227.54 difference = 0.40
Date : 1111117.00. Time 90800.00 testing_variable = 1227.19 average(testing_variable,10) = 1227.46 difference = 0.54
Date : 1111117.00. Time 90900.00 testing_variable = 1227.13 average(testing_variable,10) = 1227.38 difference = 0.75
Date : 1111117.00. Time 91000.00 testing_variable = 1226.69 average(testing_variable,10) = 1227.23 difference = 0.39
Date : 1111117.00. Time 91100.00 testing_variable = 1226.19 average(testing_variable,10) = 1227.09 difference = 0.16
Date : 1111117.00. Time 91200.00 testing_variable = 1226.50 average(testing_variable,10) = 1227.01 difference = 0.24
However, if you change the definition of testing_variable from avgprice of data1 to close of data1, the answer comes out correct using the same code:
Date : 1111117.00. Time 90300.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.63 difference = -0.38
Date : 1111117.00. Time 90400.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.60 difference = -0.35
Date : 1111117.00. Time 90500.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.60 difference = -0.35
Date : 1111117.00. Time 90600.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.55 difference = -0.30
Date : 1111117.00. Time 90700.00 testing_variable = 1227.50 average(testing_variable,10) = 1227.53 difference = -0.03
Date : 1111117.00. Time 90800.00 testing_variable = 1227.25 average(testing_variable,10) = 1227.45 difference = -0.20
Date : 1111117.00. Time 90900.00 testing_variable = 1227.00 average(testing_variable,10) = 1227.33 difference = -0.33
Date : 1111117.00. Time 91000.00 testing_variable = 1226.50 average(testing_variable,10) = 1227.18 difference = -0.67
Date : 1111117.00. Time 91100.00 testing_variable = 1226.00 average(testing_variable,10) = 1227.05 difference = -1.05
Date : 1111117.00. Time 91200.00 testing_variable = 1227.00 average(testing_variable,10) = 1227.03 difference = -0.03