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;