New to excel. Trying to run certain back tests for futures historical data

Occasional Visitor

Does anyone know how for instance I would run  a simple back test like "if the Nasdaq has had 3 down days in a row (in relation to the percentage column), what are the odds it will be green on the fourth day?" 

0 Replies