Day High and Low Tn in 1 min precision in Daily Periodicity Exploration

Hi All,
Below given code was written by Tomasz long ago that explores to find the day High, Low price and Time number.
I set the analysis settings periodicity is 5 min.so there are so many lines in the exploration window.
How can i acquire the same result if analysis periodicity is changed to Daily.

when i set the periodicity in Daily,it has to fetch the day high and low timenum in 1 min precision..but since periodicity is set in Daily i will get 1 entry per day in the exploration window.That will be helpful for me to use that data to analyze further.

Bottom line is i just want to have 1 entry per day in the exploration window instead of too many lines as seen in the attached image.

Can anyone help in this regard.
Thanks and regards,Testing Data

Tn=TimeNum();
Bi=BarIndex();

xH=BarsSince(Day()!=Ref(Day(),-1));
yH=HHV(H,xH+1);
yhc=HHV(C,xh+1);
HighTODAY=IIf(xH==0,yH,Ref(yH,0));
Hightn=ValueWhen(Ref(h,0)== Hightoday, tn,1);

xL=BarsSince(Day()!=Ref(Day(),-1));
yL=LLV(L,xL+1);
yLc=LLV(C,xL+1);
LowTODAY=IIf(xL==0,yL,Ref(yL,0));
Lowtn= ValueWhen(Ref(L,0)== Lowtoday, tn,1);

Filter=1; 

AddColumn(HighToday,"Day High",1.2); 
AddColumn(LowToday,"Day Low",1.2);

AddColumn(HighTN,"High Tn",1.2);
AddColumn(LowTN,"Low Tn",1.2);

@Gloriafilamino you could Filter your exploration on the last bar of the day and run Explore in 1 minute time frame.

LastBar = TimeNum()==155900; // in my data that is the time of the last bar

Filter = LastBar;

image

2 Likes

Thanks a Lot.
Worked great.

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.