Creating a trade calculator in Excel
Results 1 to 6 of 6

Thread: Creating a trade calculator in Excel

  1. #1
    Hello, I'm hoping to create a calculator for my trading design in excel,
    that I'm trading only using either buy or sell stops.
    I must figure my risk benefits.

    As an instance I have a buy stop on EurUsd
    Entry: 1.23053
    Stop reduction: 1.22383

    Now my take profit ought to be the exact same range as the distance from entry to stop loss,
    that in this example is: [entrance ]-[stop reduction ] = 1.23053 - 1.22383 = 0.00670

    spread commission a couple of pips of pure profit.

    That I'm using IC Markets and the incentives for EURUSD are
    EUR 0.03
    (EUR 0.06 round turn) (I have no idea what round turn means)

    Furthermore I'm planing to later on calculate the risk:benefit in euros.

  2. #2
    Quote Originally Posted by ;
    Can mt4 variable in commission disperse when showing profit/loss on trade levels in currency? Maybe someone knows the formulation on how they are calculated image image
    Hi Max:--RRB-

    Pop over into the thread here and then download the TM.rar document and have a look at the calculations used in the trading template spreadsheet. It should have everything you are after. It derives it has data from MT4 and resurrects trade history into a format that displays spread and SWAP etc..:--RRB-

    Cheers C

  3. #3
    Quote Originally Posted by ;
    quote Hi Max:--RRB- Pop over to the ribbon here and also download the TM.rar file and take a look at the calculations used in the trading template spreadsheet. It should have everything you are after. It derives it's data from MT4 and resurrects trade history into a format that shows spread and SWAP etc.:--RRB- Cheers C
    thanks allot))) Will take a look at it now

  4. #4
    Quote Originally Posted by ;
    HelloI'm trying to make a calculator to my trading style in excel, I'm trading only using either buy or sell stops. I need to figure my risk rewards. As an instance I have a buy stop on EurUsd Entry: 1.23053 Stop Loss: 1.22383 Now my take profit ought to be the exact same range as the distance from entry to stop loss, which in this example is: [entry]-[stop reduction ] = 1.23053 - 1.22383 = 0.00670 spread commission a few pips of pure profit. I'm using IC Markets and the commissions for EURUSD are EUR 0.03 (EUR 0.06 round turn) (I've no...
    round turn signifies: broker charge 0.03 for trade entry n 0.03 for exit gt;gt; complete 0.06 in deposit currency for 0.01 lot traded for round twist gt;gt; single trade [open-close]

    u may ask me anything I will help u understand FX

  5. #5
    Quote Originally Posted by ;
    quote round turn Signifies: broker charge 0.03 for Transaction entry n 0.03 for exit gt;gt; total 0.06 in deposit currency for 0.01 lot Exchanged for Around turn gt;gt; Solitary Commerce [open-close] u May ask me anything I'll help u Know FX
    thanks ) now I Find, never knew that before

  6. #6
    Can mt4 factor in commission spread when showing profit/loss on trade amounts in currency?
    Perhaps someone knows the formula on how they're calculated


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.