Percentile - Price vs Fundamentals

31 ago 2021

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.

1 set 2021

Note di rilascio

Added signature

7 set 2021

Note di rilascio

Update color function

13 set 2021

Note di rilascio

Added display headers

5 ott 2021

Note di rilascio

Convert to pine 5

23 gen 2022

Note di rilascio

Fix a small error caused due to EARNING_PER_SHARE financial security