Using FMZ’s SQLite Database to Store and Display Tick Data

Summary

The document explains how FMZ’s built-in database, accessed through DBExec, can store and manage structured strategy data. Based on SQLite, it offers a lightweight local option for traders who need more flexible persistence than the platform’s simpler key-value storage, without installing a separate database. The article introduces basic table creation and SQL operations for inserting, querying, updating, and deleting records, and notes that several table names are reserved by the platform.

A worked example creates a tick table, collects exchange ticker fields, queries the stored records, modifies and deletes rows, and displays results in a strategy status table. It describes where the database file is stored and includes a backtest configuration, but reports no performance results. The example demonstrates data handling rather than a trading signal or tested strategy; readers should also account for the limits of the sample, including its small collection loop and its dependence on FMZ’s platform interface.

Key ideas

• FMZ’s DBExec interface provides access to a lightweight SQLite database for strategy data.
• SQL statements can create tables and insert, query, update, or delete stored records.
• The example stores exchange tick fields in a table and presents query results in a status display.
• Platform-reserved table names should be avoided when creating custom tables.
• The document demonstrates database operations, not trading performance or signal quality.

Tags

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.