[megan_mcp]

Hi ,

Can you send your code for these exercises using the spoiler tag?

Thanks,

Megan

[megan_mcp]

Hi ,

Can I ask you to send me your code for 3.1?

Thanks,

Megan

[megan_mcp]

Hi ,

My suggestion is to close down/restart all the tabs needed for this workshop and re-launch the sandbox.

If you are still experiencing this error, try opening it in a private browser.

Let me know if this works.

Many thanks,

Megan

[megan_mcp]

Hi ,

The issue is that you haven’t loaded the f1 database on port 5099,  which might explain why when you run the tests for 3.6, which includes testing that fiauser can run the function getSummaryReport[], you are getting a the sensor error as sensor does not exist on port 5099.

If you load in the f1 database, the error should be resolved.

Thanks,

Megan

[megan_mcp]

Hi ,

Can I just note that by converting your symbols to strings in col2, you are going to take up a lot more memory. If it isn’t essential they be stored in the table as strings, you could convert them while querying your data instead.

Of course this is only relevant if the table will be saved on disk and if you are interested in saving memory.

Thanks,

Megan

[megan_mcp]

Hi ,

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

[megan_mcp]

Hi ,

You appear to be upserting at a table level, you could try doing the upserts at a column level and peach it. something like:

{colData:get .Q.dd[`:kdbfolder_n/<date>/trade;x];upsert[.Q.dd[`:kdbcommon/<date>/trade/;x];colData]}peach except[cols trade;`date]

For this you need to have threads enabled in the command line:

-s N

Let me know if this works,

Megan

[megan_mcp]

Hi ,

Here’s a link to Float Precision on our website https://code.kx.com/q/basics/precision/#q-simd-sum.

Hope this helps!

Megan

[megan_mcp]

Hi ,

The reason you are getting this error is because it states in the question that the q process is restricted in that it only calls to it’s API’s (screenshot attached).

That’s why you can’t run commands such as ‘refServiceHandle “tables[]”‘.

Also – to retrieve data from a connection you must use the symbol reference.

Hope this helps,

Megan

[megan_mcp]

Hi ,

I think one thing that could be helpful is using conditional evaluation Cond | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)

So you’ve got:

 

extractBrokerId: {[exchangeMessage] parts: "-" vs exchangeMessage;

 

Which is correct.

If we take a look at our messages table we can see that if the exchange message begins with CME – the brokerId is going to be at the end.

If it begins with ISE – the brokerId is going to be in the middle.

So using the conditional, we can basically say if the exchange message is like “CME*” then use the last part else use the middle part.

Let me know if this helps,

Megan

 

[megan_mcp]

Hi ,

Yes  is correct you should use ‘exec’ instead of ‘select’ – however this is the syntax for the statement you need:

exec ... from select ... from ...

exec keyword | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)

If you have any questions please let me know,

Megan

[megan_mcp]

Hi ,

If you take a look at the screenshot provided below, the question states to extract all the unique instruments so this would indicate to use the inst_id – not the option_id.

If you have any questions on this please let me know,

Megan

[megan_mcp]

Hi ,

Here are some hints to help simplify your function:

count each `. tables[] – returns the number of rows in each table

list1 ! list2 – joins these two lists together to create a dictionary

If you are still stuck let me know,

Megan

[megan_mcp]

Hi ,

Assuming you’re getting the error ‘trips’ is because you haven’t imported the trips.csv file in yet which is mentioned in the “Importing Data using KX Developer” section of the demo (screenshot provided).

Once you’ve imported this csv file, it should be able to run as expected.

Let me know if this works,

Megan

[megan_mcp]

Hi  !

Can I ask you to send over the code you’re trying to run?

Thanks,

Megan