PVIOT VE FIBO

Question

MERHABA KENDIMCE BIRSEYLER YAPMAYA CALISTIM.

K:=144;
236:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.236,0));
c/236<1 AND c/236>0.99  AND c/236>ref(c/236,-2)  OR  
K:=144;
38:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.382,0));
c/382<1 AND c/382>0.99  AND c/382>ref(c/382,-2)   OR    
K:=144;
50:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.50,0));
c/50<1 AND c/50>0.98  AND c/50>ref(c/50,-2)  OR  
K:=144;
618:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.618,0));
c/618<1 AND c/618>0.98  AND c/618>ref(c/618,-2)  OR  
K:=144;
786:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.786,0));
c/786<1 AND c/786>0.98  AND c/786>ref(c/786,-1)  OR   
K:=144;
100:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*100,0));
c/100<1 AND c/100>0.98  AND c/618>ref(c/100,-2)

BURADA AMACIM SON BAR VEYA BIR ONCEKI BAR FIYATININ (C ) BURDAKI FIBO SEVIYELERINDEN HER HANGI BIRINE YAKLASTIGINDA TARAMA ESNASINDA 1 DEGERINI VERMESINI SAGLAMAKTI AMA YAPAMADIM.AYRICA SON BAR VEYA BIR ONCEKI BAR FIYATININ PIVOT-R1 VEYA R1-R2 VEYA R2-R3 DEGERINE YUZDE 1 YAKLASTIGINDA TARAMA DA 1 DEGERINI ALMASINI SAGLAMAK ISTIYORUM.VE SON KEZ OLARAK  SON BAR VEYA BIR ONCEKI BAR FIYATININ HEM FIBO DEGERI HEMDE PIVOT DEGERLERI AYNI ANDA BIRIBIRNE YUZDE 1 YAKIN VEYA USTUNDA ISE NASIL TARAMA YAPABILIRIM. BU KONUDA YARDIMCI OLURMUSUNUZ.

NW:=ROC(Hour(),1,$)<0;
x1t:=LastValue(ValueWhen(1,NW=-1,Cum(1)));
WH:=ValueWhen(1,Nw,Ref(HighestSince(1,Nw,H),-1));
WL:=ValueWhen(1,Nw,Ref(LowestSince(1,Nw,L),-1));
WCL:=ValueWhen(1,Nw,Ref(C,-1));
Pivot:=if(cum(1)=>x1t, ( WH + WCL + WL )/3,0);
R3:=if(cum(1)=>x1t,WH + 2*(Pivot - WL),0); R1:=if(cum(1)=>x1t, 2 * Pivot -WL,0);
S1:=if(cum(1)=>x1t, 2 * Pivot - WH,0);
R2:= if(cum(1)=>x1t,Pivot + (R1 - S1),0);
S2:= if(cum(1)=>x1t,Pivot - (R1 - S1),0);
S3:= if(cum(1)=>x1t,WL - 2*(WH - Pivot),0);
1:=int(R3/0.025)*0.025;
2:=int(R2/0.025)*0.025;
3:=int(R1/0.025)*0.025 ;
4:=int(Pivot/0.025)*0.025;
5:=int(S1/0.025)*0.025;
6:=int(S2/0.025)*0.025;
7:=int(S3/0.025)*0.025;
C>4 AND C<3

Answer 1

merhaba,

tam olarak yapmak istediğinizi anlayamadık,

ancak ilk formülde bir çok yazım hatası var,

tanımları önce şartlar en sonda gelmelidir,

ayrıca aynı tanımdan 1 kere yapılması yeterlidir(K:=144)

aşağıdaki gibi inceleyip deneyiniz,

bilgilerinize

K:=144;
236:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.236,0));
38:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.382,0));
50:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.50,0));
618:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.618,0));
786:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.786,0));
100:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*100,0));
(c/236<1 AND c/236>0.99  AND c/236>ref(c/236,-2))  OR  
(c/382<1 AND c/382>0.99  AND c/382>ref(c/382,-2))  OR    
(c/50<1 AND c/50>0.98  AND c/50>ref(c/50,-2))  OR  
(c/618<1 AND c/618>0.98  AND c/618>ref(c/618,-2))  OR  
(c/786<1 AND c/786>0.98  AND c/786>ref(c/786,-1)) OR   
(c/100<1 AND c/100>0.98  AND c/618>ref(c/100,-2))

Comments

faklı bır kolan ıse hem fıbo ve hem pıvot formullerının beraber oldugu (soyle acıklayayım : hısse fıyatı  dıyelım kı 12 tl o an kı en yakınfıbo degerı 12.10 pıvot degerı de 12.12 olsun aynı anda sartları saglıyor ıse hem fıbo hemde pıvot degerıne yuzde 1 yaklastıgında veya yuzde 1 uzerınde ıken colan da tarama esnasında 1 olmasını dusunuyorudun

a colanu sadece pıvot olarak

b colan sadece fıbo olarak

c colanda ıse hem pıvot hem fıbo olarak dusunuyordum.bunu nasıl yapabılırız.

tesekkur ederım

---

merhaba

1. kolona

NW:=ROC(Hour(),1,$)<0;
x1t:=LastValue(ValueWhen(1,NW=-1,Cum(1)));
WH:=ValueWhen(1,Nw,Ref(HighestSince(1,Nw,H),-1));
WL:=ValueWhen(1,Nw,Ref(LowestSince(1,Nw,L),-1));
WCL:=ValueWhen(1,Nw,Ref(C,-1));
Pivot:=if(cum(1)=>x1t, ( WH + WCL + WL )/3,0);
R3:=if(cum(1)=>x1t,WH + 2*(Pivot - WL),0); R1:=if(cum(1)=>x1t, 2 * Pivot -WL,0);
S1:=if(cum(1)=>x1t, 2 * Pivot - WH,0);
R2:= if(cum(1)=>x1t,Pivot + (R1 - S1),0);
S2:= if(cum(1)=>x1t,Pivot - (R1 - S1),0);
S3:= if(cum(1)=>x1t,WL - 2*(WH - Pivot),0);
1:=int(R3/0.025)*0.025;
2:=int(R2/0.025)*0.025;
3:=int(R1/0.025)*0.025 ;
4:=int(Pivot/0.025)*0.025;
5:=int(S1/0.025)*0.025;
6:=int(S2/0.025)*0.025;
7:=int(S3/0.025)*0.025;
if(C>4 AND C<3,1,0)

2. kolona

K:=144;
236:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.236,0));
38:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.382,0));
50:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.50,0));
618:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.618,0));
786:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*0.786,0));
100:=(IF(BARSSINCE(HLBTop(K)=H)>BARSSINCE(HLBBot(K)=L), HLBBot(K)+(HLBTop(K)-HLBBOT(K))*100,0));
if((c/236<1 AND c/236>0.99  AND c/236>ref(c/236,-2))  OR  
(c/382<1 AND c/382>0.99  AND c/382>ref(c/382,-2))  OR    
(c/50<1 AND c/50>0.98  AND c/50>ref(c/50,-2))  OR  
(c/618<1 AND c/618>0.98  AND c/618>ref(c/618,-2))  OR  
(c/786<1 AND c/786>0.98  AND c/786>ref(c/786,-1)) OR   
(c/100<1 AND c/100>0.98  AND c/618>ref(c/100,-2)),1,0)

 

yazın

3. kolonada

cola+colb>1

yazıp deneyiniz,

bilgilerinize