real time stock prices in excel

The Magic Formula for Beating the Market: Joel Greenblatt's Investing Strategy Explained 

Joel Greenblatt is widely considered to be one of the greatest investors of all time. In his book "The Little Book that Beats the Market," Greenblatt outlines a simple but effective investment strategy that has been shown to outperform the market over the long term. 

The strategy, known as the "magic formula," relies on a metric known as the Piotroski F-score, which can be used to assess real time stock prices in excel. Let us discuss some of the important facts that you need to consider if you want to make the most out of the score.

Piotroski F-score: The Guide

The Piotroski F-score is a numeric representation of a company's financial health. It is calculated by taking into account several key indicators, including profitability, cash flow, and leverage. A company with a high Piotroski F-score is more likely to be financially sound than one with a low score.

Greenblatt's magic formula is based on the premise that companies with high Piotroski F-scores will outperform the market over time. While there is no guarantee that this will always be the case, the evidence suggests that it is a reliable predictor of future stock performance considering the conditional value at risk excel.


How to Implement The Formula:

There are a number of different ways to implement Greenblatt's magic formula investment strategy.

  • One popular method is to use Excel to screen for stocks with high Piotroski F-scores. This can be done by downloading a stock's financial data from a website like Yahoo! Finance and then plugging that data into an option pricing model excel spreadsheet.
  • Once you have a list of stocks with high Piotroski F-scores, you can further research each one to determine if it is a good investment. This research should include looking at a company's financial statements, evaluating its business model, and considering its competitive advantages.
  • If you're looking for a simple but effective investing strategy, Greenblatt's magic formula may be right for you. Using the Piotroski F-score, you can screen for stocks that have the potential to outperform the market over the long term.

How to use Piotroski's F-score to find undervalued stocks:

Piotroski's F-score is a simple way to identify undervalued stocks.

  • First, you need to find the stocks that have a score of 8 or 9. These are the stocks that are the most undervalued.
  • Then, you need to look at the price-to-book ratio and the earnings per share. If these two ratios are low, then the stock is likely undervalued.
  • Finally, you need to look at the dividends per share. If the dividend per share is high, then the stock is likely undervalued.

By using Piotroski's F-score, you can easily find undervalued stocks that have the potential to generate big returns.

Conclusion:

Greenblatt's magic formula is a simple but effective investment strategy that has been shown to outperform the market over the long term. The strategy relies on a metric known as the Piotroski F-score, which is a numeric representation of a company's financial health. Companies with high Piotroski F-scores are more likely to be financially sound than those with low scores.