Percentile - Price vs Fundamentals

2021年8月31日

This is done in the same lines of below scripts
Drawdown-Price-vs-Fundamentals
Drawdown-Range

Instead of using drawdown, here we are only plotting percentile of drawdown. Also added few more fundamental stats to the indicator. Also using part of the code from Random-Color-Generator/ to automatically generate colors. This in turn uses code from RicardoSantos for convering color based on HSL to RGB

This is how the study can be used:

Study plots percentile of price and each of the listed fundamentals based on history. History can be chose All time or particular window. If any fundamental or price is near 100 - which means it is nearer to its peak. And if something is near its bottom, it is nearer to its 0th percentile.

Price of the stock is considered undervalued based on historical levels when it is below most of the fundamentals. Price is considered overvalued based on historical levels when it is above all the fundamentals. Please note, being undervalued does not guarantee immediate mean reversion. Stocks can stay undervalued for prolonged time and can go further down. Similarly overvalued stock can stay overvalued for prolonged time before correcting itself or justifying the position. Hence, further discretion needs to be used while using this study.

Few examples:

AMZN seems to be trading in range and so are the fundamentals:


MSFT at peak along with half of the fundamentals. But, debt levels are going up along with margins reducing.


LPX is trading at 15% discount whereas most of the fundamentals are at the peak.


FLGT price seems to have gone down further whereas fundamentals look pretty healthy.

2021年9月1日

發行說明

Added signature

2021年9月7日

發行說明

Update color function

2021年9月13日

發行說明

Added display headers

2021年10月5日

發行說明

Convert to pine 5

2022年1月23日

發行說明

Fix a small error caused due to EARNING_PER_SHARE financial security