Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2010(UTC)
Posts: 24
Thanks: 1 times
|
This is the formula to plot fibonacci time ratios :
A1:=Input("date A mmddyyyy",1011960,12312100,1072009);
B1:=Input("date B mmddyyyy",1011960,12312100,1082009);
BSA:=BarsSince(A1=Month()*1000000 + DayOfMonth()*10000+ Year());
BSB:=BarsSince(B1=Month()*1000000 + DayOfMonth()*10000+ Year());
F1:=Int(If(((BSA-BSB)*.618)-BSB>0,((BSA-BSB)*.618)-BSB,0));
F2:=Int(If(((BSA-BSB)*1)-BSB>0,((BSA-BSB)*1)-BSB,0));
F3:=Int(If(((BSA-BSB)*1.382)-BSB>0,((BSA-BSB)*1.382)-BSB,0));
F4:=Int(If(((BSA-BSB)*1.618)-BSB>0,((BSA-BSB)*1.618)-BSB,0));
F5:=Int(If(((BSA-BSB)*1.786)-BSB>0,((BSA-BSB)*2)-BSB,0));
F6:=Int(If(((BSA-BSB)*2)-BSB>0,((BSA-BSB)*2.236)-BSB,0));
F7:=Int(If(((BSA-BSB)*2.618)-BSB>0,((BSA-BSB)*2.618)-BSB,0));
F1;F2;F3;F4;F5;F6;F7;
I would like to have this formula in real time....but metastock doesn' t accept more than 6 input...so I can't put hours and minuts...any suggestion?
thank's
|
|
|
|
|
|
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)
|
I imagine that if you make another set of inputs for HR+Min+SEC like you did for dates then add that condition into BSA and BSB
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 1/13/2010(UTC)
Posts: 24
Thanks: 1 times
|
Thank's Henry,you are right...but what is " Month()*1000000 + DayOfMonth()*10000"?
why 100000?
which value for hours or minutes?
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
