scrapy 无法从表中导入数据

kninwzqo  于 2023-06-29  发布在  其他
关注(0)|答案(1)|浏览(94)

首先,我是新的这个“scrapy”和“Python”我最近开始我的CE学位,请耐心哈哈哈。我正在尝试使用表中的数据(站点URL:https://www.fundsexplorer.com.br/ranking)但是我看到的关于网页抓取的指南我只是不能从网站的表中抓取数据,我认为表的结构与我用来训练lol的简单结构非常不同。如果有人能帮助我,我会很高兴,至少能够从行中抓取数据。
Thx很多。
下面是我尝试的代码的开头:
PS:我知道它的incomplete,这是因为在这个项目后约4小时试图得到的数据,我只是愤怒退出哈哈。

import scrapy
    
    class FiispiderSpider(scrapy.Spider):
        name = "fiispider"
        allowed_domains = ["fundsexplorer.com.br"]
        start_urls = ["https://fundsexplorer.com.br/ranking"]
    
        def parse(self, response):
            rows = response.css('table.default-fiis-table__container__table tr')
            for row in rows: 
                yield {
                    'name': 
                }
            
    
            #table = response.css('table.default-fiis-table__container__table')`
toe95027

toe950271#

表的数据是动态获取的。如果你在浏览器开发工具的网络标签中看到,你会发现数据是通过 AJAX 调用https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking得到的。为了得到每一行,你只需要查询url,从json转换它,然后产生对象列表中的每一行。您还需要从浏览器的请求头中获取X-Funds-Nonce令牌的值,并将其附加到您的scrapy请求中。
例如:

import scrapy
import json

headers = {"X-Funds-Nonce":" 61495f60b533cc40ad822e054998a3190ea9bca0d94791a1da"}

class FiispiderSpider(scrapy.Spider):
    name = "fiispider"
    allowed_domains = ["fundsexplorer.com.br"]
    
    def start_requests(self):
        start_urls = ["https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking"]
        for url in start_urls:
            yield scrapy.Request(url, headers=headers)

    def parse(self, response):
        for row in json.loads(response.json()):
            yield row

部分输出

{'post_id': '451', 'ticker': 'WPLZ11', 'dividendo': '0.4000', 'yeld': '0.6500', 'media_yield_3m': '0.6267', 'soma_yield_3m': '1.8800', 'media_yield_6m': '0.6467', 'soma_yield_6m': '3.8800'
, 'media_yield_12m': '0.6467', 'soma_yield_12m': '7.7600', 'variacao_cotacao_mes': '-0.3710', 'rentabilidade': '-21.1828', 'rentabilidade_mes': '0.2766', 'cotacao_fechamento': '61.7600', '
soma_yield_ano_corrente': '3.1400', 'ano': '2023', 'vpa_yield': '0.5826', 'vpa': '102.9900', 'vpa_change': '0.0551', 'pl': '105130234.6700', 'vpa_rent': '4.6842', 'vpa_rent_m': '0.6380', '
yield_vpa_3m_sum': '1.5542', 'yield_vpa_3m': '0.5181', 'yield_vpa_6m_sum': '2.8665', 'yield_vpa_6m': '0.4778', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Shoppings', 'seto
r_slug': 'shoppings', 'valor': '63.8', 'liquidezmediadiaria': '3339.61', 'patrimonio': '89762305.91', 'pvp': '0.7278', 'p_vpa': 0.6194776191863288, 'post_title': 'WPLZ11', 'v_fisica': None
, 'v_financeira': None, 'ativos': '1'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '365', 'ticker': 'WTSP11B', 'dividendo': '0.1900', 'yeld': '0.0000', 'media_yield_3m': '0.2000', 'soma_yield_3m': '0.6000', 'media_yield_6m': '0.5050', 'soma_yield_6m': '3.0300
', 'media_yield_12m': '0.6475', 'soma_yield_12m': '7.7700', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': None, 'rentabilidade_mes': '0.0000', 'cotacao_fechamento': None, 'soma_yield_
ano_corrente': '1.7900', 'ano': '2023', 'vpa_yield': '0.4021', 'vpa': '78.9232', 'vpa_change': '0.6897', 'pl': '78336432.2500', 'vpa_rent': '5.1059', 'vpa_rent_m': '1.0946', 'yield_vpa_3m_
sum': None, 'yield_vpa_3m': None, 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Misto', 'setor_slug': 'misto', 'valor': '35.05
', 'liquidezmediadiaria': '1071.09', 'patrimonio': '71950652.95', 'pvp': '0.4828', 'p_vpa': 0.4441026212824619, 'post_title': 'WTSP11B', 'v_fisica': None, 'v_financeira': None, 'ativos': '
2'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '516', 'ticker': 'XPCA11', 'dividendo': '0.1100', 'yeld': '1.1100', 'media_yield_3m': '1.3133', 'soma_yield_3m': '3.9400', 'media_yield_6m': '1.3367', 'soma_yield_6m': '8.0200'
, 'media_yield_12m': '1.3283', 'soma_yield_12m': '15.9400', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': '10.1734', 'rentabilidade_mes': '1.1100', 'cotacao_fechamento': '9.9300', 'so
ma_yield_ano_corrente': '6.5600', 'ano': '2023', 'vpa_yield': '1.3699', 'vpa': '9.4900', 'vpa_change': '-0.0084', 'pl': '317410269.3900', 'vpa_rent': '14.0009', 'vpa_rent_m': '1.3613', 'yi
eld_vpa_3m_sum': '4.4239', 'yield_vpa_3m': '1.4746', 'yield_vpa_6m_sum': '8.8416', 'yield_vpa_6m': '1.4736', 'yield_vpa_12m_sum': '15.9624', 'yield_vpa_12m': '1.4511', 'setor': 'Indefinido
', 'setor_slug': 'indefinido', 'valor': '9.55', 'liquidezmediadiaria': '1921021.24', 'patrimonio': '317410269.39', 'pvp': '1.0443', 'p_vpa': 1.0063224446786092, 'post_title': 'XPCA11', 'v_
fisica': None, 'v_financeira': None, 'ativos': '0'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '211', 'ticker': 'XPCI11', 'dividendo': '0.9300', 'yeld': '1.1100', 'media_yield_3m': '1.1167', 'soma_yield_3m': '3.3500', 'media_yield_6m': '1.1183', 'soma_yield_6m': '6.7100'
, 'media_yield_12m': '1.0308', 'soma_yield_12m': '12.3700', 'variacao_cotacao_mes': '4.7930', 'rentabilidade': '8.8637', 'rentabilidade_mes': '5.9562', 'cotacao_fechamento': '83.5200', 'so
ma_yield_ano_corrente': '5.8200', 'ano': '2023', 'vpa_yield': '0.6408', 'vpa': '93.6283', 'vpa_change': '-1.9679', 'pl': '814711734.7600', 'vpa_rent': '10.1113', 'vpa_rent_m': '-1.3397', '
yield_vpa_3m_sum': '2.2491', 'yield_vpa_3m': '0.7497', 'yield_vpa_6m_sum': '5.3563', 'yield_vpa_6m': '0.8927', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Papéis', 'setor_s
lug': 'papeis', 'valor': '86.64', 'liquidezmediadiaria': '1830912.37', 'patrimonio': '816616393.65', 'pvp': '0.9126', 'p_vpa': 0.9253612422739707, 'post_title': 'XPCI11', 'v_fisica': None,
 'v_financeira': None, 'ativos': '0'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '347', 'ticker': 'XPCM11', 'dividendo': '0.0800', 'yeld': '0.5800', 'media_yield_3m': '0.6800', 'soma_yield_3m': '2.0400', 'media_yield_6m': '0.8550', 'soma_yield_6m': '5.1300'
, 'media_yield_12m': '0.8817', 'soma_yield_12m': '10.5800', 'variacao_cotacao_mes': '-1.7857', 'rentabilidade': '-0.6816', 'rentabilidade_mes': '-1.2161', 'cotacao_fechamento': '13.7500',
'soma_yield_ano_corrente': '3.5300', 'ano': '2023', 'vpa_yield': '0.3299', 'vpa': '51.5300', 'vpa_change': '-0.7746', 'pl': '124433063.4300', 'vpa_rent': '-2.9679', 'vpa_rent_m': '-0.4473'
, 'yield_vpa_3m_sum': '0.8485', 'yield_vpa_3m': '0.2828', 'yield_vpa_6m_sum': '1.7147', 'yield_vpa_6m': '0.2858', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Lajes Corporat
ivas', 'setor_slug': 'lajes-corporativas', 'valor': '13.75', 'liquidezmediadiaria': '44398.63', 'patrimonio': '103295556.68', 'pvp': '0.3221', 'p_vpa': 0.26683485348340774, 'post_title': '
XPCM11', 'v_fisica': None, 'v_financeira': None, 'ativos': '1'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '222', 'ticker': 'XPHT11', 'dividendo': '1.6500', 'yeld': '1.4500', 'media_yield_3m': '1.3400', 'soma_yield_3m': '4.0200', 'media_yield_6m': '1.2867', 'soma_yield_6m': '7.7200'
, 'media_yield_12m': '1.0625', 'soma_yield_12m': '12.7500', 'variacao_cotacao_mes': '3.6273', 'rentabilidade': '8.2444', 'rentabilidade_mes': '5.1299', 'cotacao_fechamento': '113.9900', 's
oma_yield_ano_corrente': '6.2000', 'ano': '2023', 'vpa_yield': '1.5925', 'vpa': '94.1900', 'vpa_change': '-0.0775', 'pl': '358343595.7100', 'vpa_rent': '6.7411', 'vpa_rent_m': '1.5138', 'y
ield_vpa_3m_sum': '4.8834', 'yield_vpa_3m': '1.6278', 'yield_vpa_6m_sum': '6.2654', 'yield_vpa_6m': '1.0442', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Hotéis', 'setor_sl
ug': 'hoteis', 'valor': '125', 'liquidezmediadiaria': '75306.65', 'patrimonio': '376512967.62', 'pvp': '1.2139', 'p_vpa': 1.3271047881940758, 'post_title': 'XPHT11', 'v_fisica': None, 'v_f
inanceira': None, 'ativos': '12'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '1850', 'ticker': 'XPID11', 'dividendo': '0.4500', 'yeld': '0.5100', 'media_yield_3m': '0.6500', 'soma_yield_3m': '1.9500', 'media_yield_6m': '0.7083', 'soma_yield_6m': '4.2500
', 'media_yield_12m': '0.7000', 'soma_yield_12m': '8.4000', 'variacao_cotacao_mes': '5.1749', 'rentabilidade': '7.4418', 'rentabilidade_mes': '5.7113', 'cotacao_fechamento': '87.8000', 'so
ma_yield_ano_corrente': '6.1700', 'ano': '2023', 'vpa_yield': None, 'vpa': None, 'vpa_change': None, 'pl': None, 'vpa_rent': None, 'vpa_rent_m': None, 'yield_vpa_3m_sum': None, 'yield_vpa_
3m': None, 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Fundo de Desenvolvimento', 'setor_slug': 'fundo-de-desenvolvimento',
'valor': '86.99', 'liquidezmediadiaria': '644698.92', 'patrimonio': '0', 'pvp': '0', 'p_vpa': None, 'post_title': 'XPID11', 'v_fisica': None, 'v_financeira': None, 'ativos': ''}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '396', 'ticker': 'XPIN11', 'dividendo': '0.6500', 'yeld': '0.8200', 'media_yield_3m': '0.8567', 'soma_yield_3m': '2.5700', 'media_yield_6m': '0.8817', 'soma_yield_6m': '5.2900'
, 'media_yield_12m': '0.8525', 'soma_yield_12m': '10.2300', 'variacao_cotacao_mes': '0.6878', 'rentabilidade': '11.6191', 'rentabilidade_mes': '1.5135', 'cotacao_fechamento': '79.0500', 's
oma_yield_ano_corrente': '4.4100', 'ano': '2023', 'vpa_yield': '0.6261', 'vpa': '103.8115', 'vpa_change': '-1.3709', 'pl': '742296242.1900', 'vpa_rent': '0.7513', 'vpa_rent_m': '-0.7533',
'yield_vpa_3m_sum': '1.8454', 'yield_vpa_3m': '0.6151', 'yield_vpa_6m_sum': '3.5387', 'yield_vpa_6m': '0.5898', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Imóveis Industri
ais e Logísticos', 'setor_slug': 'imoveis-industriais-e-logisticos', 'valor': '80', 'liquidezmediadiaria': '416218', 'patrimonio': '729955133.15', 'pvp': '0.7822', 'p_vpa': 0.7706275316318
52, 'post_title': 'XPIN11', 'v_fisica': None, 'v_financeira': None, 'ativos': '98'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '275', 'ticker': 'XPLG11', 'dividendo': '0.7500', 'yeld': '0.7100', 'media_yield_3m': '0.7433', 'soma_yield_3m': '2.2300', 'media_yield_6m': '0.7633', 'soma_yield_6m': '4.5800'
, 'media_yield_12m': '0.7350', 'soma_yield_12m': '8.8200', 'variacao_cotacao_mes': '5.9000', 'rentabilidade': '11.0401', 'rentabilidade_mes': '6.6519', 'cotacao_fechamento': '105.9000', 's
oma_yield_ano_corrente': '3.8300', 'ano': '2023', 'vpa_yield': '0.6463', 'vpa': '114.4897', 'vpa_change': '0.1879', 'pl': '3102791995.7500', 'vpa_rent': '11.4711', 'vpa_rent_m': '0.8355',
'yield_vpa_3m_sum': '1.9418', 'yield_vpa_3m': '0.6473', 'yield_vpa_6m_sum': '3.8230', 'yield_vpa_6m': '0.6372', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Imóveis Industri
ais e Logísticos', 'setor_slug': 'imoveis-industriais-e-logisticos', 'valor': '112.12', 'liquidezmediadiaria': '3947504.74', 'patrimonio': '3073592158.93', 'pvp': '0.9884', 'p_vpa': 0.9793
020682209841, 'post_title': 'XPLG11', 'v_fisica': None, 'v_financeira': None, 'ativos': '19'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '373', 'ticker': 'XPML11', 'dividendo': '0.8100', 'yeld': '0.7800', 'media_yield_3m': '0.7900', 'soma_yield_3m': '2.3700', 'media_yield_6m': '0.8117', 'soma_yield_6m': '4.8700'
, 'media_yield_12m': '0.7717', 'soma_yield_12m': '9.2600', 'variacao_cotacao_mes': '1.2136', 'rentabilidade': '9.8169', 'rentabilidade_mes': '2.0031', 'cotacao_fechamento': '104.2500', 'so
ma_yield_ano_corrente': '3.9600', 'ano': '2023', 'vpa_yield': '0.7603', 'vpa': '101.2739', 'vpa_change': '-0.6573', 'pl': '2057877597.2300', 'vpa_rent': '6.5638', 'vpa_rent_m': '0.0981', '
yield_vpa_3m_sum': '2.2317', 'yield_vpa_3m': '0.7439', 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Shoppings', 'setor_slug':
 'shoppings', 'valor': '103.91', 'liquidezmediadiaria': '5638116.11', 'patrimonio': '2098002886.54', 'pvp': '1.0585', 'p_vpa': 1.0260294113290789, 'post_title': 'XPML11', 'v_fisica': None,
 'v_financeira': None, 'ativos': '12'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '345', 'ticker': 'XPPR11', 'dividendo': '0.1000', 'yeld': '0.4300', 'media_yield_3m': '0.4167', 'soma_yield_3m': '1.2500', 'media_yield_6m': '0.5717', 'soma_yield_6m': '3.4300'
, 'media_yield_12m': '0.6400', 'soma_yield_12m': '7.6800', 'variacao_cotacao_mes': '1.4680', 'rentabilidade': '-25.3158', 'rentabilidade_mes': '1.9044', 'cotacao_fechamento': '23.5000', 's
oma_yield_ano_corrente': '2.5000', 'ano': '2023', 'vpa_yield': '0.4012', 'vpa': '74.7687', 'vpa_change': '0.0522', 'pl': '547020346.8600', 'vpa_rent': '-3.6491', 'vpa_rent_m': '0.4536', 'y
ield_vpa_3m_sum': '1.1993', 'yield_vpa_3m': '0.3998', 'yield_vpa_6m_sum': '2.5088', 'yield_vpa_6m': '0.4181', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Lajes Corporativas
', 'setor_slug': 'lajes-corporativas', 'valor': '23.08', 'liquidezmediadiaria': '260064.03', 'patrimonio': '521188970.44', 'pvp': '0.3255', 'p_vpa': 0.3086853188566874, 'post_title': 'XPPR
11', 'v_fisica': None, 'v_financeira': None, 'ativos': '5'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '399', 'ticker': 'XPSF11', 'dividendo': '0.0760', 'yeld': '1.0200', 'media_yield_3m': '1.0600', 'soma_yield_3m': '3.1800', 'media_yield_6m': '1.0517', 'soma_yield_6m': '6.3100'
, 'media_yield_12m': '1.0208', 'soma_yield_12m': '12.2500', 'variacao_cotacao_mes': '5.3824', 'rentabilidade': '3.1943', 'rentabilidade_mes': '6.4573', 'cotacao_fechamento': '7.4400', 'som
a_yield_ano_corrente': '5.3000', 'ano': '2023', 'vpa_yield': '0.9016', 'vpa': '8.5400', 'vpa_change': '-4.0449', 'pl': '369792382.0500', 'vpa_rent': '-89.4039', 'vpa_rent_m': '-3.1798', 'y
ield_vpa_3m_sum': '2.6153', 'yield_vpa_3m': '0.8718', 'yield_vpa_6m_sum': '5.1091', 'yield_vpa_6m': '0.8515', 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Fundo de Fundos',
'setor_slug': 'fundo-de-fundos', 'valor': '8.04', 'liquidezmediadiaria': '588485.76', 'patrimonio': '365478307.57', 'pvp': '0.9455', 'p_vpa': 0.9414519906323185, 'post_title': 'XPSF11', 'v
_fisica': None, 'v_financeira': None, 'ativos': '0'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '174', 'ticker': 'XTED11', 'dividendo': '11.1600', 'yeld': None, 'media_yield_3m': None, 'soma_yield_3m': None, 'media_yield_6m': None, 'soma_yield_6m': None, 'media_yield_12m'
: None, 'soma_yield_12m': None, 'variacao_cotacao_mes': None, 'rentabilidade': None, 'rentabilidade_mes': None, 'cotacao_fechamento': None, 'soma_yield_ano_corrente': None, 'ano': None, 'v
pa_yield': '0.0000', 'vpa': '28.0218', 'vpa_change': '-0.3575', 'pl': '50230589.4700', 'vpa_rent': '-3.4450', 'vpa_rent_m': '-0.3575', 'yield_vpa_3m_sum': '0.0000', 'yield_vpa_3m': '0.0000
', 'yield_vpa_6m_sum': '0.0000', 'yield_vpa_6m': '0.0000', 'yield_vpa_12m_sum': '0.0000', 'yield_vpa_12m': '0.0000', 'setor': 'Lajes Corporativas', 'setor_slug': 'lajes-corporativas', 'val
or': '8.82', 'liquidezmediadiaria': '17641.88', 'patrimonio': '67378204.04', 'pvp': '0.6771', 'p_vpa': 0.3147549407960945, 'post_title': 'XTED11', 'v_fisica': None, 'v_financeira': None, '
ativos': '1'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '175', 'ticker': 'YUFI11', 'dividendo': '0.1524', 'yeld': '0.1500', 'media_yield_3m': '0.1300', 'soma_yield_3m': '0.3900', 'media_yield_6m': '0.0650', 'soma_yield_6m': '0.3900'
, 'media_yield_12m': '0.0433', 'soma_yield_12m': '0.3900', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': None, 'rentabilidade_mes': '0.0000', 'cotacao_fechamento': '105.0000', 'soma_y
ield_ano_corrente': '0.3900', 'ano': '2023', 'vpa_yield': None, 'vpa': None, 'vpa_change': None, 'pl': None, 'vpa_rent': None, 'vpa_rent_m': None, 'yield_vpa_3m_sum': None, 'yield_vpa_3m':
 None, 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Fundo de Desenvolvimento', 'setor_slug': 'fundo-de-desenvolvimento', 'val
or': '80.84', 'liquidezmediadiaria': '2895.93', 'patrimonio': '50073483.72', 'pvp': '0.7954', 'p_vpa': None, 'post_title': 'YUFI11', 'v_fisica': None, 'v_financeira': None, 'ativos': '28'}

2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '537', 'ticker': 'YUFI11B', 'dividendo': '0.6331', 'yeld': '0.0000', 'media_yield_3m': '0.0000', 'soma_yield_3m': '0.0000', 'media_yield_6m': '0.0000', 'soma_yield_6m': '0.0000
', 'media_yield_12m': '0.0000', 'soma_yield_12m': '0.0000', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': '0.0000', 'rentabilidade_mes': '0.0000', 'cotacao_fechamento': '0.0000', 'som
a_yield_ano_corrente': None, 'ano': '2022', 'vpa_yield': '0.5999', 'vpa': '105.5322', 'vpa_change': '-0.0137', 'pl': '41701052.9800', 'vpa_rent': '6.3235', 'vpa_rent_m': '0.5861', 'yield_v
pa_3m_sum': None, 'yield_vpa_3m': None, 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Indefinido', 'setor_slug': 'indefinido',
 'valor': None, 'liquidezmediadiaria': None, 'patrimonio': None, 'pvp': None, 'p_vpa': None, 'post_title': 'YUFI11B', 'v_fisica': None, 'v_financeira': None, 'ativos': '0'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '1866', 'ticker': 'ZAVI11', 'dividendo': '1.1000', 'yeld': '0.8700', 'media_yield_3m': '0.8700', 'soma_yield_3m': '2.6100', 'media_yield_6m': '0.8617', 'soma_yield_6m': '5.1700
', 'media_yield_12m': '0.8686', 'soma_yield_12m': '6.0800', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': '1.0929', 'rentabilidade_mes': '0.8700', 'cotacao_fechamento': '126.0000', 's
oma_yield_ano_corrente': '4.2300', 'ano': '2023', 'vpa_yield': None, 'vpa': None, 'vpa_change': None, 'pl': None, 'vpa_rent': None, 'vpa_rent_m': None, 'yield_vpa_3m_sum': None, 'yield_vpa
_3m': None, 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Indefinido', 'setor_slug': 'indefinido', 'valor': '125.8', 'liquidez
mediadiaria': '93518.97', 'patrimonio': '118026295.42', 'pvp': '0.9891', 'p_vpa': None, 'post_title': 'ZAVI11', 'v_fisica': None, 'v_financeira': None, 'ativos': '8'}
2023-06-23 21:49:08 [scrapy.core.scraper] DEBUG: Scraped from <200 https://www.fundsexplorer.com.br/wp-json/funds/v1/get-ranking>
{'post_id': '295', 'ticker': 'ZIFI11', 'dividendo': '3.3050', 'yeld': '0.0000', 'media_yield_3m': '0.0000', 'soma_yield_3m': '0.0000', 'media_yield_6m': '0.0000', 'soma_yield_6m': '0.0000'
, 'media_yield_12m': '0.0000', 'soma_yield_12m': '0.0000', 'variacao_cotacao_mes': '0.0000', 'rentabilidade': None, 'rentabilidade_mes': '0.0000', 'cotacao_fechamento': None, 'soma_yield_a
no_corrente': '0.0000', 'ano': '2022', 'vpa_yield': None, 'vpa': None, 'vpa_change': None, 'pl': None, 'vpa_rent': None, 'vpa_rent_m': None, 'yield_vpa_3m_sum': None, 'yield_vpa_3m': None,
 'yield_vpa_6m_sum': None, 'yield_vpa_6m': None, 'yield_vpa_12m_sum': None, 'yield_vpa_12m': None, 'setor': 'Fundo de Desenvolvimento', 'setor_slug': 'fundo-de-desenvolvimento', 'valor': '
1000', 'liquidezmediadiaria': '12438.73', 'patrimonio': '57357479.19', 'pvp': '0.8279', 'p_vpa': None, 'post_title': 'ZIFI11', 'v_fisica': None, 'v_financeira': None, 'ativos': '0'}

相关问题