Best " Lag and Lead" corraletion functions

Discussion in 'Trading' started by IV_Trader, Nov 5, 2005.

  1. in Excel. Anyone has it ?
    Thanks in advance
     
  2. List of trading functions for excel, where?
    I know some site, but mostly indicator, not
    expert function like MRO, correlation,..
     
  3. right , its mostly for indicators. The function calculates the highest correlation by using different time periods. For example the Average Hours per Week is a "leading" indicator for future Employment numbers and the lead is three month. I need the formula in Excel that calculates the lead (three month). I used to have it in spreadsheet , but lost it