PE Ratio
The PE Ratio is fundamental data that we get from a third party once a night based on the data up through that day. PE or, Price/Earnings, ratio should change as the price changes. The PE Ratio is calculated by taking the Last price and dividing by Ernings Per Share (EPS). The Earnings figures are based on the last 12 months of available data (also known as TTM - Trailing 12 months).
If you are using Excel, it will not update dynamically. eSignal calculates the PE Ratio on the fly at the Desktop level as the price changes. The PE Ratio that you see in Excel is a static figure received from the Data Manager. This static figure is updated every evening.
If you would like to have Excel calculate the PE on the fly like eSignal does, all you need to do is setup a column that takes the last price and divides it by the EPS.
Comment