How to select distinct by max value of other column
I have the following code:
a list of N subsequent elements in KDB
Given the table t: ([] a: 1 2 3 4)
, how can one obtain the column b
for e.g.,
kdb/q xdesc on table, within primary id
I’m trying to get a single line item per id with the largest count, like below:
Incompatible list lengths when passing a list of symbols into function parameter?
I have a function that filters on a master table as the below:
Why is SUM not ignoring NULLs in functional form?
I have the following bit of code inside a functional select argument:
fills on empty sub lists in KDB
Consider a table containing a column a
which is a list of lists as
How can I dynamically update column names within a function?
I built a table selector that can produce many tables from a master table by filtering on a specific column that I desire with the required values. The formula is as below:
How to check in kdb+ if a connection opened to current process is using TLS
I have a situation where I want users to connect using TLS, but I want my kdb procs to also permit plain connection so a -E 1
is specified on the proc.
Intraday OHLC chart with KX Developer
I’m trying to use the grammar of graphics plotting library in KX developer 1.5.4 to plot a 1 min
chart for IBM
. However, as you can see I get disjointed candles, which seem to have each collapsed into their respective days. How can i plot continuous intraday bars?
Optimal Trade Entries in KDB
Given ohlcv
data such as