public void DownloadQuotes(Security security, DateTime purchaseDate, bool full) { //var prices = Yahoo.GetHistoricalAsync(security.YahooCode, purchaseDate, period: Period.Daily, ascending: true).Result; var prices = avClient.GetHistoricalPrices(security.YahooCode, purchaseDate, full).Result; foreach (DataPoint price in prices) { SecurityPrice savedPrice = context.SecurityPrices .Where(s => s.Date.Date == price.Date) .Where(s => s.Security == security).SingleOrDefault(); if (savedPrice == null) { SecurityPrice newPrice = new SecurityPrice() { SecurityId = security.Id, Date = price.Date, ClosingPrice = price.Close }; context.Add <SecurityPrice>(newPrice); } } context.SaveChanges(); }