Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/27/2007(UTC)
Posts: 11
|
I wanted an Explorer formula that would:
Show stocks where close gained more than 15% over the last 2 days and and volume is greater than 300,000.
What I came up with was:
Col A: ((Ref(C, -1)) + (Ref(C, -2))) /2
Col B: V * 100
Filter: C>(colA*1.15) AND (colB>300000)
When I ran this scan it worked as expected, however, I had not purged old stocks from my database and a stock was flagged that last traded 12/18/2006. My formula looks at the last close - 1 and the last close - 2. Is there a way correct this flaw in case a stock is delisted and I have not updated my database?
For example, could I set a condition where Ref(C, -1) = month() ?
Thanks,
|
|
|
|
|
|
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)
|
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/27/2007(UTC)
Posts: 11
|
Wabbit, thanks for taking the time to reply on all three of my posts!
|
|
|
|
|
|
| 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.
