Rank: Member
Groups: Registered, Registered Users Joined: 9/11/2005(UTC) Posts: 16
|
What I want do do is get a figure for the cumulative volume between a high that would have occurred up to 1250 periods ago and a low that would have occurred no more than 250 days ago. This is what would work
((Sum(V,HHV(HIGH,1250))) - (Sum(V,LLV(LOW,250))))
were it not for the fact that this gives the error message "this variable or expression must contain only constant data"
This would be OK
((Sum(V,1000)) - (Sum(V,200)))
but for the fact that I don't know where the high/low will be for each stock and do not want to input it manually as I want this for an exploration.
SO: is there a workaround for the fact that the Sum function will only handle a constant, or is there a completely dfferent way of returning the cumulative volume between a high that would have been no more than 1250 bars ago and a low that would have been no more than 20 periods ago in such a way that it can be used for an exploration?
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 6/3/2005(UTC) Posts: 181
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Yes there will at least be 2 more new releases ...
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 6/3/2005(UTC) Posts: 181
|
Dear Patrick,
I have a small problem.
I want to create a Formula.
But i have trouble...
Which is my problem?
Suppose that Today i have a Buy Signal into this Formula.
Example:
Cross(mov(C,15,E), MOV(C,200,E))
Also suppose that this Signal borned the previous Friday: 09-09-2005
I want from the Friday 09-09-2005 and in the Range of 3 Coming Months meaning until 09-12-2005, to be true or false the,
((Current Close in any Day between the Friday 09-09-2005 and until 09-12-2005) - (Close of Friday 09-09-2005(In which the Signal of Cross(mov(C,15,E), MOV(C,200,E)) was borned))*100/(Close of Friday 09-09-2005(In which the Signal of Cross(mov(C,15,E), MOV(C,200,E)) was borned) > 8
Also that Thing to happen also in any Day into the Chart plus the 3 Months.The Friday 09-09-2005 i say it as example, this Cross can happen in any Day.
Also i want to ask if can except a Day or Days into the above Thing,
because another Formula was borned for example (H-Ref(L, -1))*100/Ref(L, -1) > 8
George K.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Sorry George I have no idea what your post mean ;)
And I mean to say this in the nicest way possible ... :D
Would you mind rewording your question :P
Patrick :mrgreen:
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users Joined: 6/3/2005(UTC) Posts: 181
|
Suppose that happen this:
If(Cross(mov(C,15,E), MOV(C,200,E)), 1, 0)
Also suppose that this Signal borned the previous Friday: 09-09-2005
I want from the Friday 09-09-2005 and in the Range of 3 Coming Months meaning until 09-12-2005, to be true or false the,
((Current Closing Price(c) in any Day between the Friday 09-09-2005 and until 09-12-2005) - ( Closing Price(c) of Friday 09-09-2005(In which the Signal of Cross(mov(C,15,E), MOV(C,200,E)) was borned))*100/(Closing Price (c) of Friday 09-09-2005(In which the Signal of Cross(mov(C,15,E), MOV(C,200,E)) was borned) > 8
Also that Thing to happen also in any Day into the Chart plus the 3 Months.The Friday 09-09-2005 i say it as example, this Cross can happen in any Day.
Also i want to ask if can except a Day or Days into the above Thing,
because another Formula was borned for example (H-Ref(L, -1))*100/Ref(L, -1) > 8
This Formula need Day Expression and Maybe Month Expression i believe.
George K.
|
|
|
|
Rank: Member
Groups: Registered, Registered Users Joined: 9/11/2005(UTC) Posts: 16
|
Thanks Patrick, looks to be what I need ( :mrgreen: :mrgreen: :mrgreen: ).
I have another (unrelated) question but will post in a new thread to make it more searchable for others.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 9/8/2004(UTC) Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
What about this :
Buy:=Cross(mov(C,15,E), MOV(C,200,E));
barssince(buy)<=90 and ((C-ValueWhen(1,Buy,C))*100)/ValueWhen(1,buy,C) > 8
Patrick :mrgreen:
|
|
|
|
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.