Dear All, Can anyone help me change the below formula from (Mon to Firday) week to (Sunday to Thursday) week.
Your Help is highly appriciated. thx in advance --------------------------------------------------------------------- firstday = ValueWhen( Cum(1)==1, DayOfWeek() ); numweeks = IIf(LastValue(DayOfWeek())==firstday, LastValue(Cum(DayOfWeek()==firstday)),LastValue(Cum(DayOfWeek() ==firstday))+1 ); numweek = IIf(firstday==1, Cum( DayOfWeek() < Ref(DayOfWeek(),-1) ), IIf(firstday>1, Cum( DayOfWeek() < Ref(DayOfWeek(),-1) )+1 , 0 )); numweek = IIf(IsEmpty(numweek),1,numweek); firstbar = LastValue(Cum(1))-LastValue(numweek)+1; dayRef = 5-LastValue(DayOfWeek()) + 4*( Cum(1) - LastValue(Cum(1)) ); xxx = Min(0,5-LastValue(DayOfWeek()) + 4*( Cum(1) - LastValue(Cum (1)) )); wo = IIf(IsEmpty( Ref(DayOfWeek(),-DayOfWeek()) ), ValueWhen(DayOfWeek()==firstday,O), ValueWhen(DayOfWeek()==1,O ) ); wh = HHV(H,Min(DayOfWeek(),5)); wl = LLV(L,Min(DayOfWeek(),5)); wc = C; weeko =Ref(wo,xxx); weekh = Ref(wh,xxx); weekl = Ref(wl,xxx); weekc = Ref(wc,xxx); PlotOHLC(weeko,weekh,weekl,weekc,"weekly",colorBlack,styleCandle); -------------------------------------------------------------------
