BrokerQL 0.0.2

The download page shows you how but tl;dr:

Linux or Windows or macOS

pip install BrokerQL

macOS only

brew tap BrokerQL/tap
brew install broker-ql

Make sure your IBKR TWS is running on localhost, and listen to port 7496 for API.

Launch the interactive shell.

broker-ql --cli

Run your first query!

select * from tws.positions;

• It's just SQL

• You can run queries on the command line and include them in scripts.

Prerequisites:

• Python Version 3.9.

Clone:

git clone git@github.com:BrokerQL/BrokerQL
cd BrokerQL

Create virtualenv, and run the pip command

python -m venv venv
source venv/bin/activate
pip install .
pip install -r requirements-dev.txt

Check the version

$ broker-ql -v
BrokerQL v0.0.1

Try it!

broker-ql --cli
connecting to tws...
tws connected
BrokerQL (none)> nopager
Pager disabled.
Time: 0.000s
BrokerQL (none)> show databases
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| tws                |
+--------------------+
3 rows in set
Time: 0.036s
BrokerQL (none)> use tws
You are now connected to database "tws" as user "panjiabang"
Time: 0.001s
BrokerQL tws> show tables
+---------------+
| Table_name    |
+---------------+
| orders        |
| positions     |
| quotes        |
| subscriptions |
+---------------+
4 rows in set
Time: 0.033s
BrokerQL tws> select * from positions
+-----------+--------+----------+--------------------+
| account   | symbol | position | avg_cost           |
+-----------+--------+----------+--------------------+
| U11739578 | ADBE   |  6.0     | 579.3533333333334  |
| U11739578 | PDD    | 32.0     | 119.65125          |
| U11739578 | URNM   | 62.0     |  49.18850806451613 |
| U11739578 | QQQ    | 27.0     | 385.82703703703703 |
| U11739578 | MSFT   | 12.0     | 378.9533333333333  |
| U11739578 | MHO    | 40.0     | 103.19500000000001 |
+-----------+--------+----------+--------------------+
12 rows in set
Time: 0.037s