Thanks very much. I appreciate it.

Hello:

If I want to return stocks where the EMA7 has crossed above the EMA20 exactly one time in the last 101 days, is the following correct? No fewer and no more crosses above.

COUNTTRUE(XUP(XAVGC7, XAVGC20),101) = 1

Thank you very much.

Yes, I think this is exactly it. I wanted to use the min/max values for historical vol instead of price. 

Thank you very much. Works perfectly.

Hello. Is it possible to do an evaluation like A but using the historical vol forumula in B instead of the H and L values max/min values?
 

I know what you're thinking to yourself. Well, the answer is: I'm never really sure. That's why.

Thank you, Bruce. I really appreciate it. Have an enjoyable weekend.

Hello.

How does one write the following historical vol calc for "7 days back"? That is, how do I output the 23-day historical vol reading from 7 days ago?

(1600 * ABS((SUM(LOG(C / C1) ^ 2, 23) - LOG(C / C23) ^ 2 / 23) / 23) ^ .5)

Thank you very much.

Hi, Bruce. Hope all is well, and thank you very much. Sorry for my late reply.

Thank you for the solutions to part A. I think for part B, simply get to know your uncle better. Take him out for coffee or miniature golf. He'll probably offer a tip or two. I don't know, just spitballing here.

Enjoy the weekend. Thanks again.

Hello.

1. What's the correct formula for counting the days back since an event has occurred? In an example, since a cross above EMA100?

2. Is there any kludge formula for outputting a "true" check for a selected ticker? Let's say I have a watchlist of 20 stocks. One of these stocks is "held by my uncle" and I want to track that piece of information with a "true check". Is there any tricky way to do this?

Thank you very much.

Hi, Bruce. I'm not sure where I went wrong, but these work well and with some adjustment of the percent do what's needed. Thank you very much for the help.

Hi, Bruce. Thanks. Yes, the last paragraph you wrote was essentially what I'm trying to do. I have been using H > MAXH49.1 for the period.