  today = date.today()
  yy = today.year
  mm = today.month
  dd = today.day
      
  book21 = open_workbook('E:\\Information\\Investment\\v.xlsm')  # } Excel Ҧb|
  sheet21 = book21.sheet_by_name(u'x')  # w excel  sheet
  nrows21 = sheet21.nrows # sheet ƪ
  ncols21 = sheet21.ncols # sheet ƪC

  a = 1
  c = 1
  d = 0
  while a < nrows21:
    if (sheet21.cell(a,d).value) != '':
      c+=1
    a+=1

  for e in range (1, c-2, 1):
    cell21=(sheet21.cell(e,d).value)
    cell22=type(cell21)
    if cell22 == float:
      cell21=int(sheet21.cell(e,d).value)
    if cell22 == str:
      cell21=str(sheet21.cell(e,d).value)
    
    for b in range(0, 2, 1):
      y1 = yy - b
      if b == 0:
        for m1 in range(mm, 0, -1):
          print (cell21, y1, m1)
          time.sleep(3.5)
          mm1 = m1
          d1 = dd
          if m1 < 10:
            mm1 = str(0) + str(m1)
          if d1 < 10:
            d1 = str(0) + str(dd)
          url="http://www.twse.com.tw/exchangeReport/STOCK_DAY?response=csv&date=" + str(y1) + str(mm1) + str(d1) + "&stockNo=" + str(cell21)
          values = {'download' : 'csv',
                    'query_year' : y1,
                    'query_month' : m1,
                    'CO_ID' : cell21 }
          data = urllib.parse.urlencode(values)
          req= urllib.request.Request(url, data.encode('utf-8'))
          response = urllib.request.urlopen(req)
          file1=open(disk11 + ":\\stock\\data\\"+str(y1)+str(m1)+' - '+str(cell21)+".csv","w")
          line = response.read().decode('cp950')
          line=line.replace("\n","")
          file1.write(line)
          file1.close()
      if b == 1:
        for m3 in range(12, mm-1, -1):
          print (cell21, y1, m3)
          time.sleep(3.5)
          mm3 = m3
          d1 = dd
          if m3 < 10:
            mm3 = str(0) + str(m3)
          if d1 < 10:
            d1 = str(0) + str(dd)
          url="http://www.twse.com.tw/exchangeReport/STOCK_DAY?response=csv&date=" + str(y1) + str(mm3) + str(d1) + "&stockNo=" + str(cell21)
          values = {'download' : 'csv',
                    'query_year' : y1,
                    'query_month' : m3,
                    'CO_ID' : cell21 }
          data = urllib.parse.urlencode(values)
          req= urllib.request.Request(url, data.encode('utf-8'))
          response = urllib.request.urlopen(req)
          file1=open(disk11 + ":\\stock\\data\\"+str(y1)+str(m3)+' - '+str(cell21)+".csv","w")
          line = response.read().decode('cp950')
          line=line.replace("\n","")
          file1.write(line)
          file1.close()