Week One Homework

# Get data for the security “XLK” (Technology Sector SPDR) in the research environment
# Pull data from the beginning of 2017 to the end of 2018 (2 years)
df = get_pricing('xlk' , start_date='2017-01-01' , end_date= '2018-12-31' , frequency='daily' )


#What was the average daily Low for “XLK” in 2017-2018?
df['low'].mean()


#What was the highest Close over these 2 years?
df['close_price'].max()


# What was the lowest Open over these 2 years?
df['open_price'].min()


# Add a column calculating the 10-day and 50-day moving averages
df['SMA_10_day'] = df['close_price'].rolling(10).mean()
df['SMA_50_day'] = df['close_price'].rolling(50).mean()


# Create a plot of the closing price, 10-day MA and 50-day MA for 2017-2018.
df[['close_price','SMA_10_day','SMA_50_day']].plot()


# Calculate the 4-period RSI on your birthday (or the first trading day after your birthday).
# My birthday is September 7th
import talib as ta
df['RSI_4_Period'] = ta.RSI(df['close_price'] , 4)
df['RSI_4_Period'].loc['2018-09-07']