Build a STOCK Database with Data in JSON format via API from a homepages

[jtandersen]

Hi friends

I am trying to build a Qliview application about stocks, showing

Income Statement, Balance Sheet and Cash Flow

Yearly and Quarterly

I can get free data via API from a homepages www.alphavantage.co/documentation/

and the data looks like this 

INCOME STATEMENT FOR IBM - DEMO

https://www.alphavantage.co/query?function=INCOME_STATEMENT&symbol=IBM&apikey=demo

And the same for 

BALANCE SHEET

https://www.alphavantage.co/query?function=BALANCE_SHEET&symbol=IBM&apikey=demo

And the same for

CASH FLOW

https://www.alphavantage.co/query?function=CASH_FLOW&symbol=IBM&apikey=demo

1) Can you tell me how this possible to load into Qlikview or Qlik Sense or both?

2) This DEMO shows "symbol" "IBM"

I want the LOAD to import many COMPANIES at the same time and thereforee lookup "symbol" in an Excelsheet where I have lots of companies, where the TICKER SYMBOL are listed by me.

Is that possible?

I am not a developer but hope to get help from you great people to solve this

Thanks a lot

Have a nice day and take care

Kind regards

John

Below I show a litle draft of the Income Statement file

{
    "symbol": "IBM",
    "annualReports": [
        {
            "fiscalDateEnding": "2020-12-31",
            "reportedCurrency": "USD",
            "totalRevenue": "73620000000",
            "totalOperatingExpense": "28789000000",
            "costOfRevenue": "38046000000",
            "grossProfit": "35575000000",
            "ebit": "5925000000",
            "netIncome": "5590000000",
            "researchAndDevelopment": "6333000000",
            "effectOfAccountingCharges": "None",
            "incomeBeforeTax": "4637000000",
            "minorityInterest": "129000000",
            "sellingGeneralAdministrative": "22456000000",
            "otherNonOperatingIncome": "-861000000",
            "operatingIncome": "6786000000",
            "otherOperatingExpense": "-626000000",
            "interestExpense": "1288000000",
            "taxProvision": "-864000000",
            "interestIncome": "None",
            "netInterestIncome": "-1288000000",
            "extraordinaryItems": "-21000000",
            "nonRecurring": "None",
            "otherItems": "None",
            "incomeTaxExpense": "-864000000",
            "totalOtherIncomeExpense": "-861000000",
            "discontinuedOperations": "89000000",
            "netIncomeFromContinuingOperations": "5501000000",
            "netIncomeApplicableToCommonShares": "5590000000",
            "preferredStockAndOtherAdjustments": "None"
        },
        {
            "fiscalDateEnding": "2019-12-31",
            "reportedCurrency": "USD",
            "totalRevenue": "77147000000",

[marcce]

You probably want a nosql database like MongoDB or dynamodb which store data directly as json. In terms of cost it depends entirely on what the data quantity and your access patterns.