TransWikia.com

How to calculate the current ratio of a company with yahooquery?

Personal Finance & Money Asked on December 25, 2020

In order to know if companies are conservatively financed I query yahooquery API and it gives me some financial information. According to Graham in The Intelligent Investor, I have to calculate the ratio of the total assets on the total liabilities and it should be at least 200%. Yet it seems that the vocabulary used for that has changed since last time I was using it.

I used to have a totalAssets and a totalLiabilities column but it seems that I now only have the assets but not the liabilities anymore:

    asOfDate    periodType  AccountsPayable AccountsReceivable  AccumulatedDepreciation AdditionalPaidInCapital AllowanceForDoubtfulAccountsReceivable  AssetsHeldForSaleCurrent    AvailableForSaleSecurities  CapitalLeaseObligations CapitalStock    CashAndCashEquivalents  CashCashEquivalentsAndShortTermInvestments  CashEquivalents CashFinancial   CommonStock CommonStockEquity   ConstructionInProgress  CurrentAssets   CurrentCapitalLeaseObligation   CurrentDebt CurrentDebtAndCapitalLeaseObligation    CurrentDeferredLiabilities  CurrentDeferredRevenue  CurrentLiabilities  CurrentProvisions   DerivativeProductLiabilities    DividendsPayable    DuefromRelatedPartiesCurrent    DuetoRelatedPartiesCurrent  DuetoRelatedPartiesNonCurrent   EmployeeBenefits    FinancialAssets ForeignCurrencyTranslationAdjustments   GainsLossesNotAffectingRetainedEarnings Goodwill    GoodwillAndOtherIntangibleAssets    GrossAccountsReceivable GrossPPE    IncomeTaxPayable    Inventory   InvestedCapital InvestmentinFinancialAssets InvestmentsAndAdvances  InvestmentsinAssociatesatCost   LandAndImprovements LongTermCapitalLeaseObligation  LongTermDebt    LongTermDebtAndCapitalLeaseObligation   LongTermEquityInvestment    LongTermProvisions  MachineryFurnitureEquipment MinorityInterest    NetDebt NetPPE  NetTangibleAssets   NonCurrentAccountsReceivable    NonCurrentDeferredAssets    NonCurrentDeferredLiabilities   NonCurrentDeferredRevenue   NonCurrentDeferredTaxesAssets   NonCurrentDeferredTaxesLiabilities  NonCurrentPensionAndOtherPostretirementBenefitPlans NonCurrentPrepaidAssets OrdinarySharesNumber    OtherCurrentAssets  OtherCurrentBorrowings  OtherCurrentLiabilities OtherEquityAdjustments  OtherEquityInterest OtherIntangibleAssets   OtherInvestments    OtherNonCurrentLiabilities  OtherPayable    OtherProperties OtherReceivables    OtherShortTermInvestments   Payables    PayablesAndAccruedExpenses  PensionandOtherPostRetirementBenefitPlansCurrent    PrepaidAssets   Properties  Receivables RetainedEarnings    ShareIssued StockholdersEquity  TangibleBookValue   TaxesReceivable TotalAssets TotalCapitalization TotalDebt   TotalEquityGrossMinorityInterest    TotalLiabilitiesNetMinorityInterest TotalNonCurrentAssets   TotalNonCurrentLiabilitiesNetMinorityInterest   TotalTaxPayable TradeandOtherPayablesNonCurrent TreasurySharesNumber    TreasuryStock   UnrealizedGainLoss  WorkingCapital
