If you are overlaying a study from a higher timeframe chart, using the Study/Price Overlay study on the lower timeframe chart, with Fill Blanks With Last Value set to Yes, there will be some consecutive segments with equal values.
To extrapolate a slope from these consecutive cells of equal value, put this formula in cell, e.g., Z3:
This example assumes the overlay study’s output is in column AA.
This will give an indication of the previous direction of the higher timeframe study, skipping over the equal values cells on the lower timeframe, until the direction changes.
You can then reference this cell to create alerts, color bars, or autotrading signals, etc.