Some of the largest nested cells in my program started with ideas from Vesselin Bontchev when we used to be on the qqqq board. I mostly just hack and adapt. That indirect command has always been the toughest.
Excel is an awesome program.
You CAN time the market!
But only after you trash the big 3 myths.
Myth 1 - its possible to get every point of every move ...Myth 2 - you'll never have a drawdown ......Myth 3 - you'll never have a loss