def get_bad(self, days: int = 502):
rows = list(self.wb['Bad'])[1:]
h = []
i = 1
for row in rows:
h.append(
Quote(
# Quoto.date cannot be null.
row[3].value or datetime.now(),
# Keep micro values.
'{:f}'.format(PyDecimal(row[4].value))
if row[4].value is not None else None,
'{:f}'.format(PyDecimal(row[5].value))
if row[5].value is not None else None,
'{:f}'.format(PyDecimal(row[6].value))
if row[6].value is not None else None,
'{:f}'.format(PyDecimal(row[7].value))
if row[7].value is not None else None,
'{:f}'.format(PyDecimal(row[8].value))
if row[8].value is not None else None,
))
h.reverse()
return h[:days]
def get_compare(self, days: int = 502):
rows = list(self.wb['Compare'])[1:]
h = []
for row in rows:
h.append(
Quote(
row[3].value,
row[4].value,
row[5].value,
row[6].value,
row[7].value,
row[8].value,
))
h.reverse()
return h[:days]
def get(self, days: int = 502):
rows = list(self.wb['History (primary)'])[1:]
h = []
for row in rows:
h.append(
Quote(
row[3].value,
row[4].value,
row[5].value,
row[6].value,
row[7].value,
row[8].value,
))
h.reverse()
return h[:days]