function downloadExcel(format, companycode, defaultshare, defaultmarket, selectedlang){
    var min_date_result;
    var max_date_result;
    var min_date = document.getElementById('min_date').value;
    var max_date = document.getElementById('max_date').value;        
    var separator = "/";
    var dividends = "false";
    if(format.indexOf("/") > -1)
        separator = "/";
    if(format.indexOf(".") > -1)
        separator = ".";
    if(format.indexOf("-") > -1)
        separator = "-";
    var arr = format.split(separator); 
    var min_date_arr = min_date.split(separator);   
    var max_date_arr = max_date.split(separator);   
    
    var min_date_result_day, max_date_result_day, min_date_result_month, max_date_result_month, min_date_result_year, max_date_result_year;  
    
    for(var i = 0; i < arr.length; i++){
        if(arr[i].toLowerCase() == '%d'){
            min_date_result_day = min_date_arr[i];
            max_date_result_day = max_date_arr[i];
        }
        if(arr[i].toLowerCase() == '%m'){
            min_date_result_month = min_date_arr[i];
            max_date_result_month = max_date_arr[i];
        }
        if(arr[i].toLowerCase() == '%y'){
            min_date_result_year =  min_date_arr[i];
            max_date_result_year =  max_date_arr[i];
        }
    }
   
    min_date_result = min_date_result_day + '|' + min_date_result_month + '|' + min_date_result_year;
    max_date_result = max_date_result_day + '|' + max_date_result_month + '|' + max_date_result_year;

    
    if(document.fCtrls.dividends && document.fCtrls.dividends.checked == true){
        dividends = "true";
    }
    
    var sma = 0;
    if(document.fCtrls.movingAv10.checked == true){
        sma = 10;
    }
    if(document.fCtrls.movingAv50.checked == true){
        sma = 50;
    }
    if(document.fCtrls.movingAv200.checked == true){
        sma = 200;
    }
    var _indices = "";
    var _peers = "";
    var _cntrl = "boxShares";
    for(var i = 0; i < downloadExcelarrIsins.length; i++){
        _cntrl = "boxShares" + i;
        if(document.fCtrls[_cntrl].checked == true){
            if(downloadExcelarrTypes[i] == 1){
                 if(_indices.length > 0)
                    _indices +=  "," + downloadExcelarrIsins[i] + ";" + downloadExcelarrMarkets[i];
                 else
                    _indices += downloadExcelarrIsins[i] + ";" + downloadExcelarrMarkets[i];
            }else{
                 if(_peers.length > 0)
                    _peers +=  "," + downloadExcelarrIsins[i] + ";" + downloadExcelarrMarkets[i];
                 else
                    _peers += downloadExcelarrIsins[i] + ";" + downloadExcelarrMarkets[i];        
            }
        }
    }   
    
    var reqUrl = "";
    if(sma > 0){
        reqUrl = "http://tools.euroland.com/investortools/ChartDownload/arabic.aspx?arrindex=" + _indices + "&arrisins=" + _peers + "&mindate=" + min_date_result + "&maxdate=" + max_date_result + "&dividends=" + dividends + "&companycode=" + companycode + "&default=" + defaultshare + "&defaultmarket=" + defaultmarket + "&lang=" + selectedlang + "&defaultculture=en-gb&sma=" + sma;
    }else{
        reqUrl = "http://tools.euroland.com/investortools/ChartDownload/arabic.aspx?arrindex=" + _indices + "&arrisins=" + _peers + "&mindate=" + min_date_result + "&maxdate=" + max_date_result + "&dividends=" + dividends + "&companycode=" + companycode + "&default=" + defaultshare + "&defaultmarket=" + defaultmarket + "&lang=" + selectedlang + "&defaultculture=en-gb";
    }
    
  //  alert(reqUrl);
    document.location.href=reqUrl;
}
