Request for CFD margin call calculation

Hi, sorry for necroposting (some kind…).

I found answers to my questions so I delete my comment, but just one thing about blocked funds, to be sure. In @David calculation, blocked funds are fixed

So I made my excel calculation, using the formula below

  1. Over 50% → [Total funds / (Total Funds + Blocked funds)] x 100%
  2. Under 50% → (Total funds / Blocked funds) x 50%

Deposit $1500, share price $450, 10 shares, column status using formula =1500/(1500+900), then =1150/(1150+830) etc… and the last column is with fixed blocked funds ($900) for all rows. Of course, after 50%, I used (Total funds / Blocked funds) x 50% or =(300/660)*0,5

1500 450 LOSS 10 20% margin Status Fixed blocked ($900)
acc value price blocked
4500,00 900,00 63% 63%
1150,00 415 350,00 4150,00 830,00 58% 56%
1000,00 400 500,00 4000,00 800,00 56% 53%
800,00 380 700,00 3800,00 760,00 51% 47%
700,00 370 800,00 3700,00 740,00 47% 39%
500,00 350 1000,00 3500,00 700,00 36% 28%
300,00 330 1200,00 3300,00 660,00 23% 17%
1 Like