I am a trader and I currently use Excel to help me determine when I should
enter and exit trades. I would like to find a way to compare my Profit and
Loss on a real-time basis so that I know how much I have been up and how much
I have been down. With this, I will use P-n-L management to help me exit all
my positions when the P-n-L on these trades falls a certain percentage. Is
it possible to create a graph that will show the high and low of a cell's
value, even if it has changed quite frequently? What I want to do is have
the high value and the low value both printed in a separate and then plotted
on a graph with the current pnl value. I have tried to get the value using
'IF' statements, but it isn't working.

Such as:
=IF(K24J24,CELL("contents",K24),CELL("contents",J 24))


Thank You