-
Fundamental Capstone 3.1/3.2
Hi everyone,
My answer to 3.2 is failing, I think because of my output from 3.1
Everything seems fine aside from a few table rows missing bid and ask values.
Not sure why these are missing or how to fix it, I’m attaching my answers and results from 3.1 and 3.2 if anyone has any ideas.
Thank you!
-
2 Replies
-
Hi ,
I see you have sorted your trade table in ascending order by time and option_id, but as you can see by the sample data, the trade table isn’t sorted at all.
However, if we look at the nbbo table, you can see it is sorted in ascending order by time.
By sorting tables that do not require it and then preceding to join these tables together is where you can experience an overall table with an incorrect format.
Hope this helps,
Megan
-
Thank you! Removing the trade sorting fixed it
Log in to reply.