We have a margin product in our brokerage house, we force sell the client's stocks if the margin maintenance fell under 30%, so am building an Excel to calculate what is the minimum quantity i have to sell to get back client to 30%.
I have shared below a sample data, the first table is the client's current stocks where the margin maintenance become 27.8%, the second table is an example to sell ABC stock, i was increasing the "Sell Qty" of ABC stock manually until i touched the 30%, so my question, what will be the equation to calculate this Sell Qty automatically?
Note: after the sell order the "Last Price" will be equal to the "Sell Price" that's why the "New Weight" is calculated using the "Sell Price".
I have shared below a sample data, the first table is the client's current stocks where the margin maintenance become 27.8%, the second table is an example to sell ABC stock, i was increasing the "Sell Qty" of ABC stock manually until i touched the 30%, so my question, what will be the equation to calculate this Sell Qty automatically?
Note: after the sell order the "Last Price" will be equal to the "Sell Price" that's why the "New Weight" is calculated using the "Sell Price".