"""
Ch12 Q1
"""

import pandas as pd

data = pd.read_csv("SPY.csv", index_col=0)

n = len(data)

data["CO"] = 0

for i in range(n):
    if data.iloc[i,3] > data.iloc[i,0]:
        data.iloc[i,6] = 1
        
print("Percentage of daily higher close",data["CO"].sum()/n)

#Part (b) starts here
data["Up"] = 0

for i in range(n-1):
    if data.iloc[i+1,4] > data.iloc[i,4]:
        data.iloc[i+1,7] = 1

print("Percentage of daily higher close",data["Up"].sum()/n)