Forums ProRealTime English forum ProBuilder support trying to code a formula into Reply To: trying to code a formula into

#247764

calculate the overall average of the last 10 London session ranges, which you’ve already set up. Now, we take it a step further with a refined statistical approach:

1️⃣ Identify the 5 highest values in the dataset of 10.
2️⃣ Calculate the average of these 5 highest values.
3️⃣ Identify the 5 lowest values in the dataset.
4️⃣ Calculate the average of these 5 lowest values.

This gives you a high average and low average, which is a more nuanced measure than standard deviation. It’s brilliant because it filters extreme variations without being overly sensitive to outliers.

Collects the last 10 London ranges
Sorts the dataset to easily extract the highest and lowest values
Selects the 5 highest and 5 lowest values
Computes their respective averages