The Lead/Lag selection under Action will shift data “x” number of periods forward (lead) or backward (lag).  An example of where you might want to use this is to compare today’s price to yesterday’s price.

  • Start by selecting History, or Charts
  • Enter or look up the symbol(s) you want to display
  • Click on the Action button
  • Select Lead/Lag

Excel Add21

  • In the dialog box select Lead to move the data forward, or lag to move it backward.
  • Then enter the number of periods to lead or lag.
Category: ExcelTags: