private void EnterIntoCompanyTableFromYahooApi(string symbol)
{
YahooApiGateway api = new YahooApiGateway();
Dictionary <string, Object> stats = new Dictionary <string, object>();
api.RetrieveYahooCompanyInfo(symbol, ref stats);
Company comp = new Company(symbol, Convert.ToString(stats["Name"]), Convert.ToString(stats["Industry"]), Convert.ToString(stats["Sector"]));
CompanyBL.Instance.UpdateCompany(comp);
}
private void CreateExcelDocument(List <string> comps)
{
string filename = @"C:\Users\Daniel\Documents\Visual Studio 2012\ExcelFiles\yahooStatsTest_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" + DateTime.Now.Hour + DateTime.Now.Minute + ".xlsx";
FileInfo newFile = new FileInfo(filename);
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
string[] financialColumns = FinancialStatisticsColumns();
ExcelWorksheet finStatsWS = xlPackage.Workbook.Worksheets.Add("FinancialStatistics");
int i = 1;
finStatsWS.Row(1).Style.Font.Bold = true;
foreach (string col in financialColumns)
{
finStatsWS.Cells[1, i].Value = col;
i++;
}
YahooApiGateway yahooAPI = new YahooApiGateway();
int count = 2;
foreach (string company in comps)
{
if (!company.Contains("."))
{
Dictionary <string, Object> compStats = yahooAPI.GetAllCompanyStatsFromYahoo(company);
finStatsWS.Cells[count, 1].Value = company;
finStatsWS.Cells[count, 2].Value = compStats["Name"];
//finStatsWS.Cells[count, 3].Value = compStats["Sector"];
//finStatsWS.Cells[count, 4].Value = compStats["Industry"];
finStatsWS.Cells[count, 5].Value = compStats["BusinessSummary"];
finStatsWS.Cells[count, 6].Value = compStats["LastTradePriceOnly"];
finStatsWS.Cells[count, 7].Value = compStats["BookValuePerShare"];
finStatsWS.Cells[count, 8].Value = compStats["ReturnOnEquityPercent"];
finStatsWS.Cells[count, 9].Value = compStats["ReturnOnAssetsPercent"];
finStatsWS.Cells[count, 10].Value = compStats["TotalDeptPerEquity"];
finStatsWS.Cells[count, 11].Value = compStats["YearHigh"];
finStatsWS.Cells[count, 12].Value = compStats["YearLow"];
finStatsWS.Cells[count, 13].Value = compStats["OneyrTargetPrice"];
finStatsWS.Cells[count, 14].Value = compStats["DilutedEPS"];
finStatsWS.Cells[count, 15].Value = compStats["RevenuePerShare"];
finStatsWS.Cells[count, 16].Value = compStats["AverageDailyVolume"];
finStatsWS.Cells[count, 17].Value = compStats["MarketCapitalization"];
finStatsWS.Cells[count, 18].Value = compStats["TotalDeptInMillion"];
finStatsWS.Cells[count, 19].Value = compStats["ShortRatio"];
finStatsWS.Cells[count, 20].Value = compStats["FiftydayMovingAverage"];
finStatsWS.Cells[count, 21].Value = compStats["TwoHundreddayMovingAverage"];
finStatsWS.Cells[count, 22].Value = compStats["TrailingAnnualDividendYieldInPercent"];
finStatsWS.Cells[count, 23].Value = compStats["OperatingMarginPercent"];
finStatsWS.Cells[count, 24].Value = compStats["ProfitMarginPercent"];
finStatsWS.Cells[count, 25].Value = compStats["PERatio"];
finStatsWS.Cells[count, 26].Value = compStats["PEGRatio"];
finStatsWS.Cells[count, 27].Value = compStats["EBITDA"];
finStatsWS.Cells[count, 28].Value = compStats["Revenue"];
//finStatsWS.Cells[count, 29].Value = compStats["SharesOutstanding"];
finStatsWS.Cells[count, 30].Value = compStats["EBITDAInMillion"];
finStatsWS.Cells[count, 31].Value = compStats["CurrentRatio"];
finStatsWS.Cells[count, 32].Value = compStats["GrossProfitInMillion"];
finStatsWS.Cells[count, 33].Value = compStats["LeveredFreeCashFlowInMillion"];
finStatsWS.Cells[count, 34].Value = compStats["OperatingCashFlowInMillion"];
finStatsWS.Cells[count, 35].Value = compStats["QuarterlyRevenueGrowthPercent"];
finStatsWS.Cells[count, 36].Value = compStats["QuarterlyEarningsGrowthPercent"];
finStatsWS.Cells[count, 37].Value = compStats["RevenuePerShare"];
finStatsWS.Cells[count, 38].Value = compStats["TotalCashInMillion"];
finStatsWS.Cells[count, 39].Value = compStats["TotalCashPerShare"];
count++;
}
}
xlPackage.Save();
}
}
private Dictionary<string, Object> GetYahooStatistics(string symbol)
{
YahooApiGateway yahoo = new YahooApiGateway();
return yahoo.GetCompanyAnnualStats(symbol);
}
private Dictionary <string, Object> GetYahooStatistics(string symbol)
{
YahooApiGateway yahoo = new YahooApiGateway();
return(yahoo.GetCompanyAnnualStats(symbol));
}
private void CreateExcelDocument(List<string> comps)
{
string filename = @"C:\Users\Daniel\Documents\Visual Studio 2012\ExcelFiles\yahooStatsTest_" + DateTime.Now.Year + "_" + DateTime.Now.Month + "_" + DateTime.Now.Day + "_" + DateTime.Now.Hour + DateTime.Now.Minute + ".xlsx";
FileInfo newFile = new FileInfo(filename);
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
string[] financialColumns = FinancialStatisticsColumns();
ExcelWorksheet finStatsWS = xlPackage.Workbook.Worksheets.Add("FinancialStatistics");
int i = 1;
finStatsWS.Row(1).Style.Font.Bold = true;
foreach (string col in financialColumns)
{
finStatsWS.Cells[1, i].Value = col;
i++;
}
YahooApiGateway yahooAPI = new YahooApiGateway();
int count = 2;
foreach (string company in comps)
{
if (!company.Contains("."))
{
Dictionary<string, Object> compStats = yahooAPI.GetAllCompanyStatsFromYahoo(company);
finStatsWS.Cells[count, 1].Value = company;
finStatsWS.Cells[count, 2].Value = compStats["Name"];
//finStatsWS.Cells[count, 3].Value = compStats["Sector"];
//finStatsWS.Cells[count, 4].Value = compStats["Industry"];
finStatsWS.Cells[count, 5].Value = compStats["BusinessSummary"];
finStatsWS.Cells[count, 6].Value = compStats["LastTradePriceOnly"];
finStatsWS.Cells[count, 7].Value = compStats["BookValuePerShare"];
finStatsWS.Cells[count, 8].Value = compStats["ReturnOnEquityPercent"];
finStatsWS.Cells[count, 9].Value = compStats["ReturnOnAssetsPercent"];
finStatsWS.Cells[count, 10].Value = compStats["TotalDeptPerEquity"];
finStatsWS.Cells[count, 11].Value = compStats["YearHigh"];
finStatsWS.Cells[count, 12].Value = compStats["YearLow"];
finStatsWS.Cells[count, 13].Value = compStats["OneyrTargetPrice"];
finStatsWS.Cells[count, 14].Value = compStats["DilutedEPS"];
finStatsWS.Cells[count, 15].Value = compStats["RevenuePerShare"];
finStatsWS.Cells[count, 16].Value = compStats["AverageDailyVolume"];
finStatsWS.Cells[count, 17].Value = compStats["MarketCapitalization"];
finStatsWS.Cells[count, 18].Value = compStats["TotalDeptInMillion"];
finStatsWS.Cells[count, 19].Value = compStats["ShortRatio"];
finStatsWS.Cells[count, 20].Value = compStats["FiftydayMovingAverage"];
finStatsWS.Cells[count, 21].Value = compStats["TwoHundreddayMovingAverage"];
finStatsWS.Cells[count, 22].Value = compStats["TrailingAnnualDividendYieldInPercent"];
finStatsWS.Cells[count, 23].Value = compStats["OperatingMarginPercent"];
finStatsWS.Cells[count, 24].Value = compStats["ProfitMarginPercent"];
finStatsWS.Cells[count, 25].Value = compStats["PERatio"];
finStatsWS.Cells[count, 26].Value = compStats["PEGRatio"];
finStatsWS.Cells[count, 27].Value = compStats["EBITDA"];
finStatsWS.Cells[count, 28].Value = compStats["Revenue"];
//finStatsWS.Cells[count, 29].Value = compStats["SharesOutstanding"];
finStatsWS.Cells[count, 30].Value = compStats["EBITDAInMillion"];
finStatsWS.Cells[count, 31].Value = compStats["CurrentRatio"];
finStatsWS.Cells[count, 32].Value = compStats["GrossProfitInMillion"];
finStatsWS.Cells[count, 33].Value = compStats["LeveredFreeCashFlowInMillion"];
finStatsWS.Cells[count, 34].Value = compStats["OperatingCashFlowInMillion"];
finStatsWS.Cells[count, 35].Value = compStats["QuarterlyRevenueGrowthPercent"];
finStatsWS.Cells[count, 36].Value = compStats["QuarterlyEarningsGrowthPercent"];
finStatsWS.Cells[count, 37].Value = compStats["RevenuePerShare"];
finStatsWS.Cells[count, 38].Value = compStats["TotalCashInMillion"];
finStatsWS.Cells[count, 39].Value = compStats["TotalCashPerShare"];
count++;
}
}
xlPackage.Save();
}
}
private void EnterIntoCompanyTableFromYahooApi(string symbol)
{
YahooApiGateway api = new YahooApiGateway();
Dictionary<string, Object> stats = new Dictionary<string, object>();
api.RetrieveYahooCompanyInfo(symbol, ref stats);
Company comp = new Company(symbol, Convert.ToString(stats["Name"]), Convert.ToString(stats["Industry"]), Convert.ToString(stats["Sector"]));
CompanyBL.Instance.UpdateCompany(comp);
}