kdb Developer Level 2 Capstone Project Exercise 3 & 4 Errors

Academy Support
1

Hi Folks Need little guidance here while trying to complete the project

I am getting below format error for tradeContext and edge15 tables which I had created but I am not sure what’s wrong in them

I also tried to have edge15 column both as minute and time format still no luck

testSection[`exercise3]

quizItem success description error

exercise3.1 Pass "tradeContext Is Defined In Process" ""
exercise3.1 Fail "tradeContext Has Correct Format" ""
exercise3.3 Fail "abort" "abort in before block due to error \"length\""
exercise3.4 Pass "badTrades Is Saved In Correct Dir" ""
exercise3.4 Pass "Contents Of CSV File Is Correct" ""

meta tradeContext
c t f a
date d
option_id s
trade_id C
time t
price f
qty j
side s
edge f
exch_id j
broker_id j
bid f
ask f

date option_id trade_id time price qty side edge exch_id broker_id bid ask

2020.08.06 FB20200720C230 "37" 09:40:54.492 22.89417 27 B 48.54252 3 708 22.66 23.04
2020.08.06 FB20200720C230 "74" 10:00:36.511 20.99512 94 B 363.9133 4 708 20.88 21.44
2020.08.06 FB20200720C230 "113" 10:25:05.502 5.925473 26 S -18.60517 4 703 5.89 6.18
2020.08.06 FB20200720C230 "185" 11:28:44.556 27.83063 94 B 104.0323 4 705 27.81 28.1

quizItem success description error

exercise4.1 Pass "edge15 Is Present In Process" ""
exercise4.1 Fail "edge15 Table Format Is Correct" ""
exercise4.4 Pass "top5EdgeTimes Is Defined In Process" ""
exercise4.4 Pass "top5EdgeTimes Has Correct Format" ""
exercise4.5 Pass "bottom5QtyTime Is Defined In Process" ""
exercise4.5 Pass "If bottom5QtyTimes Has Correct Format" ""
exercise4.6 Pass "timeSeries Is Defined In Process" ""
exercise4.6 Pass "timeSeries Has Correct Format" ""
exercise4.7 Pass "edgeCor Is Defined In Process" ""
exercise4.7 Pass "edgeCor Has Correct Format" ""

meta edge15
c t f a
time t s
edge f
qty j
numTrds j
time edge qty numTrds
09:30:00.000 8768.013 11576 210
09:45:00.000 960.9537 4434 92
10:00:00.000 2985.002 3056 64
c t f a
minute u s
edge f
qty j
numTrds j
minute edge qty numTrds
09:30 8768.013 11576 210
09:45 960.9537 4434 92
10:00 2985.002 3056 64
2

Hi @simply.bibhu ,

I will probably need to run through your code to see where you need some guidance, but in the meantime here are some tips.

  1. You should use aj for tradeContext, resulting in a p attribute on option_id.
  2. 3.3 is testing that badTrades can be created from your function, a length error suggests your classifyTrades function may have an issue.
  3. If edge15 is not in the correct format, ensure you are using xbar correctly

If you are still having issues, forward your code to devrel@kx.com and I can run through it.

Laura