Remember Me?

#1
December 10th 05, 01:10 PM posted to microsoft.public.excel.worksheet.functions
 carl Posts: n/a
Finding Matching (ContraSide) Transactions

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 ?

#2
December 11th 05, 02:30 AM posted to microsoft.public.excel.worksheet.functions
 Biff Posts: n/a
Finding Matching (ContraSide) Transactions

Hi!

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

If "one side" of a transaction is "sell", then the other "side" must be

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

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="bu y")*(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

"carl" wrote in message
...
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 ?

#3
December 12th 05, 06:57 PM posted to microsoft.public.excel.worksheet.functions
 Biff Posts: n/a
Finding Matching (ContraSide) Transactions

Biff

"carl" wrote in message
...
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 ?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post The Mage Excel Worksheet Functions 4 September 18th 05 03:36 AM cattle mgr Excel Discussion (Misc queries) 2 August 29th 05 08:32 PM Marcin Wolku Excel Worksheet Functions 1 August 25th 05 04:46 PM PokerZan Excel Discussion (Misc queries) 1 July 8th 05 09:58 AM ndrewitt Excel Worksheet Functions 0 April 13th 05 01:43 AM

All times are GMT +1. The time now is 05:39 PM.