Skip to content

Instantly share code, notes, and snippets.

View adhw601's full-sized avatar

adhw601

View GitHub Profile
@adhw601
adhw601 / Apple (6) (1).csv
Created April 18, 2026 15:25
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 22 columns, instead of 19 in line 4.
Standard and Poor's Identifier,Data Date,Data Year - Fiscal,Industry Format,Level of Consolidation - Company Annual Descriptor,Population Source,Data Format,ISO Currency Code,Accounting Changes - Cumulative Effect,Current Assets - Total,Accrued Expenses and Deferred Income,Assets - Other,Assets and Liabilities - Other - Net Change,Accounts Payable and Accrued Liabilities - Increase/(Decrease),Assets - Total,Cash and Cash Equivalents - Increase/(Decrease),Development Revenue (Real Estate),Dividends - Share Capital - Other,Dividends - Total,Financing Activities - Net Cash Flow,Gross Profit (Loss),Active/Inactive Status Marker
001690,30/9/2018,2018,INDL,C,D,STD,USD,0,131339,,22283,38023,9175,365725,5624,,,13735,-87876,110903,A
001690,30/9/2019,2019,INDL,C,D,STD,USD,0,162819,,32978,-4452,-1923,338516,24311,,,14129,-90976,109692,A
001690,30/9/2020,2020,INDL,C,D,STD,USD,0,143713,,33952,1409,-4062,323888,-10435,,,14087,-86820,114656,A
001690,30/9/2021,2021,INDL,C,D,STD,USD,0,134836,,38762,-567,12326,351002,-3860,,,1
@adhw601
adhw601 / sp500_ZScore_avgCoDebt.csv
Created April 18, 2026 13:50
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 1 column, instead of 2 in line 1.
Ticker Year Fiscal_Year_End Name Sector_Key Industry_Key Total_Assets Current_Assets Current_Liab Retained_Earnings Total_Liab Total_Debt Shares_Number EBIT Sales Int_Exp Market_Cap Closing_Price Closing_Price_Date Z_Score prev_debt avg_debt AvgCost_of_Debt Z_Score_lag
AAL 2021 2021-12-31 American Airlines Group, Inc. industrials airlines 66467000000 17336000000 19006000000 -8638000000 73807000000 46177000000 647727595 -748000000 29882000000 1800000000 11633187013.2 17.95999908 2021-12-31 2.94916E-01
AAP 2021 2021-12-31 Advance Auto Parts Inc. consumer-cyclical auto-parts 12194209000 6275476000 5180307000 4605791000 9065918000 3371971000 62009000 820284000 10997989000 37791000 13502133317.1 217.7447357 2021-12-31 2.654042491
ABBV 2021 2021-12-31 AbbVie Inc. healthcare drug-manufacturers-general 1.46529E+11 27928000000 35194000000 3127000000 1.31093E+11 76684000000 1768337696 15412000000 56197000000 2423000000 2.06475E+11 116.7620239 2021-12-31 1.64600359
ABT 2021 2021-12-31 Abbott Laboratories