Generally speaking I've noticed in strong uptrends you want to buy more and sell less, and vice versa in downtrends....ie, buy less and sell more. Therefor the buy multiple settings on uptrends will generally be higher than the sell multiple, and vice versa for downtrends (sell multiple higher than buy multiple).
I've traded in all scenarios, so yes....I've achieved results similar to what the sheet is displaying.
I have a good feel for when an optimization is good enough....or is actually optimal. The data charts at the bottom of the sheet are very useful. Things to look for are a good clean uptrend in the "B&H vs. XDEV chart" and also a good turnover between stock and cash on the Portfolio chart. The ethereum examples below are good examples of this:
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.