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",
