Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
COP logo

COP

NYE
ConocoPhillips
EnergyOil & Gas E&P
Watchlists:
Last updated: Sunday 20th July 2025
91.64
-1.17 (-1.26%)
Prev Close:92.81
Open:93.365
Bid:90.5
Ask:93.01
52 Week Range
79.88
116.08
Volume:7,785,879
Mkt Cap:116,836 M
Price Target
$105.39
+15.0%

Price Per Book (TTM)

Live
Returns the ratio of the stock's current price to its book value over the past 12 months.

How calculated

It is calculated by dividing share price by book value of the company per share

Example usage

=PricePerBook("MSFT")

Notes

Valuation of the company goes high with higher price to book number and vice versa

Assets

Stocks