How to paste values that stick into dynamically generated cells

[Bridger18]

I have setup some excel sheets for paper trading stocks. Please see attached.
Column C is a dynamically changing price, every 15 seconds.
Column G is a stop loss price, It is calculated from C minus 4%, what I would like to do is have it be static, that is once calculated, not to keep changing with the value of C.
Column E calculates to see if the current price (C) is lower than the stop loss price G and if yes then enters the the stop loss price into column E.
My problem is two fold, first of all the Stop loss price G is always changing with C, second if I could stop the G from changing, the value in E would appear and disappear with the fluctuations in cell C. How can I make values "stick" in G once they are calculated and in E once the IF statement is true, so that it does not change again when the IF statement becomes False.
Thank you in advance for any help.

[AliGW]

This will require VBA, so I'm moving your thread to that section.

[maniacb]

Possibly this solution in the sheet module

Please Login or Register  to view this content.

[Bridger18]

Thank you Maniacb, That worked great!