Table des matières

Ce script récupère les cours boursiers actuels depuis l’API Twelve Data et met à jour les lignes correspondantes dans une table SeaTable.

You need a free API key from Twelve Data and a table with columns Symbol (text) and Price (number).

from seatable_api import Base, context
import requests

base = Base(context.api_token, context.server_url)
base.auth()

TABLE_NAME = "Stocks"
API_KEY = "your-api-key"

rows = base.list_rows(TABLE_NAME)
for row in rows:
    symbol = row.get('Symbol')
    if not symbol:
        continue

    url = f"https://api.twelvedata.com/price?symbol={symbol}&apikey={API_KEY}"
    response = requests.get(url)
    data = response.json()

    if 'price' in data:
        base.update_row(TABLE_NAME, row['_id'], {
            'Price': float(data['price'])
        })
        print(f"{symbol}: {data['price']}")

print("Stock prices updated.")

You can replace the Twelve Data API with any other financial data provider. Adjust the URL and response parsing accordingly.

For the complete function reference, visit the SeaTable Developer Manual .