WHC whitehaven coal limited
Add to My Watchlist 0.46% ! $5.50

=SUMPRODUCT(--(P4>{0;100;150;175;225;300}),(P4-{0;100;150;175;225...

  1. hagetaka
    6,949 Posts.
    lightbulb Created with Sketch. 1174
    clock Created with Sketch.
    22/06/24
    17:50
    Post #: 74440185
    =SUMPRODUCT(--(P4>{0;100;150;175;225;300}),(P4-{0;100;150;175;225;300}), {0.07;0.055;0.025;0.05;0.1;0.1})
    .
    Put the sale price in cell P4.
    .
    Easy Excel.
    .
    https://hotcopper.com.au/data/attachments/6264/6264027-6650808e0edab1bb416d675ac61f7cdb.jpg
    WHC Price at posting: $7.95 Sentiment: Hold Disclosure: Held
    Likes Created with Sketch. 7  Upvote
    lightbulb Created with Sketch.  Great analysis
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 

Featured News

NEWS Equity Metals reports that drilling is underway on the Silver Queen Ag-Au property
right-arrow Created with Sketch.
NEWS Many Peaks accelerating gold hunt in Côte d'Ivoire after assay 'justification'
right-arrow Created with Sketch.
NEWS Orthocell Announces First US Surgical Use of Remplir Following FDA Clearance
right-arrow Created with Sketch.
NEWS Uranium ignites: Is this the start of a supercycle?
right-arrow Created with Sketch.
NEWS How Do You Trade? Take Our 1-Minute Survey & Share Your Style
right-arrow Created with Sketch.
NEWS Bullish Brookside expands with fifth DSU at 'highly sought after' American oil and gas field
right-arrow Created with Sketch.
Add to My Watchlist
What is My Watchlist?
A personalised tool to help users track selected stocks. Delivering real-time notifications on price updates, announcements, and performance stats on each to help make informed investment decisions.
Add to My Watchlist
(20min delay)
Last
$5.50 		Change
0.025(0.46%) 		Mkt cap ! $4.609B
Open High Low Value Volume
$5.48 $5.54 $5.45 $5.975M 1.086M

Buyers (Bids)

No. Vol. Price($)
25 30894 $5.49
 

Sellers (Offers)

Price($) Vol. No.
$5.50 19230 14
View Market Depth
Last trade - 11.11am 27/06/2025 (20 minute delay) ?
WHC (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.