excel: wildcards (or something?) :p

[Gordon Gekko]

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??

thanks!

 

[AmbushHillbilly]

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

 

[pspr]

Why don't you use the continuous contract ES #F if you are collecting data from Esignal ?

 

[Gordon Gekko]

AmbushHillbilly, thanks. i will try that.

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