Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/18/2010(UTC)
Posts: 7
|
Yes, I tried a lot more I could not.
I'm trying to program an explorer to show me stock who has 5% below of the higher price of the whole period.
If the most high from all period was 100 dollars, will be true if the high is > than 95 dollars
I try unsuccessfully:
H>(Highest( H)*0.95)
And if i use this function create error:
H>(hhv( H, 65000 )*0.95)
Because a wanna get the high value of all data, if the stock has less than 65000 show me a error, need to be some like this:
H>(hhv( H, all data?)*0.95)
Please help.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Does:
H>(LastValue(Highest(H))*0.95)
work?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/18/2010(UTC)
Posts: 7
|
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/18/2010(UTC)
Posts: 7
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Try using
H>(LastValue(Highest(H))*0.95)
as the filter for the explorer.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/18/2010(UTC)
Posts: 7
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Go into options in the Explorer window and select like 1300 records. It looks like you are selecting just one.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 12/18/2010(UTC)
Posts: 7
|
Works fine now Johnl!
Is the Explorer Option which was checked "Load Minimal Record"
Thank you very much
|
|
|
|
|
|
| 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.
