Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
Quadrant lines take the highest and lowest range and plot it into 4 equal areas
this formula plots the range into eighths
A1:=Input("date A mmddyyyy",1011960,12312100,1062000);
B1:=Input("date B mmddyyyy",1011960,12312100,1072000);
PT:=Input("B=1trough or 2 Peak",1,2,1);
D:=Input("Decimal Point",.001,100.0,1.0);
Mult:=Input("Multiplier",.125,10,1);
PA:=If(PT=1,ValueWhen(1,A1=Month()*1000000 + DayOfMonth()*10000+ Year(),H),ValueWhen(1, A1=Month()*1000000 + DayOfMonth()*10000+ Year(),L));
PB:=If(PT=1,ValueWhen(1,B1=Month()*1000000 + DayOfMonth()*10000+ Year(),L),ValueWhen(1, B1=Month()*1000000 + DayOfMonth()*10000+ Year(),H));
V0:= If(PT=1,PA*D*Mult,PB*D*Mult);
V1:=If(PT=1,PA-((Abs(PA-PB)*.125)*D*Mult),PA+(( Abs(PA-PB)*.125)*D*Mult));
V2:=If(PT=1,V1-((Abs(PA-PB)*.125)*D*Mult),V1+(( Abs(PA-PB)*.125)*D*Mult));
V3:=If(PT=1,V2-((Abs(PA-PB)*.125)*D*Mult),V2+ ((Abs(PA-PB)*.125)*D*Mult));
V4:=If(PT=1,V3-((Abs(PA-PB)*.125)*D*Mult),V3+((Abs(PA-PB)*.125)*D*Mult));
V5:=If(PT=1,V4-((Abs(PA-PB)*.125)*D*Mult),V4+((Abs(PA-PB)*.125)*D*Mult));
V6:=If(PT=1,V5-((Abs(PA-PB)*.125)*D*Mult),V5+((Abs(PA-PB)*.125)*D*Mult));
V7:=If(PT=1,V6-((Abs(PA-PB)*.125)*D*Mult),V6+((Abs(PA-PB)*.125)*D*mult));
V8:=If(PT=1,V7-((Abs(PA-PB)*.125)*D*Mult),V7+((Abs(PA-PB)*.125)*D*Mult));
V9:=If(PT=1,V8-((Abs(PA-PB)*.125)*D*Mult),V8+((Abs(PA-PB)*.125)*D*Mult));
V10:=If(PT=1,V9-((Abs(PA-PB)*.125)*D*Mult),V9+((Abs(PA-PB)*.125)*D*Mult));
V0;V1;V2;V3;V4;V5;V6;V7;V8;{V9;V10;}
enter the date from point A and from point B
enter if point B is a peak or trough
D and multi can be adjusted for scale
|
