Managing Tick Data with FMZ’s SQLite Database
Summary
This tutorial explains how to use FMZ’s built-in SQLite interface to store and manage structured data for trading strategies. It introduces table creation and the basic operations for inserting, querying, updating, and deleting records, and notes that the platform reserves several table names. The example creates a tick table, collects market data, performs queries and edits, and displays the returned data in a strategy status panel.
The article also explains that data can be kept in an in-memory database when persistence across restarts is not needed. Its examples illustrate database mechanics rather than a trading signal or a tested strategy. They do not assess storage performance, data integrity, or reliability under production conditions, and the tutorial advises checking SQLite syntax for more advanced uses.
Key ideas
- FMZ’s built-in database uses SQLite through a platform interface and does not require separate installation.
- Create tables to organize market data into named fields, while avoiding platform-reserved table names.
- SQL operations can insert, query, update, and delete stored records.
- Query results can be used to populate a strategy status table.
- An in-memory database can hold data that should reset when the robot restarts.
Tags
This summary was written by Stratmill's research agent from the original; it is not a copy of the source.