Dear All, the below formula displays the weekly prices from Monday to friday. Can anyone help me change it to sunday till thursday.
Pls help me thx ---------------------------------------------------------- firstday = ValueWhen( Cum(1)==1, DayOfWeek() ); 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," open= "+ weeko+ " high= "+weekh + " low= "+ weekl + " close= " +weekc,colorBlack, styleCandle); -------------------------------------------------------------------
