PureBytes Links
Trading Reference Links
|
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
<*> 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/
|