Sometimes you need an AFL which makes it easier to identify certain stocks. At times like this, color coding helps a stock visually stand out so it gets your attention.
An example is this report which visually highlights stocks gaining or losing more than 2%, close above/ below 10 DMA and RSI more / less than 80/ 20.
.
Note that FILTER=1 so all stocks from your list/ watchlist will be displayed.
And this is the code:
All the color coding is done via IIF functions.
An example is this report which visually highlights stocks gaining or losing more than 2%, close above/ below 10 DMA and RSI more / less than 80/ 20.
Note that FILTER=1 so all stocks from your list/ watchlist will be displayed.
And this is the code:
No comments:
Post a Comment