# -*- coding: utf-8 -*-
"""
Created on Sun Mar 17 15:55:08 2019

@author: cpace
"""

from Modules.dataseries import dataseries
import numpy as np
import pandas as pd
import calendar
import datetime


crop = 'Corn'
month = 'Dec'
curyear = 2019
abbr_to_num = {name: num for num, name in enumerate(calendar.month_abbr) if num}
monthnum = abbr_to_num[month]
out = []
start = []
end = []


def getdate(str): # in form of date string 'month-day'
    mon = int(str.split('-')[0])
    day = int(str.split('-')[1])
    
    if datetime.date(curyear, mon, day) > datetime.date(curyear, monthnum, 15):
        curdate = datetime.date(curyear-1, mon, day)
    elif datetime.date(curyear, mon, day) > datetime.date(curyear, 1, 1) and datetime.date(curyear, mon, day) <= datetime.date(curyear, monthnum, 15):
        curdate = datetime.date(curyear, mon, day)
        
    return curdate

for year in range(2019,2020):
    df = dataseries(crop, month, year).dataseries

    startdate = datetime.date(year,3,18)
    
    enddate = datetime.date(year,7,20)
    
    for i in range(len(df)):
        if df.Date[i] == startdate:
            start = df.Close[i]
        elif df.Date[i] == enddate:
            end = df.Close[i]
        
    try:
        profit = end - start
        out.append([year, start, end, profit])
    except:
        continue