SONJOE JOSEPH
Member
Dear All,
In the Excel sheet attached i have some completed transactions and on the right side u will find the Equity Curve data. I want only the completed transaction to appear in the Equity Curve. My idea is as soon as i enter the S.Price whether its Profit or loss the value should be updated in the "AMT" column as well as the "Dates" and if its Profit or Loss" in the notes it should either come "PROFIT OR LOSS".
Whether it can be done....just help me how to do it.
Regards,
Sonjoe Joseph
(Working file attached)
In the Excel sheet attached i have some completed transactions and on the right side u will find the Equity Curve data. I want only the completed transaction to appear in the Equity Curve. My idea is as soon as i enter the S.Price whether its Profit or loss the value should be updated in the "AMT" column as well as the "Dates" and if its Profit or Loss" in the notes it should either come "PROFIT OR LOSS".
Whether it can be done....just help me how to do it.
Regards,
Sonjoe Joseph
(Working file attached)