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

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?"