InvestorsHub Logo
Followers 2
Posts 1185
Boards Moderated 0
Alias Born 07/15/2014

Re: None

Saturday, 09/24/2016 12:53:03 AM

Saturday, September 24, 2016 12:53:03 AM

Post# of 47078
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?

Best,

Allen

Join the InvestorsHub Community

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.