Finding Matching (ContraSide) Transactions

[Guest]

I have my transactions recorded as a buy and sell. An example is below. I am
trying to find a formula for ColE (TimeDiff Contra) that will look at the
values in ColC,D,E then find the matching (other side of the transaction) and
display yhe TimeDiff from that side of the transaction.

TimeDiff Side Stock Price Size TimeDiff Contra
0:00:00 Sell OMC 6.2 10 0:01:59
0:01:59 Buy OMC 6.2 10 0:00:00

Is this possible ?

Thank you in advance.

 

[Biff]

Hi!

Let's see if I understand........

If "one side" of a transaction is "sell", then the other "side" must be
"buy" and vice versa.

No error checking in this. This assumes that there will always be an
"opposite side" for each entry. In other words, every "sell" has a
corresponding "buy" and vice versa.

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=IF(B2="sell",INDEX(A$2:A$20,MATCH(1,(B$2:B$20="buy")*(C$2:C$20=C2)*(D$2$20=D2)*(E$2:E$20=E2),0)),INDEX(A$2:A$20,MATCH(1,(B$2:B$20="sell")*(C$2:C$20=C2)*(D$2$20=D2)*(E$2:E$20=E2),0)))

Biff

 

[Biff]

See reply to your post on 12/10/2005.

Biff