Fundamental capstone exercise 3

[daramcs]

Exercise 3.2

At the end of exercise 3, my tradeContext table doesn't have the correct format. I am unsure where I am going wrong

[ashish31]

refer below

https://community.kx.com/t5/KX-Academy/Capstone-Project-Issue-3-Data-Analytics-and-Reporting-Fail-qu... 

[daramcs]

Hi Ashish, thank you for the reply. I read through the thread you linked and I have the same schema for tradeContext and my figures look the same so I am still unsure what is wrong

[megan_mcp]

Hi @daramcs!

Can you share your definition of tradeContext so I can better assist - you can use the spolier tag (expand three dots in toolbar to select).

Thanks,

Megan

[daramcs]

Hi megan,

Thanks for the response

Spoiler

tradeContext: aj[`option_id`time;select from trade where date= last date;select option_id, time, bid, ask from nbbo where date= last date]

[daramcs · Accepted solution]

All good, I changed date to last date