Capstone Project 4.1 test failed

Academy Support
1

I pass all the tests for the capstone project, except for exercise4.1 Fail "edge15 Table Format Is Correct" "".

I tried it both keyed and unkeyed, tried to rename minuteBin to minute and they all failed.

What is wrong with the code?

lastDate: max classifiedTrades`date
tradesToday: select from trade where date=lastDate, time >= 09:30:00
tradesToday:update minuteBin: 0D00:15:00.000 xbar timespan$time from tradesToday tradesToday:update minuteBin: time$minuteBin from tradesToday
edge15: select edge: sum edge, qty: sum qty, numTrds: count i by minuteBin from tradesToday

type edge15: 99h

2

Hi @dana.catalinaa1903 ,

Try using time.minute instead of casting time to timespan. See the examples of using xbar here: xbar | Reference | kdb+ and q documentation - kdb+ and q documentation

Hope this helps,

Laura