You can try the approach advocated by Norgate Premium Data. See "How can I increase the scanning speed of AmiBroker?" where they describe how to use AmiBroker itself to create a duplicate local database.
http://www.premiumdata.net/support/amibroker.php#speedissues Note that this would read in the entire database history though. Mike --- In [email protected], "steved512" <steved...@...> wrote: > > 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? >
