public static StockPortfolio ParseAvanzaOldListHistory(string website, StockPortfolio stockPortfolio)
{
HtmlDocument html = new HtmlDocument();
html.LoadHtml(new WebClient().DownloadString(website));
HtmlNode root = html.DocumentNode;
var contentTable = root.Descendants().Where(n => n.GetAttributeValue("id", "").Equals("contentTable"));
var contentTableData = contentTable.First();
var tbody = contentTableData.Descendants("tbody").First();
var trs = tbody.Descendants("tr");
for (int i = 0; i < trs.Count(); i++)
{
double today;
double.TryParse(trs.ElementAt(i).Descendants("td").ElementAt(2).InnerText, out today);
stockPortfolio.Stocks[i].Today = today;
double oneMonth;
double.TryParse(trs.ElementAt(i).Descendants("td").ElementAt(3).InnerText, out oneMonth);
stockPortfolio.Stocks[i].OneMonth = oneMonth;
double threeMonths;
double.TryParse(trs.ElementAt(i).Descendants("td").ElementAt(4).InnerText, out threeMonths);
stockPortfolio.Stocks[i].ThreeMonths = threeMonths;
double oneYear;
double.TryParse(trs.ElementAt(i).Descendants("td").ElementAt(5).InnerText, out oneYear);
stockPortfolio.Stocks[i].OneYear = oneYear;
double threeYears;
double.TryParse(trs.ElementAt(i).Descendants("td").ElementAt(6).InnerText, out threeYears);
stockPortfolio.Stocks[i].ThreeYears = threeYears;
}
return(stockPortfolio);
}
public static StockPortfolio ParseAvanzaOldList(string website, StockPortfolio stockPortfolio)
{
HtmlDocument html = new HtmlDocument();
html.LoadHtml(new WebClient().DownloadString(website));
HtmlNode root = html.DocumentNode;
var contentTable = root.Descendants().Where(n => n.GetAttributeValue("id", "").Equals("contentTable"));
var contentTableData = contentTable.First();
var tbody = contentTableData.Descendants("tbody").First();
var trs = tbody.Descendants("tr");
stockPortfolio.Stocks = new List <Stock>();
for (int i = 0; i < trs.Count(); i++)
{
string value = trs.ElementAt(i).Descendants("td").ElementAt(6).InnerText;
if (value.Length > 6)
{
value = value.Remove(value.Length - 8, 2);
}
value = value.Replace(",", ".");
string stringValue = string.Format("{0:0,##}", value);
double doubleValue = 0;
bool doubleParseResult = double.TryParse(stringValue, NumberStyles.Number, CultureInfo.InvariantCulture, out doubleValue);
string name = trs.ElementAt(i).Descendants("td").ElementAt(1).Descendants("a").First().InnerText.Trim();
string outerHTML = trs.ElementAt(i).Descendants("td").ElementAt(1).Descendants("a").First().OuterHtml.ToString();
string href = outerHTML.Substring(10, outerHTML.Length - (37 + 19 + name.Length * 2));
stockPortfolio.Stocks.Add(new Stock
{
StockCatalogueName = stockPortfolio.StockCatalogueName,
Name = name,
Href = href,
Industry = doubleValue < 100 ? "Energi" : "Material och råvaror",
Currency = doubleValue > 50 && doubleValue < 250 ? "SEK" : "USD",
ValueDouble = doubleValue,
ValueString = stringValue
});
}
;
return(stockPortfolio);
}
public static StockPortfolio ParseAvanzaOldListOverview(string website, StockPortfolio stockPortfolio)
{
HtmlDocument html = new HtmlDocument();
html.LoadHtml(new WebClient().DownloadString(website));
HtmlNode root = html.DocumentNode;
var contentTable = root.Descendants().Where(n => n.GetAttributeValue("id", "").Equals("contentTable"));
var contentTableData = contentTable.First();
var tbody = contentTableData.Descendants("tbody").First();
var trs = tbody.Descendants("tr");
for (int i = 0; i < trs.Count(); i++)
{
string marketCap = CharHandling.RemoveSpecialCharacters(trs.ElementAt(i).Descendants("td").ElementAt(2).InnerText);
string marketCapCleansed = "N/A";
if (marketCap.Length - 4 > 3)
{
marketCapCleansed = marketCap.Remove(marketCap.Length - 4, 4);
}
int marketCapInt = 0;
if (int.TryParse(marketCapCleansed, out marketCapInt))
{
marketCapCleansed = marketCapInt.ToString("# ##0");
}
stockPortfolio.Stocks[i].MarketCap = marketCapCleansed;
stockPortfolio.Stocks[i].MarketCapInt = marketCapInt;
string dividend = trs.ElementAt(i).Descendants("td").ElementAt(3).InnerText;
stockPortfolio.Stocks[i].Dividend = dividend.Replace(",", ".");
double dividendDouble = 0;
bool doubleParseDividendResult = double.TryParse(dividend, out dividendDouble);
stockPortfolio.Stocks[i].DividendDouble = dividendDouble;
string volatility = trs.ElementAt(i).Descendants("td").ElementAt(4).InnerText;
volatility = volatility.Replace(",", ".");
double volatilityDouble = 0;
bool doubleParseVolatilityResult = double.TryParse(volatility, NumberStyles.Number, CultureInfo.InvariantCulture, out volatilityDouble);
stockPortfolio.Stocks[i].Volatility = volatilityDouble;
stockPortfolio.Stocks[i].PortfolioVolatility = volatilityDouble * stockPortfolio.Stocks[i].Weight / 100;
string beta = trs.ElementAt(i).Descendants("td").ElementAt(5).InnerText;
stockPortfolio.Stocks[i].Beta = beta.Replace(",", ".");
double betaDouble = 0;
bool doubleParseBetaResult = double.TryParse(beta, out betaDouble);
stockPortfolio.Stocks[i].BetaDouble = betaDouble;
string priceEarnings = trs.ElementAt(i).Descendants("td").ElementAt(6).InnerText;
stockPortfolio.Stocks[i].PriceEarnings = priceEarnings.Replace(",", ".");
double priceEarningsDouble = 0;
bool doubleParsePriceEarningsResult = double.TryParse(priceEarnings, out priceEarningsDouble);
stockPortfolio.Stocks[i].PriceEarningsDouble = priceEarningsDouble;
string priceSales = trs.ElementAt(i).Descendants("td").ElementAt(7).InnerText;
stockPortfolio.Stocks[i].PriceSales = priceSales.Replace(",", ".");
double priceSalesDouble = 0;
bool doubleParsePriceSalesResult = double.TryParse(priceSales, out priceSalesDouble);
stockPortfolio.Stocks[i].PriceSalesDouble = priceSalesDouble;
string consensus = trs.ElementAt(i).Descendants("td").ElementAt(8).InnerText;
stockPortfolio.Stocks[i].Consensus = consensus;
double consensusDouble = 0;
bool doubleParseConsensusResult = double.TryParse(consensus.Substring(0, consensus.Length - 1), out consensusDouble);
stockPortfolio.Stocks[i].ConsensusDouble = consensusDouble;
}
;
return(stockPortfolio);
}