#!/usr/bin/env python
#
# YahooCsvToXml.py: Converts Yahoo historical stock prices from CSV
# to XML format.
#
# Copyright (c) 2006 Steven Engelhardt.  Free to use and modify without
# restrictions.

import sys
import csv
import time

def yahooCsvToXml(infile, outfile):
    reader = csv.reader(infile)
    header = reader.next()

    outfile.write('<Prices>\n')
    for row in reader:
        date = time.strptime(row[0], '%d-%b-%y')
        outfile.write('  <Price>\n')
        outfile.write('    <Date>%s</Date>\n' % (time.strftime('%Y-%m-%d', date)))
        outfile.write('    <Open>%s</Open>\n' % (row[1]))
        outfile.write('    <High>%s</High>\n' % (row[2]))
        outfile.write('    <Low>%s</Low>\n' % (row[3]))
        outfile.write('    <Close>%s</Close>\n' % (row[4]))
        outfile.write('    <Volume>%s</Volume>\n' % (row[5]))
        outfile.write('    <AdjClose>%s</AdjClose>\n' % (row[6]))
        outfile.write('  </Price>\n')
    outfile.write('</Prices>')

def main():
    yahooCsvToXml(sys.stdin, sys.stdout)

if __name__ == '__main__':
    main()