-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathetl.env
129 lines (85 loc) · 6.01 KB
/
etl.env
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
##################################################Reference Items ##############################################
ref_industry_names = 'http://people.stern.nyu.edu/adamodar/pc/datasets/indname.xlsx'
ref_bonds = 'http://people.stern.nyu.edu/adamodar/pc/datasets/indname.xlsx' #placeholder url.
#CORPORATE_GOVERNANCE_INSIDER_AND_INSTITUTIONAL_HOLDINGS_BY_INDUSTRY_SECTOR
inhold = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/inshold.html'
############################################Discount Rate Estimation##########################################
# Historical Returns on Stocks, Bonds and Bills: 1928-2021
histretSP = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histretSP.html'
#Historical Implied Equity Risk Premiums
histimpl = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histimpl.html'
#Cost of Equity and Capital (US) IMPORTANT DATASET
wacc = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wacc.html'
#Total Betas by Sector (for computing private company costs of equity) - US IMPORTANT DATASET
totalbeta = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/totalbeta.html'
#Country Default Spreads and Risk Premiums IMPORTANT DATASET
ctryprem = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html'
#Betas by Sector (US) IMPORTANT DATASET
betas = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/Betas.html'
# Corporate Marginal Tax Rates - By country
countrytaxrates = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/countrytaxrates.html'
#Tax Rates by Sector (US)
taxrate = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/taxrate.html'
# Risk measures by Market Cap Class (US)
mktcaprisk = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/mktcaprisk.html'
############################################Cash Flow Estimations##########################################
# Working Capital Ratios by Sector (US)
wcdata = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/wcdata.html'
#Financing Flows by Sector (US)
finflows = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/finflows.html'
#Margins by Sector (US)
margin = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/margin.html'
#Goodwill Statistics by Sector (US)
goodwill = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/goodwill.html'
#R&D Statistics by Sector (US)
r_d = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/R&D.html'
#Capital Expenditures by Sector (US)
capex = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/capex.html'
############################################Growth Rate Estimation##########################################
#Return on Equity by Sector (US)
roe = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/roe.html'
#Fundamental Growth in EPS by Sector (US)
fundgr='http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/fundgr.html'
#Historical (Compounded Annual) Growth Rates by Sector
histgr = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histgr.html'
#Fundamental Growth in EBIT by Sector (US)
fundgrEB ='http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/fundgrEB.html'
############################################Dividend Policy##########################################
# Dividends and FCFE by Sector (US)
divfcfe = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/divfcfe.html'
# Dividend Fundamentals by Sector (US)
divfund = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/divfund.html'
############################################Capital Structure##########################################
# Macro Economic Data - Annual
macro = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/macro.html'
#Debt Fundamentals by Sector (US)
dbtfund = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/dbtfund.html'
#Debt Details by Sector (US)
debtdetails = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/debtdetails.html'
#Lease Effect on Debt and Profitability by Sector
leaseeffect = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/leaseeffect.html'
############################################ Multiples ###########################################
# PE Ratio by Sector (US)
pedata = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/pedata.html'
# Price and Value to Book Ratio by Sector (US)
pbvdata = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/pbvdata.html'
#Revenue Multiples by Sector (US)
psdata = 'https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/psdata.html'
#Multiples by Market Cap Class (US)
mktcapmult = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/mktcapmult.html'
#Country Averages
countrystats = 'https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/countrystats.html'
# Enterprise value multiples by sector (US)
vebitda = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/vebitda.html'
############################################ Dollar Value ###########################################
# Aggregate Values (in US $) by Sector (US)
dollarus = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/DollarUS.html'
#######################################Covid Effects##########################################
# Effects of COVID shtudown & recovery by Sector (US)
covideffects = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/COVIDeffects.html'
########################################Option Pricing Models##################################
# Standard Deviation by Sector (US)
optvar = 'http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/optvar.html'
############################################Return Measures ############################
#Economic value added by Sector (US)
eva = 'https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/EVA.html'