Creating a trade calculator in Excel | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

MT4 Position Size Calculator Excel Spreadsheets 28 replies

Excel Trade Calculator - Try it! 3 replies

Creating a Trade Journal for Word/Excel 0 replies

Can somebody share your excel calculator? 0 replies

excel calculator 2 replies

Attachments: Creating a trade calculator in Excel
Exit Attachments

Creating a trade calculator in Excel

  • #1
  • First Post: Jan 16, 2018 7:59am Jan 16, 2018 7:59am
Hello, I`m trying to create a calculator for my trading style in excel,
I`m trading only using either buy or sell stops.
I need to calculate my risk rewards.

For example I have a buy stop on EurUsd
Entry : 1.23053
Stop Loss : 1.22383

Now my take profit should be the same range as the distance from entry to stop loss,
which in this example would be : [entry]-[stop loss] = 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 have no idea what round turn means)

Furthermore i`m planing to later on calculate the risk:reward in euros.
The truth is hidden from you
  • #2
  • Jan 16, 2018 8:08am Jan 16, 2018 8:08am
Does mt4 factor in commission+spread when showing profit/loss on trade levels in currency ?
Perhaps someone knows the formula on how they are calculated
Attached Images
The truth is hidden from you
  • #3
  • Jan 16, 2018 8:22am Jan 16, 2018 8:22am
Quoting MaxenshteinD
Does mt4 factor in commission+spread when showing profit/loss on trade levels in currency ? Perhaps someone knows the formula on how they are calculated {image} {image}
Hi Max :-)

Pop over to the the thread here and download the TM.rar file and have 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 which displays spread and SWAP etc. :-)

Cheers C
  • #4
  • Jan 16, 2018 9:03am Jan 16, 2018 9:03am
Quoting Copernicus
{quote} Hi Max :-) Pop over to the the thread here and download the TM.rar file and have 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 which displays spread and SWAP etc. :-) Cheers C
thanks allot))) Will take a look at it now
The truth is hidden from you
  • #5
  • Jan 16, 2018 1:26pm Jan 16, 2018 1:26pm
Quoting MaxenshteinD
Hello, I`m trying to create a calculator for my trading style in excel, I`m trading only using either buy or sell stops. I need to calculate my risk rewards. For example I have a buy stop on EurUsd Entry : 1.23053 Stop Loss : 1.22383 Now my take profit should be the same range as the distance from entry to stop loss, which in this example would be : [entry]-[stop loss] = 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 have no...
round turn means: broker charge 0.03 for trade entry n 0.03 for exit >> total 0.06 in deposit currency for 0.01 lot traded for round turn >> single trade [open-close]

u can ask me anything I will help u understand FX
WaBaS Where are Buyers and Sellers
  • #6
  • Jan 16, 2018 1:53pm Jan 16, 2018 1:53pm
Quoting mr.brown
{quote} round turn means: broker charge 0.03 for trade entry n 0.03 for exit >> total 0.06 in deposit currency for 0.01 lot traded for round turn >> single trade [open-close] u can ask me anything I will help u understand FX
thanks ) now I see, never knew that before
The truth is hidden from you
  • #7
  • May 18, 2020 7:44pm May 18, 2020 7:44pm
Quoting mr.brown
{quote} round turn means: broker charge 0.03 for trade entry n 0.03 for exit >> total 0.06 in deposit currency for 0.01 lot traded for round turn >> single trade [open-close] u can ask me anything I will help u understand FX
Could you help me out please,
say if I was going to place a 0.5 lot trade on a currency and I close it after 10 pip profit.
What would that mean in terms of the commission charged?
From what I can understand, would that mean that from the profit made at 1:500 leverage, of about £41, I would be charged £2.5 commission? because they say they charge on a GBP account of 0.025, they charge GBP 0.05 round turn on a 0.01 lot trade
  • #8
  • Nov 5, 2020 7:41am Nov 5, 2020 7:41am
It's really cool that you decided to do this, because it seems to me that this may be relevant for a large number of traders who really want to understand trading and often difficulties arise precisely at the stage of calculations, because here you need to evaluate the value of assets and many others parameters, and traders often make mistakes with this, they cannot correctly assess what part of the capital they are risking, etc. And this leads to great losses and frustration in their own work. This seems hopeless and wrong to me, so I wish you to cope with this task as soon as possible and that traders will appreciate your development.
  • #9
  • Last Post: Nov 5, 2020 7:42am Nov 5, 2020 7:42am
And I have heard the opinion that this is not the most necessary thing in the market, because a trader still needs to try to carry out all operations in the market, including calculations, because it contributes to the fact that he will learn to work with quality in his own practice and mistakes, and thus become a real professional who understands the principles of work and can make informed decisions in the market. I can certainly make mistakes and perhaps beginners really need to use such things. But definitely passive formats in all their manifestations should not outweigh the active options of work, because it will lead to the depreciation of this business...
0 traders viewing now