Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 6/12/2012(UTC)
Posts: 19
Location: South Africa - JHB
|
Hi,
I am trying to work out when volume is increasing
Volume past 10 days is 2 times the vol over the past 20 days
I am trying to work out when the volume has increased for 5 consecutive periods?
Code:Ref(V,-1)>Ref(V,-2) ANDRef(V,-2)>Ref(V,-3) ANDRef(V,-3)>Ref(V,-4)
I am not sure if I am doing my formulas right??
Would appreciate help
|
|
|
|
|
|
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)
|
RUTrading wrote:I am trying to work out when the volume has increased for 5 consecutive periods? I'd be tempted to do something like this:
wabbit [:D]
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Unverified Users
Joined: 6/12/2012(UTC)
Posts: 19
Location: South Africa - JHB
|
Thanks Wabbit,
Just wanted to hear your thoughts on the other formula "Volume past 10 days is 2 times the vol over the past 20 days." Is this the best way to do it?
|
|
|
|
|
|
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)
|
If it produces the results you expect....
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.
