KX Technology
Using kdb+/q or any KX development tools? Discuss with our community of users and experts here!
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Dashboards 1.4.1 Released!

Calling all Dashboards users - download the latest version from code.kx.com and take it for a spin. New features include Document Graph auto-clean up, ANSI SQL support (note - this features requires s.k. beta), PDF export, Data Grid composite sparkli...

Documentgraphgif.gif
dfallon by New Contributor III
  • 271 Views
  • 1 replies
  • 7 kudos

Resolved! Question on streaming

I have a question. Having a data source publishing real time quotes(bid price and ask price), I want to subscribe it and plot the mid price(0.5*bid+0.5*ask) using the streaming mode. How to do it please? As shown in the picture, it seems only one fil...

MSHK by New Contributor
  • 285 Views
  • 8 replies
  • 0 kudos

Resolved! Using GG Plot and Grammar of Graphics in Dashboards

I have created a demo of a dashboard using GG Plot to create a candlesticks graph which can be panned and zoomed and displays trade positions which run off screen. The code and details on how to set up the demo can be found here: https://github.com/l...

lmills_0-1631517533721.png
lmills by New Contributor
  • 178 Views
  • 2 replies
  • 2 kudos

Resolved! Basic (but still intriguing to me) q Interpreter question

A bit at lost here... Can someone enlighten me as to how the interpreter works in the following situation: q)show a:10?(-1 0 1) //Just to have something0 1 1 0 -1 0 1 -1 0 0 q)(>)a //That's the curiosity1 2 6 0 3 5 8 9 4 7 I understand this is actual...

JP by New Contributor
  • 176 Views
  • 2 replies
  • 0 kudos

Resolved! Transform Specific Column Values

