logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dklugmann  
#1 Posted : Wednesday, May 10, 2006 11:01:53 PM(UTC)
dklugmann

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 10/6/2005(UTC)
Posts: 30

Hi I'm trying to write a formula that returns the top (number to be specified) shares as far as rate of change is concerned over a specific time period. is there any way to limit the shares being returned by say the top 100. Many thanks David
wabbit  
#2 Posted : Thursday, May 11, 2006 12:57:08 AM(UTC)
wabbit

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)
No. Just return all the stocks from the explorer and sort them according to your condition. The top (however) many will be at the top or bottom of the list depending on you sort. You can pick them off from there. You can always export the list to Excel too. wabbit :D
dklugmann  
#3 Posted : Thursday, May 11, 2006 2:16:12 AM(UTC)
dklugmann

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 10/6/2005(UTC)
Posts: 30

Wabbit Thanks a lot. If I say sort (by clicking on the title of the results I assume) is there any way of getting that list into favourites in the correct order so you can scroll through them one at a time with the next previous buttons as I do with a regular search. This may involve an export/import or maybe the sort button will leave the shares in that order when you do open favourites / results of last exploration. Thanks again for your help. David
Users browsing this topic
Guest (Hidden)
Similar Topics
Formula required about Rate of Change (ROC) (Formula Assistance)
by mwaseemtaqi 4/29/2007 12:21:19 PM(UTC)
TASC - Sept 2005 - Moving Slope Rate of Change (Formula Assistance)
by StorkBite 9/8/2005 1:34:39 AM(UTC)
Rate of Change Since a Specific Date (Formula Assistance)
by Patrick 8/19/2005 4:38:16 PM(UTC)
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.