Weekly number of trades
Date: 14 May 2002 20:14:24 -0700
Message-ID: <ca86b9e9.0205141914.617e0da1_at_posting.google.com>
I have to build a 2-dimenshion Chart showing time, number of trades.
Vertical line would be number of trades
Data comes from one table called Trade:
Trade:
This query would calculate data for one week:
select count(*) from trade where trade_date > '2002-05-04' and
trade_date < '2002-05-12';
How is it possible to get number of trades for each week for period of
time???
Reporting tool I am going to use for this would be Crystal Reports 8.5
Horizontal - time
I have to use number of trades per week as a one point in diagram
connecting these points into graph which would show trading activity
over period of time.
# of Trades 100 |
80 | *
60 | *
40 | *
20 |
0 |_______________________________
1st week 2nd week 3d week
Name Null? Type
----------------------------------------- --------
----------------------------
TRADE_ID NOT NULL CHAR(32)
TRADE_DATE NOT NULL CHAR(10)
TRADE_QTY NOT NULL NUMBER(15,2)
TRADE_PRICE NOT NULL NUMBER(15,8)
Would very much appreciate your help? Received on Wed May 15 2002 - 05:14:24 CEST