HomeReady-2-GoPortfolioRankingScreenerStockETFToolsCommunityHelp
ForumsEmail UserPollsFeature RequestsGroups


  Index  | Recent Threads  | Who's Online  | User List  | Search
  Search  
Quick Go »
Thread Status: Normal
Total posts in this thread: 2
[Request a Feature] [Add To My Favorites] [Watch this Thread]
Author
Previous Thread This topic has been viewed 695 times and has 1 reply Next Thread
FelixB
Member


UNITED STATES
Joined: Apr 12, 2004
Posts: 6
Status: Offline

Increase number of arguments in Max / Min functions. Reply to this Post
Reply with Quote

The mathematical functions in Portfolio123 are very useful, but there is an annoying problem I have run in to and perhaps others have as well.

Suppose one wanted to find the maximum of the closing prices from 10 and 11 trading days ago; one simply uses
Max(Close(10),Close(11)).

But suppose one wanted to find the maximum of the closing prices from 10 through 19 trading days ago, a span of ten days. Because the Max function only allows for two arguments, this would require re-writing the Max function nine times:

Max(Max(...Max(Max(Close(10),Close(11)),Close(12)),...Close(18)),Close(19)).

Not only does this require a lot of extra writing of Max's and parentheses, it's also confusing. Why not allow for ten or more arguments, as in
Max(A1,A2,...,A10) ?

Ditto for the Min function.

A good design would still allow for the use of a smaller number of arguments, as in
Max(A1,A2,A3),
to fit the user's purpose. That is, a good design would allow for flexibility in the number of arguments specified by the user.

One further advantage: Because each BUY or SELL RULE has a limit on the number of characters that can be written (probably around 200), this change would allow the number of quantities for which the maximum (or minimum) is sought per RULE to be increased, since fewer characters would be used up in writing Max's and parentheses.
----------------------------------------
[Edit 1 times, last edit by FelixB at Oct 10, 2004 3:20:40 PM]
[Oct 8, 2004 7:32:59 PM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
marco


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

Re: Increase number of arguments in Max / Min functions. Reply to this Post
Reply with Quote

FelixB, thanks for the suggestions. This is in our to-do list, and it's something I've been wanting too.
----------------------------------------
Portfolio123 Staff
[Oct 15, 2004 10:37:45 AM] Show Post Printable Version     [Link] Report threaten post: please login first  Go to top 
[Show Thread Printable Version]

Free Trial  /  Log In
Username or Email
Password
Stay logged in
Can't remember username or password?