Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 06:40:02 +0000



Post From: Basic question about a spreadsheet system for trading

[2024-08-19 23:19:23]
AntoineOpala - Posts: 66
Thank you for your replies. Last question :

I want to backtest whether a trade went to 3R or stopped out at -1R first.

I added a cell where I manually write down my entry price so it remains still.
I added another containing the size of my stoploss.
Another that says how many ticks must be overcome to reach 3R.
Another that says the hard price where 3R is.

I cannot seem to find a formula that would tell me which happened first after my entry : whether -1R or +3R.

How would you proceed?