cancel
Showing results for 
Search instead for 
Did you mean: 

Fundamental Capstone 3.1/3.2

Jacob
New Contributor II

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!

1 ACCEPTED SOLUTION

megan_mcp
Community Manager Community Manager
Community Manager

Hi @Jacob,

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 🙂

View solution in original post

2 REPLIES 2

megan_mcp
Community Manager Community Manager
Community Manager

Hi @Jacob,

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 🙂

Jacob
New Contributor II

Thank you! Removing the trade sorting fixed it