Fundamentals Capstone 2.1

[gyorokpeter-kx]

Apparently the exercise 1 test doesn’t really check the table, only that it exists.

According to the description, getOptionRef takes a list of IDs, but you are passing in a symbol, and due to some bad luck this doesn’t result in a type error but the function returns all the rows matching your symbol which there are none.

[gyorokpeter-kx]

The update statement normally returns the modified table. If you want to save the result back to the in-memory table, you have two options:

• use an assignment statement to overwrite the table with the result
• pass the name of the table to update rather than its value

The second option is explained at QSQL query templates | Basics | kdb+ and q documentation – Kdb+ and q documentation (kx.com).

[msshaikh11]

 

Thanks for the reply, you were right about using the assignment to update the table:

optRef : update expiry: $[“D”;expiry] from optRef

To make sure the change is applied to the table of the datatype for the expiry column to date. However I came across another problem (I think it might be the date format but not sure) : when I pass the ex2 test function ex2.1 fails, even though all the column have the correct datatypes.

My output:

option_id                    inst_id      opt_type         strike                expiry
———————————————————————————-
FB20200720C230         9                C                    230                  2020.07.20

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

* Expected schema for the `optRef` table:

|Column Name| Column Type
|———| —–
|option_id| symbol
|inst_id | long
|opt_type | symbol
|strike | long
|expiry | date

 

 

[gyorokpeter-kx]

The test checks for an exact match with the expected table, not just the schema. Can you check if you created the optRef table correctly? How many rows are there in the table?

[msshaikh11]

Yes, You are right.

when I call the refServiceget handle for ex1.4 I get just the columns, so I have no observations.

How I created optRef table:

optRef: refServiceHandle(`getOptionRef,`uniqueOpts)

I assumed my optRef table was correct as it passed the ex1 function test, but now I think I may have called the refServiceHandle function incorrectly and the optRef table wrong (ex1.4) as there are 0 rows.

 

[msshaikh11]

, Thank you so much for your help in solving this capstone ex2 problem which was linked another problem in ex1.4 that I didn’t know I had!