python爬取欧易okey所有虚拟货币价格

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

python爬取欧易okey虚拟货币实时价格

import d#自定义设置路径函数
from mysql import *
import mysql#mysql为自定义函数库，在我的csdn博客资源中下载，用户名：sirhzx
from selenium import webdriver
browser=webdriver.Chrome()
browser.get("https://www.ouyicn.gift/markets/spot-list")


# 以下为发送叮叮消息
from dingtalkchatbot.chatbot import DingtalkChatbot
from dingtalkchatbot   import  *
def send_msg(msg):
    webhook='*********'#(webhook需要在叮叮群聊机器人中获取，复制到此处)
    xiaoding=DingtalkChatbot(webhook)
    at_mobiles = ['123456']#这里填写需要提醒的用户的手机号码，字符串或数字都可以
    try:
        xiaoding.send_text(msg=msg,at_mobiles=at_mobiles)
        print('消息发送成功')
    except:
        print('消息发送失败')
send_msg('可以正常发送消息')


# 以下为提取虚拟货币对价格和名称
data=browser.page_source
# print(data)
import re,time
ltc='>[$](.*?)</span></div>'
eurusd=re.findall(ltc,data,re.S)#提取价格
eurusd
k=[]
for i in range(len(eurusd)):
    c=eurusd.replace(',','ss')
#     print(c)
    k.append(c)
eurusd=k
eurusd


# 正则表达式提取虚拟货币名称
name_p='<div class="short">(.*?)</div>'
name=re.findall(name_p,data,re.S)
name






# 以下为新建mysql表格用于存入数据，然后循环添加爬取到的名称为列
show_db()
# database('crypto')
use('crypto')
drop_tb('crypto')
table('crypto','id')
# add_col('crypto','id')
# delete_col('crypto','price')
show_tb()
show_value('crypto')
def add_col1(table_name,col_name):
    sql=f'alter table {table_name} add {col_name} text null;'
    cursor.execute(sql)
   
for i in range(len(name)):
    namei=name.replace('/','111')
    print(namei)
    add_col1('crypto',namei)
   
show_value('crypto')
db.commit()






