Skip to content

Instantly share code, notes, and snippets.

@currencysecrets
Created January 4, 2014 07:08
Show Gist options
  • Save currencysecrets/8252586 to your computer and use it in GitHub Desktop.
Save currencysecrets/8252586 to your computer and use it in GitHub Desktop.
Importing ASCII data from forexDataDownloader into AmiBroker automatically (i.e. without running the Import Data)
EnableScript("JScript");
<%
function importForexQuotes() {
var files = [
"Z:\\Dropbox\\DATA\\OANDA\\D1\\AUDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\AUDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\AUDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\AUDNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\AUDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\CADCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\CADJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\CHFJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURGBP.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\EURUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\GBPUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\NZDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\NZDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\NZDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\NZDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\USDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\USDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\D1\\USDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\AUDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\AUDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\AUDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\AUDNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\AUDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\CADCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\CADJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\CHFJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURGBP.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\EURUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\GBPUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\NZDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\NZDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\NZDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\NZDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\USDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\USDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H1\\USDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\AUDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\AUDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\AUDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\AUDNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\AUDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\CADCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\CADJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\CHFJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURGBP.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\EURUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\GBPUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\NZDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\NZDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\NZDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\NZDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\USDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\USDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\W1\\USDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\AUDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\AUDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\AUDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\AUDNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\AUDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\CADCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\CADJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\CHFJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURGBP.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\EURUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPAUD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPNZD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\GBPUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\NZDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\NZDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\NZDJPY.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\NZDUSD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\USDCAD.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\USDCHF.csv",
"Z:\\Dropbox\\DATA\\OANDA\\H4\\USDJPY.csv"
];
var AB = new ActiveXObject("Broker.Application");
for ( var i = 0; i < 112; i += 1 ) {
AB.Import( 0, files[i] );
}
AB.RefreshAll();
}
importForexQuotes();
%>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment