Portfolio123 - View Thread - Feature Request: Eval with multiple conditions

Home Ready-2-Go Portfolio Ranking Screener Stock ETF Tools Community Help

Forums Email User Polls Feature Requests Groups

Index | Recent Threads | Who's Online | User List | Search

Portfolio123 » List all forums » Forum: Feature Suggestions » Thread: Feature Request: Eval with multiple conditions

Thread Status: Normal
Total posts in this thread: 2

[Request a Feature] [Add To My Favorites] [Watch this Thread]

Author

This topic has been viewed 868 times and has 1 reply

stenci
Advanced Member

UNITED STATES
Joined: Feb 19, 2006
Posts: 131
Status: Offline

Feature Request: Eval with multiple conditions

Reply to this Post
Reply with Quote

The Eval function allows to enter only one condition.
I would like to enter more conditions like that:

Eval(Condition1, Value1, [Condition2, Value2,] Value)

This would allow to use something like this in a ranking:

Eval(Price < 2, 0, Price < 4, (Price - 2) / 2, Price < 40, 1, Price < 60, (Price - 40) / 20, 0)
View the feature request here.

[Sep 1, 2006 8:14:23 PM]

[Link]

marco

UNITED STATES
Joined: Jan 1, 1970
Posts: 3980
Status: Offline

Re: Feature Request: Eval with multiple conditions

Reply to this Post
Reply with Quote

I think you can do this with multiple Evals. For example to screen for:

Stocks with a MarketCap > 10B

OR

Stocks with last close > 5

Enter the following:

eval(mktcap<10000 , eval(close(0) > 5 , TRUE,FALSE) , TRUE)

With 2 Evals you can have 3 different values although the example above has 2.
----------------------------------------
Portfolio123 Staff

[Sep 1, 2006 9:25:39 PM]

[Link]

[Show Thread Printable Version]

Free Trial / Log In