def row_to_record (row):
"""
Converts row of CSV file to COT_Record data object
Arguments:
- `row`: - array of CSV values
"""
sym = name_to_symbol (row[0])
if sym == None:
return None
return COT_Record (symbol = sym,
date = utils.parseIsoDate (row[2]),
oi = long (row[7]),
pos_non_comm_long = long (row[8]),
pos_non_comm_short = long (row[9]),
pos_non_comm_spread = long (row[10]),
pos_comm_long = long (row[11]),
pos_comm_short = long (row[12]),
pos_non_rep_long = long (row[15]),
pos_non_rep_short = long (row[16]),
count_non_comm_long = long (row[78]),
count_non_comm_short = long (row[79]),
count_non_comm_spread = long (row[80]),
count_comm_long = long (row[81]),
count_comm_short = long (row[82]))
def row_to_record(row):
"""
Converts row of CSV file to COT_Record data object
Arguments:
- `row`: - array of CSV values
"""
sym = name_to_symbol(row[0])
if sym == None:
return None
return COT_Record(symbol=sym,
date=utils.parseIsoDate(row[2]),
oi=long(row[7]),
pos_non_comm_long=long(row[8]),
pos_non_comm_short=long(row[9]),
pos_non_comm_spread=long(row[10]),
pos_comm_long=long(row[11]),
pos_comm_short=long(row[12]),
pos_non_rep_long=long(row[15]),
pos_non_rep_short=long(row[16]),
count_non_comm_long=long(row[78]),
count_non_comm_short=long(row[79]),
count_non_comm_spread=long(row[80]),
count_comm_long=long(row[81]),
count_comm_short=long(row[82]))
def get (self):
# download http://cftc.gov/dea/newcot/deacit.txt, and check first line and third CSV value
try:
res = fetch_cftc_file ("/dea/newcot/deacit.txt")
for row in csv.reader ([res.split ('\n')[0]], delimiter=',', quotechar='"'):
if row[2] == '':
return None
return utils.parseIsoDate (row[2])
except:
pass
return None
def get(self):
# download http://cftc.gov/dea/newcot/deacit.txt, and check first line and third CSV value
try:
res = fetch_cftc_file("/dea/newcot/deacit.txt")
for row in csv.reader([res.split('\n')[0]],
delimiter=',',
quotechar='"'):
if row[2] == '':
return None
return utils.parseIsoDate(row[2])
except:
pass
return None