//Step 2: Make sure all full analyses have data
public static void CheckData()
{
Console.Write("Path to the folder containing the analyses: ");
string path = Console.ReadLine();
path = path.Replace("\"", "");
string[] files = System.IO.Directory.GetFiles(path);
List <string> BlankFiles = new List <string>();
foreach (string s in files)
{
FullResearchSet frs = JsonConvert.DeserializeObject <FullResearchSet>(System.IO.File.ReadAllText(s));
bool flagthis = false;
if (frs.AveragePerformance == null)
{
flagthis = true;
}
if (frs.PerformancesFollowingInsiderBuys == null)
{
flagthis = true;
}
if (frs.PerformancesFollowingInsiderBuys.Length == 0)
{
flagthis = true;
}
if (flagthis)
{
Console.WriteLine(s);
BlankFiles.Add(s);
}
}
AdminPrint("Delete the ones that did not contain useful data? 'yes' to confirm", ConsoleColor.Yellow);
string ip = Console.ReadLine();
if (ip == "yes")
{
foreach (string s in BlankFiles)
{
AdminPrint("Deleting " + s + "...", ConsoleColor.Red);
System.IO.File.Delete(s);
}
}
else
{
Console.WriteLine("Will not delete.");
}
}
//Step 1: Analyze stock performance
public static void PerformFullAnalysis()
{
Console.Write("Path of folder containing S&P500 equity transactions (or single file): ");
string path1 = Console.ReadLine();
Console.Write("Path of full analysis export: ");
string path2 = Console.ReadLine();
//Clean paths
path1 = path1.Replace("\"", "");
path2 = path2.Replace("\"", "");
//Get the files
string[] files = null;
if (System.IO.Directory.Exists(path1))
{
files = System.IO.Directory.GetFiles(path1);
}
else if (System.IO.File.Exists(path1))
{
files = new string[] { path1 };
}
//Process each
int FileCounter = 1;
foreach (string s in files)
{
string file_name = System.IO.Path.GetFileName(s);
AdminPrint("Checking #" + FileCounter.ToString() + "/" + files.Length.ToString() + ": " + file_name + "...");
if (System.IO.File.Exists(path2 + "\\" + file_name) == false)
{
AdminPrint("This has not been research yet. Going!");
//Reseaerch
bool ResearchFailed = false;
FullResearchSet frs = new FullResearchSet();
frs.StatusPrintingOn();
try
{
frs.GenerateFromTransactionsFileAsync(s).Wait();
}
catch (Exception ex)
{
AdminPrint("Generation for " + file_name + " failed. Msg: " + ex.Message, ConsoleColor.Red);
ResearchFailed = true;
}
//Write it (if it has analyses)
if (frs.PerformancesFollowingInsiderBuys != null)
{
if (frs.PerformancesFollowingInsiderBuys.Length > 0)
{
if (ResearchFailed == false)
{
AdminPrint("Writing to file...");
System.IO.File.WriteAllText(path2 + "\\" + file_name, JsonConvert.SerializeObject(frs));
AdminPrint("Successfully written!");
}
}
else
{
AdminPrint("Not going to write this one to file... It had no performance analyses following transctions!", ConsoleColor.Yellow);
}
}
}
else
{
AdminPrint("This has already been researched. skipping.");
}
FileCounter = FileCounter + 1;
}
}
//Step 3: Assemble results into a CSV file
public static void AssembleResultsCsv()
{
Console.Write("Folder with the full analyses >");
string analysis_folder = Console.ReadLine().Replace("\"", "");
Console.Write("Output CSV file to folder:");
string output_folder = Console.ReadLine().Replace("\"", "");
string[] files = System.IO.Directory.GetFiles(analysis_folder);
AdminPrint(files.Length.ToString() + " files found");
CsvFile csv = new CsvFile();
//Label the averages
DataRow drl = csv.AddNewRow();
drl.Values.Add("");
drl.Values.Add("");
drl.Values.Add("Averages");
drl.Values.Add("");
drl.Values.Add("");
drl.Values.Add("");
drl.Values.Add("");
drl.Values.Add("Following buys");
DataRow headerrow = csv.AddNewRow();
headerrow.Values.Add("Symbol");
headerrow.Values.Add("Insider Buys");
//Average
headerrow.Values.Add("14 Days");
headerrow.Values.Add("30 Days");
headerrow.Values.Add("90 Days");
headerrow.Values.Add("180 Days");
headerrow.Values.Add("360 Days");
//Following buys
headerrow.Values.Add("14 Days");
headerrow.Values.Add("30 Days");
headerrow.Values.Add("90 Days");
headerrow.Values.Add("180 Days");
headerrow.Values.Add("360 Days");
foreach (string s in files)
{
DataRow dr = csv.AddNewRow();
AdminPrint("Opening " + System.IO.Path.GetFileName(s) + "...");
FullResearchSet frs = JsonConvert.DeserializeObject <FullResearchSet>(System.IO.File.ReadAllText(s));
AdminPrint("Writing " + System.IO.Path.GetFileName(s) + "...");
dr.Values.Add(frs.Symbol.ToUpper().Trim());
dr.Values.Add(frs.PerformancesFollowingInsiderBuys.Length.ToString());
//Write the average over that period
string ar14 = frs.AveragePerformance.Return14.ToString();
string ar30 = frs.AveragePerformance.Return30.ToString();
string ar90 = frs.AveragePerformance.Return90.ToString();
string ar180 = frs.AveragePerformance.Return180.ToString();
string ar360 = frs.AveragePerformance.Return360.ToString();
dr.Values.Add(ar14);
dr.Values.Add(ar30);
dr.Values.Add(ar90);
dr.Values.Add(ar180);
dr.Values.Add(ar360);
//Get the averages
StockPerformanceSet avg = StockPerformanceSet.Average(frs.PerformancesFollowingInsiderBuys);
dr.Values.Add(avg.Return14.ToString());
dr.Values.Add(avg.Return30.ToString());
dr.Values.Add(avg.Return90.ToString());
dr.Values.Add(avg.Return180.ToString());
dr.Values.Add(avg.Return360.ToString());
}
//Write to the file
AdminPrint("Writing to file...");
string path = output_folder + "\\InsiderBuyPerformance.csv";
FileStream fs = System.IO.File.Create(path);
StreamWriter sw = new StreamWriter(fs);
sw.Write(csv.GenerateAsCsvFileContent());
sw.Close();
fs.Close();
AdminPrint("Successfully wrote to " + path, ConsoleColor.Green);
}
