# -*- coding: utf-8 -*-
"""
Created on Tue Apr 12 12:22:32 2022

@author: Michael Chan
"""

import requests
from bs4 import BeautifulSoup
import pandas as pd
url = "http://www.aastocks.com/tc/ltp/rtai.aspx"
sess = requests.session()
req = sess.get(url)
if req.status_code == 200:
    stocklist = ['00268','02252','00700']
    soup = BeautifulSoup(req.text, "html.parser")
    for i in soup.select(".cellL .boxM"):
        LE = i.text.replace("\r\n","") 
        stocklist.append(LE[LE.find('0'):-3])

df = pd.DataFrame(stocklist, columns = ["股票代號"] )
df.to_excel('watchlist.xlsx', header=True, index=False)