Developer level 2 Capstone project exercise failure

Academy Support
1

Hi I am trying to complete the capstone level 2 project but there are two failures in excercise but Im sure my coding is correct, please help me on this.

exercise4.7 Fail "edgeCor Has Correct Format" ""

code: edgeCor:flip select edge cor edge,edge cor qty,edge cor numTrds from (flip timeSeries)

exercise5.2 Fail "edgeProfile Has Correct Format And Values" ""

code: edgeProfile:select numTrds:count i,avgEdge: avg edge,minQty: min qty,maxQty: max qty by option_id from trade where date=last date,edge >= (avg;edge) fby option_id

please guide me what should be correct on this to complete the project.

2

Hi @chowdaryshivafan01,

For 4.7 the format of edgeCor should be

edge   | -9
qty    | -9
numTrds| -9

but yours is

edge   | 9
qty    | 9
numTrds| 9

which means your values are enlisted. You’re very close to the correct answer, though a simpler way to do it might be using cor/:

For 5.2, again you’re very close!

The question is just asking for the values where edge is greater than the average, not “greater than or equal to”. A small change in your whereclause and that test should pass.

Hope this helps,

Laura

3

Thank you. All test cases passed.