使用Python和BeautifulSoup提取CME数据

Question

我想从下面的CME网站上获取一个符号列表，其中包含该符号的相关价格。我可以得到一个符号列表，但我还没有弄清楚如何提取每行的价格

在浏览器上使用“Inspect”时遇到问题，无法查询“span”以外的标记。想让我克服这个问题吗

代码：

import urllib
from requests import get
from requests.exceptions import RequestException
from contextlib import closing
from bs4 import BeautifulSoup

def simple_get(url):
    """
    Attempts to get the content at `url` by making an HTTP GET request.
    If the content-type of response is some kind of HTML/XML, return the
    text content, otherwise return None.
    """
    try:
        with closing(get(url, stream=True)) as resp:
            if is_good_response(resp):
                return resp.content
            else:
                return None

    except RequestException as e:
        log_error('Error during requests to {0} : {1}'.format(url, str(e)))
        return None

def is_good_response(resp):
    """
    Returns True if the response seems to be HTML, False otherwise.
    """
    content_type = resp.headers['Content-Type'].lower()
    return (resp.status_code == 200 
            and content_type is not None 
            and content_type.find('html') > -1)

def log_error(e):
    print(e)

raw_html = simple_get('https://www.cmegroup.com/trading/price-limits.html#equityIndex')
html = BeautifulSoup(raw_html, 'html.parser', store_line_numbers=True)
seq = ['ESM0', 'NQM0', 'RTYM0', 'YMM0'] 

for quote in html.find_all('span'):
    symbolcme = quote.get_text(strip=True)
    #print("Check Symbol: ", symbolcme)
    for text in seq:
        if text in symbolcme: 
            print(quote.sourceline, ' Symbol:', symbolcme)

结果:

2014  Symbol: E-mini S&P 500 Futures (ESM0)
2047  Symbol: E-mini Nasdaq-100 Futures (NQM0)
2065  Symbol: E-mini Dow ($5) Futures (YMM0)
2392  Symbol: E-mini  Russell 2000 Index Futures (RTYM0)
2500  Symbol: Micro E-mini Dow Jones Industrial Average Index Futures (MYMM0)
2515  Symbol: Micro E-mini Nasdaq-100 Index Futures (MNQM0)
2551  Symbol: Micro E-mini S&P 500 Index Futures (MESM0)

Answer 1

BeautifulSoup的^{}和^{}在这里配合得很好，假设您希望价格与打印的报价在同一行

for quote in html.find_all('span'):
    symbolcme = quote.get_text(strip=True)
    for text in seq:
        if text in symbolcme:
            print(quote.sourceline, ' Symbol:', symbolcme)
            prices = [sibling.get_text() for sibling in quote.parent.next_siblings]
            print(prices)

输出：

2015  Symbol: E-mini S&P 500 Futures (ESM0)
['240000', '252000 / 228000', '223150', '208700', '191850']
2048  Symbol: E-mini Nasdaq-100 Futures (NQM0)
['726475', '762900 / 690050', '675475', '631725', '580725']
2066  Symbol: E-mini Dow ($5) Futures (YMM0)
['19951', '20955 / 18947', '18545', '17340', '15934']
2393  Symbol: E-mini  Russell 2000 Index Futures (RTYM0)
['104070', '109360 / 98780', '96660', '90310', '82900']