All cells in the formula are at zero when the stock market is closed. I have not yet tested the formula during market open because Im trying to finish before open. Also I want the spread sheet to work when market is closed, even though the data the formula looks at is zero. My sprea...