Looked at your pivot calculation xls - what do you use for a time frame for your "yesterday" data? Because of Globex, these markets (I trade S&P E-mini) are well-nigh contniuous, making the choice of start/stop times pretty flexible. For example, some use Midnight as a divider, others use only...