private static void createDefaultConfigurationTxt(string configPath)
{
//create the configuration.txt file with default settings
var sb = new StringBuilder("", 1830);
sb.Append("#***********************************************************************************\n");
sb.Append("#***CONFIGURATION FILE**************************************************************\n");
sb.Append("#***********************************************************************************\n");
sb.Append("#Lines that start with a pound sign (#) are comments\n");
sb.Append("#colons (:) separate variable names and values\n");
sb.Append("#semicolon (;) indicates the end of a line\n");
sb.Append("#***********************************************************************************\n");
sb.Append("#Column Header Names are defined with [variable name]:[string name from spreadsheet]\n");
sb.Append("#Neither the variable names, nor the values are case-sensitive\n");
sb.Append("#White-spaces are ignored\n");
sb.Append("#-----------------------------------------------------------------------------------\n");
sb.Append("reportDate: report_date_as_mm_dd_yyyy;\n");
sb.Append("markeCode: cftc_contract_market_code;\n");
sb.Append("openInterest: open_interest_all;\n");
sb.Append("largeTraderLongPositions: noncomm_positions_long_all;\n");
sb.Append("largeTraderShortPositions: noncomm_positions_short_all;\n");
sb.Append("commercialLongPositions: comm_positions_long_all;\n");
sb.Append("commercialShortPositions: comm_positions_short_all;\n");
sb.Append("smallSpecLongPositions: nonrept_positions_long_all;\n");
sb.Append("smallSpecShortPositions: nonrept_positions_short_all;\n");
sb.Append("#***********************************************************************************\n");
sb.Append("#STOCK INDEX FUTURE, S&P 500 - INTERNATIONAL MONETARY MARKET\n");
sb.Append("#or S&P 500 STOCK INDEX - INTERNATIONAL MONETARY MARKET\n");
sb.Append("#CFTC_Contract_Market_Code\n");
sb.Append("#-----------------------------------------------------------------------------------\n");
sb.Append("spMarketCode: 138741;\n");
sb.Append("#***********************************************************************************\n");
sb.Append("# Output ticker symbols\n");
sb.Append("#-----------------------------------------------------------------------------------\n");
sb.Append("symbolCotCommercials: ^ COTSPXCOM;\n");
sb.Append("symbolcotLargeTraders: ^ COTSPXLG;\n");
sb.Append("symbolcotSmallSpeculators: ^ COTSPXSM;\n");
sb.Append("symbolcotSpread: ^ COTSPXSpread;\n");
sb.Append("#***********************************************************************************\n");
sb.Append("#Output files Metastock headers\n");
sb.Append("#-----------------------------------------------------------------------------------\n");
sb.Append("metastockHeaders: <NAME>,<TICKER>,<PER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>\n");
try
{
File.WriteAllText(configPath, sb.ToString());
}
catch (UnauthorizedAccessException)
{
ErrorHelpers.immediateEx("ERROR. Cannot create configuration file due to insufficient permissions.");
}
catch (IOException)
{
ErrorHelpers.immediateEx("ERROR. Cannot create configuration file due to an unexpected error.");
}
catch (Exception)
{
ErrorHelpers.immediateEx("ERROR. Cannot create configuration file due to an unknown error.");
}
}
public static DataTable convertXLSToDataTable(string sourceFilePath)
{
string strConn = String.Concat(_oleDbConnectionString.Replace("$FILEPATH$", sourceFilePath));
using (var conn = new OleDbConnection(strConn))
{
try
{
conn.Open();
string sheetName = findFirstSheetName(sourceFilePath);
using (var cmd = new OleDbCommand(String.Concat("SELECT * FROM [", sheetName, "]"), conn))
{
//select the data from the spreadsheet and convert it to a DataTable
cmd.CommandType = CommandType.Text;
using (var da = new OleDbDataAdapter(cmd))
{
using (var dt = new DataTable())
{
try
{
da.Fill(dt);
return(dt);
}
catch (Exception)
{
ErrorHelpers.immediateEx(String.Format("ERROR. Could not find data in a worksheet named {0}.\nPlease select a different file.", sheetName));
}
}
}
}
}
catch {
ErrorHelpers.immediateEx(_alreadyOpenError);
}
}
return(null);
}
public static string getConfigVal(string keyName)
{
if (_htConfig == null)
{
loadConfigFile();
}
if (_htConfig.ContainsKey(keyName))
{
//only stock symbol values are returned in uppercase
if (keyName.StartsWith("symbol"))
{
return(_htConfig[keyName].ToString().ToUpper());
}
else
{
return(_htConfig[keyName].ToString().ToLower());
}
}
else
{
ErrorHelpers.immediateEx((String.Format("ERROR. Could not find the configuration value for {0}.", keyName)));
}
return("");
}
