''' Automatic stock quoter checker.
    Designed for PythonWin
    License:  Public Domain
    Author:   Raymond Hettinger
    Updates:  http://users.rcn.com/python/download/python.htm
'''

#  Revision In Use:  'File %n, Ver %v, Date %f'
version = 'File QUOTER.PYW, Ver 23, Date 13-Mar-2002,3:18:02'

from winsound import PlaySound, SND_FILENAME, SND_ASYNC
PlaySound( 'c:\windows\media\start.wav', SND_FILENAME | SND_ASYNC )

from win32com.client.dynamic import Dispatch
xl = Dispatch( 'Excel.Application' )
reqtickers = xl.Range('tickers').Value

stocks = [ str(t[0]) for t in reqtickers ]
stockstr = '+'.join( stocks )

import urllib
reply = urllib.urlopen( 'http://finance.yahoo.com/d/quotes.csv?s=' +
        stockstr + '&f=l1&e=.csv').read()

table = [ [s] for s in reply.split() ]
xl.Range('currPrices').Value = table
PlaySound( r'c:\windows\media\tada.wav', SND_FILENAME )