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

Notification

Icon
Error

Options
Go to last post Go to first unread
autoct  
#1 Posted : Sunday, May 18, 2008 8:08:01 PM(UTC)
autoct

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 5/19/2008(UTC)
Posts: 2

Hi everyone

I need a formula to get the best 10 stocks performers and 10 worst losers in the last 20 days.

Thank you

johnl  
#2 Posted : Sunday, May 18, 2008 9:01:30 PM(UTC)
johnl

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602

What is your criteria? Need something like: (% gain/loss) or (total $ gain/loss) or whatever.

autoct  
#3 Posted : Monday, May 19, 2008 8:36:03 AM(UTC)
autoct

Rank: Newbie

Groups: Registered, Registered Users, Subscribers
Joined: 5/19/2008(UTC)
Posts: 2

I have no critera just need the best/worst stock name or symbol. Thats why im having trouble figuring out if its possible.

Thanks

johnl  
#4 Posted : Wednesday, May 21, 2008 1:44:56 PM(UTC)
johnl

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602

Read some investment books on stock selection and technical analysis to narrow down
your requirements. You can find some by Googling the net. Stocks are like ice cream,
they come in all different flavors and everyone has a different taste. You have to find what works best for you.

wabbit  
#5 Posted : Wednesday, May 21, 2008 7:47:55 PM(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)
autoct wrote:
I need a formula to get the best 10 stocks performers and 10 worst losers in the last 20 days.


How are you defining best and worst? Are you comparing the price on the last bar with the price twenty bars ago?

Code:

{col A}
ROC(C,20,%);


Then sort the results by the column.

Or do you have another defintion?



wabbit :D

P.S. If you want to use calendar days instead of bars this can be done too.

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.