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.
M&M Long 1396 1401.45 250 1403.91376.6 1362.5
MARUTI Short 2945 2942 125 2963.15 2921 375
Final Profit=1737.5
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.
M&M Long 1396 1401.45 250 1403.91376.6 1362.5
MARUTI Short 2945 2942 125 2963.15 2921 375
Final Profit=1737.5