Calculating Margin Call | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Margin Levels and Margin Calls 23 replies

Margin/Free Margin/Equity 11 replies

Margin/Margin calls based on equity? 5 replies

difference between Usable Margin and Used Margin 9 replies

Understanding Margin and Margin Calls 0 replies

Attachments: Calculating Margin Call
Exit Attachments

Calculating Margin Call

  • #1
  • First Post: Apr 18, 2011 12:39am Apr 18, 2011 12:39am
Hi traders.

I created this Excel when on Friday evening(April 15th), I thought I bought EURJPY price (on FX Primus) at 120.082
On the broker server it gave me a buy price of 120.21x
Its around 11-13 pips off. This is my first time seeing this on my new broker.

Shocked, I went to http://messenger.providesupport.com/.../fxprimus.html
to rectify the problem!

Am a short term trader. Luckily this problem happened in a consolidated period, otherwise I'd be a sitting duck to be roasted.

Attached is a Margin Call (Excel 2003) spreadsheet.

To mathematicians & veteran traders, I need all the help to solve the equation to auto-calculate the pips needed to trigger margin call %
I know different brokers have different Margin Call policies.

Should my earlier formulas be wrong, pls do not hesitate to alert me. Thank you & enjoy my Excel format.

Or if there was any advanced spreadsheet that is better than mine, pls do point me to the URL link.

Thank you.
Attached File(s)
File Type: xls Margin Call calculation.xls   57 KB | 2,859 downloads
CCI decipherer
  • #2
  • Apr 18, 2011 7:43pm Apr 18, 2011 7:43pm
Hello...

Thanx for the file.
  • #3
  • Apr 18, 2011 8:09pm Apr 18, 2011 8:09pm
Maybe this will help you.

http://fxtrade.oanda.com/account/mar...ll-calculator/
  • #4
  • Nov 20, 2021 9:10am Nov 20, 2021 9:10am
Quoting sogt725
Hi traders. I created this Excel when on Friday evening(April 15th), I thought I bought EURJPY price (on FX Primus) at 120.082 On the broker server it gave me a buy price of 120.21x Its around 11-13 pips off. This is my first time seeing this on my new broker. Shocked, I went to http://messenger.providesupport.com/.../fxprimus.html to rectify the problem! Am a short term trader. Luckily this problem happened in a consolidated period, otherwise I'd be a sitting duck to be roasted. Attached is a Margin Call (Excel 2003) spreadsheet....
Hope this help. If someone can mod this to indicator Stop Order broker of my account will be the best.
Attached File(s)
File Type: mq4 noloss_v5.mq4   8 KB | 247 downloads
  • #5
  • Last Post: Jan 8, 2022 3:44am Jan 8, 2022 3:44am
Very interesting information which is provided by you. I personally use another way to calculate margin call. To calculate the margin required for a long stock purchase, multiply the number of shares X the price X the margin rate. The margin requirement for a short sale is the regular margin requirement plus 100% of the value of the security. "Margin Requirement = shares x price x margin rate percentage." That's it. The vast majority of traders will definitely find this option easy, however beginners might be confused because of lack of knowledge and experience in trading. Nevertheless, I use it permanently.
0 traders viewing now