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
- Over 50% → [Total funds / (Total Funds + Blocked funds)] x 100%
- 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% |