+1 888 340 6572

# wrong calculation involving avgprice

Description

when a calculation involves avgprice, MC retures a wrong answer.

Steps to reproduce this issue

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

History
Issue basics
• Type of issue
Bug report
• Category
Not determined
• Targeted for
MultiCharts 7.4 (RELEASED)
• Status
Released
• Priority
Not determined
User pain
• Type of bug
Not triaged
• Likelihood
Not triaged
• Effect
Not triaged
Affected by this issue (3)
People involved
Times and dates
• Posted at
• Last updated
Issue details
• Reproducability
Not determined
• Severity
Critical
Attachments (0)
There is nothing attached to this issue
Commits (0)
There are no code checkins for this issue
Duplicate issues (0)
This issue does not have any duplicates