InvestorsHub Logo
Followers 3
Posts 82
Boards Moderated 0
Alias Born 09/03/2021

Re: None

Thursday, 03/24/2022 7:57:39 AM

Thursday, March 24, 2022 7:57:39 AM

Post# of 8725
Hi Myst,

I am wondering whether the formula in the Actual Shares Bot column is correct. See below:



I understand the logic of the formula to mean that if the (Absolute) suggested shares sold is greater than the actual shares held (in column X309), then the formula returns the value “0”.

Should it not be the case that if the (absolute) indicated shares bot / sold is greater than the actual shares held the amount to be sold should be (- / minus) * X309 not “0”?

Interestingly, as it currently stands, the formula, has had the effect of keeping us LONG an asset a little longer because every time the suggested shares sold is greater than the amount of actual shares held nothing happens (the formula returns “0”) and we stay LONG for longer than we otherwise would. So, if the asset rises, we continue to benefit. Then, after keeping us LONG, if the price increases sufficiently, when the value of the shares held is once again greater than the value of the suggested shares sold, the formula once again returns the suggested shares sold (AD309). Was this intentional?

Regards,

Alex

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.