Skip to content. | Skip to navigation

Personal tools
Sections
You are here: Home config Published Properties

Published Properties

Experimental properties and where to find them.

Sentiment

url: http://www.aaii.com/files/surveys/sentiment.xls
name: sentiment
file: sentiment.xls
type: Excel
startCol: 8
sheet: 0 
date: {col: 0} 
minRows: 100
Sentiment_AAII_Bullish: {col: 1, type: Percent} 
Sentiment_AAII_Neutral: {col: 2, type: Percent}
Sentiment_AAII_Bearish: {col: 3, type: Percent}

Gas

url:  http://www.eia.gov/petroleum/gasdiesel/xls/pswrgvwall.xls
name: gas-price-regular-conventional
file: gas.xls
type: Excel
startCol: 4
sheet: 1 
date: {col: 0} 
minRows: 100
Gas_Price_Reg_Conv_USA: {col: 1}

Fed

type: Fred
name: Fed_CPI_Not_Adj
file: CPIAUCNS.txt
minRows: 100
lag: 35
type: Fred
name: Fed_CPI
file: CPIAUCSL.txt
minRows: 100
lag: 35

type: Fred
name: Fed_Total_Construction_Spend
file: TTLCONS.txt
lag: 60
type: Fred
name: Fed_Home_Price_20_City_Avg
file: SPCS20RSA.txt
lag: 60
type: Fred
name: Fed_Mortgage_Rate_30_Yr
file: MORTG.txt
lag: 35
type: Fred
name: Fed_Prime_Loan_Rate
file: MPRIME.txt
lag: 35
type: Fred
name: Fed_Funds_Rate
file: FEDFUNDS.txt
lag: 35
type: Fred
name: Fed_GDP
file: FYGDP.txt
type: Fred
name: Fed_Public_Debt
file: GFDEBTN.txt
lag: 180
type: Fred
name: Fed_Public_Debt_to_GDP
file: GFDEGDQ188S.txt
lag: 180
type: Fred
name: Fed_Surplus_or_Deficit
file: FYFSD.txt
lag: 35
type: Fred
name: Fed_Civilian_Unemployment
file: UNRATE.txt
lag: 35
type: Fred
name: Fed_ISM_Manufacturing
file: NAPM.txt
minRows: 100
lag: 35

Fed Exchange Rate

type: Fred
name: Fed_Forex_US_EURO
file: DEXUSEU.txt
lag: 5
type: Fred
name: Fed_Forex_CHINA_US
file: DEXCHUS.txt
lag: 5
type: Fred
name: Fed_Forex_US_UK
file: DEXUSUK.txt
lag: 5
type: Fred
name: Fed_Forex_BRAZIL_US
file: DEXBZUS.txt
lag: 5
type: Fred
name: Fed_Forex_JAPAN_US
file: DEXJPUS.txt
lag: 5

Treasury Constant Maturity Rates

type: Fred
name: Fed_Treasury_10Y
file: DGS10.txt
lag: 0
type: Fred
name: Fed_Treasury_1Y
file: DGS1.txt
lag: 0
type: Fred
name: Fed_Treasury_5Y
file: DGS5.txt
lag: 0
type: Fred
name: Fed_Treasury_20Y
file: DGS20.txt
lag: 0
type: Fred
name: Fed_Treasury_30Y
file: DGS30.txt
lag: 0
type: Fred
name: Fed_Treasury_3Y
file: DGS3.txt
lag: 0
type: Fred
name: Fed_Treasury_2Y
file: DGS2.txt
lag: 0
type: Fred
name: Fed_Treasury_3M
file: DGS3MO.txt
lag: 0
type: Fred
name: Fed_Treasury_1M
file: DGS1MO.txt
lag: 0
type: Fred
name: Fed_Treasury_6M
file: DGS6MO.txt
lag: 0

Dcii

url: https://www.equitieslab.com/wiki/remotedata/dcii.xls/at_download/file
name: Dciix
file: dcii.xls
type: Excel
startCol: 2
sheet: 0 
date: {col: 0} 
minRows: 100
Dciix: {col: 1, type: Float} 

Bfmei

url: http://download.equitieslab.com/files/bfmei.xls
name: Bfmei
file: bfmei.xls
type: Excel
startCol: 2
sheet: 0 
date: {col: 0} 
minRows: 10
Bfmei_Stress: {col: 1, type: Float} 
Bfmei_Market: {col: 2, type: Float} 
Bfmei_Econ: {col: 3, type: Float} 
Bfmei_Stress_Raw: {col: 1, sheet: 1, type: Float} 
Bfmei_Market_Raw: {col: 1, sheet: 2, type: Float} 
Bfmei_Econ_Raw: {col: 1, sheet: 3, type: Float} 

Bfmei_Raw_Econ

url: http://download.equitieslab.com/files/bfmei_econ.xls
name: Bfmei_Raw_Econ
file: bfmei_econ.xls
type: Excel
startCol: 2
sheet: 0 
date: {col: 0} 
minRows: 10
Bfmei_Raw_Econ: {col: 1, type: Float} 

Bfmei_Raw_Credit

url: http://www.equitieslab.com/files/bfmei_credit.xls
name: Bfmei_Raw_Credit
file: bfmei_credit.xls
type: Excel
startCol: 2
sheet: 0 
date: {col: 0} 
minRows: 10
Bfmei_Raw_Credit: {col: 1, type: Float}