Re: [amibroker] Exporting (converting) U.S StockDatabase for .DAT (Metastock).

Sat, 02 Sep 2006 08:29:38 -0700

Hi Focorba,

Code is fine, just need to sort out the word wrap.

See red parts of lines below in the code - move them and append to line above.
Should run fine for you then..

Monty

focorba wrote: 
This issue is specially for new users. Amibroker has just released 
complete databank for all U.S stocks in their site, which is very 
simple and efficent way to install company&symbol database without 
need for manual adding per symbol.

Very simple to get full .TLS database for amibroker. Use following 
link to to get it.

http://www.amibroker.com/docs/ab305.html

Each business areas are placed so well that,

If any would like to export this same database for .DAT (Metastock) 
format I found this code provided in here, does anyone know what´s 
wrong with it ? I created "export.afl" in formulaeditor, but got a 
lot of syntax-errors - anyone knows what´s wrong in this code ?

Best Regards,

Focorba ([EMAIL PROTECTED])

/***** START *****/

// Export data to C:\Trf in MetaStock format: 
Tkr,D,yymmdd,O,H,L,C,V,I

// 1) Execution: AA - ApplyTo (set "filters") - Date Range (doesn't 
work) - Scan
// 2) If the directory doesn't exist it WILL be created automatically
// 3) Hitting "verify" or "apply" buttons exports only the active 
symbol. Use "scan" to export a watch list

output_folder = "C:\\Trf";
output_file = "Mseod.csv";

if ( Status("stocknum") == 0 )
{
fmkdir( output_folder ); // if the directory doesn't exists it will 
be
automatically created
fopen( output_folder + "\\" + output_file, "w"); // if the file 
already exists
all data will be w=overwritten
}

fh = fopen( output_folder + "\\" + output_file, "a"); // a=append 
needed to get
all tickers from watch list
if (fh)
{
t = Name();
p = "D";
y = Year()%100; // to have four digit year use: y = Year();
m = Month();
d = Day();
for( i = 0; i < BarCount; i++ ) // loop
{
fputs( t + "," , fh );
fputs( p + "," , fh );
ds = StrFormat( "%02.0f%02.0f%02.0f,", y[i], m[i], d[i] ); // date 
string
fputs( ds, fh );
qs = StrFormat("%.4f,%.4f,%.4f,%.4f,%.0f,%.0f\n", O[i], H[i], L[i], C
[i],
V[i], OI[i] ); // quote string
fputs( qs, fh );
}
fclose( fh );
}
Buy = 0; // link to "scan" button

/***************
"One time switch" is used; it opens the file in overwrite mode once 
and then runs in append mode rest of the time.
***************/

/***** END *****/








Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html

 
Yahoo! Groups Links

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

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

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

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com

For other support material please check also:
http://www.amibroker.com/support.html




SPONSORED LINKS
Software support Small business finance Business finance online
Business finance training Business finance course

YAHOO! GROUPS LINKS



__,_._,___

Reply via email to