[megan_mcp]

Hi @timbs_1995

In exercise 2.3, it asks you to define a dictionary using the logic from the table above (screenshot below). This is missing from your function and is needed to be able to complete the functional code for benchmark and chk.

Can I ask that you include this and let me know the outcome?

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

It states in the exercise that you must load the lap table from disk.

To do we use the system command:

\l

**Tip: Instead of listing each individual column, you can simply run

select from lap

To retrieve the entire lap table.

Hope this helps!

Thanks,

Megan

[megan_mcp]

Hi @masmail

For question 2.3, you must convert the code that is provided within the .f1.checkSensor function into functional form.

So instead of the following select statement:

benchmark:select benchmarkValue:avg sensorValue by sensorId from lapTab;

It must be in the following format:

Functional Select

?[ table; whereConditions; groupBy; selectedColumns]

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @masmail

I believe this error is due to the way you structured your .Q.dpft function.

If you take a look at the screenshot provided you will see that this namespace only accepts 4 arguments;

• d is a directory handle
• p is a partition of a database
• f is a field of the table named by t below
• t the name (as a symbol) of a simple table whose columns are vectors or compound lists

The first two parameters are correct [f1DbPath;2020.01.02, ..] however you need to take a look at the order of your second two.

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Can you share a screenshot of your edge15 table please ?

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Can you make sure your variable names match up with those that are given in the expected schema?

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Since you have adjusted your code to use ‘ * ‘ to read in your columns as strings, you no longed need the following cast statement:

messages: update trade_id: `$string trade_id from messages

As this is changes the format of the column from image_1 to image_2.

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Let me break down question 4.7 for you:

• Using your timeSeries dictionary that you created in ex 4.6, compare the correlation of edge against the correlation of qty then the correlation of edge against the correlation of numTrds. To do this you can use the keyword cor – cor – corelation coefficient | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)
• Store this data in a dictionary called edgeCor with the keys being edge, qty and numTrds and the values being their correlation with the edge series.

There are a few different ways this can be done but using iteration is included as a suggestion.

Let me know if you require further assistance.

Thanks,

Megan

code.kx.com

cor – corelation coefficient | Reference | kdb+ and q documentation - Kdb+ and q documentation

cor is a q keyword that calculates the correlation coefficient of two numeric lists.

[megan_mcp]

Hi @kal8na

I believe the problem is within your badTrades variable you do not provide the classifyTrades function with a parameter.

To fix this, simply pass in the tradeContext table into the function:

badTrades: select from classifyTrades[tradeContext] where exQuality = 0b;

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

So the question is asking for more than just joining the two tables.

– It’s looking for the last date

– It’s looking you to add two extra columns bid and ask which contain information from the nbbo table

Here is an example from the documentation to help (screenshot below).

If you have any further questions please let me know!

Thanks,

Megan

[megan_mcp]

Hi @kenan_davidsonyahoo-com

I don’t believe your answer for exercise 3.1 requires a get, set.

However try this:

hdbH:hopen 5099
hdbH"\\l f1"
hdbH"tables[]"

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi @kenan_davidsonyahoo-com

I’ve took a look at your ‘.f1.createLapTable’ function and I’ve made a few adjustments:

.f1.createLapTable:{[eventInput;sensorInput]

uniqueSensor: distinct select sensorId from sensorInput;

rack:(select from eventInput) cross uniqueSensor;

w:(rack[`time];rack[`endTime]);

f:wj[w;`date`sensorId`time;select from rack;(select from sensorInput;(avg;`sensorValue))];

delete date from f

}

• To retrieve a column from a table you must use bracket notation with a backtick as follows – w:(rack[`time];rack[`endTime]); *Example provided below*

• It states in the .f1.createLapTable function template that it wants a table returned with the following columns: `session`lapId`time`endTime`sensorId`sensorValue. Hence why the delete statement for date was included at the end.

If you have any questions please let me know!

Thanks,

Megan

[megan_mcp]

Hi @Kal8na

I believe the error lies in how you imported your messages.csv. It states in the question that “The exch_message column should be read in as a string”.

To do this in q we use the ( * ) character. So to adjust your import, change “SJF” to “**”.

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi @Htip18

Due to technical issues with our coding format, it makes it hard to understand.

Would you be able to send me your code as just text?

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

Sorry my mistake – you must add the name of the directory.

Which in this case is f1:

\l f1

Thanks,

Megan