Using data from 4 hours graph in 5 min graph

 

Hi all


Is there any simple way to get for each candle in 5 min graph the suitable data from 4 hours graph ?

for example i want to know for each canle in 5 min graph the High/Low/Close for the last Printed candle (i=1) in 4 hours graph.


thank you

 
 


Thank you for your answer. I know those functions but they don't help me.

The problem is that I try to run an Candles index (i) of 4H graph from 5 min graph by counting candles. it works but gives wrong results because there are missing candles in the 5 min graph (especially in week ends).

is there any way to connect between a candle in the 5 min graph to the suitable data of the 4H graph that this candle belongs ?

If not, is there any way to get the open time of the candle ??


Thank you.

Reason: