Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Price To Earnings Ratio (PE Ratio - Historical)

Live
The price-to-earnings ratio (P/E ratio) is the ratio for valuing a company that measures its current share price relative to its per-share earnings (EPS).

How calculated

P/E Ratio is calculated by dividing the market price of a share by the earnings per share.

Example usage

=hf_Price_to_Earnings_Ratio("MSFT",2021)- Returns the value of for the year 2021.
=hf_Price_to_Earnings_Ratio("MSFT",2021,2)- Returns the value for the year 2021 and the calendar quarter 2
=hf_Price_to_Earnings_Ratio("MSFT",2021,3,"TTM")- Returns the value for the year 2021 and trailing twelve months from the calendar quarter
=hf_Price_to_Earnings_Ratio("MSFT","lq") - Returns the value for the last quarter
=hf_Price_to_Earnings_Ratio("MSFT","lq-1")-Returns the value for the last quarter-1
=hf_Price_to_Earnings_Ratio("MSFT","ly") - Returns the value for the last year
=hf_Price_to_Earnings_Ratio("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Price_to_Earnings_Ratio("MSFT","lt") - Returns the value for the last 12 months.
=hf_Price_to_Earnings_Ratio("MSFT","lt-1") - Returns the value for the previous last 12 months.

Assets

Stocks