import requests
import time
from bs4 import BeautifulSoup
# Define the URL to retrieve the data from
url = ‘https://etfdb.com/etfs/leveraged/all/’
# Define the function to retrieve the latest prices
def get_latest_prices():
response = requests.get(url)
soup = BeautifulSoup(response.content, ‘html.parser’)
table = soup.find(‘table’, {‘class’: ‘etfs table table-hover table-bordered table-striped table-responsive-xs’})
rows = table.findAll(‘tr’)
prices = {}
for row in rows[1:]:
cells = row.findAll(‘td’)
symbol = cells[1].text.strip()
price = cells[2].text.strip()
prices[symbol] = price
return prices
# Define the function to update the table on your website
def update_table(prices):
# Implement your code to update the table on your website here
# You may need to use a web scraping library or an API to update the table
# Main loop to retrieve and update prices every 5 minutes
while True:
prices = get_latest_prices()
update_table(prices)
time.sleep(300) # Sleep for 5 minutes