public List <CompanyStatsYF> GetCachedCompaniesYF()
{
List <CompanyStatsYF> cachedCompanies = new List <CompanyStatsYF>();
HashSet <string> cachedSymbols = _cache.GetCachedSymbols("yf-companies");
foreach (string cacheKey in cachedSymbols)
{
CompanyStatsYF company = (CompanyStatsYF)_cache.Get(cacheKey);
if (company != null)
{
cachedCompanies.Add(company);
}
}
return(cachedCompanies);
}
public static async Task <CompaniesListYF> GetScreenedCompaniesAsync(CompaniesListYF allCompanies, string screenId)
{
CompaniesListYF screened = new CompaniesListYF
{
SymbolsToCompanies = new Dictionary <string, CompanyYF>()
};
foreach (var company in allCompanies.SymbolsToCompanies)
{
string symbol = company.Key;
CompanyYF companyObject = company.Value;
CompanyStatsYF stats = companyObject.Stats;
if (stats.Price < 20 && stats.Price > .01M && stats.VolumeAverage10dUSD > 1000000
/*&& !String.IsNullOrEmpty(stats.Earnings.EPSReportDate)*/)
{
screened.SymbolsToCompanies.Add(symbol, companyObject);
}
}
return(await Task.FromResult(screened));
}
//Yahoo Finance Company Cache Entry Update Routine
public void UpdateYFCompanyCacheEntry(object key, object value, EvictionReason reason, object state = null)
{
try
{
Stopwatch sw = new Stopwatch(); sw.Start();
string cacheKey = (string)key;
string channel = cacheKey.Split('-')[0];
string symbol = cacheKey.Split('-')[2];
//Remove before updating and re-adding
RemoveCachedSymbol(cacheKey);
CompanyStatsYF companyStats = YahooFinance.GetCompanyStatsAsync(symbol).Result;
//Save YF Company to cache
this.Add(companyStats, cacheKey);
string perf = sw.ElapsedMilliseconds.ToString();
}
catch (Exception e)
{
Debug.WriteLine("ERROR UpdateYFCompanyCacheEntry: " + e.Message);
}
}
public static async Task <CompaniesListYF> GetAllCompaniesAsync()
{
CompaniesListYF companies = new CompaniesListYF()
{
SymbolsToCompanies = new Dictionary <string, CompanyYF>()
};
string nasdaqData = Companies.GetFromFtpUri(Companies.NasdaqSymbolsUri);
string[] nasdaqDataLines = nasdaqData.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
for (int i = 1; i < nasdaqDataLines.Length - 1; i++) //trim first and last row
{
string line = nasdaqDataLines[i];
string[] data = line.Split('|');
if (data.Count() > 3)
{
string symbol = data[1];
if (!companies.SymbolsToCompanies.ContainsKey(symbol) && !String.IsNullOrEmpty(symbol))
{
bool isNasdaq = data[0] == "Y";
if (isNasdaq)
{
CompanyStatsYF stats = YahooFinance.GetCompanyStatsAsync(symbol).Result;
CompanyYF company = new CompanyYF
{
Symbol = symbol,
Exchange = "NASDAQ",
Stats = stats
};
companies.SymbolsToCompanies.Add(symbol, company);
}
}
}
}
string otcData = Companies.GetFromFtpUri(Companies.OtcSymbolsUri);
string[] otcDataLines = otcData.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
for (int j = 1; j < otcDataLines.Length - 1; j++) //trim first and last row
{
string line = otcDataLines[j];
string[] data = line.Split('|');
if (data.Count() > 3)
{
string symbol = data[0];
if (!companies.SymbolsToCompanies.ContainsKey(symbol) && !String.IsNullOrEmpty(symbol))
{
CompanyStatsYF stats = YahooFinance.GetCompanyStatsAsync(symbol).Result;
CompanyYF company = new CompanyYF
{
Symbol = symbol,
Exchange = "OTC",
Stats = stats
};
companies.SymbolsToCompanies.Add(symbol, company);
}
}
}
string otcMarketsData = Companies.GetFromUri(Companies.OtcMarketsUri);
string[] otcMarketsDataLines = otcMarketsData.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
for (int k = 1; k < otcMarketsDataLines.Length; k++) //trim first row
{
string line = otcMarketsDataLines[k];
string[] data = line.Split(',');
if (data.Count() > 3)
{
string symbol = data[0];
if (!companies.SymbolsToCompanies.ContainsKey(symbol) && !String.IsNullOrEmpty(symbol))
{
CompanyStatsYF stats = YahooFinance.GetCompanyStatsAsync(symbol).Result;
CompanyYF company = new CompanyYF
{
Symbol = symbol,
Exchange = data[2],
Stats = stats
};
companies.SymbolsToCompanies.Add(symbol, company);
}
}
}
return(await Task.FromResult(companies));
}
public static async Task <CompanyStatsYF> GetCompanyStatsAsync(string symbol)
{
CompanyStatsYF companyStat = new CompanyStatsYF();
try
{
//Yahoo Quote
Security quote = GetQuoteAsync(symbol).Result;
if (quote != null)
{
//parse quote data into company stat
companyStat.Symbol = symbol;
companyStat.Exchange = quote.FullExchangeName;
companyStat.CompanyName = quote.LongName;
companyStat.CompanyTrading = quote.Tradeable;
//companyStat.CompanyQuoteType = quote.QuoteType;
//companyStat.CompanyMarket = quote.Market;
//companyStat.MarketCap = quote.MarketCap;
//companyStat.SharesOutstanding = quote.SharesOutstanding;
decimal peTrailing = 0.0M;
try { peTrailing = decimal.Parse(quote.TrailingPE.ToString()); }
catch (Exception e) { /*do nothing*/ }
decimal peForward = 0.0M;
try { peForward = decimal.Parse(quote.ForwardPE.ToString()); }
catch (Exception e) { /*set to trailing*/ peForward = peTrailing; }
decimal epsTrailing = 0.0M;
try { epsTrailing = decimal.Parse(quote.EpsTrailingTwelveMonths.ToString()); }
catch (Exception e) { /*do nothing*/ }
decimal epsForward = 0.0M;
try { epsForward = decimal.Parse(quote.EpsForward.ToString()); }
catch (Exception e) { /*set to trailing*/ epsForward = epsTrailing; }
//companyStat.BookValue = decimal.Parse(quote.BookValue.ToString());
companyStat.Price = decimal.Parse(quote.RegularMarketPrice.ToString());
companyStat.PriceAverage50DayUSD = decimal.Parse(quote.FiftyDayAverage.ToString());
companyStat.PriceAverage200DayUSD = decimal.Parse(quote.TwoHundredDayAverage.ToString());
companyStat.PriceHigh52w = decimal.Parse(quote.FiftyTwoWeekHigh.ToString());
companyStat.PriceLow52w = decimal.Parse(quote.FiftyTwoWeekLow.ToString());
companyStat.PriceAverageEstimate52w = (companyStat.PriceHigh52w + companyStat.PriceLow52w) / 2;
//companyStat.PriceToBook = decimal.Parse(quote.PriceToBook.ToString());
companyStat.VolumeToday = decimal.Parse(quote.RegularMarketVolume.ToString());
companyStat.VolumeTodayUSD = (companyStat.VolumeToday * companyStat.Price);
companyStat.VolumeAverage10d = decimal.Parse(quote.AverageDailyVolume10Day.ToString());
companyStat.VolumeAverage10dUSD = (companyStat.VolumeAverage10d * companyStat.Price);
companyStat.VolumeAverage3m = decimal.Parse(quote.AverageDailyVolume3Month.ToString());
companyStat.VolumeAverage3mUSD = (companyStat.VolumeAverage3m * companyStat.Price);
/*Could get more trade data from IEX possibly
* companyStat.TradeData = new TradeDataYF
* {
* BidPrice = decimal.Parse(quote.Bid.ToString()),
* BidSize = decimal.Parse(quote.BidSize.ToString()),
* AskPrice = decimal.Parse(quote.Ask.ToString()),
* AskSize = decimal.Parse(quote.AskSize.ToString())
* };*/
}
//Yahoo Dividends for the last year
//You should be able to query data from various markets including US, HK, TW
var dividends = await Yahoo.GetDividendsAsync(symbol, DateTime.Now.AddYears(-1), DateTime.Now);
foreach (DividendTick div in dividends)
{
companyStat.Dividends.Add(div);
}
//Yahoo historical trade data and splits data
var splits = await Yahoo.GetSplitsAsync(symbol, DateTime.Now.AddYears(-1), DateTime.Now);
foreach (var split in splits)
{
companyStat.Splits.Add(split);
}
//Composite Score, this gets the YF quote twice right now
//TODO: Update this method to not get YF quote twice during cache loading
var score = Controllers.SearchController.GetCompositeScoreInternal(symbol, quote);
if (score.CompositeScoreValue > 0)
{
companyStat.CompositeScoreResult = score;
}
}
catch (Exception e)
{
Debug.WriteLine("EXCEPTION CAUGHT: YF.cs YF.GetComanyStatsAsync for symbol " + symbol + ", message: " + e.Message + ", StackTrace: " + e.StackTrace);
}
return(await Task.FromResult(companyStat));
}
