Hello Monty, Made those fixes and export.afl seems not to give any error messages anymore, instead it creates empty .csv file including only topics> "Ticker,Trade,Date,Close," without actual filling nothing, not tickers, trades, dates or close prices.
Do I actually have to run this created .afl in automatic analyze section in amibroker ? Best Regards&appreciated your help, Focorba --- In [email protected], Monty <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > > > > > > > > > > > > > > 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/
