Jump to content

How many trades to reach a set profit target


Recommended Posts

Hi,

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

Assuming:

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

Hello,

Hope this finds you well.

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

https://1drv.ms/x/s!AlwK9pqvvQo_aWChCgsxdHMqpLw?e=0zW5co

image.thumb.png.1855e0349d704f2f0b0c816686ade033.png

 

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. 

image.thumb.png.ce64c9cb26c544c0c67c69c86dd74ae8.png

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
  • image.png

  • Posts

    • Recently, U.S. Senator Bill Hagerty from Tennessee spoke at the Bitcoin conference, stating his efforts to push for Bitcoin-supportive legislation to promote freedom and opportunity. This year, cryptocurrency has become a key battleground in the election campaigns. It remains to be seen whether future policies on cryptocurrency will improve.
    • The digital landscape is undergoing a profound transformation as attention, once a freely given commodity, is increasingly recognized as a valuable asset. Layer3 is at the forefront of this revolution, pioneering a new economy where attention can be owned, traded, and monetized   This innovative approach empowers individuals to monetize their engagement, providing unprecedented control over personal data. Simultaneously, advertisers benefit from transparent metrics that optimize campaign performance. Content creators are presented with diverse revenue avenues beyond traditional advertising, while the overall ecosystem experiences a more equitable distribution of value.   The implications of Layer3 extend across various sectors. Social media platforms, for instance, can leverage this technology to revolutionize user engagement and monetization strategies. Tokenomics play a crucial role in driving Layer3's economy, incentivizing participation and rewarding value creation. While challenges such as data privacy and market volatility exist, the potential benefits of Layer3 are immense   Anticipation is building as its native token $L3 is on Bitget Pre-market as users await its listing on the exchange. This milestone is expected to significantly increase the token's visibility and accessibility, potentially driving substantial growth and attracting new investors. As the countdown begins, the crypto community watches with keen interest, eager to see how Layer3 will perform in this new chapter.
    • I've been exploring the world of play-to-earn gaming recently, looking for something that's not just about endless grinding but actually offers a fun and rewarding experience. OGC really stood out to me because it combines gaming with a sense of community in a unique way. OGC isn't just a game; it's a platform where you can play, earn, and even help shape its future. You're not just a player; you're part of a community with a voice. The idea of earning crypto while playing games is exciting, but what makes OGC special is its focus on community involvement. Your feedback can directly influence the development of the game, which is a big deal. I've also heard that the OGC token is available for pre-market trading on Bitget. While I'm still getting to know the platform and its features, it's definitely something to keep an eye on. Has anyone else tried OGC? What has your experience been like? I'd love to hear your thoughts and any tips you might have.
×
×
  • Create New...
us