Hi Gang, In checking my spreadsheet version of the online calculator I found an error that I fixed the way I thought it needed to be, but it turned out that the sell price was a match but the buy price did not match. I scratched my head for quite a while but never found out exactly what I did differently that made the difference. Then I did the calculations where the sell and buy would happen relative to the current price and I found an oddity with the online line calculator.
PC 3498, 377 shares, share price $9.28, buy,sell, % shares all 10%. The Online Calculator comes up with:
@ Stock Value Above $4373 Min Sell Order Size $437 Min Sell Price $11.6 Min # Shares Sell 37.7
@ Stock Value Below $2915 Min Buy Order Size $292 Max Buy Price $7.73 Min # Shares Buy 37.7
The percentage between current price, and the next sell, 11.6/9.28=125%. The percentage between current price and the next buy price, 9.28/7.73=120% going up or 7.73/9.28=83.3% going down.
With my spreadsheet version I get the same next sell price, $11.60 but the next buy I get is $7.56. Calculating the percentage difference between the current price and the next buy percentage is 9.28/7.56=122.75% going up or 7.56/9.28=81.46% going down.
I can not seem to get the same percentage for the buy as for the sell but I am a bit closer. This is good as it delays a buy a bit more, which is good.
I am contemplating making the the next buy at 75%, thereby matching the range on the buy side with the range on the sell side, which is quite easy to do. What do you think of this idea?
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.