I don't know how to program a spreadsheet macro, but if I did, I would make one that would link to my broker (IB) and close a pair when the ratio hit my target. Unattended. Even better, when the ratio hits the target, trailing stops would be issued to allow profitable positions to run.
Can...