#!/usr/bin/python

f = open('dji.csv', 'r')

ln = f.readlines()

def pct(nl, p):
  pc = "%3.1f" % ((nl / p * 100.0) - 100.) 
  return pc

#print ln
# Date,Open,High,Low,Close,Volume,Adj Close

fo = open('dji.txt', 'w')

for i in range(len(ln),0,-1):
  fo.write(ln[i-1])

fo.close()
f.close()

f = open('dji.txt', 'r')

# track new high
nh = 0.0
ph = 0.0
nl = 99999.9

for ln in [x.strip() for x in f]:
  d = ln.split(',')
  p = float(d[6])

  if p<nl:
    nl = p
    dtnl = d[0]
  
  if p>nh:
    ph = nh
    if p != nl and float(pct(nl,ph))<-5.0:
      print d[0], p, dtnl, nl, pct(nl,ph)
    nh = p
    nl = 99999.9

print d[0], p, dtnl, nl, ph, pct(nl,ph), pct(p, ph)