Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/7/2011(UTC)
Posts: 9
|
I have a Dual Crossover and I want to know the date that the most recent cross over happened when running the explorer. Can someone help me?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
You can use the ValueWhen() function, combined with the date functions to determine the date; there has been many posts on different ways to achieve it and some of the problems you can encounter on the way, this might get you started (but is a long way from a complete solution); Code:
event:={your crossing event};
{date format: ddmmyy}
dd:=10000*valuewhen(1,event,dayofmonth());
mm:=100*valuewhen(1,event,month());
yy:=valuewhen(1,event,year());
yy:=If(yy<2000,yy-1900,yy-2000);
{plot/return}
yy+mm+dd;
Have a look in your MS User Manual and the free Equis Formula Primer for more things you can do with these functions. wabbit [:D]
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 4/7/2011(UTC)
Posts: 9
|
Is there a way to also a way to have it tell me exactly how many trading days ago it happened as well?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
Read the manual: BarsSince()
wabbit [:D]
|
|
|
|
|
|
| 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.