Hello, Assume that I have a table like; prices:([]sym:`u#`$();price:`float$()) ..and updating this table through the standard .u.upd function with the incoming data like; data:((`$"AAPL.B*";`$"AAPL^#");(122.74;123.17)) Furthermore; I have loaded a CS...

Resolved! How to generate PDFs using kdb+ data and embedPy

I have created a repository that contains a q script with python and ggplot wrapper functions which generate a Report PDF containing graphs, text and kdb+ data tables. All instructions and the q script are uploaded to this repository: https://gitlab....

kbate by New Contributor
  • 247 Views
  • 1 replies
  • 2 kudos

Resolved! Dashboards - action triggers on page load

I created a virtual query which clears some view states and set it as data source for an action. It works as expected when action is triggered but I found out that it is also executed at page load. If I pass parameters to the dashboard they are now c...

Nick_Mospan_0-1628310860367.png

Resolved! embedPy/ BeautifulSoup

Hi All, I am currently looking into scraping data using BeautifulSoup4 in embedPy. My issue is that I am having difficulty accessing the list of lists produced by the method find_all from a BeautifulSoup object. I have ran the below code in python an...

Resolved! Trouble With Huge CSVs

Greetings All, I've got a couple 40gb CSVs that I'm hoping to perform some joins on. I do not know the column format, or headers, or if headers are even in the csv. Im working with a good bit of memory, with 256gb accessible. Loading the files into m...

ticktick_0-1625838980094.png
ticktick by New Contributor III
  • 439 Views
  • 3 replies
  • 0 kudos

Resolved! Technical Analysis using embedPy

Hello All, I'm just starting out with embedPy and wondering if aoneone can help. I'm trying to use a module in python for some technical analysis. I was trying to use this module https://technical-analysis-library-in-python.readthedocs.io/en/latest/ ...

pyq add column to table

Greetings all, Trying to add a numpy array (as a column) to a table in pyq. Pyq documentation doesn't seem to have an answer for me. Any help greatly appreciated.

ticktick by New Contributor III
  • 322 Views
  • 3 replies
  • 0 kudos

Need help installing pyq

I am new to KDB+ and q. I want to install it in my google cloud Debian Buster Linux. I have tried many things to install the pyq extension but didnt find a way to install it successfully. Here are specifications and methods I have tried. 1) uname -m ...

cron job of q script with timer

Hi, I had a previous question about cron job of q script with timer (can't see the non-published group email.)it seems I figured out--the way I was able to keep the q process keep running when starting from cron was to add a port number. Hmm... not s...

Angela by New Contributor
  • 304 Views
  • 2 replies
  • 0 kudos

cron job q script with timer

Hi,I can't seem to get a q script with a timer to continue running in cron.For example:$ cat bin/test.q.z.ts:{0N!.z.Z;}\t 2000If I run this normally it works fine. But when I try to put in in cron, it exits after one timer run. I tried using -t arg t...

Angela by New Contributor
  • 179 Views
  • 1 replies
  • 0 kudos

KX Community - Spoiler Alert!

Hi q-urus! Thank you so much for all the great responses to the new community initiative, we’re delighted you are as excited as we are! ? As promised, here are some examples of how the new community will work: Forums Within a forum you can post quest...

Laura by Community Manager
  • 206 Views
  • 0 replies
  • 2 kudos

Can't run K code from nsl.com (K n00b warning)

charset=utf-8Subject: Can't run K code from nsl.com (K n00b warning) To: personal-kdbplus@googlegroups.comFrom: Alexander Shendi Message-ID: <322A2B6D-128C-4B54-A917-0B4C17FA7116@web.de>X-Provags-ID: V03:K1:onkuEXbX1dOYssgSuCQ5fURUxBQCX+LEog9akuH52P7...

upsert to dictionary of tables?

Hi,So it's better/faster to do upsert with the symbol "`t upsert ..." than upsert and assign "t:t upsert ...", as show here, right?q)t0:t1:([]sym:`a`b;data:1 2)q)\t do[50000;`t1 upsert ([]sym:`a`b;data:1 2)]27q)t1:t0q)\t do[50000;t1:t1 upsert ([]sym:...

Angela by New Contributor
  • 503 Views
  • 5 replies
  • 0 kudos

openssl troubles in kdb 32bit version

Hi everyone!I'm trying to get data from iex and quandl directly into q, but I'm running into troubles with openssl. I'm aware kdb only works with openssl 1.0.X, so I installed 1.0.2o i386 version but went from "incompatible ssl version" to ELFCLASS64...

KX Community Launch June 2021

Hi q-urus! Many of you may not know me - I’m Laura Kerr, the latest addition to the KX Evangelism team. I’m delighted to be reaching out today to let you all know that the KX Community is moving to a new location on the 15th of June 2021! Over the ye...

Laura by Community Manager
  • 127 Views
  • 0 replies
  • 0 kudos

The Array Cast

For our first episode, host Conor Hoekstra talks to Adám Brudzewsky of Dyalog Ltd., Stephen Taylor, the KX Librarian, and Bob Therriault, a J enthusiast, about the qualities of the array languages that they enjoy.arraycast.comStephen Taylor | Librari...

SJT by New Contributor
  • 112 Views
  • 0 replies
  • 0 kudos

From loops to vectors

In learning q most of us have to drop the habit of edging into a solution with loops and think instead of vector operations. The transition is typically both awkward and exhilarating. It is harder if you are a solo student without vector-savvy collea...

SJT by New Contributor
  • 110 Views
  • 0 replies
  • 0 kudos

.Q.gz?

Hi,I sent an email before asking about .Q.gz I wanted to follow up on. (The email is not yet posted).I was able to use the qgz library so I think that should suffice. I'm still not sure about .Q.gz from documentation. Is it only in 4.0 and not in 3.6...

Angela by New Contributor
  • 426 Views
  • 4 replies
  • 0 kudos

.Q.gz ?

Hi,I can't get ".Q.gz"? https://code.kx.com/q/ref/dotq/#qgz-gzipq).Q.gz'.Q.gz [0] .Q.gz ^I'm on Ubuntu (wsl 2). I did install 32 bit zlib ("sudo apt-get install zlib1g-dev:i386") though I'm uncertain if I'm using the right one or setting it up correc...

Angela by New Contributor
  • 115 Views
  • 0 replies
  • 0 kudos