Rank: Newbie
Groups: Registered, Registered Users
Joined: 11/16/2012(UTC)
Posts: 2
|
New to formula writing and any assistance is greatly appreciated.
How would I write the formula for the total volume on days when a stock closed up over the last 50 days?
-Thank You
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 7/25/2005(UTC)
Posts: 1,042
Was thanked: 57 time(s) in 54 post(s)
|
Hi madden20
Try this.
Sum((C>Ref(C,-1))*V,50);
Roy
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 5/13/2005(UTC)
Posts: 715
Location: Midwest, USA
Was thanked: 1 time(s) in 1 post(s)
|
FYI, have put links to the Formula Primer and other Tutorial below.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 11/16/2012(UTC)
Posts: 2
|
Roy that was it thank you so much for your help.
|
|
|
|
|
|
| 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.
