The mistake happens because cell AA4 in the Suggested Shared Bot/Sold formula rightly refers to cell H4 but as a result wrongly references the High % Dev Band multiple 5.53% in cell H4 in the yellow box.
Try manually entering "0" into Cell AA4. Do you agree that the problem is then resolved?
We might have to make that a hard coded "0" in all future sheets.
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.