Hi all,
I am trying to link an file of ascii datas with
Amibroker.
I have downloaded, in Amibroker'sguide, a
jscript procedure which is capable to realize this, bur it does'not work with
me.
Here is the source of this Jscript
:
/* ** AmiBroker/Win32 scripting
Example ** ** File: Import.js ** Created: Tomasz Janeczko,
January 30th, 2000 ** Purpose: Import quotes from Metastock ASCII
file ** Language: JScript (Windows Scripting Host) ** ** The data is
stored in lines with following format **
<ticker>,<per>,<date>,<high>,<low>,<close>,<volume> ** */ ImportMsASCII(
"C:\\ACCOR.Txt" );
function ImportMsASCII( filename
) { var fso, f, r; var ForReading = 1; var
AmiBroker; var date; var quote; var
fields; var stock;
/* Create AmiBroker app object
*/ AmiBroker = new ActiveXObject( "Broker.Application" );
/* ... and file system object */ fso
= new ActiveXObject( "Scripting.FileSystemObject" );
/* open ASCII file */ f =
fso.OpenTextFile( filename, ForReading);
/* skip first line which contains format
definition */ f.SkipLine();
/* read the file line by line
*/ while ( !f.AtEndOfStream ) { r
= f.ReadLine(); /* split the
lines using semicolon as a separator */ fields =
r.split(";"); /* add a ticker -
this is safe operation, in case that */ /* ticker
already exists, AmiBroker returns existing one */ stock =
AmiBroker.Stocks.Add( fields[ 0 ] );
/* notify the user */ WScript.Echo(
"Importing " + fields[ 0 ] );
/* parse the date from the text
file */ date = new Date( fields[ 1 ]
);
/* add a new quotation */
quote = stock.Quotations.Add( date.getvarDate()
);
/* put data into it
*/ quote.Open = parseFloat(
fields[2]); quote.High = parseFloat( fields[ 3 ]
); quote.Low = parseFloat( fields[ 4 ]
); quote.Close = parseFloat( fields[ 5 ]
); quote.Volume = parseInt( fields[ 6 ]
); }
/* refresh ticker list and windows
*/ AmiBroker.RefreshAll();
/* notify the user */ WScript.Echo(
"Finished" );
} and here is an example of datas
file :
<Ticker>,<date_DMY>,<Open>,<High>,<Low>,<Close>,<Volume> ACCOR;09/10/2009;
37.42; 38.12;
36.87; 37.10;
735891 ACCOR;12/10/2009;
37.25; 37.84;
37.13; 37.68;
673107 ACCOR;13/10/2009;
37.36; 38.02;
37.21; 37.34;
726353 ACCOR;14/10/2009;
37.71; 38.29;
37.59; 37.81;
850644 ACCOR;15/10/2009;
37.85; 38.10;
36.30; 36.50;
1445724 ACCOR;16/10/2009;
36.50; 36.88;
35.90; 36.08;
1541279 ACCOR;19/10/2009;
36.12; 36.65;
35.90; 36.28;
1036342 ACCOR;20/10/2009;
36.49; 36.63;
36.05; 36.20;
799961 ACCOR;21/10/2009;
36.31; 36.40;
35.57; 35.74;
889888 ACCOR;22/10/2009;
35.47; 35.47;
34.70; 35.02;
804990 ACCOR;23/10/2009;
35.50; 35.78;
34.26; 34.31;
1473307 ACCOR;26/10/2009;
34.49; 34.85;
33.75; 33.87; 1293311
I always have an error message : "cet objet
ne gère pas cette propriété"
at the lnstruction "quote = stock.Quotations.Add(
date.getvarDate() )" (In red in the source code)
Can anyone help me ?
Best regards;
__._,_.___
**** 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/
__,_._,___
|