Jump to content

How many trades to reach a set profit target

Recommended Posts


I'm trying to calculate how many trades I would need to make to reach a certain profit goal, taking into account win rate and profit/loss ratio.

For example:

Win rate of 50%
Profit/loss ratio of 2:1


A profit trade makes £50
A loss trade loses £25

How many trades to reach a total profit goal of, lets say... £1000

I know the answer is 80 trades, i.e. (40 x £50 = £2000) - (40 x £25 = £1000) = £1000

Here's where I'm struggling... How would I create a calculation in excel to manipulate the various values, win rate, profit loss ratio etc. and find how many trades to meet a set target. Any help much appreciated.

Link to comment


Hope this finds you well.

I have prepared the calculator. Attaching the same for your perusal. 




The yellow cells are the inputs and the color coded region is the P&L. 

As mentioned and highlighted, 80 trades with win rate of 50% would lead to P&L of 1000. 


Similarly, the other sheet in the calculator is based on the profit and loss per trade for given trade number and win rate.


The cells can be changed as per scenario to get insights. 


please let me know if any clarity is required. 

  • Like 2
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
    • Total Posts
    • Total Members
    • Most Online
      10/06/21 10:53

    Newest Member
    Joined 04/12/23 11:30
  • Posts

    • If you ever need advice or assistance in navigating the complexities of the mortgage market, I usually consult with Mortgage Broker Chelmsford for all my financial matters. They've been a great resource for me, and I highly recommend reaching out to experts like them for guidance.Let's hope the extension of the scheme provides some relief to first-time buyers and helps stimulate the housing market.
    • Going by what i see on the weekly TF, BTC is heading to $46-48k major price zone level. If it breaks and holds above this zone, then $51-52k is the next minor zone, since its a minor zone, BTC might rally at this zone before deciding to go all the way up or coming back down. Though, I am still mindful of the bearish flag pattern, so there is tendency that BTC could start dumping from any of this zones yah. Lets see how it plays out yah.
    • Interesting update. I also withdrew my funds from Binance and deposited it on Bitget and Bybit exchange just to be safe. Though, personally, I believe Binance will bounce back from this set back. It is no news that both CZ and Binance has contributed immense to the growth of the crypto space and continues to do so.. More so, their case is a different from FTX as you clearly stated. I am optimistic Binance is going no where, not any time soon yah.
  • Create New...