In this tutorial we are going to recreate this example RSI calculation in q, the language of the kdb database. The relative strength index (RSI) is a technical indicator used in the analysis of financial markets. It is intended to chart the current and historical strength or weakness of a stock or market based on […]
While doing the project euler programming challenges it annoyed me how verbose the java answers would have to be compared to kdb. Then I got to wondering if I could create functions like til,mod,where,asc etc. in java and use them to create really short answers. Once I had the basic functions working, I wondered if […]
Let’s look at how to write moving average analytics in q for the kdb database. As example data (mcd.csv) we are going to use stock price data for McDonalds MCD. The below code will download historical stock data for MCD and place it into table t: Simple Moving Average The simple moving average can be […]
qStudio is an IDE for kdb+ database by kx systems that allows querying kdb+ servers, charting results and browsing server objects from within the GUI. Version 1.29 of qStudio is now available: http://www.timestored.com/qstudio/ Changes in the latest version include a new dark theme for charts and the ability to run multiple instances of qStudio. The […]
Typical feed handlers for kdb+ are for market data and trade data such as bloomberg B-Pipe or reuters market feeds. These feeds typically contain ticker symbol, bid price, ask price and the time. We’ve been working on something a little different, a twitter feed handler. With this feed handler you can subscribe to: A random […]
qStudio is an editor for kdb+ database by kx systems. Version 1.28 of qStudio is now available for download: http://www.timestored.com/qstudio/ Changes in the latest version include: Added Csv Loader (pro) Added qUnit unit testing (pro) Bugfix to database management column copying. Export selection/table bugs fixed and launches excel (thanks Jeremy / Ken) Kdb+ Csv Loader […]
The excellent Q For Mortals: A Tutorial In Q Programming by Jeffry Borror will soon be updated to version 3. Jeff mentioned it at the recent NY user meeting. You can read q for mortals online for free at: http://code.kx.com/wiki/JB:QforMortals2/contents version 2 – added a new chapter on kdb database disk storage. He said to […]
Added four new tutorials for those starting to learn kdb: kdb database – why a column-oriented in-memory database is best for timeseries analysis q Programming Style Best Practices – coding standards for effective maintainability Kdb database errors and limitations – Kdb has its limits. History of Kdb – What is kdb? k4? q kdb+ kdb+tick […]
q Code File Browser and Adding Multiple Kdb Servers Added IDE Features: Add File Tree that allows browsing directory and providing autocomplete qDoc supports custom user tags (Thanks Aaron) Allow adding/exporting whole lists of servers at once (much quicker) Installers are now signed. Ctrl-D “goto definition” of function to open that file/position (PRO) Unit Testing […]
Added qStudio Features: Faster chart drawing (~1.6x faster) Added No Redraw chart option for those who want extra speed Numerous bugfixes to charts that froze Allow setting code editor font size Fix display of boolean/byte lists