Download Pulse

Add kdb+ Server Connection

To add a connection goto Connections->"Add Data Connection" and fill in your details.
You can try clicking test to see if the connection works before adding it.

Pulse connecting to kdb+ database

Populating the Tables

Copy and Paste the below code into the SQL Editor and press "Send Query":

You can run "-10 sublist trade" to check the data is there:

kdb+ Data Insert
  1. Make sure your data source is selected
  2. Enter your SQL query, click save or highlight all text and press ctrl+E
  3. Highlight -10 sublist trades and press Ctrl+E to run only that code

Real-Time Trade Blotter

First make sure you are in design-mode else click the toggle at the top of the dashboard. This should add a top panel that allows you to add components.

  1. Click Table to add that component
  2. Make sure your kdb+ data source is selected
  3. Select the refresh rate. Every 250ms
  4. Enter your SQL query, click save or press ctrl+E
kdb+ Trade Blotter

Customizing Table Appearance

Formatting Columns

Column formatters can be applied by either:

  1. Right-clicking on the tables column and selecing the formatter.
  2. Or on the right-hand side, select a formatter from the dropdown.

Here you can see TAG styling being applied to render the sym column with a unique colour per string and
the DATABAR styling used to represent the percentage as an inline bar chart.

For more information on styling tables see our table docs or for row specific highlighting see row formatting.

Styling kdb+ Trade Blotter

Table Configuration

The table can be customized to:

  1. show Pulse Pivot - Which allows end users to perform group-bys and pivots using only the UI.
  2. autoSize columns - To toggle where columns spread to occupy 100% or try to fit the data.
  3. show Filters - Similar to excel, smart filters allow users to filter the rows displayed.

More information can be found in the Pivot documentation.

Styling kdb+ Table

Next - Try it yourself

Thanks for watching our demo. Please download Pulse to give it a try for yourself.