Download MetaTrader 5

Question about formulate to calculate last N numbers in a series of numbers

To add comments, please log in or register
Line_Trader
27
Line_Trader  

I‌ would like to index the last 5 minutes from any current point

i‌f current minute is 50 (CurMin) then last 5  (N) by index:  

‌1 = 45‌
2 = 46
3 = 47
4 = 48‌
5 = 49 

I‌t's just CurMin-N+Index

But if current minute is 2 (CurMin) then last 5 (N) by index:

‌1 = 57
2 = 58
3 = 59
4 = 0

5 = 1 ‌

‌How can this be put in a formula? I think I need to work with MathMod().

T‌hanks.

whroeder1
17050
whroeder1  
Line_Trader: I‌ would like to index the last 5 minutes from any current point

You don't index time. Simply subtract 5 minutes (300) from current time (TimeCurrent.)

You index bars. Once you have the time you can find the M1 bar that corresponds with iBarShift.

To add comments, please log in or register