Switching to Manual Calculations

When you are working with a large set of data you can find the model runs slowly. If this is happening you can switch Excel into Manual Calculation Mode. This means that the formulas will only update when you click a button.

Check out this video to see me demonstrating with an intraday backtest model.

Next Step

Learn how to: How to Get New Price Data Into A Model!