Discussions
»
Product and Service Development
»
Formula Assistance
»
Current Closing Price is within 0-33% between 52 weeks Low and High
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/17/2010(UTC)
Posts: 2
|
Hi All!
Need help with formula to explore:-
All daily closing prices which are lower than their
$52WkLow + 0.33 X ($52WkHigh - $52WkLow)
Thanks.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Try something like: a1:=LLV(C,52)+(0.33)*(HHV(C,52)-LLV(C,52)); a2:=LLV(C,52)+(0.0)*(HHV(C,52)-LLV(C,52)); a3:=(C>a2)*(C<a1); a3 Run exploration over (a3=1). Run over weekly data:
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 11/17/2010(UTC)
Posts: 2
|
Thanks johnl.
The 2nd column in the report consist of 0 & 1 where when I checked the search is correct for 1 and wrong for 0.
The rejected ones in other tabs had error message. Should I worry?
Can you explain a bit more what do you mean by explore over (a3=1)? How to filter the results as I want to get rid the ticks with 0 and keep tickers 1 only.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
The error messages probably means that security did not have enough data to calculate the HHV() and LLV() functions correctly.
The final plot (a3) will be either 1 or 0. If you use a3=1 as the filter for your exploration,
only those "a3=1"s will show up. The exploration filter is the last right hand column of the
exploration. The other columns just display what ever data you tell each column to calculate..
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Current Closing Price is within 0-33% between 52 weeks Low and High
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.
