[amibroker] Re: Import Data in Java Script

["dfgfdgdfg.fgdfgdfg" <dfgfdgdfg.fgdfgdfg@xxxxxxxx>]

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 amibroker@xxxxxxxxxxxxxxx, "dfgfdgdfg.fgdfgdfg" <dfgfdgdfg.fgdfgdfg@xxx> 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 amibroker@xxxxxxxxxxxxxxx, 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

<*> 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:
    amibroker-digest@xxxxxxxxxxxxxxx 
    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/