Hello ThanX for your quick answer
I must say that these are my first steps in Java I wish to automate Data import with a Macro Express script This is why I need Java My script works but I need gentle help to format dates Can you do that ? Regards Katarina --- In [email protected], Tomasz Janeczko <gro...@...> wrote: > > Hello, > > You should use > > AmiBroker = new ActiveXObject( "Broker.Application" ); > > AmiBroker.Import("filetoimport", "formatdefinitionfile" ); > > instead. It is faster and simpler. > > Read > http://www.amibroker.com/guide/objects.html > and > http://www.amibroker.com/guide/d_ascii.html > > > Best regards, > Tomasz Janeczko > amibroker.com > > On 2010-02-01 10:15, dfgfdgdfg.fgdfgdfg wrote: > > Hi > > I try 2 import data > > I've almost arrived except that I have no idea how 2 format the date > > > > ImportMsASCII( "4356.txt" ); > > > > function ImportMsASCII( filename ) > > { > > var fso, f, r; > > var ForReading = 1; > > var AmiBroker; > > var date; > > var quote; > > var fields; > > var stock; > > > > AmiBroker = new ActiveXObject( "Broker.Application" ); > > > > fso = new ActiveXObject( "Scripting.FileSystemObject" ); > > > > ticker = fso.GetBaseName( filename ).toUpperCase(); > > > > stock = AmiBroker.Stocks.Add( ticker ); > > > > f = fso.OpenTextFile( filename, ForReading); > > > > f.SkipLine(); > > > > while ( !f.AtEndOfStream ) > > { > > r = f.ReadLine(); > > > > fields = r.split("\t"); > > > > date = new Date( fields[ 0 ] ); /* Problem here ?*/ > > > > quote = stock.Quotations.Add( date.getVarDate() ); /* Problem here ? > > */ > > > > quote.Open = parseFloat( fields[ 1 ] ); > > quote.High = parseFloat( fields[ 2 ] ); > > quote.Low = parseFloat( fields[ 3 ] ); > > quote.Close = quote.Open = parseFloat( fields[ 4 ] ); > > quote.Volume = parseInt( fields[ 5 ] ); > > } > > > > AmiBroker.RefreshAll(); > > > > WScript.Echo( "Finished" ); > > } > > > > > > Here is a txt data example in 4356.txt > > > > DATE OPEN HIGH LOW CLOSE VOLUME > > 04/01/2010 38.080 38.890 38.020 38.890 6117 > > 05/01/2010 38.810 38.900 38.200 38.650 6570 > > 06/01/2010 38.460 38.600 37.240 38.190 13264 > > 07/01/2010 38.060 38.060 37.470 37.800 9621 > > 08/01/2010 38.040 38.170 37.560 37.830 7808 > > 11/01/2010 38.080 38.110 37.560 37.580 13947 > > 12/01/2010 37.250 37.250 36.610 36.760 11846 > > 13/01/2010 36.610 36.970 36.600 36.920 7922 > > 14/01/2010 37.200 37.530 37.010 37.290 8228 > > 15/01/2010 37.475 38.015 36.840 37.040 9589 > > > > > > > > > > > > > > > > > > ------------------------------------ > > > > **** 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 > > > > > > > > > > >
