Percentile - Price vs Fundamentals

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.

เอกสารเผยแพร่:

Added signature

เอกสารเผยแพร่:

Update color function

เอกสารเผยแพร่:

Added display headers

เอกสารเผยแพร่:

Convert to pine 5

เอกสารเผยแพร่:

Fix a small error caused due to EARNING_PER_SHARE financial security