import xlrd
import re
import TrackedUsers
import QuantCharterCheck
import QuantEmailSender
test = False
trackedUsers = [r'hbkticker',r'QuantResearchGroup', r'csnevill', r'stevenscapital', r'PFTC', r'BGI']
end = datetime.date.today()
if not test:
start = end + datetime.timedelta(days = -30)
else:
start = end + datetime.timedelta(days = -30)
#be sure you can connect to FCPAP01
QuantCharterCheck.checkConnection()
TrackedUsers.main(trackedUsers, end, end)
downloads = "\\\\fcpap01.fcproduction.local\\G6Log\\firstcoverage.com-transfers-%s.log" % start
quants = xlrd.open_workbook("\\\\Fcpstorage01\\reporting\\QuantCharterSpreadsheet.xls")
sheet = quants.sheet_by_index(0)
pattern = r", RETR"
while start <= end:
print start
print downloads
supressRow = True
for row in range(sheet.nrows-1):
if( (sheet.cell_value(rowx = row+1, colx = 9) == '-' or sheet.cell_value(rowx = row+1, colx = 9) == '')\
and sheet.cell_value(rowx = row+1, colx = 10) == ''):
