Fundamental capstone exercise 3

Community Support
1

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

 

 

2

refer below

https://community.kx.com/t5/KX-Academy/Capstone-Project-Issue-3-Data-Analytics-and-Reporting-Fail-quot/m-p/14361#M264 

3

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

 

4

Hi !

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

5

Hi megan,

Thanks for the response

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

6

All good, I changed date to last date