Fundamentals Capstone 5.2

Community Support
1

I cant seem to fix the type error on the 2nd part of question 5 my code looks like this,

 

avgtrdata : select avgEdge by option_id from optProfile

select edge,avg avgEdge by option_id from latesttrds ij avgtrdata where edge > avgEdge

 

I gave up with the fby for now as I was getting the same type errors but it seems when I am using the “by” command in SQL the data type changes from 32 to 64 bit or lowercase to uppercase on the meta of the table and this means that it is no longer comparable with the > symbol.

Any help would be appreciated thanks,

Dan

2

UPDATE:

I now have this which works,

edgeProfile: select numTrds:count i, avgEdge: avg edge, minQty:min qty, maxQty:max qty by option_id from latesttrds where edge <(avg;edge) fby option_id

However it fails the test… any help would be great my output table looks like this,

?

3

Hi ,

Can you send the code for the table latesttrds please?

Thanks,

Megan

4

Thanks for the reply,

latesttrds: select from trade where date = 2020.08.06

was just a way of selecting only the last day and not having to worry about it.

thanks,

Dan

5

Hi ,

As you can see in the screenshot provided below the question asks to include trades where the edge collected was greater than the average edge collected by that option.

If you adjust this, it should work fine.

Thanks,

Megan

6

Amazing, I apologise that was a silly error however on a very similar note, I thought that would fix the fail for the values on 5.3, unfortunately, it hasn’t.

My code looks like this,

optinstRef: optRef ij select by inst_id from instRef

edgeProfileFull: select numTrds, avgEdge, minQty, maxQty, inst_id, opt_type, strike, expiry, inst_syb, inst_name by option_id from edgeProfile ij select by option_id from optinstRef

and my table top row matches the one printed in the work book,

Any final help would be amazing on this,

Thanks Dan?

7

For further reference this is the data types in the table,

 

8

Can I ask you to send the fail message you are getting? I’ve ran your code and it seems to work fine.

Thanks,

Megan

9

Thanks for the reply there is actually no message it just says it has failed and I cant submit.

 

Thanks,

Dan

10

Just to add i restarted everything and reran it but it seems to still fail without an error message,

11

Hi ,

Sorry for the delay in this response, the majority of the columns in your edgeProfileFull table are in the wrong format and I feel this has something to do with your code leading up to creating this table.

Can I ask you to download your notebook and send it to me at mmcparland@kx.com so I can have a better look? 

Thanks,

Megan