[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Moving intraday quotes from one Amibroker database to another



PureBytes Links

Trading Reference Links

Hi all,

I use interactive brokers intraday quotes on my computer at work. I 
would like to save a copy of the S&P 500 1 minute bars and accumulate 
them. There is a JS script which we can run to export quotes from 
Amibroker to a CSV format. However it works fine for EOD data but 
when I export the intraday data no time data is added to each row.

Question 1: Does anyone know how to add the time to the existing JS 
script? see below for extract of amibroker supplied export.js script

Question 2: Does anyone know if there is a free source for 1 minute 
bars for S&P 500, russell 2000, DJI.

Thank you advance for your help...

Regards, Tony

// extract from standard export.js script supplied by amibroker.
// no timestamp on date
f.WriteLine("$SEPARATOR ,");
f.WriteLine("$FORMAT Ticker,Date_YMD,Open,High,Low,Close,Volume")

for( i = 0; i < Qty; i++ )
{
	oQuote = oStock.Quotations( i );

	var oDate = new Date( oQuote.Date );

	f.WriteLine( 	oStock.Ticker + "," + 
			oDate.getFullYear() + "-" + (oDate.getMonth()
+1) + "-" + oDate.getDate() + "," + 
			FormatFloat( oQuote.Open ) + "," + 
			FormatFloat( oQuote.High ) + "," +
			FormatFloat( oQuote.Low ) + "," +
			FormatFloat( oQuote.Close ) + "," + 
			Math.round( oQuote.Volume )  );
}





Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
 
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:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto: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/