Data plugin can connect to any database that has corresponding ODBC driver. In order to allow to access data, the table holding quotations needs to have the following columns:
* SYMBOL - holding ticker symbol (text - varchar)
* DATE - quotation date / time (DATETIME type - for Microsoft SQL Server, or TIMESTAMP type for mySQL (open source))
* OPEN - open (recommended FLOAT type)
* HIGH - high (recommended FLOAT type)
* LOW - low (recommended FLOAT type)
* CLOSE - close (recommended FLOAT type)
* VOLUME - volume (recommended FLOAT or INT type)
* OPENINT (optional) - open interest - (recommended FLOAT or INT type)
Types of fields are not that important as plugin has ability to auto-convert if types differ. Recommended types are just as a guideline for best performance.
Partager