Forums › ProRealTime English forum › ProBuilder support › trying to code a formula into › Reply To: trying to code a formula into
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