do you have any idea how I can, sort and group variables together based on distance threshold (so in my exemple only variable1,3,4 would be grouped together because there is less than 15 point distance between them)? The idea finally would be to draw a rectangle between 196 and 207.
Thx very much robertogozzi, that’s already very valuable!
then I guess I can do:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Var1-var2<15then
Rect1=var1
Rect2=var2
Endif
IfVar1-var3<15then
Rect1=var1
Rect2=var3
Endif
Ifvar1-var4<15then
Rect1=var1
Rect2=var4
Endif
Ifvar1-var5<15then
Rect1=var1
Rect2=var5
Endif
And repeat that 4 more times (var2-var3<15 etc).and it should work.
problem maybe is that I have more than 50 variables, so it could become a very very long code.
So anyone has an idea in order to optimize that by first filtering all variables with price too far from the latest price? But then you add a level of complexity because you don’t know anymore how many variables do you have…