Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
ONEOK Inc. logo


Sector: Energy   

Industry: Oil & Gas Midstream

Optionable: Yes  Market Cap: 44,950 M  90-day average vol: 2,968,486

Previous close: 77.88  Open: 78.1  Bid: 78.46  Ask: 79.99
52 week range    
ATO / 
SRE / 
NFG / 
WES / 
SE / 
UGI / 
SWX / 
Last updated: Sunday 21st April 2024
MarketXLS Rank

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord



StockDividendMarket Cap (B)PEPrice ($)


0.025714 B20.9105.94


8 B-2.421.17


0.03076 B15.359.52



0.032143 B37.7137


0.0364 B16.666.04


0.033810 B6.640.81



OKE Income Statement

AccruedPreferredStockDividends767000.01 M1 M1 M
AcquisitionExpense30 M
Amortization of intangibles9 M12 M12 M12 M12 M12 M12 M11 M
Basic EPS from continuing operations1.291.531.191.682.
Basic EPS total1.
Basic weighted shares outstanding206 M209 M210 M211 M297 M411 M414 M431 M446 M448 M
Cost of sales10,222 M10,089 M5,641 M6,496 M9,538 M9,423 M6,788 M5,110 M-12,878 M-18,536 M
Depreciation239 M295 M355 M392 M406 M429 M477 M579 M
Depreciation unreconciled239 M295 M355 M392 M406 M429 M477 M579 M
Diluted EPS total1.271.491.161.662.585.563.071.423.353.84
Diluted normalized net income/share1.271.521.191.672.585.563.071.423.353.84
Diluted weighted shares outstanding210 M210 M211 M212 M300 M414 M415 M432 M447 M448 M
Dividends paid per share1.482.132.432.462.723.253.533.743.743.74
Earnings from equity interest111 M117 M125 M140 M159 M158 M155 M143 M123 M148 M
EarningsFromEquityInterestNetOfTax111 M117 M125 M140 M159 M158 M155 M143 M123 M148 M
ExplorationDevelopmentAndMineralPropertyLeaseExpenses-599 M-606 M-668 M-607 M
GainOnSaleOfBusiness195 M
GainOnSaleOfPPE12 M7 M6 M10 M924000.0601000.0-3 M1 M1 M
GainsLossOnDisposalOfDiscontinuedOperations-12 M-6 M-6 M-2 M
Gross operating profit1,650 M2,107 M2,122 M2,425 M2,636 M3,170 M3,376 M3,432 M3,662 M3,851 M
ImpairmentOfCapitalAssets76 M264 M20 M645 M
Income before tax755 M820 M522 M958 M1,041 M1,518 M1,651 M802 M1,984 M2,250 M
Income restructuring and M&A139 M2 M
Income taxes166 M151 M137 M212 M447 M363 M372 M190 M484 M527 M
InterestExpenseNonOperating271 M356 M417 M470 M486 M470 M492 M713 M733 M676 M
MinorityInterests-310 M-349 M-134 M354 M388 M-3 M
MiscOtherSpecialCharges35 M-9 M-2 M2 M-20 M-6 M74 M48 M-2 M-30 M
Net income from total operations267 M314 M245 M352 M388 M1,152 M1,279 M612 M1,499 M1,721 M
NetIncomeCommonStockholders11,447 M11,601 M7,098 M352 M387 M1,151 M1,277 M612 M1,499 M1,721 M
NetIncomeContinuousOperations267 M314 M245 M352 M388 M1,152 M1,279 M612 M1,499 M1,721 M
NetIncomeDiscontinuousOperations-12 M-6 M-6 M-2 M
NetNonOperatingInterestIncomeExpense-271 M-356 M-417 M-470 M-486 M-470 M-492 M-713 M-733 M-676 M
Normalized income618 M681 M862 M613 M746 M1,199 M1,307 M1,315 M1,568 M1,777 M
Operating income881 M1,144 M996 M1,286 M1,392 M1,835 M1,914 M1,361 M2,596 M2,807 M
Operating income before depreciation (EBITDA)1,265 M1,471 M1,293 M1,819 M1,933 M2,416 M2,619 M2,094 M3,339 M3,552 M
OperatingExpense781 M-229 M-164 M1,149 M1,229 M1,336 M1,459 M858 M-1,067 M-1,043 M
Other income net-157 M-39 M136 M-152 M-120 M-153 M-226 M-155 M-122 M-118 M
Other special charges2 M3 M
OtherImpairmentOfCapitalAssets76 M264 M20 M38 M
OtherOperatingExpenses-479 M-599 M668 M724 M803 M864 M761 M106 M
OtherTaxes62 M76 M88 M89 M98 M104 M119 M125 M167 M191 M
OtherunderPreferredStockDividend767000.01 M1 M1 M1 M1 M
PreferredStockDividends767000.01 M1 M1 M1 M1 M
RestructringAndMnAIncome139 M2 M
Special income/charges139 M78 M264 M20 M645 M-3 M-3 M
Total Income available for interest expense (EBIT)1,026 M1,176 M939 M1,428 M1,526 M1,988 M2,143 M1,515 M2,717 M2,926 M
Total common shares outstanding208 M208 M210 M211 M411 M412 M413 M445 M446 M447 M
Total net income267 M314 M245 M352 M388 M1,152 M1,279 M612 M1,499 M1,721 M
Total ordinary shares583 M583 M583 M583 M583 M583 M583 M583 M583 M583 M
Total revenues11,872 M12,195 M7,763 M8,921 M12,174 M12,593 M10,164 M8,542 M16,540 M22,387 M
TotalExpenses11,003 M9,860 M5,478 M7,645 M10,767 M10,758 M8,247 M5,968 M13,944 M19,579 M
TotalRevenue11,872 M12,195 M7,763 M8,921 M12,174 M12,593 M10,164 M8,542 M16,540 M22,387 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University