I've been trying to come up with a formula for the following.
I have 100,000 of X stock which i want to sell
I only want to be 20% of the market each day and no more.
How many days will it take to liquidate and how much on average will i loose or make.
I have a large amount of historical data so volumes for every day and the Change in price for the days.
I have produced a spreadsheet that i think basically does the job however its figures are stupid it suggests a loss of 69% for example.
Whats going wrong and how can i correct it?
basically what im doing is the following: WAvgCost = WAvgCost + volume.Cells(numRows) * chngeOnDay.Cells(numRows) / targetVolume and for the last volume traded on a day i take the % of that needed to make the target volume: WAvgCost = WAvgCost + (targetVolume - aggregateVolume) * chngeOnDay.Cells(numRows) / targetVolume
Once i have done this for all the possible combinations of days i then sum them together to see how much i would have made or lost if i had wanted to be 20% of the market and i had 100,000 shares to sell.
Sorry if this is in the wrong place i just really need some help.