Like Tree2Likes
  • 1 Post By RobRoy
  • 1 Post By shri

HK Stocks - Balance Sheets / Cash Flow Data

Reply
  1. #1

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    45,325

    HK Stocks - Balance Sheets / Cash Flow Data

    Very long shot, as I've spend a fair bit of time looking for this data in a structured format (JSON or CSV) for HK listed stocks.

    Does anyone know a monthly subscription or on-demand priced service where I can query some data for personal use.

    Willing to spend HKD 100-200 a month or nominal per query charges.

    (Am not familiar with the data feeds from IB / Saxo etc - but these seem to be quotes / ticks)

    The closest would be something like what IEX Cloud offers for a bunch of US listed stocks.

    e.g.

    Code:
    {
      "symbol": "AAPL",
      "balancesheet": [
        {
          "reportDate": "2017-03-31",
          "fiscalDate": "2017-03-31",
          "currency": "USD",
          "currentCash": 25913000000,
          "shortTermInvestments": 40388000000,
          "receivables": 23186000000,
          "inventory": 3956000000,
          "otherCurrentAssets": 12087000000,
          "currentAssets": 131339000000,
          "longTermInvestments": 170799000000,
          "propertyPlantEquipment": 41304000000,
          "goodwill": null,
          "intangibleAssets": null,
          "otherAssets": 22283000000,
          "totalAssets": 365725000000,
          "accountsPayable": 55888000000,
          "currentLongTermDebt": 8784000000,
          "otherCurrentLiabilities": 40230000000,
          "totalCurrentLiabilities": 116866000000,
          "longTermDebt": 93735000000,
          "otherLiabilities": 4268000000,
          "minorityInterest": 0,
          "totalLiabilities": 258578000000,
          "commonStock": 40201000000,
          "retainedEarnings": 70400000000,
          "treasuryStock": null,
          "capitalSurplus": null,
          "shareholderEquity": 107147000000,
          "netTangibleAssets": 107147000000
        } // , { ... }
      ]
    }
    and

    Code:
    {
      "symbol": "AAPL",
      "cashflow": [
        {
          "reportDate": "2018-09-30",
          "fiscalDate": "2018-09-30",
          "currency": "USD",
          "netIncome": 14125000000,
          "depreciation": 2754000000,
          "changesInReceivables": -9082000000,
          "changesInInventories": 1942000000,
          "cashChange": -6058000000,
          "cashFlow": 19523000000,
          "capitalExpenditures": -3041000000,
          "investments": -926000000,
          "investingActivityOther": 1566000000,
          "totalInvestingCashFlows": -3001000000,
          "dividendsPaid": -3530000000,
          "netBorrowings": -27000000,
          "otherFinancingCashFlows": -260000000,
          "cashFlowFinancing": -22580000000,
          "exchangeRateEffect": null
        } // , { ... }
      ]
    }

  2. #2

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    45,325

    One option would be to scrape AAStocks site and transform the scraped data - but that involves a fair bit of work and not something I want to do as I assume this might involve licensing / bad faith issues.

    CKH HOLDINGS (00001.HK) - Balance Sheet


  3. #3

    Shri,

    Did you find a solution for this matter?

    Doesn't AAstocks have an API for getting what you want?
    The website is not clear to me in their offerings.

    Great day,
    Petra


  4. #4

    Join Date
    Dec 2002
    Location
    薄扶林
    Posts
    45,325

    A fair bit of info is available through quantopian datasets. Take a look.

    PetravanderVegt likes this.

  5. #5

    Join Date
    Jun 2011
    Posts
    1,369

    How about pulling the data off yahoo finance?

    shri likes this.