Re: Need some tips on query generating averages on time series data

Lennart:

What OLAP functions? I don't see any in your reply or in the thread.

How did I get 109.7
- by subtracting the buy and sell time for 200 shares (rows 4 and 8 as these
  match up by quantity and direction (one is buy and the other is sell).   So, the calc here is 12678 - 12568.3.

How did I get 21940?
- by multiplying 109.7 by 200. This is the weighted hold time. At the end I
  divide by the total number of shares traded (500) to come up with weighted   average hold time. Received on Thu Oct 24 2013 - 17:03:46 CEST