symbol                                                                                                                                                                                                                                                                                                                                                                                                                  
TEFN.MX 2016-12-31  12M 1.185900e+10    8.828000e+09    -8.612000e+10   3.227000e+09    -2.795000e+09   2.100000e+07    9.765000e+09    NaN 5.038000e+09    3.736000e+09    6.690000e+09    1.659000e+09    2.077000e+09    5.038000e+09    1.815700e+10    3.350000e+09    1.997400e+10    NaN 1.397700e+10    1.397700e+10    2.073000e+09    1.569000e+09    3.545100e+10    1.218000e+09    2.747000e+09    NaN 28000000.0  497000000.0 NaN 6.147000e+09    NaN -1.474000e+10   -1.355500e+10   2.868600e+10    4.920400e+10    1.162300e+10    1.225130e+11    4.860000e+08    1.055000e+09    7.499900e+10    9.765000e+09    9.841000e+09    NaN 1.193000e+10    NaN 4.286500e+10    4.286500e+10    76000000.0  3.726000e+09    1.072330e+11    1.022800e+10    5.310600e+10    3.639300e+10    -3.104700e+10   NaN 8.229000e+09    3.906000e+09    9.030000e+08    8.229000e+09    2.395000e+09    9.350000e+08    NaN 5.037805e+09    NaN 1.397700e+10    7.720000e+08    1.176000e+09    7.834000e+09    2.051800e+10    NaN NaN 1.721000e+09    3.639300e+10    418000000.0 2.954000e+09    1.640900e+10    1.640900e+10    1.002000e+09    1.401000e+09    0.0 1.080700e+10    1.709300e+10    5.037805e+09    1.815700e+10    -3.104700e+10   1.533000e+09    1.236410e+11    6.102200e+10    5.684200e+10    2.838500e+10    9.525600e+10    1.036670e+11    5.980500e+10    2.332000e+09    414000000.0 NaN 1.480000e+09    9000000.0   -1.547700e+10
TEFN.MX 2017-12-31  12M 1.152300e+10    8.328000e+09    -8.364300e+10   4.538000e+09    -2.563000e+09   NaN 8.167000e+09    NaN 5.192000e+09    5.192000e+09    7.346000e+09    1.202000e+09    3.990000e+09    5.192000e+09    1.692000e+10    3.289000e+09    1.993100e+10    NaN 9.134000e+09    9.134000e+09    1.559000e+09    1.387000e+09    2.906600e+10    1.304000e+09    2.872000e+09    NaN 32000000.0  491000000.0 0.0 5.666000e+09    NaN -1.934700e+10   -1.790200e+10   2.684100e+10    4.484600e+10    1.089100e+10    1.178680e+11    5.800000e+08    1.117000e+09    6.951400e+10    8.167000e+09    8.244000e+09    NaN 1.134400e+10    NaN 4.346000e+10    4.346000e+10    77000000.0  3.552000e+09    1.032350e+11    9.698000e+09    4.740200e+10    3.422500e+10    -2.792600e+10   NaN 7.820000e+09    3.488000e+09    7.740000e+08    7.820000e+09    2.145000e+09    1.030000e+09    NaN 5.192132e+09    NaN 9.134000e+09    2.800000e+08    1.371000e+09    7.555000e+09    1.800500e+10    NaN NaN 1.522000e+09    NaN 367000000.0 2.154000e+09    1.587700e+10    1.587700e+10    9.120000e+08    1.366000e+09    0.0 1.010200e+10    1.822500e+10    5.257820e+09    1.692000e+10    -2.792600e+10   1.375000e+09    1.150660e+11    6.038000e+10    5.259400e+10    2.661800e+10    8.844800e+10    9.513500e+10    5.938200e+10    2.341000e+09    344000000.0 65687859.0  6.880000e+08    74000000.0  -9.135000e+09
TEFN.MX 2018-12-31  12M 1.169400e+10    8.009000e+09    -9.085900e+10   4.538000e+09    -2.657000e+09   1.492000e+09    1.050000e+09    NaN 5.192000e+09    5.692000e+09    7.901000e+09    8.060000e+08    4.886000e+09    5.192000e+09    1.794700e+10    2.453000e+09    2.334000e+10    NaN 9.138000e+09    9.138000e+09    1.868000e+09    1.617000e+09    2.964900e+10    1.026000e+09    2.287000e+09    311000000.0 33000000.0  520000000.0 NaN 4.499000e+09    2.776000e+09    -1.475100e+10   -1.352200e+10   2.574800e+10    4.260400e+10    1.066600e+10    1.241540e+11    5.800000e+08    1.692000e+09    7.013200e+10    1.050000e+09    1.691000e+09    68000000.0  1.194900e+10    NaN 4.304700e+10    4.304700e+10    68000000.0  3.021000e+09    1.097520e+11    9.033000e+09    4.649300e+10    3.329500e+10    -2.465700e+10   478000000.0 7.822000e+09    4.232000e+09    8.960000e+08    7.631000e+09    2.674000e+09    3.890000e+08    2.041000e+09    5.192132e+09    566000000.0 9.138000e+09    1.067000e+09    1.598000e+09    7.540000e+09    1.685600e+10    573000000.0 NaN 1.092000e+09    3.329500e+10    718000000.0 2.209000e+09    1.566400e+10    1.566400e+10    8.860000e+08    1.253000e+09    0.0 1.043600e+10    1.488500e+10    5.257628e+09    1.794700e+10    -2.465700e+10   1.676000e+09    1.140470e+11    6.099400e+10    5.218500e+10    2.698000e+10    8.706700e+10    9.070700e+10    5.741800e+10    2.047000e+09    332000000.0 65496120.0  6.860000e+08    -369000000.0    -6.309000e+09
TEFN.MX 2019-12-31  12M 1.111400e+10    8.171000e+09    -8.903100e+10   4.538000e+09    -2.798000e+09   8.180000e+08    3.530000e+08    7.226000e+09    5.192000e+09    6.042000e+09    9.165000e+09    8.330000e+08    5.209000e+09    5.192000e+09    1.711800e+10    2.381000e+09    2.432800e+10    1.600000e+09    8.552000e+09    1.015200e+10    1.792000e+09    1.596000e+09    3.019100e+10    5.620000e+08    2.358000e+09    282000000.0 37000000.0  634000000.0 NaN 5.789000e+09    3.389000e+09    -1.458800e+10   -1.349100e+10   2.540300e+10    4.143700e+10    1.096900e+10    1.281980e+11    1.073000e+09    1.999000e+09    6.660000e+10    3.530000e+08    1.093000e+09    140000000.0 1.058800e+10    5.626000e+09    4.093000e+10    4.655600e+10    140000000.0 2.697000e+09    1.082900e+11    8.332000e+09    4.344000e+10    3.916700e+10    -2.431900e+10   903000000.0 6.903000e+09    5.457000e+09    1.187000e+09    6.682000e+09    2.908000e+09    5.650000e+08    1.657000e+09    5.192132e+09    625000000.0 8.552000e+09    9.040000e+08    1.541000e+09    8.267000e+09    1.603400e+10    600000000.0 4.328800e+10    1.081000e+09    6.939000e+09    895000000.0 3.123000e+09    1.567100e+10    1.567100e+10    1.110000e+09    1.057000e+09    0.0 1.066400e+10    1.337800e+10    5.269694e+09    1.711800e+10    -2.431900e+10   1.561000e+09    1.188770e+11    5.804800e+10    5.670800e+10    2.545000e+10    9.342700e+10    9.454900e+10    6.323600e+10    2.560000e+09    379000000.0 77562635.0  7.660000e+08    -444000000.0    -5.863000e+09

So I wonder what should I use now: TotalAssets on TotalLiabilitiesNetMinorityInterest?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP