Fundamental Capstone Exercise 4 and 5

[Laura]

Hi

The first few rows of edge15 look like :

minute| edge    qty numTrds 
------| ---------------------- 
09:30 | 2946.818 3193 58 
09:45 | 721.9481 905 21 
10:00 | 564.0584 499 11 
10:15 | 563.706 870 14 
10:30 | 670.9859 1222 21 
10:45 | 784.223 1002 21 
11:00 | 134.2699 957 17 
11:15 | 230.7435 728 14 
11:30 | 560.6381 528 11 
11:45 | 306.1817 769 14 
12:00 | 876.8397 765 17

so it does seem different to your results – if you can share you definition of edge15 I can better assist – you can use the spolier tag (expand three dots in toolbar to select).

[daramcs]

Hi Michaela, thanks for the reply

 

edge15: select edge:sum edge,qty:sum qty, numTrds:count trade_id by 15 xbar `minute$time from tradeContext where date=2020.08.03,time >= 09:30:00

 

[megan_mcp]

Hi !

If you take a look at the attached image of the question at hand, you’ll see the variable itself must be named ‘minute’.

As well as this, we are after the latest date so the most recent date. You can do this by using ‘date = last date’. Feel free to have a look at this on our website ! first, last Reference kdb+ and q documentation – Kdb+ and q documentation (kx.com)

Thanks,

Megan