I just added the built in Function Gappers Daily to a Watch List, and it populates the cells with either Gap Up or Gap Down. Neat

How do they do that, or of more curiosity, can I do the same thing?

Any other functions do an equivalent thing?

Thanks

It is only able to do this and output text because it is on the servers. The actual formula used just returns 1 when there is a gap up and 2 whene there is a gap down.

-1 * (L>H1) + -2 * (H<L1)

The key to how this works is that a Boolean (true or false) expression in parentheses is going to return -1 when true and 0 when false. An alternative would be to use an ABS() function instead of just plain parentheses because that will return 1 when true and 0 false.

So how do I get coding access to the servers? Just joking.

Thought it would be something like that, but I was so pleased?, surprised? to see words in a WatchList, I just had to ask.

Thanks

Sorry there isn't a way to output words. But you can use numbers to communicate multiple results in the same WatchList column.

Thanks for the comment about using numbers, with PCFs similar to Gappers. I'll have to think about where to use it eg scoring stocks across several criteria.

You're welcome.

How can I set up the gap scan so that it scan pre-market?

Ander509

Pre-market scanning is not currently available in TC2000.