Madhav1203
New Member
Hi guys,
Im doing pair trading and calculating p/L in excel sheet. Final profit field value is changing depending upon Profit or loss.. I want to know whats the high profit and whats the low loss. Just want to make a note of High and Low of that field....
Is this possible to catch high and low which is changing always.
Plz guys any one suggest .... thanks in advance.
In below Image A--> which marked.. wil change depending upon Profit or loss... I want to add new high value in B cell.. low value in C field....
A field wil change every second...... Plz find attached file for image
[/IMG]
Im doing pair trading and calculating p/L in excel sheet. Final profit field value is changing depending upon Profit or loss.. I want to know whats the high profit and whats the low loss. Just want to make a note of High and Low of that field....
Is this possible to catch high and low which is changing always.
Plz guys any one suggest .... thanks in advance.
In below Image A--> which marked.. wil change depending upon Profit or loss... I want to add new high value in B cell.. low value in C field....
A field wil change every second...... Plz find attached file for image