July 21, 2006
Universal ODBC/SQL Data/AFL plugin
General purpose Data and AFL plugin for ODBC data sources has just been released. There are actually two plugins available one data plugin and the other one for accessing external databases from AFL level and they can be used either independently or together.
The plugins are provided with source code for reference purposes. Making any changes, use of source codes in any other project, derivative work based on it requires our formal approval.
Documentation, download links and more information is available from:
http://www.amibroker.com/odbc.html
Filed by Tomasz Janeczko at 10:12 am under Plugins,Releases
5 Comments
Tomasz,
Could you make the SQL/ODBC plugin a little more flexible so I could directly use a tick database? I have a lot of eSignal tick data and I’m currently using the following ASCII import format:
$FORMAT Skip, Date_YMD, Time, Close, Volume
$SKIPLINES 2
$SEPARATOR ,
$CONT 1
$GROUP 255
$AUTOADD 1
$DEBUG 1
$TICKMODE 1
Obviously, the first format line is the only important one for a database of ticks. The “Skip” is in there for the “T” or “Q” field. The date (YYMMDD) and time (HHMMSS) are separate fields. Here’s a sample of what the data looks like (this is from an ER2 eSignal tick file):
T,051229,001724,683.1,1,
T,051229,003227,683,1,
T,051229,003247,683,1,
T,051229,003318,683,1,
T,051229,003439,682.9,1,
T,051229,003920,682.9,1,
T,051229,003926,682.9,1,
T,051229,004151,683.2,1,
Thanks for considering this request.
In my opinion, there is no need for special “support” for that.
You can put tick data into database, just import them:
combine date and time fields into single datetime field and put price and volume in separate fields,
then in plugin configuration screen define open, high, low, close fields
to point to single PRICE field that you have in your database.
[…] See also announcement of version 1.0.0: http://www.amibroker.com/devlog/2006/07/21/odbcsql-dataafl-plugin/ […]
Hi Tomasz , I don’t get anny success with figgering this -ODBC/SQL Data/AFL plugin-, I followed the instruction but I dont get the Table name combo box with the list of available tables , it stay empty, anny idea what am I missing ? doing wrong ?
thanks for your help,,,,
Hi Tomasz , I find the problem ! I was useing an XLS file as a data base, some how it couldnt read this file only if its a CSV file it can be read & transfered into AB , allso
the file can be transferd into AB only if its closed . is there no way to the plugin to read the CSV file wile it is open & updating from & external source, do I have to save & close this file so the plugin then can pull data into AB ?????