PE Ratio Intrinsic ValueThe "Median PE Ratio and Intrinsic Value" indicator is designed for traders and investors who wish to evaluate the intrinsic value of a stock based on a comparative analysis of Price-to-Earnings (PE) ratios across multiple stocks. This tool not only provides insights into whether a stock is undervalued or overvalued but also allows you to visualize the intrinsic value directly on the chart.
Comparison Across Multiple Stocks:
This indicator calculates the PE ratio for up to five different stocks, allowing you to compare the target stock's valuation against four other same sector companies. By default, the stocks included are Apple (AAPL), Google (GOOG), Microsoft (MSFT), and Amazon (AMZN), but you can customize these symbols to fit your analysis needs.
Dynamic PE Ratio Calculation:
The indicator calculates the PE ratio for each stock by dividing the current price by the earnings per share (EPS). The EPS data is retrieved based on the selected period, which can be one of the following:
FY (Fiscal Year)
FH (Fiscal Half-Year)
FQ (Fiscal Quarter)
TTM (Trailing Twelve Months)
You can easily switch between these periods using the provided input options, enabling a more customized analysis based on your preferred financial timeframe.
Once the PE ratios for the selected stocks are computed, the indicator calculates the average PE ratio. The average value is a robust measure that reduces the influence of outliers and provides a balanced view of market valuation.
The intrinsic value of the stock on the chart is calculated by multiplying its EPS by the median PE ratio of the selected stocks. This gives you an estimate of what the stock should be worth if it were to trade at a fair valuation relative to the chosen peers.
The intrinsic value is plotted directly on the price chart as a step line with breaks. This step line style is chosen to represent changes in intrinsic value clearly, with breaks indicating periods where the calculated value is not valid (e.g., negative intrinsic value). Only positive intrinsic values are displayed, helping you focus on meaningful data.
You can easily customize the stocks analyzed by entering the ticker symbols of your choice. Additionally, the indicator allows you to adjust the timeframe for EPS data, giving you flexibility depending on whether you are focused on long-term trends or shorter financial periods.
How to Use:
Compare the current stock price to the plotted intrinsic value. If the current price is below the intrinsic value, the stock may be undervalued. Conversely, if the price is above the intrinsic value, the stock might be overvalued. By comparing your stock against major market players, you can gauge whether it's trading at a premium or discount relative to other key companies in the sector. Use the period selection (FY, FQ, TTM) to adapt your analysis to different market conditions or earnings cycles, giving you more control over your valuation assessment.
Ideal For:
Long-term Investors looking to assess the intrinsic value of a stock based on comparative analysis.
Fundamental Analysts who want to combine multiple stocks' PE ratios to estimate a fair valuation.
Value Investors interested in finding undervalued opportunities by comparing the market price to intrinsic value.
Financialstocks
Financial Ratios Fundamental StrategyWhat are financial ratios?
Financial ratios are basic calculations using quantitative data from a company’s financial statements. They are used to get insights and important information on the company’s performance, profitability, and financial health.
Common financial ratios come from a company’s balance sheet, income statement, and cash flow statement.
Businesses use financial ratios to determine liquidity, debt concentration, growth, profitability, and market value.
The common financial ratios every business should track are
1) liquidity ratios
2) leverage ratios
3)efficiency ratio
4) profitability ratios
5) market value ratios.
Initially I had a big list of 20 different ratios for testing, but in the end I decided to stick for the strategy with these ones :
Current ratio: Current Assets / Current Liabilities
The current ratio measures how a business’s current assets, such as cash, cash equivalents, accounts receivable, and inventories, are used to settle current liabilities such as accounts payable.
Interest coverage ratio: EBIT / Interest expenses
Companies generally pay interest on corporate debt. The interest coverage ratio shows if a company’s revenue after operating expenses can cover interest liabilities.
Payables turnover ratio: Cost of Goods sold (or net credit purchases) / Average Accounts Payable
The payables turnover ratio calculates how quickly a business pays its suppliers and creditors.
Gross margin: Gross profit / Net sales
The gross margin ratio measures how much profit a business makes after the cost of goods and services compared to net sales.
With this data, I have created the long and long exit strategy:
For long, if any of the 4 listed ratios,such as current ratio or interest coverage ratio or payable turn ratio or gross margin ratio is ascending after a quarter, its a potential long entry.
For example in january the gross margin ratio is at 10% and in april is at 15%, this is an increase from a quarter to another, so it will get a long entry trigger.
The same could happen if any of the 4 listed ratios follow the ascending condition since they are all treated equally as important
For exit, if any of the 4 listed ratios are descending after a quarter, such as current ratio or interest coverage ratio or payable turn ratio or gross margin ratio is descending after a quarter, its a potential long exit.
For example in april we entered a long trade, and in july data from gross margin comes as 12% .
In this case it fell down from 15% to 12%, triggering an exit for our trade.
However there is a special case with this strategy, in order to make it more re active and make use of the compound effect:
So lets say on july 1 when the data came in, the gross margin data came descending (indicating an exit for the long trade), however at the same the interest coverage ratio came as positive, or any of the other 3 left ratios left . In that case the next day after the trade closed, it will enter a new long position and wait again until a new quarter data for the financial is being published.
Regarding the guidelines of tradingview, they recommend to have more than 100 trades.
With this type of strategy, using Daily timeframe and data from financials coming each quarter(4 times a year), we only have the financial data available since 2016, so that makes 28 quarters of data, making a maximum potential of 28 trades.
This can however be "bypassed" to check the integrity of the strategy and its edge, by taking for example multiple stocks and test them in a row, for example, appl, msft, goog, brk and so on, and you can see the correlation between them all.
At the same time I have to say that this strategy is more as an educational one since it miss a risk management and other additional filters to make it more adapted for real live trading, and instead serves as a guiding tool for those that want to make use of fundamentals in their trades
If you have any questions, please let me know !
Stock Comparison to S&P 500This indicator, "Stock Comparison to S&P 500," is designed to help traders compare the financial health and valuation of a chosen stock to the S&P 500 index. It compares several key financial metrics of the stock to the corresponding metrics of the S&P 500, including earnings growth, price-to-earnings ratio, price-to-book ratio, and price-to-sales ratio.
The indicator calculates the differences between each metric of the selected stock and the S&P 500, and then weights them using a formula that takes into account the importance of each metric. The resulting value represents the overall comparison between the stock and the S&P 500.
The indicator also displays the differences between the individual metrics in separate plots, allowing traders to see how each metric contributes to the overall comparison. Additionally, it colors the plots green if the selected stock is performing better than the S&P 500 in a particular metric and red if it's performing worse.
Traders can use this indicator to gain insight into the relative financial health and valuation of a selected stock compared to the S&P 500 index, which can help inform their trading decisions.
