Hello, It should be AmiBroker.Import( 0, "filetoimport", "format defitiniton");
By the way, this is NOT Java. This is JavaScript. Read this for more info: http://www.amibroker.com/newsletter/02-2001.html Best regards, Tomasz Janeczko amibroker.com On 2010-02-01 11:18, dfgfdgdfg.fgdfgdfg wrote: > I try your idea but there is an error : Type mismatch > > I've certainly made a mistake or I didn't undestood > > Please remember that I'm a beginner in AFL + Java > > > AmiBroker = new ActiveXObject( "Broker.Application" ); > > AmiBroker.Import("4356.txt", "_IntraDay.format" ); > > regards Katarina > > > --- In [email protected], > "dfgfdgdfg.fgdfgdfg"<dfgfdgdfg.fgdfg...@...> wrote: > >> 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<groups@> 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 >>>> >>>> >>>> >>>> >>>> >>>> >>> >> > > > > ------------------------------------ > > **** 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 > > > > >
