import requests
import csv
import pandas as pd

f=open('stock.csv',mode='w',encoding='GBK',newline='')
csv_writer=csv.DictWriter(f,fieldnames=['股票代码','股票名称','当前价'])
csv_writer.writeheader()
content_list=[]

for page in range(1,11):
    headers={'Cookie':'xq_a_token=4fda997cf0d3bc4ef43eba42532cf38a54bcbc00; xqat=4fda997cf0d3bc4ef43eba42532cf38a54bcbc00; xq_r_token=a440894245f0f9be071ea5c41d674edb42789120; xq_id_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJ1aWQiOi0xLCJpc3MiOiJ1YyIsImV4cCI6MTcwMzI5MTg4MiwiY3RtIjoxNzAxMDUyNDM2ODE0LCJjaWQiOiJkOWQwbjRBWnVwIn0.GFFwXRb2E9KbxBTCpt4KdJYuj0KEaHATCup9jOwm_y-5w8VSW_k0mpmKv5AxZIUj0tYT0E29LbHWcMq78VWpgKPw7plgTf7Tn8S2gtbq14mC8P_MfZQ93Ekfq4g4mVhEPjWuIqOC6KDCYOrOQa6iVBZQlO707BTRkTu4XnZMpOWu3pbWURc6slNh1VGNmbFWrBb04vTtguFxyuyCOAvozlmLKDQSSLtDzWguZTQsHtfrgT-j5alqMTpmabuJhybRIaCrwyBXUQLtvfUzhMWd2U13Pr3AptV3UExzJLs-Yc9W7g1CLca_gA234lCS_oLv8ugdTh23jFY4qQ8Zd5GNxg; cookiesu=321701052477780; u=321701052477780; device_id=efb20afd8a6af0e23aa5a234e0a379c5; Hm_lvt_1db88642e346389874251b5a1eded6e3=1701052481; s=b5123z5jd6; Hm_lpvt_1db88642e346389874251b5a1eded6e3=1701052485','User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.5735.289 Safari/537.36'}
    url='https://stock.xueqiu.com/v5/stock/screener/quote/list.json?page='+str(page)+'&size=30&order=desc&orderby=percent&order_by=percent&market=CN&type=sh_sz'

    response=requests.get(url=url,headers=headers)

    json_data=response.json()
    # response.text()
    # response.content()
    for index in json_data['data']['list']:
        dict={
            '股票代码':index['symbol'],
            '股票名称': index['name'],
            '当前价': index['current'],
        }
        # print(dict)
        content_list.append(dict)
        csv_writer.writerow(dict)

data=pd.DataFrame(content_list)
data.to_excel("股票.xlsx",index=False)