[amibroker] Re: How Do Input an ODBC database to an internal Amibroker database?

["Mike" <sfclimbers@xxxxxxxxx>]

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 amibroker@xxxxxxxxxxxxxxx, "steved512" <steved512@xxx> 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?
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/