public void Should_Format_CryptoQuotes() { IEXFormatter formatter = new IEXFormatter(); using (StreamReader reader = new StreamReader(Path.Combine("IexSseResponseText", "cryptoquotes.json"))) { string cryptoQuoteJson = reader.ReadLine(); List <IexCryptoQuote> cryptoQuotes = formatter.FormatCryptoQuoteLine(cryptoQuoteJson); cryptoQuotes[0].Symbol.Should().Be("BTCUSDT"); cryptoQuotes[0].AskPrice.Should().Be(6970.25); cryptoQuotes[0].AskSize.Should().Be(0.075793); cryptoQuotes[0].BidPrice.Should().Be(7145); cryptoQuotes[0].BidSize.Should().Be(1.718794); cryptoQuotes[0].CalculationPrice.Should().Be("realtime"); cryptoQuotes[0].High.Should().BeNull(); cryptoQuotes[0].LatestPrice.Should().Be(6874.43); cryptoQuotes[0].LatestSource.Should().Be("Real time price"); cryptoQuotes[0].LatestUpdate.Should().Be(1618359674388); cryptoQuotes[0].LatestVolume.Should().BeNull(); cryptoQuotes[0].Low.Should().BeNull(); cryptoQuotes[0].PreviousClose.Should().BeNull(); cryptoQuotes[0].PrimaryExchange.Should().Be("0"); cryptoQuotes[0].Sector.Should().Be("otcureryncyrcp"); cryptoQuotes[0].Symbol.Should().Be("BTCUSDT"); cryptoQuoteJson = reader.ReadLine(); cryptoQuotes = formatter.FormatCryptoQuoteLine(cryptoQuoteJson); cryptoQuoteJson = reader.ReadLine(); cryptoQuotes = formatter.FormatCryptoQuoteLine(cryptoQuoteJson); } }
public void Should_Format_DataPoints_WithNullDateTimes() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "DataPointsWithNullDateTimes.json"))) { string dataPointsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexDataPoint> iexDataPoints = formatter.FormatDataPoints(dataPointsJson); } }
public void Should_Format_TimeSeries() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "TimeSeries.json"))) { string timeSeriesJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexTimeSeries> iexTimeSeries = formatter.FormatTimeSeries(timeSeriesJson); } }
public void Should_Format_SingleDataPoint() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "SingleDataPoint.json"))) { string dataPointJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); DateTime lastUpdated = formatter.FormatDataPoint(dataPointJson); lastUpdated.Should().Be(new DateTime(2020, 6, 30)); } }
public void Should_Format_AccountUsage() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "AccountUsage.json"))) { string accountUsageJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IEXAccountUsage accountUsage = formatter.FormatAccountUsage(accountUsageJson); accountUsage.Messages.MonthlyUsage.Should().Be(128054); } }
public void Should_Format_UpcomingEarnings() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "UpcomingEarnings.json"))) { string upcomingEarningsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexUpcomingEarnings> iexUpcomingEarnings = formatter.FormatUpcomingEarnings(upcomingEarningsJson); iexUpcomingEarnings.Count.Should().Be(1); iexUpcomingEarnings[0].Symbol.Should().Be("AAPL"); iexUpcomingEarnings[0].ReportDate.Should().Be(new DateTime(2019, 11, 09)); } }
public void Should_Format_HistoricalPrices() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "HistoricalPrices.txt"))) { string historicalPricesJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IEXHistoricalPrice> historicalPrices = formatter.FormatHistoricalPrices(historicalPricesJson); historicalPrices.Count.Should().Be(64); historicalPrices[0].open.Should().Be(133.7m); } }
public void Should_Format_Company2() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "Company2.json"))) { string companyJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexCompany company = formatter.FormatCompany(companyJson); company.Symbol.Should().Be("AAAU"); company.Employees.Should().BeNull(); } }
public void Should_Format_GetPeers() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "PeersResponse.txt"))) { string peersJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <string> peers = formatter.FormatPeers(peersJson); peers.Count.Should().Be(7); peers[0].Should().Be("MSFT"); peers[6].Should().Be("XLK"); } }
public void Should_Format_KeyStats() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "KeyStats.json"))) { string keyStatsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexKeyStats keyStats = formatter.FormatKeyStats(keyStatsJson); keyStats.CompanyName.Should().Be("Apple Inc."); keyStats.SharesOutstanding.Should().Be(5213840000); keyStats.Float.Should().Be(5203997571); } }
public void Should_Format_KeyStats3() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "KeyStats3.json"))) { string keyStatsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexKeyStats keyStats = formatter.FormatKeyStats(keyStatsJson); keyStats.CompanyName.Should().Be("Ormat Technologies Inc"); keyStats.Avg10Volume.Should().Be(491633); keyStats.ExDividendDate.Should().Be(DateTime.MinValue); } }
public async Task GetUpcomingEarnings_Should_FetchResults() { var config = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .Build(); string token = config["TOKEN"]; IEXClient client = new IEXClient(IEXBaseUrl.SandboxUrl, token); string result = await client.GetUpcomingEarnings("market"); IEXFormatter formatter = new IEXFormatter(); List <IexUpcomingEarnings> iexUpcomingEarnings = formatter.FormatUpcomingEarnings(result); var a = iexUpcomingEarnings.Max(w => w.ReportDate); result.Should().NotBeNullOrEmpty(); }
public void Should_Format_IEXSymbols() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "AllIEXSymbols.txt"))) { string symbols = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IEXSymbol> symbolsList = formatter.FormatIEXSymbols(symbols); symbolsList[0].Symbol.Should().Be("A"); symbolsList[0].Date.Should().Be(new DateTime(2019, 4, 5)); symbolsList[0].IsEnabled.Should().Be(true); symbolsList.Count.Should().Be(8737); } }
public void Should_Format_TopsLast1() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "TopsLast1.json"))) { string topsLastJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexTopsLast topsLast = formatter.FormatTopsLast(topsLastJson).First(); topsLast.Symbol.Should().Be("MSFT"); topsLast.Price.Should().Be(171.21); topsLast.Size.Should().Be(101); topsLast.Time.Should().Be(1662031674818); } }
public void Should_Format_CashFlowStatement() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText/CashFlowStatement.txt"))) { string cashFlowStatementJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IEXCashFlowStatementList incomeStatementList = formatter.FormatCashFlowStatement(cashFlowStatementJson); incomeStatementList.Symbol.Should().Be("AAPL"); incomeStatementList.CashFlow.Count.Should().Be(4); incomeStatementList.CashFlow[0].CashFlow.Should().Be(26779302494); incomeStatementList.CashFlow[0].Depreciation.Should().Be(3514688687); } }
public void Should_Format_BalanceSheet() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText/BalanceSheet.txt"))) { string balanceSheetJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IEXBalanceSheetList balanceSheetList = formatter.FormatBalanceSheet(balanceSheetJson); balanceSheetList.Symbol.Should().Be("AAPL"); balanceSheetList.BalanceSheet.Count.Should().Be(4); balanceSheetList.BalanceSheet[0].NetTangibleAssets.Should().Be(120177150156); balanceSheetList.BalanceSheet[0].TreasuryStock.Should().BeNull(); } }
public void Should_Format_IncomeStatement() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText/IncomeStatement.txt"))) { string incomeStatementJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IEXIncomeStatementList incomeStatementList = formatter.FormatIncomeStatement(incomeStatementJson); incomeStatementList.Symbol.Should().Be("AAPL"); incomeStatementList.Income.Count.Should().Be(4); incomeStatementList.Income[0].TotalRevenue.Should().Be(87741596877); incomeStatementList.Income[0].NetIncome.Should().Be(20683606036); } }
public void Should_Format_KeyStats2() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "KeyStats2.json"))) { string keyStatsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexKeyStats keyStats = formatter.FormatKeyStats(keyStatsJson); keyStats.CompanyName.Should().Be("Apple Inc."); keyStats.Employees.Should().Be(null); keyStats.ExDividendDate.Should().Be(null); keyStats.NextDividendDate.Should().Be(null); keyStats.NextEarningsDate.Should().Be(null); } }
public void Should_Format_DataPoints2() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "DataPoints2.json"))) { string dataPointsJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexDataPoint> iexDataPoints = formatter.FormatDataPoints(dataPointsJson); iexDataPoints.Count.Should().Be(1); IexDataPoint latest10k = iexDataPoints.Where(dp => dp.Key == "LATEST-FINANCIAL-ANNUAL-REPORT-DATE").FirstOrDefault(); latest10k.LastUpdated.Should().Be(new DateTime(2019, 8, 31, 8, 5, 34)); latest10k.Weight.Should().Be(0); } }
public void Should_Format_Company() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "Company.json"))) { string companyJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); IexCompany company = formatter.FormatCompany(companyJson); company.Ceo.Should().Be("Timothy Donald Cook"); company.Tags.Length.Should().Be(2); company.Tags[0].Should().Be("Electronic Technology"); company.Tags[1].Should().Be("Telecommunications Equipment"); company.Symbol.Should().Be("AAPL"); company.Employees.Should().Be(132000); } }
public void Should_Format_TopsLast2() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "TopsLast2.json"))) { string topsLastJson = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexTopsLast> topsLast = formatter.FormatTopsLast(topsLastJson); topsLast.Count.Should().Be(9838); var lastTopsLast = topsLast.Last(); lastTopsLast.Symbol.Should().Be("GTS"); lastTopsLast.Price.Should().Be(14.15); lastTopsLast.Size.Should().Be(102); lastTopsLast.Time.Should().Be(1628083243790); } }
public void Should_Format_NewsEvents() { IEXFormatter formatter = new IEXFormatter(); using (StreamReader reader = new StreamReader(Path.Combine("IexSseResponseText", "newsevents.json"))) { string newsEventJson = reader.ReadLine(); var newsEvents = formatter.FormatNewsLine(newsEventJson); newsEvents[0].Datetime.Should().Be(1545215400000L); newsEvents[0].HasPaywall.Should().BeTrue(); newsEvents[0].Headline.Should().NotBeEmpty(); newsEvents[0].Image.Should().NotBeEmpty(); newsEvents[0].Lang.Should().Be("en"); newsEvents[0].Related.Should().Be("AAPL,AMZN,GOOG,GOOGL,MSFT"); newsEvents[0].Source.Should().Be("Benzinga"); newsEvents[0].Summary.Should().NotBeEmpty(); newsEvents[0].Url.Should().NotBeEmpty(); } }
public void Should_Format_Dividend() { using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "Dividend.json"))) { string dividend = reader.ReadToEnd(); IEXFormatter formatter = new IEXFormatter(); List <IexDividend> iexDividend = formatter.FormatDividends(dividend); iexDividend.Count.Should().Be(4); iexDividend[0].amount.Should().Be(0.47m); iexDividend[1].amount.Should().Be(0.48m); iexDividend[2].amount.Should().Be(0.47m); iexDividend[3].amount.Should().Be(0.48m); iexDividend[0].exDate.Should().Be("2019-08-21"); iexDividend[1].exDate.Should().Be("2019-05-24"); iexDividend[2].exDate.Should().Be("2019-02-21"); iexDividend[3].exDate.Should().Be("2018-11-24"); } }
public async Task LastReportDate_Should_BeTheSameAs_TheDataPointForTheLastReportDate() { var config = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .Build(); string token = config["TOKEN"]; IEXClient client = new IEXClient(IEXBaseUrl.SandboxUrl, token); IEXFormatter formatter = new IEXFormatter(); // Get the last updated data point string dataPointResult = await client.GetDataPoint("MSFT", IexDataPointVariable.LATEST_FINANCIAL_REPORT_DATE); DateTime lastUpdated = formatter.FormatDataPoint(dataPointResult); // Get the actual point that was supposed to be updated var balanceSheetString = await client.GetBalanceSheet("MSFT", 1, "quarter"); var balanceSheet = formatter.FormatBalanceSheet(balanceSheetString); // Ensure they are the same time balanceSheet.BalanceSheet[0].ReportDate.Should().Be(lastUpdated); }
public void Should_Format_TimeSeriesFundamentals() { IEXFormatter formatter = new IEXFormatter(); using (StreamReader reader = new StreamReader(Path.Combine("IEXResponseText", "TimeSeriesFundamentals.json"))) { string advancedFundamentalsJson = reader.ReadLine(); List <IexAdvancedFundamentals> advancedFundamentals = formatter.FormatTimeSeriesFundamentals(advancedFundamentalsJson); advancedFundamentals.Count.Should().Be(125); advancedFundamentals[0].AccountsPayable.Should().Be(1095671180); advancedFundamentals[0].AccountsPayableTurnover.Should().Be(22.189243428275); advancedFundamentals[0].AccountsReceivable.Should().Be(3263373562); advancedFundamentals[0].AccountsReceivableTurnover.Should().Be(7.12195066683242); advancedFundamentals[0].AsOfDate.Should().Be(new DateTime(2000, 09, 22)); advancedFundamentals[0].AssetsCurrentCash.Should().Be(24944558998); advancedFundamentals[0].AssetsCurrentCashRestricted.Should().Be(0); advancedFundamentals[0].AssetsCurrentDeferredCompensation.Should().Be(0); advancedFundamentals[0].AssetsCurrentDeferredTax.Should().Be(1716790839); advancedFundamentals[0].AssetsCurrentDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].AssetsCurrentInvestments.Should().Be(0); advancedFundamentals[0].AssetsCurrentLeasesOperating.Should().Be(0); advancedFundamentals[0].AssetsCurrentLoansNet.Should().Be(0); advancedFundamentals[0].AssetsCurrentOther.Should().Be(1603035750); advancedFundamentals[0].AssetsCurrentSeparateAccounts.Should().Be(0); advancedFundamentals[0].AssetsCurrentUnadjusted.Should().Be(31804373456); advancedFundamentals[0].AssetsFixed.Should().Be(22087936390); advancedFundamentals[0].AssetsFixedDeferredCompensation.Should().Be(0); advancedFundamentals[0].AssetsFixedDeferredTax.Should().Be(0); advancedFundamentals[0].AssetsFixedDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].AssetsFixedLeasesOperating.Should().Be(0); advancedFundamentals[0].AssetsFixedOperatingDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].AssetsFixedOperatingSubsidiaryUnconsolidated.Should().Be(0); advancedFundamentals[0].AssetsFixedOreo.Should().Be(0); advancedFundamentals[0].AssetsFixedOther.Should().Be(2295214900); advancedFundamentals[0].AssetsFixedUnconsolidated.Should().Be(0); advancedFundamentals[0].AssetsUnadjusted.Should().Be(53181057889); advancedFundamentals[0].Capex.Should().Be(0); advancedFundamentals[0].CapexAcquisition.Should().Be(0); advancedFundamentals[0].CapexMaintenance.Should().Be(0); advancedFundamentals[0].CashConversionCycle.Should().Be(-43.6686002826987); advancedFundamentals[0].CashFlowFinancing.Should().Be(-2244631413); advancedFundamentals[0].CashFlowInvesting.Should().Be(-12446022212); advancedFundamentals[0].CashFlowOperating.Should().Be(14290423920); advancedFundamentals[0].CashFlowShareRepurchase.Should().Be(0); advancedFundamentals[0].CashLongTerm.Should().Be(18556224574); advancedFundamentals[0].CashOperating.Should().Be(0); advancedFundamentals[0].CashPaidForIncomeTaxes.Should().Be(0); advancedFundamentals[0].CashPaidForInterest.Should().Be(0); advancedFundamentals[0].CashRestricted.Should().Be(0); advancedFundamentals[0].ChargeAfterTax.Should().Be(0); advancedFundamentals[0].ChargeAfterTaxDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].ChargesAfterTaxOther.Should().Be(0); advancedFundamentals[0].Cik.Should().Be("802010"); advancedFundamentals[0].CreditLossProvision.Should().Be(0); advancedFundamentals[0].DataGenerationDate.Should().Be(new DateTime(2000, 9, 22)); advancedFundamentals[0].DaysInAccountsPayable.Should().Be(17.6159753855746); advancedFundamentals[0].DaysInInventory.Should().Be(0); advancedFundamentals[0].DaysInRevenueDeferred.Should().Be(79.1919718879045); advancedFundamentals[0].DaysRevenueOutstanding.Should().Be(54.1720696085545); advancedFundamentals[0].DebtFinancial.Should().Be(0); advancedFundamentals[0].DebtShortTerm.Should().Be(0); advancedFundamentals[0].DepreciationAndAmortizationAccumulated.Should().Be(2465657087); advancedFundamentals[0].DepreciationAndAmortizationCashFlow.Should().Be(0); advancedFundamentals[0].DividendsPreferred.Should().Be(0); advancedFundamentals[0].DividendsPreferredRedeemableMandatorily.Should().Be(0); advancedFundamentals[0].EarningsRetained.Should().Be(0); advancedFundamentals[0].EbitReported.Should().Be(11368438545); advancedFundamentals[0].EbitdaReported.Should().Be(10985863946); advancedFundamentals[0].EquityShareholder.Should().Be(42609388771); advancedFundamentals[0].EquityShareholderOther.Should().Be(41157614266); advancedFundamentals[0].EquityShareholderOtherDeferredCompensation.Should().Be(0); advancedFundamentals[0].EquityShareholderOtherEquity.Should().Be(41123661177); advancedFundamentals[0].EquityShareholderOtherMezzanine.Should().Be(0); advancedFundamentals[0].Expenses.Should().Be(8982791754); advancedFundamentals[0].ExpensesAcquisitionMerger.Should().Be(0); advancedFundamentals[0].ExpensesCompensation.Should().Be(0); advancedFundamentals[0].ExpensesDepreciationAndAmortization.Should().Be(0); advancedFundamentals[0].ExpensesDerivative.Should().Be(0); advancedFundamentals[0].ExpensesDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].ExpensesDiscontinuedOperationsReits.Should().Be(0); advancedFundamentals[0].ExpensesEnergy.Should().Be(0); advancedFundamentals[0].ExpensesForeignCurrency.Should().Be(0); advancedFundamentals[0].ExpensesInterest.Should().Be(0); advancedFundamentals[0].ExpensesInterestFinancials.Should().Be(0); advancedFundamentals[0].ExpensesInterestMinority.Should().Be(0); advancedFundamentals[0].ExpensesLegalRegulatoryInsurance.Should().Be(0); advancedFundamentals[0].ExpensesNonOperatingCompanyDefinedOther.Should().Be(0); advancedFundamentals[0].ExpensesNonOperatingOther.Should().Be(0); advancedFundamentals[0].ExpensesNonOperatingSubsidiaryUnconsolidated.Should().Be(0); advancedFundamentals[0].ExpensesNonRecurringOther.Should().Be(0); advancedFundamentals[0].ExpensesOperating.Should().Be(12483040873); advancedFundamentals[0].ExpensesOperatingOther.Should().Be(92870582); advancedFundamentals[0].ExpensesOperatingSubsidiaryUnconsolidated.Should().Be(0); advancedFundamentals[0].ExpensesOreo.Should().Be(0); advancedFundamentals[0].ExpensesOreoReits.Should().Be(0); advancedFundamentals[0].ExpensesOtherFinancing.Should().Be(-3231301125); advancedFundamentals[0].ExpensesRestructuring.Should().Be(-163555956); advancedFundamentals[0].ExpensesSga.Should().Be(5342674992); advancedFundamentals[0].ExpensesStockCompensation.Should().Be(0); advancedFundamentals[0].ExpensesWriteDown.Should().Be(0); advancedFundamentals[0].Ffo.Should().Be(0); advancedFundamentals[0].Figi.Should().Be("H40GB05PB9B0"); advancedFundamentals[0].FilingDate.Should().Be(new DateTime(2000, 9, 19)); advancedFundamentals[0].FilingType.Should().Be("01K"); advancedFundamentals[0].FiscalQuarter.Should().Be(4); advancedFundamentals[0].FiscalYear.Should().Be(2000); advancedFundamentals[0].GoodwillAmortizationCashFlow.Should().Be(0); advancedFundamentals[0].GoodwillAmortizationIncomeStatement.Should().Be(0); advancedFundamentals[0].GoodwillAndIntangiblesNetOther.Should().Be(0); advancedFundamentals[0].GoodwillNet.Should().Be(0); advancedFundamentals[0].IncomeFromOperations.Should().Be(0); advancedFundamentals[0].IncomeNet.Should().Be(9876712662); advancedFundamentals[0].IncomeNetPerRevenue.Should().Be(0.428715526975316); advancedFundamentals[0].IncomeNetPerWabso.Should().Be(1.89); advancedFundamentals[0].IncomeNetPerWabsoSplitAdjusted.Should().Be(0.936366203594105); advancedFundamentals[0].IncomeNetPerWabsoSplitAdjustedYoyDeltaPercent.Should().Be(0.179956830359489); advancedFundamentals[0].IncomeNetPerWadso.Should().Be(1.7); advancedFundamentals[0].IncomeNetPerWadsoSplitAdjusted.Should().Be(0.86164289757498); advancedFundamentals[0].IncomeNetPerWadsoSplitAdjustedYoyDeltaPercent.Should().Be(0.198730830033077); advancedFundamentals[0].IncomeNetPreTax.Should().Be(14564361269); advancedFundamentals[0].IncomeNetYoyDelta.Should().Be(1643807769); advancedFundamentals[0].IncomeOperating.Should().Be(0); advancedFundamentals[0].IncomeOperatingDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].IncomeOperatingOther.Should().Be(0); advancedFundamentals[0].IncomeOperatingSubsidiaryUnconsolidated.Should().Be(0); advancedFundamentals[0].IncomeOperatingSubsidiaryUnconsolidatedAfterTax.Should().Be(0); advancedFundamentals[0].IncomeTax.Should().Be(4997467773); advancedFundamentals[0].IncomeTaxCurrent.Should().Be(4967002243); advancedFundamentals[0].IncomeTaxDeferred.Should().Be(0); advancedFundamentals[0].IncomeTaxDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].IncomeTaxOther.Should().Be(0); advancedFundamentals[0].IncomeTaxRate.Should().Be(0.356706924091196); advancedFundamentals[0].InterestMinority.Should().Be(0); advancedFundamentals[0].Inventory.Should().Be(0); advancedFundamentals[0].InventoryTurnover.Should().Be(0); advancedFundamentals[0].Liabilities.Should().Be(53339209718); advancedFundamentals[0].LiabilitiesCurrent.Should().Be(10132819168); advancedFundamentals[0].LiabilitiesNonCurrentAndInterestMinorityTotal.Should().Be(1072756067); advancedFundamentals[0].LiabilitiesNonCurrentDebt.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentDeferredCompensation.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentDeferredTax.Should().Be(1074295922); advancedFundamentals[0].LiabilitiesNonCurrentDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentLeasesOperating.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentLongTerm.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentOperatingDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].LiabilitiesNonCurrentOther.Should().Be(0); advancedFundamentals[0].NibclDeferredCompensation.Should().Be(0); advancedFundamentals[0].NibclDeferredTax.Should().Be(0); advancedFundamentals[0].NibclDiscontinuedOperations.Should().Be(0); advancedFundamentals[0].NibclLeasesOperating.Should().Be(0); advancedFundamentals[0].NibclOther.Should().Be(3909498296); advancedFundamentals[0].NibclRestructuring.Should().Be(0); advancedFundamentals[0].NibclRevenueDeferred.Should().Be(5006790741); advancedFundamentals[0].NibclRevenueDeferredTurnover.Should().Be(4.80963089909927); advancedFundamentals[0].NibclSeparateAccounts.Should().Be(0); advancedFundamentals[0].Oci.Should().Be(1554676823); advancedFundamentals[0].PeriodEndDate.Should().Be(new DateTime(2000, 9, 28)); advancedFundamentals[0].PpAndENet.Should().Be(1921740190); advancedFundamentals[0].PricePerEarnings.Should().Be(48.5904949202319); advancedFundamentals[0].PricePerEarningsPerRevenueYoyDeltaPercent.Should().Be(3.02529199458566); advancedFundamentals[0].ProfitGross.Should().Be(20917908239); advancedFundamentals[0].ProfitGrossPerRevenue.Should().Be(0.887953122168392); advancedFundamentals[0].ResearchAndDevelopmentExpense.Should().Be(3842833151); advancedFundamentals[0].Reserves.Should().Be(0); advancedFundamentals[0].ReservesInventory.Should().Be(0); advancedFundamentals[0].ReservesLifo.Should().Be(0); advancedFundamentals[0].ReservesLoanLoss.Should().Be(0); advancedFundamentals[0].Revenue.Should().Be(24069019401); advancedFundamentals[0].RevenueCostOther.Should().Be(3031939551); advancedFundamentals[0].RevenueIncomeInterest.Should().Be(0); advancedFundamentals[0].RevenueOther.Should().Be(23718394997); advancedFundamentals[0].RevenueSubsidiaryUnconsolidated.Should().Be(0); advancedFundamentals[0].SalesCost.Should().Be(3114198394); advancedFundamentals[0].SharesIssued.Should().Be(5461328561); advancedFundamentals[0].SharesOutstandingPeDateBs.Should().Be(0); advancedFundamentals[0].SharesTreasury.Should().Be(0); advancedFundamentals[0].StockCommon.Should().Be(0); advancedFundamentals[0].StockPreferred.Should().Be(0); advancedFundamentals[0].StockPreferredEquity.Should().Be(0); advancedFundamentals[0].StockPreferredMezzanine.Should().Be(0); advancedFundamentals[0].StockTreasury.Should().Be(0); advancedFundamentals[0].Symbol.Should().Be("MSFT"); advancedFundamentals[0].Wabso.Should().Be(5330696285); advancedFundamentals[0].WabsoSplitAdjusted.Should().Be(10837405870); advancedFundamentals[0].Wadso.Should().Be(5622198972); advancedFundamentals[0].WadsoSplitAdjusted.Should().Be(11243710069); advancedFundamentals[0].Id.Should().Be("LSUAMDNFEANT"); advancedFundamentals[0].Key.Should().Be("MTFS"); advancedFundamentals[0].Subkey.Should().Be("mtt"); advancedFundamentals[0].Updated.Should().Be(1668478218063); } }