Fundamental capstone 3.1

[maxzy]

Hi i am working on the fundamental capstone project. I am using this

tradedata: select from trade where date = last date
nbbodata: select option_id, time,bid, ask from nbbo where date = last date
tradedata:time option_id xasc tradedata
nbbodata: time option_id xasc nbbodata

tradedata
tradeContext: aj[ option_id ;tradedata;nbbodata], However I am unable to do tradeContext: aj[ option_id ;tradedata;nbbodata] due to mismatched data types: even though the meta of both match perfectly.

I am passing all but the 3.1 one:

uizItem success description error

exercise3.1 Pass "tradeContext Is Defined In Process" ""
exercise3.1 Fail "tradeContext Has Correct Format" ""
exercise3.3 Pass "badTrades Is Defined In Process" ""
exercise3.3 Pass "bad Trades Has Correct Format" ""
exercise3.4 Pass "badTrades Is Saved In Correct Dir" ""
exercise3.4 Pass "Contents Of CSV File Is Correct" ""

I am getting the section 3 test failure. I was wondering where the problem of my data is

[maxzy]

Also how do you run the corresponding test file as I am unable to run the test file and have been manually running the tests

[mmcparland]

Hi @maxzy

There are a couple of reasons for your tradeContext table not being in the correct format:

1. You are pre sorting the trade table in ascending order of time and option_id before joining which is not necessary. If you look at the sample trade input table, these columns are not sorted. This will ultimately cause the format of the table to be wrong. This line can be removed.
2. There are two columns that are common in both tables which are option_id and time. You must use both of these columns when joining using the aj join.

I hope this helps, if you have any questions about the above please let me know!