If working with a one minute chart, can i plot a pivot and s/r lines based on the prior days (not minutes) High/Low/close? I'm surprised i cannot find anything on daily pivots that can be ploted on any time scale. JK

Here's a version of the formula: {daily pivot on intraday bars} ic:=ValueWhen(1,ROC(DayOfWeek(),1,$)<>0,Ref(C,-1)); ih:=ValueWhen(1,ROC(Hour(),1,%)<0,HighestSince(2,ROC(Hour(),1,%)<0,Ref (H,-1))); il:=ValueWhen(1,ROC(Hour(),1,%)<0,LowestSince(2,ROC(Hour(),1,%)<0,Ref (L,-1))); mp1:=(ih+il+ic)/3; r2:=mp1+(ih-il); r1:=(mp1*2)-il; s1:=(mp1*2)-ih; s2:=mp1-(r1-s1); r1; r2; s1; s2;

JK Try this one also:- ---start--- {Capture H/L/C print from previous intraday's trading at specific times, use Time1 for start time & Time2 for end time} Time1:=Hour()=14 AND Minute()=32; Time2:=Hour()=21 AND Minute()=00; ldih:=ValueWhen(1,Time2,Ref(HighestSince(1,Time1,H),-1)); {last day intraday high} ldil:=ValueWhen(1,Time2,Ref(LowestSince(1,Time1,L),-1)); {last day intraday low} ldic:=ValueWhen(1,Time2,Ref(C,-0)); {last day intraday close} ldih; ldil; ldic; ---end--- Being based in the UK (GMT=0hrs) the above allows me to get a print of yesterday's DJ cash (GMT-5hrs) high, low and close from a 2 minute intraday chart, where the same opened at 14:30 hrs and closed at 21:00 hrs my local time. Hope this helps you as well as that excellent response from Jose, especially as with the above you can fragment any market into specific data portions - ie slice the H/L/C data into a morning session and an afternoon session etc. Also you can apply pivot points to this or fib calcs; the uses go on.... trade well & rgs

Hi all, Based on Joetrade 69, we can plot the daily privot (based on previous day H, L, C) on intraday bars. How can we plot "3-day rolling pivot range" based on 3-day's H, L C? I am interested in plotting the following r1 and s1 only:- 3DPV1 = (highest high of last 3 days + lowest low of last three days + yesterday's close)/3 3DPV2 = (highest high of last 3 days + lowest low of last three days)/2 Diff = Abs(3DPV1 - 3DPV2) r1 = 3DPV1 + Diff s1 = 3DPV1 - Diff I initially want to code it, but failed.... need help on this.. Gary Joetrade 69's code

Looks good ... Good job Gary :D

Try without your reference : [code:1:0cc5b6f3a2]{Yesterday's close} ic:=ValueWhen(1,ROC(DayOfWeek(),1,$)<>0,Ref(C,-1)); {highest high & lowest low of last 3 days} ih2:=ValueWhen(1,ROC(Hour(),1,%)<0,HighestSince(4,ROC(Hour(),1,%)<0,H)); il2:=ValueWhen(1,ROC(Hour(),1,%)<0,LowestSince(4,ROC(Hour(),1,%)<0,L)); mp1:=(ih2+il2+ic)/3; sn1:=(ih2+il2)/2; diff:=Abs(mp1-sn1); r1:=mp1+diff; s1:=mp1-diff; r1;s1;[/code:1:0cc5b6f3a2]

Alrigh waht about {Yesterday's close} ic:=ValueWhen(1,ROC(DayOfWeek(),1,$)<>0,Ref(C,-1)); {highest high & lowest low of last 3 days} ih2:=ValueWhen(1,ROC(Hour(),1,%)<0,HighestSince(3,ROC(DayOfWeek(),1,$)<>0,H)); il2:=ValueWhen(1,ROC(Hour(),1,%)<0,LowestSince(3,ROC(DayOfWeek(),1,$)<>0,L)); mp1:=(ih2+il2+ic)/3; sn1:=(ih2+il2)/2; diff:=Abs(mp1-sn1); r1:=mp1+diff; s1:=mp1-diff; r1;s1;

Hi Jose, I use your code to amend it to show the yesterday's Pivot Range (defined by Mark Fisher), it works fine....

Hi Jose, Thanks for your input, it works now!! Also, can you explain briefly the follwoing logic / algorithm of the following as I want to learn it? Hd:=HighestSince(pds,dStart,H); Hd:=ValueWhen(1,dStart,ValueWhen(2,1,Hd)); Hd:=ValueWhen(1,Hd>0,Hd); Thanks! Gary p/s Patrick, I think you should consider to add this (or similar stuff) to your training video (or something) to let us learn it as I can't find or learn it from Formula Primer!!!

Jose, Thanks for your explanation... nevertheless, I find it difficult to understand.... poor me! Gary Patrick, I strongly recommend that you could include a similar example to your training video to teach us!! thanks!!