Help JavaScript => AmiBroker

[aaa 10]

Hi

 

Help will B appreciated

 

It's my first step with Java

 

****************************

 

I try 2 import datas in AB

 

I've almost arrived except that I have no idea how 2 format the date

 

Here is a txt data example in attachement 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

 

and my script

 

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" );
}

 

There is also a mix of OHLC datas

 

4356.txt

Edited January 25, 2010 by aaa

[aaa 10]

***************************

[sevensa 10]

Maybe someone here would be able to help you? Amibroker User Group

[aaa 10]

ThanX Sevensa I try right now