Stock Screener

[Denny]

Hi,

I'm a developer myself, and I think it's worth while listening to user
requests. I think the Stock Screener and what you've done with the
whole portfolio section of the web site is fantastic -- my congratz to
all responsible parties at Google! In case you are looking for ways
to improve your product, I'd like to suggest a few ways:

1. Add screening criteria that can be customized by entering
calculated fields. For example, I'd like to be able to add filtering
criteria:

VOLUME > 10000 // volume filter

and

(MAXH30 + MIN10) / CLOSE < 0.75 // volitility filter

where:
MAXH30 = Maximum high of the last 30 days
MIN10 = Minimum low of the last 10 days
CLOSE = Current day close

Or other criteria using other available fields.

2. I'd like to be able to select from ETF funds. Maybe you could add
that to one of the dropdowns?

3. I can edit portfolios and cut and paste the order the way I want
(which is how I do it now), but it would be great to have an up/down
button to rearrange the order, or even Kooler yet, drag and drop to
rearrange the order.

4. I was going to ask for the ability to enter multiple entries of the
same equity symbol to keep track of transactions in different
brokerages, but that's when I thought you could only have one
portfolio. Since then I've found it's bettah to have a separate
portfolio for each brokerage -- GOOD THINKING AND GOOD WORK!

Thanks!
Denny

[Denny]

One more:

5. Add the ability to fire an email when one or more criteria
expressions are met.
The criteria could be entered using common fields the same way as
described in (1) above.

Some fields that might be used in criteria expressions (among
others):

ATR15 = Average true range of the last 15 days
ATR20 = Average true range of the last 15 days

CLOSE = Current day close

MA20 = 20 day moving average
MA30 = 30 day moving average
MA50 = 50 day moving average
MAXH3 = Maximum high of the last 3 days
MAXH9 = Maximum high of the last 9 days
MAXH15 = Maximum high of the last 15 days

MAXH30 = Maximum high of the last 30 days

MIN3 = Minimum low of the last 3 days
MIN4 = Minimum low of the last 4 days

MIN10 = Minimum low of the last 10 days

XMA7 = 7 day exponential moving average
XMA15 = 15 day exponential moving average

Maybe it would be better to offer functions like ATR(days) and
XMA(days) that would return the average true range and exponential
moving average for the given number of days, which could be used in
the criteria expressions.

Just another idea!