Read Live Algorithm
Export Trades
Description
The CSV file contains the closed trades that the /live/trades/read endpoint returns for the project. The response contains the trades with an entry time at or after start.
Request
Download the closed trades of a project from the start time provided. The /live/export/trades API accepts requests in the following format:
ExportLiveTradesRequest Model - Request to download the closed trades of the live deployments of a project. | |
|---|---|
| projectId | integer Id of the project from which to download the closed trades. |
| start | integer Earliest entry time of the trades in Unix time (seconds). The default value is one hour before the first deployment of the project. |
| Example |
{
"projectId": 23456789,
"start": 1727222400
}
|
Responses
The /live/export/trades API provides a response in the following format:
200 Success
text/csv - Closed trades of the live deployments of the project. | |
|---|---|
| content | string One row per closed trade. The Entry Time and Exit Time columns are in UTC. |
| Example |
Entry Time,Symbols,Exit Time,Direction,Entry Price,Exit Price,Quantity,P&L,Fees,MAE,MFE,Drawdown,IsWin,Order Ids 2026-10-09T14:17:04.8008663Z,"SPY",2026-10-09T18:06:03.8005312Z,Buy,670.08,672.61,10,25.3,2,-8.9,25.3,8.9,1," 276,308" |
401 Authentication Error
UnauthorizedError Model - Unauthorized response from the API. Key is missing, invalid, or timestamp is too old for hash. | |
|---|---|
| www_authenticate | string Header |
Examples
The following example demonstates creating, reading, updating, and listing live algorithms of a project through the cloud API.
from base64 import b64encode
from hashlib import sha256
from time import time
from requests import get, post
BASE_URL = 'https://www.quantconnect.com/api/v2/'
# You need to replace these with your actual credentials.
# You can request your credentials at https://www.quantconnect.com/settings/
# You can find our organization ID at https://www.quantconnect.com/organization/
USER_ID = 0
API_TOKEN = '____'
ORGANIZATION_ID = '____'
def get_headers():
# Get timestamp
timestamp = f'{int(time())}'
time_stamped_token = f'{API_TOKEN}:{timestamp}'.encode('utf-8')
# Get hased API token
hashed_token = sha256(time_stamped_token).hexdigest()
authentication = f'{USER_ID}:{hashed_token}'.encode('utf-8')
authentication = b64encode(authentication).decode('ascii')
# Create headers dictionary.
return {
'Authorization': f'Basic {authentication}',
'Timestamp': timestamp
}
# Authenticate to verify credentials
response = post(f'{BASE_URL}/authenticate', headers = get_headers())
print(response.json())
# --------------------
### Create Live Algorithm
# Define placeholder IDs for compilation and node (replace with actual values)
project_id = 12345678
compile_id = "compile_id..."
node_id = "node_id..."
# Prepare the data payload for creating a live algorithm with necessary details
payload = {
"versionId": "-1", # Use the latest version of the algorithm
"projectId": project_id, # ID of the project to deploy as a live algorithm
"compileId": compile_id, # Compilation ID for the algorithm code
"nodeId": node_id, # Node ID where the algorithm will run
"brokerage": { # Brokerage configuration for live trading
"id": "QuantConnectBrokerage", # Brokerage identifier
"user": "", # Brokerage username (replace with actual value)
"password": "", # Brokerage password (replace with actual value)
"environment": "live-paper", # Trading environment (live or paper)
"account": "" # Brokerage account ID (replace with actual value)
},
"dataProviders": { # Data provider configuration
"QuantConnectBrokerage": {
"id": "QuantConnectBrokerage" # Data provider identifier
}
},
"parameters": {}, # Optional algorithm parameters (empty in this example)
"notification": {} # Optional notification settings (empty in this example)
}
# Send a POST request to the /live/create endpoint to deploy the algorithm
response = post(f'{BASE_URL}/live/create', headers=get_headers(), json=data)
# Parse the JSON response into python managable dict from the API
result = response.json()
# Extract the deploy ID from the response for future operations
deploy_id = result['deployId']
# Check if the request was successful and print the result
if result['success']:
print("Live Algorithm Created Successfully:")
print(result)
### Read Live Algorithm Statistics
# Prepare data payload with project and deploy IDs to fetch statistics
payload = {
"projectId": project_id, # ID of the project
"deployId": deploy_id # ID of the deployed live algorithm
}
# Send a POST request to the /live/read endpoint to get algorithm statistics
response = post(f'{BASE_URL}/live/read', headers=get_headers(), json=payload)
# Parse the JSON response into python managable dict
result = response.json()
# Check if the request was successful and print the statistics
if result['success']:
print("Live Algorithm Statistics:")
print(result)
### Liquidate Live Algorithm
# Prepare data payload with project ID to liquidate the algorithm
payload = {
"projectId": project_id # ID of the project to liquidate
}
# Send a POST request to the /live/update/liquidate endpoint to liquidate
response = post(f'{BASE_URL}/live/update/liquidate', headers=get_headers(), json=payload)
# Parse the JSON response into python managable dict
result = response.json()
# Check if the request was successful and print the result
if result['success']:
print("Live Algorithm Liquidated Successfully:")
print(result)
### Stop Live Algorithm
# Prepare data payload with project ID to stop the algorithm
payload = {
"projectId": project_id # ID of the project to stop
}
# Send a POST request to the /live/update/stop endpoint to stop the algorithm
response = post(f'{BASE_URL}/live/update/stop', headers=get_headers(), json=payload)
# Parse the JSON response into python managable dict
result = response.json()
# Check if the request was successful and print the result
if result['success']:
print("Live Algorithm Stopped Successfully:")
print(result)
### List Live Algorithms
# Prepare data payload with filters for listing live algorithms
payload = {
"status": "Running", # Filter to show only running algorithms
"start": 1717801200, # Start time (Unix timestamp) for the list range
"end": 1743462000 # End time (Unix timestamp) for the list range
}
# Send a POST request to the /live/list endpoint to list algorithms
response = post(f'{BASE_URL}/live/list', headers=get_headers(), json=payload)
# Parse the JSON response into python managable dict
result = response.json()
# Check if the request was successful and print the list
if result['success']:
print("List of Live Algorithms:")
print(result)
### Export Orders
from decimal import Decimal
from time import sleep
# Download the orders of the last 750 days as a CSV file
payload = {
"projectId": project_id # ID of the project
}
response = post(f'{BASE_URL}/live/export/orders', headers=get_headers(), json=payload)
rows = response.text.splitlines()
header, recent = rows[0], rows[1:]
# The export starts at its first row. Older orders come from the /live/orders/read endpoint.
cutoff = recent[0].split(',')[1][:19].replace('T', ' ') if recent else '9999'
# Map the order type and status enums to the names in the CSV file
order_types = ["Market", "Limit", "Stop Market", "Stop Limit", "Market On Open", "Market On Close",
"Option Exercise", "Limit If Touched", "Combo Market", "Combo Limit", "Combo Leg Limit", "Trailing Stop"]
order_statuses = ["New", "Submitted", "Partially Filled", "Filled", "", "Canceled", "None", "Invalid",
"Cancel Pending", "Update Submitted"]
def number(value):
text = format(Decimal(str(value)), 'f')
return text.rstrip('0').rstrip('.') if '.' in text else text
# Read the older orders of each deployment that started before the cutoff
older = []
response = post(f'{BASE_URL}/live/list', headers=get_headers(), json={"projectId": project_id})
deployments = sorted(response.json()['live'], key=lambda x: x['launched'])
for deployment in deployments:
if deployment['launched'] >= cutoff:
continue
start = 0
while True:
payload = {
"projectId": project_id, # ID of the project
"deployId": deployment['deployId'], # ID of the deployment
"start": start, # Starting index for orders
"end": start + 1000 # Ending index for orders
}
result = post(f'{BASE_URL}/live/orders/read', headers=get_headers(), json=payload).json()
# The first request can return a loading status while the orders are prepared
if result.get('status') == 'loading':
sleep(1)
continue
for order in result['orders']:
if order['time'][:19].replace('T', ' ') >= cutoff:
continue
older.append(','.join([
deployment['deployId'], order['time'], order['symbol']['value'],
number(order['price']), number(order['quantity']),
f'"{order_types[order["type"]]}"', f'"{order_statuses[order["status"]]}"',
number(order['value']), '"' + order['tag'].replace('"', '""') + '" '
]))
start += 1000
if start >= result['length']:
break
# Save all the orders in one CSV file
with open(f'orders-{project_id}.csv', 'w', newline='') as file:
file.write('\n'.join([header] + older + recent) + '\n')
print(f"Saved {len(older) + len(recent)} orders")
### Export Trades
# Download the closed trades that opened since the start time as a CSV file
payload = {
"projectId": project_id, # ID of the project
"start": 1717801200 # Start time (Unix timestamp) for the trade entry time
}
response = post(f'{BASE_URL}/live/export/trades', headers=get_headers(), json=payload)
with open(f'trades-{project_id}.csv', 'w', newline='') as file:
file.write(response.text)