Calculate PE Ratio Automatically in Excel in Under 5 Minutes with 3 Simple Steps

If you’re sick of doing Price to Earnings Ratio (PE Ratio) calculations by hand and spending tons of time manually entering data, then check out this Excel hack.

In this short process, we’ll show you how to pull the P/E Ratio for US publicly traded companies without doing manual calculations, which is possible through the Intrinio Excel Add-In.

Getting Started

Before you can pull the P/E Ratio, you will need to follow the following steps:

  1. Create a free Intrinio account by signing up here.
  2. Take a trial, or subscribe, to either/or both of the following Intrinio data feeds: US Fundamentals or US Sector and Industry.
  3. Download and install the free Excel Add-In. For help with downloading/installing the add-in, check out the Excel Tutorial.

 

Calculating PE Ratio

Now, in just three steps, you will be able to pull the P/E Ratio using the API Explorer and the Excel Add-In.

  1. Go to the P/E Ratio data tag page
  2. Scroll down to the API Explorer and copy the formula by clicking the notepad iconP/E Ratio Formula
  3. Paste the function into the excel sheet, change the company ticker to the cell in which the ticker is written, for instance, on the example below, “AAPL” was changed to be A2. This will allow you to update a whole list of tickers without manually changing the ticker on each formula. P/E Ratio Formula in Excel

 

How Intrinio Calculates PE Ratio

Our P/E Ratio is calculated by using the close price, over the net income, divided by weighted average diluted shares outstanding.

Intrinio P/E Ratio Calculation

 

Additional PE Ratio Calculations

Check out our PE Calculation video tutorial to also learn how to:

  1. Compare your calculations with our P/E Ratio calculation
  2. Calculate a real-time P/E Ratio
  3. Calculate a historical P/E Ratio