Capstone Fundamental Ex 1.5

Community Support
1

refServiceHandle: hopen ::5010 \*\*1.5 Using the handle refServiceHandleand theuniqueOptsvariable we created before, call the getOptionRefAPI and retrieve the associated Options Reference data. Store the returned table in a variableoptRef`.**

optRef: refServiceHandle(`getOptionRef;uniqueOpts)

Using this line of code is not working. IPC says blocked. How do I fix it?

2

Hi !

Can you try 

refServiceHandle: hopen 5010;

instead of 

refServiceHandle: hopen `::5010

Let me know if this works,

Megan

3

Hi  

It still says its blocked unfortunately. 

Praviga. 

4

 can you download your notebook and send it to me so I can take a closer look?

You can dm me on here or email me (mmcparland@kx.com).

Thanks,

Megan

5

 

I notice for your uniqueOpts variable you’ve declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

 Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec  keyword. 

Once you’ve edited this, it should work fine.

Thanks,

Megan

6

Thanks Megan! It’s working for me now!