If you’re sick of doing Price to Earnings Ratio (P/E Ratio) calculations by hand and spending tons of time manually entering data, then check out this Excel hack.
Before you can pull the P/E Ratio, you will need to follow the following steps:
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 icon.
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.
Our P/E Ratio is calculated by using the close price, over the net income, divided by weighted average diluted shares outstanding.
Check out our P/E Calculation video tutorial to also learn how to: