Fundamentals Capstone 5.2 length error

[megan_mcp]

Hi @Kenan

The problem lies with your last bit of code ‘edge > avgEdgePerOption[avgEdge]’.
You are only able to index into a dictionary, not a table. So as avgEdgePerOption returns as a table, when you run ‘avgEdgePerOption[avgEdge]’ it returns nothing (screenshot below).

This is what causes the length error as edge is a list and avgEdgePerOption[`avgEdge] is an empty dictionary.

Hope this helps!

Thanks,

Megan🙂

[Kenan]

Hi Megan,

Thank you for your help. I pass all the tests but format for 5.2.

This is my 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

I attached the test results and my schema for edgeProfile.