# 循环爬取写入sql数据库,将爬取到的价格字符串数据转变为列表数值后用于判断
import re,time
price=[]
a=43318
b=41578
while True:
    data=browser.page_source
    ltc='<div class="last-num">₮(.*?)<span class=".*?">'
    eurusd=re.findall(ltc,data,re.S)
    name=eurusd
    k=[]
    for i in range(len(name)):
        cc=name.replace(',','')
        cc=float(cc)
        k.append(cc)
    price.append(k)
    sql='insert into crypto(BTC111USDT,ETH111USDT,OKB111USDT,OKT111USDT,LTC111USDT,DOT111USDT,DOGE111USDT,LUNA111USDT,PEOPLE111USDT,SHIB111USDT,SLP111USDT,SOL111USDT,METIS111USDT,JOE111USDT,DOME111USDT,1INCH111USDT,AAC111USDT,AAVE111USDT,ABT111USDT,ACA111USDT,ACT111USDT,ADA111USDT,AE111USDT,AERGO111USDT,AGLD111USDT,AKITA111USDT,ALCX111USDT,ALGO111USDT,ALPHA111USDT,ALV111USDT,ANC111USDT,ANT111USDT,ANW111USDT,API3111USDT,APIX111USDT,APM111USDT,AR111USDT,ARK111USDT,AST111USDT,ASTR111USDT,ATOM111USDT,AUCTION111USDT,AVAX111USDT,AXS111USDT,BABYDOGE111USDT,BADGER111USDT,BAL111USDT,BAND111USDT,BAT111USDT,BCD111USDT,BCH111USDT,BETH111USDT,BHP111USDT,BICO111USDT,BLOC111USDT,BLOK111USDT,BNT111USDT,BORING111USDT,BOX111USDT,BSV111USDT,BTG111USDT,BTM111USDT,BTT111USDT,BZZ111USDT,CELO111USDT,CELR111USDT,CEL111USDT,CELT111USDT,CFX111USDT,CFG111USDT,CGS111USDT,CHAT111USDT,CHE111USDT,CHZ111USDT,CRV111USDT,CLV111USDT,CMT111USDT,CNTM111USDT,CONV111USDT,COMP111USDT,COVER111USDT,CQT111USDT,CRO111USDT,CSPR111USDT,CTC111USDT,CTXC111USDT,CVC111USDT,CVP111USDT,CVT111USDT,CVX111USDT,DAI111USDT,DAO111USDT,DASH111USDT,DCR111USDT,DEP111USDT,DEVT111USDT,DGB111USDT,DHT111USDT,DIA111USDT,DMD111USDT,DMG111USDT,DNA111USDT,DORA111USDT,DOSE111USDT,DYDX111USDT,EC111USDT,EDEN111USDT,EFI111USDT,EGLD111USDT,EGT111USDT,ELF111USDT,ELON111USDT,EM111USDT,ENJ111USDT,ENS111USDT,EOS111USDT,ERN111USDT,ETC111USDT,ETM111USDT,EXE111USDT,FAIR111USDT,FIL111USDT,FLOW111USDT,FLM111USDT,FODL111USDT,FORTH111USDT,FRONT111USDT,FSN111USDT,FTM111USDT,GAS111USDT,GAL111USDT,GALA111USDT,GF111USDT,GARI111USDT,GHST111USDT,GLM111USDT,GLMR111USDT,GODS111USDT,GM111USDT,GOG111USDT,GRT111USDT,GTO111USDT,GUSD111USDT,HBAR111USDT,HC111USDT,HDAO111USDT,HEGIC111USDT,HYC111USDT,ICP111USDT,ICX111USDT,ILV111USDT,IMX111USDT,INT111USDT,INX111USDT,IOST111USDT,IOTA111USDT,IQ111USDT,ITC111USDT,JFI111USDT,JST111USDT,KAN111USDT,KAR111USDT,KCASH111USDT,KDA111USDT,KINE111USDT,KISHU111USDT,KLAY111USDT,KNC111USDT,KOL111USDT,KONO111USDT,KP3R111USDT,KSM111USDT,LAT111USDT,LAMB111USDT,LBA111USDT,LDN111USDT,LEO111USDT,LEASH111USDT,LET111USDT,LINK111USDT,LITH111USDT,LMCH111USDT,LON111USDT,LOOKS111USDT,LOON111USDT,LPT111USDT,LRC111USDT,LSK111USDT,MANA111USDT,MASK111USDT,MATIC111USDT,MCO111USDT,MDA111USDT,MDT111USDT,MEME111USDT,MINA111USDT,MIR111USDT,MITH111USDT,MKR111USDT,MLN111USDT,MOF111USDT,MON111USDT,MOVR111USDT,MXC111USDT,MXT111USDT,NANO111USDT,NAS111USDT,NDN111USDT,NEAR111USDT,NEO111USDT,NMR111USDT,NFT111USDT,NU111USDT,NULS111USDT,OMG111USDT,OM111USDT,OMI111USDT,ONE111USDT,ONT111USDT,ORBS111USDT,ORS111USDT,OXT111USDT,PAX111USDT,PAY111USDT,PERP111USDT,PHA111USDT,PICKLE111USDT,PLG111USDT,PNK111USDT,POLS111USDT,POLYDOGE111USDT,PPT111USDT,PROPS111USDT,PRQ111USDT,PST111USDT,QTUM111USDT,RACA111USDT,RAY111USDT,REN111USDT,REP111USDT,REVV111USDT,RFUEL111USDT,RIO111USDT,RNT111USDT,ROAD111USDT,RON111USDT,RSR111USDT,RVN111USDT,SAND111USDT,SAMO111USDT,SC111USDT,SFG111USDT,SKL111USDT,SIS111USDT,SNT111USDT,SNX111USDT,SOC111USDT,SOS111USDT,SPELL111USDT,SRM111USDT,STARL111USDT,STORJ111USDT,STRK111USDT,STX111USDT,SUN111USDT,SUSHI111USDT,SWFTC111USDT,SWRV111USDT,TAI111USDT,TCT111USDT,THETA111USDT,THG111USDT,TMTG111USDT,TONCOIN111USDT,TOPC111USDT,TORN111USDT,TOWN111USDT,TRA111USDT,TRADE111USDT,TRB111USDT,TRIO111USDT,TRUE111USDT,TRX111USDT,TUSD111USDT,TUP111USDT,UBTC111USDT,UMA111USDT,UNI111USDT,USDC111USDT,UST111USDT,UTK111USDT,VALUE111USDT,VELO111USDT,VIB111USDT,VRA111USDT,VSYS111USDT,WAVES111USDT,WBTC111USDT,WEMIX111USDT,WGRT111USDT,WIN111USDT,WING111USDT,WNCG111USDT,WNXM111USDT,WOO111USDT,WSB111USDT,WTC111USDT,WXT111USDT,XCH111USDT,XEC111USDT,XEM111USDT,XLM111USDT,XMR111USDT,XPO111USDT,XPR111USDT,XRP111USDT,XSR111USDT,XTZ111USDT,XUC111USDT,YEE111USDT,YFI111USDT,YFII111USDT,YGG111USDT,YOU111USDT,YOYO111USDT,ZEC111USDT,ZEN111USDT,ZIL111USDT,ZKS111USDT,ZRX111USDT,ZYRO111USDT)  values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);'
    cursor.execute(sql,(name[0],name[1],name[2],name[3],name[4],name[5],name[6],name[7],name[8],name[9],name[10],name[11],name[12],name[13],name[14],name[15],name[16],name[17],name[18],name[19],name[20],name[21],name[22],name[23],name[24],name[25],name[26],name[27],name[28],name[29],name[30],name[31],name[32],name[33],name[34],name[35],name[36],name[37],name[38],name[39],name[40],name[41],name[42],name[43],name[44],name[45],name[46],name[47],name[48],name[49],name[50],name[51],name[52],name[53],name[54],name[55],name[56],name[57],name[58],name[59],name[60],name[61],name[62],name[63],name[64],name[65],name[66],name[67],name[68],name[69],name[70],name[71],name[72],name[73],name[74],name[75],name[76],name[77],name[78],name[79],name[80],name[81],name[82],name[83],name[84],name[85],name[86],name[87],name[88],name[89],name[90],name[91],name[92],name[93],name[94],name[95],name[96],name[97],name[98],name[99],name[100],name[101],name[102],name[103],name[104],name[105],name[106],name[107],name[108],name[109],name[110],name[111],name[112],name[113],name[114],name[115],name[116],name[117],name[118],name[119],name[120],name[121],name[122],name[123],name[124],name[125],name[126],name[127],name[128],name[129],name[130],name[131],name[132],name[133],name[134],name[135],name[136],name[137],name[138],name[139],name[140],name[141],name[142],name[143],name[144],name[145],name[146],name[147],name[148],name[149],name[150],name[151],name[152],name[153],name[154],name[155],name[156],name[157],name[158],name[159],name[160],name[161],name[162],name[163],name[164],name[165],name[166],name[167],name[168],name[169],name[170],name[171],name[172],name[173],name[174],name[175],name[176],name[177],name[178],name[179],name[180],name[181],name[182],name[183],name[184],name[185],name[186],name[187],name[188],name[189],name[190],name[191],name[192],name[193],name[194],name[195],name[196],name[197],name[198],name[199],name[200],name[201],name[202],name[203],name[204],name[205],name[206],name[207],name[208],name[209],name[210],name[211],name[212],name[213],name[214],name[215],name[216],name[217],name[218],name[219],name[220],name[221],name[222],name[223],name[224],name[225],name[226],name[227],name[228],name[229],name[230],name[231],name[232],name[233],name[234],name[235],name[236],name[237],name[238],name[239],name[240],name[241],name[242],name[243],name[244],name[245],name[246],name[247],name[248],name[249],name[250],name[251],name[252],name[253],name[254],name[255],name[256],name[257],name[258],name[259],name[260],name[261],name[262],name[263],name[264],name[265],name[266],name[267],name[268],name[269],name[270],name[271],name[272],name[273],name[274],name[275],name[276],name[277],name[278],name[279],name[280],name[281],name[282],name[283],name[284],name[285],name[286],name[287],name[288],name[289],name[290],name[291],name[292],name[293],name[294],name[295],name[296],name[297],name[298],name[299],name[300],name[301],name[302],name[303],name[304],name[305],name[306],name[307],name[308],name[309],name[310],name[311],name[312],name[313],name[314],name[315],name[316],name[317],name[318],name[319],name[320],name[321],name[322],name[323],name[324],name[325],name[326],name[327],name[328],name[329],name[330]))
    print('添加成功')
    time.sleep(3)
#     对价格进行判断
    try:
        if price[-1][0]>a:#
            print('收盘价首次突破a')
            send_msg('收盘价首次突破a')
        elif price[-1][0]:#
            print('收盘价首次跌破b')
            send_msg('收盘价首次跌破b')
        else:
            pass
    except:
        print('判断程序异常')
   
   

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：python 虚拟货币 Key database browser 爬虫 虚拟货币 欧易okey