Capstone Project fails optRef table type

Academy Support
1

when I run the meta for the optRef table i get the same schema as what is expected but when I run the test i get “exercise2.1 Fail (optRef Has Correct Format" “”“ ").

my table meta below:

c t f a
option_id s
inst_id j
opt_type s
strike j
expiry d

code used to create the table - optRef:@[refServiceHandle;`getOptionRef;(uniqueOpts)]

optRef:select from option where option_id in uniqueOpts

optRef: update “D”$expiry from optRef

The table has 99 rows

Any help would be greatly appreciated.

Hi Laura, thanks for responding. The option table is one already created for the Capstone project, i did not make it. I tried using the code you sent in and still get the count at 99 and a fail.

 –

Hi, I also get the same error: "exercise2.1 Fail "optRef Has Correct Format"" with optRef having 99 rows and the "expiry" column changed to Date datatype

 –

1 Answer

1
2

Hi @ross_curtis ,

I’d need some more of your code to be able to troubleshoot properly, I’m not sure what your “option” table is.

A simpler way to create the optRef table would be:

optRef:refServiceHandle (`getOptionRef;uniqueOpts);

It should have 100 rows, you don’t need to run that second line where you filter on uniqueOpts as that is what the getOptionRef API is doing.

Hope this helps,

Laura

Hi Laura, thanks for responding. The option table is one already created for the Capstone project, i did not make it. I tried using the code you sent in and still get the count at 99 and a fail.

 –