Jeg blev kontaktet per mail og spurgt, om jeg ikke kunne hjælpe med at få udtrukket denne liste over historiske afkast fra Nordnet.
Den slags har jeg efterhånden så meget rutine i, at dette program ikke tog lang tid at skrive:
import requests, csv
from bs4 import BeautifulSoup
finished = False
page = 1
with open('stocks.csv', 'w', newline='') as csvfile:
writer = csv.writer(csvfile)
while finished == False:
url = f'https://www.nordnet.dk/markedet/aktiekurser?sortField=yield_10y&sortOrder=descending&selectedTab=historical&page={page}'
request = requests.get(url)
soup = BeautifulSoup(request.text, 'lxml')
table = soup.select('div[class*="FlexTable__StyledDiv-"]')[0]
if page==1:
headers = []
header = table.select('div[class*="HeaderRow__StyledHeaderRow-"]')[0]
spans = header.find_all('span')
for span in spans:
span_content = span.string
if span_content and not 'Køb' in span_content and not 'Sælg' in span_content:
headers.append(span_content)
writer.writerow(headers)
rows = table.select('div[class*="Row__StyledRow-"]')
if len(rows) == 1:
finished = True
break
for row in rows[1:]:
cells = row.select('div[role="cell"]')
csv_row =[]
for cell in cells:
cell_content = cell.get_text()
if cell_content and not 'KøbSælg' in cell_content:
# Some companies do not have a logo an instead have the first letter of the
# company name displayed. This letter is removed.
if not cell.select('img') and cell.select('div[class*="NestedBadgestyles__"]'):
cell_content = cell_content[1:]
csv_row.append(cell_content)
writer.writerow(csv_row)
page += 1