Fundamentals Capstone 3.1

Community Support
1

Hi all, 

I’m having difficulty with section 3.1. My code is as follows:

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

I’ve swapped the bid and the ask around as was the solution in a previous post, does anyone know why I am still getting a “trade context has correct format error”? 

I feel like it has something to do with the meta of my table…

Thanks

(Please see attached photos for what my trade tableContext table looks like and it’s meta)

2

Hello,

The reason behind this is because the data is partitioned. Referring to the documentation,  https://code.kx.com/q/ref/aj/, you will see that you must bring where clauses, on dates, inside the join.

I hope this helps.

Many Thanks

Luke