Feb-23-2019, 12:57 AM
My dictionary will be similar to below. I want it to not have the terms in red and I want each row to be a quarter date as output and each title to be a column populated with the dictionary values. Any help of how to make this a table in excel? Thanks!!
example output:
Total change liabilities .................
2018-09-30 64000000 ................
{'cashflowStatementHistoryQuarterly': {'APA':
[{'2018-09-30': {'changeToLiabilities': 64000000, 'totalCashflowsFromInvestingActivities': -926000000, 'netBorrowings': -228000000, 'totalCashFromFinancingActivities': -459000000, 'changeToOperatingActivities': -48000000, 'netIncome': 81000000, 'changeInCash': -379000000, 'totalCashFromOperatingActivities': 1006000000, 'depreciation': 676000000, 'otherCashflowsFromInvestingActivities': -22000000, 'dividendsPaid': -96000000, 'changeToInventory': 2000000, 'changeToAccountReceivables': -12000000, 'otherCashflowsFromFinancingActivities': -135000000, 'changeToNetincome': 243000000, 'capitalExpenditures': -942000000}},
{'2018-06-30': {'changeToLiabilities': -20000000, 'totalCashflowsFromInvestingActivities': -1024000000, 'netBorrowings': -228000000, 'totalCashFromFinancingActivities': -194000000, 'changeToOperatingActivities': 213000000, 'netIncome': 195000000, 'changeInCash': -105000000, 'totalCashFromOperatingActivities': 1113000000, 'depreciation': 656000000, 'otherCashflowsFromInvestingActivities': -11000000, 'dividendsPaid': -96000000, 'changeToInventory': 24000000, 'changeToAccountReceivables': -36000000, 'otherCashflowsFromFinancingActivities': -98000000, 'changeToNetincome': 81000000, 'capitalExpenditures': -1017000000}},
{'2018-03-31': {'changeToLiabilities': 66000000, 'totalCashflowsFromInvestingActivities': -890000000, 'netBorrowings': -150000000, 'totalCashFromFinancingActivities': -316000000, 'changeToOperatingActivities': -152000000, 'netIncome': 145000000, 'changeInCash': -591000000, 'totalCashFromOperatingActivities': 615000000, 'depreciation': 596000000, 'otherCashflowsFromInvestingActivities': -22000000, 'dividendsPaid': -95000000, 'changeToInventory': -33000000, 'changeToAccountReceivables': -65000000, 'otherCashflowsFromFinancingActivities': -71000000, 'changeToNetincome': 58000000, 'capitalExpenditures': -877000000}},
{'2017-12-31': {'changeToLiabilities': 61000000, 'totalCashflowsFromInvestingActivities': -793000000, 'netBorrowings': -150000000, 'totalCashFromFinancingActivities': -149000000, 'changeToOperatingActivities': 32000000, 'netIncome': 456000000, 'changeInCash': -274000000, 'totalCashFromOperatingActivities': 668000000, 'depreciation': 632000000, 'otherCashflowsFromInvestingActivities': -45000000, 'dividendsPaid': -95000000, 'changeToInventory': 15000000, 'changeToAccountReceivables': -200000000, 'otherCashflowsFromFinancingActivities': -54000000, 'changeToNetincome': -328000000, 'capitalExpenditures': -763000000}}]}}
example output:
Total change liabilities .................
2018-09-30 64000000 ................
{'cashflowStatementHistoryQuarterly': {'APA':
[{'2018-09-30': {'changeToLiabilities': 64000000, 'totalCashflowsFromInvestingActivities': -926000000, 'netBorrowings': -228000000, 'totalCashFromFinancingActivities': -459000000, 'changeToOperatingActivities': -48000000, 'netIncome': 81000000, 'changeInCash': -379000000, 'totalCashFromOperatingActivities': 1006000000, 'depreciation': 676000000, 'otherCashflowsFromInvestingActivities': -22000000, 'dividendsPaid': -96000000, 'changeToInventory': 2000000, 'changeToAccountReceivables': -12000000, 'otherCashflowsFromFinancingActivities': -135000000, 'changeToNetincome': 243000000, 'capitalExpenditures': -942000000}},
{'2018-06-30': {'changeToLiabilities': -20000000, 'totalCashflowsFromInvestingActivities': -1024000000, 'netBorrowings': -228000000, 'totalCashFromFinancingActivities': -194000000, 'changeToOperatingActivities': 213000000, 'netIncome': 195000000, 'changeInCash': -105000000, 'totalCashFromOperatingActivities': 1113000000, 'depreciation': 656000000, 'otherCashflowsFromInvestingActivities': -11000000, 'dividendsPaid': -96000000, 'changeToInventory': 24000000, 'changeToAccountReceivables': -36000000, 'otherCashflowsFromFinancingActivities': -98000000, 'changeToNetincome': 81000000, 'capitalExpenditures': -1017000000}},
{'2018-03-31': {'changeToLiabilities': 66000000, 'totalCashflowsFromInvestingActivities': -890000000, 'netBorrowings': -150000000, 'totalCashFromFinancingActivities': -316000000, 'changeToOperatingActivities': -152000000, 'netIncome': 145000000, 'changeInCash': -591000000, 'totalCashFromOperatingActivities': 615000000, 'depreciation': 596000000, 'otherCashflowsFromInvestingActivities': -22000000, 'dividendsPaid': -95000000, 'changeToInventory': -33000000, 'changeToAccountReceivables': -65000000, 'otherCashflowsFromFinancingActivities': -71000000, 'changeToNetincome': 58000000, 'capitalExpenditures': -877000000}},
{'2017-12-31': {'changeToLiabilities': 61000000, 'totalCashflowsFromInvestingActivities': -793000000, 'netBorrowings': -150000000, 'totalCashFromFinancingActivities': -149000000, 'changeToOperatingActivities': 32000000, 'netIncome': 456000000, 'changeInCash': -274000000, 'totalCashFromOperatingActivities': 668000000, 'depreciation': 632000000, 'otherCashflowsFromInvestingActivities': -45000000, 'dividendsPaid': -95000000, 'changeToInventory': 15000000, 'changeToAccountReceivables': -200000000, 'otherCashflowsFromFinancingActivities': -54000000, 'changeToNetincome': -328000000, 'capitalExpenditures': -763000000}}]}}