from pytrends.pyGTrends import pyGTrends
import time
import datetime
from random import randint

path_to_save = 'C:/Users/Grygory/Desktop/AnnaR/Result/'
path_to_source = 'C:/Users/Grygory/Desktop/AnnaR/source_words.csv'
path_to_addwords = 'C:/Users/Grygory/Desktop/AnnaR/FTSE100.csv'
google_username = ""
google_password = ""
start_date = "01/2014"
f1 = open(path_to_source)
keywords = f1.readline()
keywords = keywords.replace('\xa0', '').replace('\n', '').split(',')
f1.close()
f2 = open(path_to_addwords)
i = 0
positive = list()
negative = list()
toogle   = list()
for line in f2:
        if i == 0:
            i = i + 1
            continue
        else:
            tmpwords = line.replace('\xa0', '').replace('\n', '').split(',')
            if tmpwords[0] != '':
                positive.append(tmpwords[0])
            if tmpwords[1] != '':
                negative.append(tmpwords[1])
            if tmpwords[2] != '':
                toogle.append(tmpwords[2])
f2.close()
date1 = datetime.date(2014, 1, 15)
date2 = datetime.date(2016, 4, 1)
delta = datetime.timedelta(weeks=13)

while date1 <= date2:
    datestr = date1.strftime('%m/%Y')
    date1 = date1 + delta
    datestr2 = date1.strftime('%m/%Y')
    print(datestr)
    print(datestr2)
    word = keywords[0]
    connector = pyGTrends(google_username, google_password)
    connector.request_report(word, date= datestr + " 3m")
    time.sleep(randint(5, 25))
    connector.save_csv(path_to_save + 'Positive/',
                       datestr.replace('/', '.') + '_' +
                       datestr2.replace('/', '.')
                        + ' ' + word + '_postive_report')