Remember Me?

#1
December 12th 05, 02:09 PM posted to microsoft.public.excel.worksheet.functions
 carl Posts: n/a

I have a transaction (buy and sell) that comes in like this:

TimeDiff Side Stock Price Size Time1 Firm
0:00:00 Sell OMC 6.2 10 10:57:52 AM 919
0:01:59 Buy OMC 6.2 10 10:57:52 AM 980

I am trying to find a formula that can be added to each side of the
transaction that will display the counterside's "TimeDiff".

So for the first transaction, the formula would return 0:01:59. And for the
second, 0:00:00

I think the formula needs to compare the Stock, Price, Size, and Time1 and
if Side is Opposite (i.e. if "sell" comparison need to be "buy").

Carl

#2
December 12th 05, 06:58 PM posted to microsoft.public.excel.worksheet.functions
 Biff Posts: n/a

Biff

"carl" wrote in message
...

I have a transaction (buy and sell) that comes in like this:

TimeDiff Side Stock Price Size Time1 Firm
0:00:00 Sell OMC 6.2 10 10:57:52 AM 919
0:01:59 Buy OMC 6.2 10 10:57:52 AM 980

I am trying to find a formula that can be added to each side of the
transaction that will display the counterside's "TimeDiff".

So for the first transaction, the formula would return 0:01:59. And for
the
second, 0:00:00

I think the formula needs to compare the Stock, Price, Size, and Time1 and
if Side is Opposite (i.e. if "sell" comparison need to be "buy").

Carl

 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 BorisS Excel Discussion (Misc queries) 3 November 17th 05 01:13 PM Jen Excel Worksheet Functions 1 October 24th 05 07:55 PM Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM bentleybr Excel Discussion (Misc queries) 1 December 7th 04 12:48 PM Todd Excel Worksheet Functions 1 November 16th 04 08:44 PM

All times are GMT +1. The time now is 06:42 PM.