I've got ten years of 5000+ stock data I access through the ODBC data plug-in. How do I create and populate an internal amibroker database of the previous three years of data for the 5000+ stocks.
It looks to me the only way to do this is to export the SQL database to ascii files and import into Amibroker. I could do a Exploration with no filter and copy and paste the resulting output to ascii files. Filter=1; AddColumn(O,"Open"); AddColumn(H,"High"); AddColumn(L,"Low"); AddColumn(C,"Close"); AddColumn(V,"Volume",1.0); AddColumn(OI,"Open Interest",1.0); Is there a way either through an AFL script or the Amibroker COM interface to import SQL data into an internal Amibroker databasae?
