private void ImportCurrency(string fileName)
{
DataTable table = CsvToDataTable.ReadFile(fileName);
int position = 1;
foreach (DataRow row in table.Rows)
{
CodeSet codeSet = new CodeSet();
codeSet.Code = row["Code"].ToString();
codeSet.EnumCode = (int)row["EnumCode"].ToString().ParseInt();
codeSet.Value = row["Value"].ToString();
codeSet.Description = row["Description"].ToString();
codeSet.ReferenceKey = string.Empty;
codeSet.Position = position;
CoreDatabaseObjects.Instance.Save(codeSet);
position++;
}
}
public DataTable ReadData(string fileName)
{
return(CsvToDataTable.ReadFile(fileName));
}
public static void Main(string[] args)
{
// Initialising variables + increases window size to facilitate all data
Console.WindowWidth = 180;
bool InLength = false;
string Ticker = "";
string IntervalChoice = "";
do
{
// Reads in Ticker input
Console.WriteLine("Enter stock ticker: ");
Ticker = Console.ReadLine();
// Makes sure Ticker length is less than 6 otherwise loops and restarts
if (Ticker.Length < 6)
{
InLength = true;
}
else
{
Console.WriteLine("Invalid Ticker Retry");
InLength = false;
}
} while (InLength == false); // If ticker length is valid program continues
bool a = false;
do
{
Console.WriteLine("Choose a timeframe: " + "\n1: Todays Trading" + "\n2: Intraday" + "\n3: Daily");
string TimeFrame = Console.ReadLine();
switch (TimeFrame)
{
case "1":
Console.Clear();
AlphaConnect conn = new AlphaConnect("connect"); // calls the variable conn from APIConnect class
conn.ImportToCSVCurrent(Ticker);
DataFrame df = DataFrame.LoadCsv("calledData.csv"); // imports the csv file containing stock data into a dataframe
CsvToDataTable obj = new CsvToDataTable(); // calls CSVtoDataTable Method
DataTable dtData = obj.ConvertCsvToDataTable("calledData.csv");
obj.ShowData(dtData); // outputs data
a = true;
break;
case "2": // secondary menu
Console.WriteLine(
"Choose the intervals: " +
"\n1: 1 Minute:" +
"\n2: 5 Minutes" +
"\n3: 15 Minutes" +
"\n4: 30 Minutes" +
"\n5: 60 Minutes"
);
string Interval = Console.ReadLine();
switch (Interval)
{
case "1":
IntervalChoice = "1 Minute";
AlphaConnect._minute = "1min";
break;
case "2":
IntervalChoice = "5 Minutes";
AlphaConnect._minute = "5min";
break;
case "3":
IntervalChoice = "15 Minutes";
AlphaConnect._minute = "15min";
break;
case "4":
IntervalChoice = "30 Minutes";
AlphaConnect._minute = "30min";
break;
case "5":
IntervalChoice = "60 Minutes";
AlphaConnect._minute = "60min";
break;
}
Console.Clear();
Console.WriteLine(
"Your ticker is: " + Ticker +
"\nYour selected timeframe is: " + IntervalChoice +
"\nPlease Wait..."
);
conn = new AlphaConnect("connect"); // calls the variable conn from APIConnect class
conn.ImportToCSVIntraDay(Ticker);
df = DataFrame.LoadCsv("calledData.csv"); // imports the csv file containing stock data into a dataframe
obj = new CsvToDataTable(); // calls CSVtoDataTable Method
dtData = obj.ConvertCsvToDataTable("calledData.csv");
obj.ShowData(dtData); // outputs the stock data
a = true;
break;
case "3":
string choice = "Daily";
Console.Clear();
Console.WriteLine(
"Your ticker is: " + Ticker +
"\nYour selected timeframe is: " + choice +
"\nPlease Wait..."
);
conn = new AlphaConnect("connect"); // calls the variable conn from the APIConnect Class
conn.ImportToCSVDaily(Ticker);
df = DataFrame.LoadCsv("calledData.csv"); // imports the csv file containging stock data into a dataframe
obj = new CsvToDataTable(); // calls CSVtoDataTable Method
dtData = obj.ConvertCsvToDataTable("calledData.csv");
obj.ShowData(dtData); // outputs the stock data
a = true;
break;
}
} while (a == false);
}
