public string ToCsv()
{
return($"F,{Symbol},{ExchangeId},{PE.ToInvariantString()},{AverageVolume.ToInvariantString()},{FiftyTwoWeekHigh.ToInvariantString()}," +
$"{FiftyTwoWeekLow.ToInvariantString()},{CalendarYearHigh.ToInvariantString()},{CalendarYearLow.ToInvariantString()},{DividendYield.ToInvariantString()}," +
$"{DividendAmount.ToInvariantString()},{DividendRate.ToInvariantString()},{PayDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{ExDividendDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{CurrentYearEarningsPerShare.ToInvariantString()},{NextYearEarningsPerShare.ToInvariantString()},{FiveYearGrowthPercentage.ToInvariantString()}," +
$"{FiscalYearEnd.ToInvariantString()},{CompanyName},{RootOptionSymbol},{PercentHeldByInstitutions.ToInvariantString()}," +
$"{Beta.ToInvariantString()},{Leaps},{CurrentAssets.ToInvariantString()},{CurrentLiabilities.ToInvariantString()}," +
$"{BalanceSheetDate.ToInvariantString(FundamentalDateTimeFormat)},{LongTermDebt.ToInvariantString()},{CommonSharesOutstanding.ToInvariantString()}," +
$"{SplitFactor1},{SplitFactor2},{FormatCode},{Precision.ToInvariantString()},{SIC.ToInvariantString()}," +
$"{HistoricalVolatility.ToInvariantString()},{SecurityType},{ListedMarket},{FiftyTwoWeekHighDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{FiftyTwoWeekLowDate.ToInvariantString(FundamentalDateTimeFormat)},{CalendarYearHighDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{CalendarYearLowDate.ToInvariantString(FundamentalDateTimeFormat)},{YearEndClose.ToInvariantString()},{MaturityDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{CouponRate.ToInvariantString()},{ExpirationDate.ToInvariantString(FundamentalDateTimeFormat)},{StrikePrice.ToInvariantString()}," +
$"{NAICS.ToInvariantString()},{ExchangeRoot},{OptionsPremiumMultiplier.ToInvariantString()},{OptionsMultipleDeliverables.ToInvariantString()}," +
$"{SessionOpenTime.ToInvariantString(FundamentalTimeSpanFormat)},{SessionCloseTime.ToInvariantString(FundamentalTimeSpanFormat)}," +
$"{BaseCurrency},{ContractSize},{ContractMonths},{MinimumTickSize.ToInvariantString()},{FirstDeliveryDate.ToInvariantString(FundamentalDateTimeFormat)}," +
$"{FIGI},{SecuritySubType.ToInvariantString()}");
}
public LiabilitiesAndEquity()
{
CurrentLiabilities = new CurrentLiabilities();
}
public LiabilitiesAndEquity(CurrentLiabilities currentLiabilities)
{
CurrentLiabilities = currentLiabilities;
}
private ConsolidatedBalanceSheet GetBalanceSheet(IWebElement table)
{
var currentAssets = new CurrentAssets();
var assets = new Assets();
var liabilities = new LiabilitiesAndEquity();
var currentLiabilities = new CurrentLiabilities();
var stockholdersEquity = new StockholdersEquity();
var tableRows = table.FindElements(By.TagName("tr"));
foreach (var tr in tableRows)
{
var tableCellCount = tr.FindElements(By.TagName("td")).Count();
var tcs = tr.FindElements(By.TagName("td"));
if (tr.Text.Contains("Cash and cash equivalents"))
{
currentAssets.CashAndEquivalents = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Marketable securities"))
{
currentAssets.MarketableSecurities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accounts receivable"))
{
currentAssets.AccountsReceivable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Receivable under reverse repurchase agreements"))
{
currentAssets.ReceivableUnderReversePurchase = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred income taxes, net"))
{
assets.DeferredIncomeTaxes = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Income taxes receivable, net"))
{
currentAssets.IncomeTaxesReceivable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Prepaid revenue share, expenses and other assets") || tr.Text.Contains("Other current assets"))
{
currentAssets.OtherCurrentAssets = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Prepaid revenue share, expenses and other assets, non-current") || tr.Text.Contains("Other non-current assets"))
{
assets.OtherNoncurrentAssets = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Non-marketable investments"))
{
assets.NonmarketableInvestments = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Property and equipment, net"))
{
assets.NetProperty = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Intangible assets, net"))
{
assets.NetIntangibleAssets = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Goodwill"))
{
assets.Goodwill = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accounts payable"))
{
currentLiabilities.AccountsPayable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Short-term debt"))
{
currentLiabilities.ShortTermDebt = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accrued compensation and benefits"))
{
currentLiabilities.AccruedCompensationAndBenefits = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accrued expenses and other current liabilities"))
{
currentLiabilities.AccruedExpensesAndOtherCurrentLiabilities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accrued revenue share"))
{
currentLiabilities.AccruedRevenueShare = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Securities lending payable"))
{
currentLiabilities.SecuritiesLendingPayable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred revenue"))
{
currentLiabilities.DeferredRevenue = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Income taxes payable, net"))
{
currentLiabilities.NetIncomeTaxesPayable = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Long-term debt"))
{
liabilities.LongTermDebt = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred revenue, non-current"))
{
liabilities.DeferredRevenueNonCurrent = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Income taxes payable, non-current"))
{
liabilities.IncomeTaxesPayableNonCurrent = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Deferred income taxes, net, non-current"))
{
liabilities.DeferredIncomeTaxes = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Other long-term liabilities"))
{
liabilities.OtherLongTermLiabilities = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Convertible preferred stock"))
{
stockholdersEquity.ConvertiblePreferredStock = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Class A and Class B common stock, and Class C capital stock and additional paid-in capital"))
{
stockholdersEquity.CommonStockClassAandB = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Accumulated other comprehensive income"))
{
stockholdersEquity.AccumulatedOtherCompehensiveLoss = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
else if (tr.Text.Contains("Retained earnings"))
{
stockholdersEquity.RetainedEarnings = GetDoubleFromString(tcs[tableCellCount - 2].Text);
}
}
assets.CurrentAssets = currentAssets;
liabilities.CurrentLiabilities = currentLiabilities;
return(new ConsolidatedBalanceSheet(assets, liabilities, stockholdersEquity));
}
