excel: wildcards (or something?) :p

Discussion in 'Trading Software' started by Gordon Gekko, Jan 21, 2004.

  1. alright, i'm trying to get excel to recognize when i'm trading ES.

    currently, i use a line like this in excel: =IF(B2="ESH4", 50, "")

    what i want to do is have excel still recognize ES when the contract changes. i want to do something like this: =IF(B2="ES*", 50, "")

    anyone know a solution??

  2. =if(left(cell,2)="ES", then..,else..,)
  3. pspr


    Why don't you use the continuous contract ES #F if you are collecting data from Esignal ?
  4. AmbushHillbilly, thanks. i will try that. :cool:

    pspr, i do use ES #F when i do DDE with esignal. however, for this situation, it is dealing with my IB trades.