Strompreise-Check

Strompreis Dashboard

Börsenstrompreise Dashboard

EPEX SPOT Day-Ahead (Spotmarkt)
Zeitkorrektur: automatisch an lokale Zeit angepasst
Die Preise für den Folgetag stehen täglich ab ca. 13:30 Uhr zur Verfügung

Auswahl:

Börse (Aktuell) —

Preise inkl. Börsenstrompreis, Vermarktungsentgelt, Netzentgelte, Umlagen bzw. Abgaben und Steuern

inkl. Vermarktungsentgelt (1,80 ct/kWh netto). Preisstand Netzentgelte und Umlagen: 01.01.2026

Netzbetreiber: SW Buchen
(+17,34 ct/kWh netto | +20,63 ct/kWh brutto) —

Netzbetreiber: Netze BW
(+15,69 ct/kWh netto | +18,67 ct/kWh brutto) —

Tages- & Langzeit-Durchschnitte

Berechnet aus dem Durchschnitt aller Viertelstunden-Werte des Tages ohne Mengengewichtung.

Börse (Tag) —

Börse (Monatsdurchschnitt) —

Börse (Jahresdurchschnitt) —

Datenquelle: Bundesnetzagentur | SMARD.de

<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
    <style>
        * { box-sizing: border-box; }
        body { font-family: sans-serif; background-color: transparent; color: #2c3e50; padding: 10px; line-height: 1.6; margin: 0; overflow: hidden; }
        .wrap { max-width: 1150px; margin: 0 auto; background: white; padding: 30px; border-radius: 12px; box-shadow: 0 10px 25px rgba(0,0,0,0.1); border-top: 10px solid #3498db; }
        h2 { text-align: center; color: #2c3e50; font-size: 2.2em; margin-bottom: 5px; }
        p.sub { text-align: center; color: #7f8c8d; margin-bottom: 30px; }
        .simple-upload { background-color: #ebf5fb; border: 2px solid #3498db; padding: 30px; text-align: center; border-radius: 8px; margin-bottom: 20px; }
        input[type="file"] { font-size: 1.1em; padding: 10px; background: white; border-radius: 5px; cursor: pointer; width: 100%; max-width: 400px; margin-bottom: 20px; }
        .btn-start { background-color: #27ae60; color: white; padding: 15px 30px; border: none; border-radius: 8px; font-size: 1.2em; font-weight: bold; cursor: pointer; transition: 0.2s; display: inline-block; }
        .btn-start:hover { background-color: #1e8449; }
        #loading { display: none; text-align: center; font-size: 1.2em; font-weight: bold; margin-top: 20px; color: white; background-color: #f39c12; padding: 15px; border-radius: 8px;}
        #errorBox { display: none; text-align: left; font-size: 1.1em; margin-top: 20px; color: white; background-color: #e74c3c; padding: 20px; border-radius: 8px; font-family: monospace; }
        .results { display: none; margin-top: 30px; }
        
        .grid-2 { display: grid; grid-template-columns: 1fr 1fr; gap: 15px; margin-bottom: 30px; }
        @media (max-width: 768px) { .grid-2 { grid-template-columns: 1fr; } }
        
        .box { padding: 20px; border-radius: 10px; color: white; text-align: center; }
        .c-dark { background-color: #34495e; }
        .c-gray { background-color: #5d6d7e; }
        .val { font-size: 1.6em; font-weight: bold; margin-top: 5px; display: block; }
        .val-sub { font-size: 0.65em; display: block; margin-top: 5px; opacity: 0.9; font-weight: normal; }
        .label { font-size: 0.85em; text-transform: uppercase; font-weight: 700; opacity: 0.9; }
        table { width: 100%; border-collapse: collapse; margin-top: 10px; font-size: 0.9em; margin-bottom: 10px; }
        th, td { border: 1px solid #ddd; padding: 10px; text-align: center; }
        th { background-color: #3498db; color: white; }
        tr:nth-child(even) { background-color: #f9f9f9; }
        .month-row { background-color: #d0ecf6; font-weight: bold; }
        .total-row { background-color: #2c3e50; font-weight: bold; color: white; }
        h3 { border-bottom: 2px solid #3498db; padding-bottom: 10px; color: #2c3e50; margin-top: 40px; }
    </style>
</head>
<body>
    <div id="contentWrapper" class="wrap">
        <h2>Lastgang-Analyse</h2>
        <p class="sub">Lade deine Excel- oder CSV-Datei hoch (Aufbau ohne Überschrift: Datum | Uhrzeit | kWh). Bitte Lastgangdaten erst ab 01.01.2026 einlesen.</p>
        <div class="simple-upload">
            <label for="fileInput" style="display:block; margin-bottom:10px; font-weight:bold;">1. Bitte wähle hier deine Datei aus:</label>
            <input type="file" id="fileInput" accept=".csv, .xlsx, .xls">
            <br>
            <button id="startBtn" class="btn-start" onclick="startAnalysis()">2. Datei jetzt auswerten</button>
        </div>
        <div id="errorBox"></div>
        <div id="loading">⏳ Lese Datei ein…</div>
        <div class="results" id="resultArea">
            
            <h3>Monats-Übersicht</h3>
            <table id="monthTable"><thead><tr><th>Monat</th><th>Verbrauch</th><th>Kosten (Netto)</th><th>Kosten (Brutto)</th><th>Ø Preis (Netto)</th><th>Ø Preis (Brutto)</th></tr></thead><tbody></tbody><tfoot></tfoot></table>
            
            <div id="operatorExplanation" style="display:none; margin-top: 50px; text-align: center;">
                <p style="color: #2c3e50; font-size: 1.1em; margin-top: 10px; margin-bottom: 20px; background: #ebf5fb; padding: 15px 20px; border-radius: 8px; display: inline-block; border: 1px solid #3498db;">
                    Ø Börsenpreis (<strong id="explAvgPrice" style="color:#27ae60; font-size:1.1em;">0,00 ct/kWh</strong>) <strong>+</strong> fixe Aufschläge (Vermarktungsentgelt, Netzentgelte, Umlagen, Abgaben, Steuern).
                </p>
            </div>

<div class="grid-2" id="gridOperators" style="display:none; margin-top: 10px;">
                <div class="box c-dark">
                    <span class="label">SW BUCHEN (+17,34 CT/KWH NETTO)</span>
                    <span class="val" id="resSWBuchen">0,00 ct/kWh netto (0,00 ct/kWh brutto)</span>
                </div>
                <div class="box c-gray">
                    <span class="label">NETZE BW (+15,69 CT/KWH NETTO)</span>
                    <span class="val" id="resNetzeBW">0,00 ct/kWh netto (0,00 ct/kWh brutto)</span>
                </div>
            </div>
            
            <h3>Tages-Details (nur Börsenstrompreis ohne Aufschläge)</h3>
            <table id="dailyTable"><thead><tr><th>Datum</th><th>Verbrauch</th><th>Kosten (Netto)</th><th>Kosten (Brutto)</th><th>Ø Preis (Netto)</th><th>Ø Preis (Brutto)</th></tr></thead><tbody></tbody><tfoot></tfoot></table>

<h3 style="margin-top: 60px;">1/4 Stunden-Details (nur Börsenstrompreis ohne Aufschläge)</h3>
            <div style="background-color: #ebf5fb; padding: 20px; border-radius: 8px; text-align: center; margin-bottom: 20px; border: 1px solid #3498db;">
                <label for="daySelect" style="font-weight:bold; margin-right: 15px; font-size: 1.1em; color: #2c3e50;">Tag auswählen:</label>
                <select id="daySelect" style="padding: 10px 15px; font-size: 1.1em; border-radius: 5px; border: 1px solid #3498db; cursor: pointer; outline: none; background: white; color: #2c3e50; font-weight: bold; min-width: 200px;"></select>
            </div>
            <table id="quarterTable">
                <thead>
                    <tr>
                        <th>Uhrzeit</th>
                        <th>Verbrauch</th>
                        <th>Börsenpreis (Netto)</th>
                        <th>Kosten (Netto)</th>
                        <th>Kosten (Brutto)</th>
                    </tr>
                </thead>
                <tbody></tbody>
                <tfoot></tfoot>
            </table>

</div>
        
        <div style="text-align: center; margin-top: 30px; font-size: 0.85em; color: #7f8c8d;">
            Datenquelle: <a href="https://www.smard.de" target="_blank" style="color: #3498db; text-decoration: none;">Bundesnetzagentur | SMARD.de</a>
        </div>
    </div>
    <script>
        // SMART RESIZER: Funkt die Höhe an WordPress
        const resizeObserver = new ResizeObserver(entries => {
            for (let entry of entries) {
                const height = entry.target.offsetHeight + 60; // Puffer für Schatten
                window.parent.postMessage({ type: 'resize', height: height }, '*');
            }
        });
        resizeObserver.observe(document.getElementById('contentWrapper'));

const mw = 1.19;
        const aufschlagSWBuchen = 17.34;
        const aufschlagNetzeBW = 15.69;
        
        window.globalDetailedData = {};

// Standard 2 Nachkommastellen
        function formatMoney(val) { return val.toLocaleString("de-DE", { minimumFractionDigits: 2, maximumFractionDigits: 2 }); }
        
        // 5 Nachkommastellen für die 1/4-Stunden Tabelle
        function formatMoney5(val) { return val.toLocaleString("de-DE", { minimumFractionDigits: 5, maximumFractionDigits: 5 }); }

function showError(msg) { document.getElementById("errorBox").style.display = "block"; document.getElementById("errorBox").innerHTML = "<strong>FEHLER:</strong><br><br>" + msg; document.getElementById("loading").style.display = "none"; }
        function getMonthNameText(isoString) { let parts = isoString.split("-"); let d = new Date(parts[0], parts[1]-1, 1); return ["Januar", "Februar", "März", "April", "Mai", "Juni", "Juli", "August", "September", "Oktober", "November", "Dezember"][d.getMonth()] + " " + d.getFullYear(); }
        
        function renderQuarterTable(dateKey) {
            let qBody = document.querySelector("#quarterTable tbody");
            let qFoot = document.querySelector("#quarterTable tfoot");
            qBody.innerHTML = ""; qFoot.innerHTML = "";
            let dayData = window.globalDetailedData[dateKey];
            if(!dayData) return;

let sumKwh = 0, sumNetto = 0;
            
            for(let i=0; i<96; i++) {
                if(!dayData[i]) continue; 
                let data = dayData[i];
                
                let h = Math.floor(i / 4);
                let m = (i % 4) * 15;
                let timeStr = (h < 10 ? "0" + h : h) + ":" + (m === 0 ? "00" : m);

sumKwh += data.kwh;
                sumNetto += data.costNetto;

async function processData(rows) {
            try {
                let parsedData = []; let datesToFetch = new Set();
                for (let row of rows) {
                    if (!row || row.length < 2) continue;
                    let val0 = row[0], val1 = row[1], val2 = row[2], isoDate = null;
                    if (typeof val0 === "number") isoDate = new Date(Math.round((val0 - 25569) * 86400 * 1000)).toISOString().split("T")[0];
                    else if (typeof val0 === "string") {
                        let str = val0.replace(/['"]/g, "").trim();
                        if (str.indexOf("-") === 4) isoDate = str.substring(0, 10);
                        else if (str.includes(".")) { let p = str.split("."); if (p.length >= 3) isoDate = (p[2].length===2?"20"+p[2]:p[2]) + "-" + p[1].padStart(2,'0') + "-" + p[0].padStart(2,'0'); }
                    }
                    let timeIdx = -1;
                    if (typeof val1 === "number") timeIdx = val1 < 1 ? Math.floor(Math.round(val1 * 1440) / 15) : (val1===24 ? 95 : -1);
                    else if (typeof val1 === "string" && val1.includes(":")) { let p = val1.split(":"); timeIdx = (parseInt(p[0]) * 4) + Math.floor(parseInt(p[1]) / 15); }
                    let kwh = typeof val2 === "number" ? val2 : parseFloat(String(val2).replace(/['"]/g, "").replace(/\./g, "").replace(",", "."));
                    if (!isNaN(kwh) && isoDate && timeIdx >= 0) { datesToFetch.add(isoDate); parsedData.push({ date: isoDate, timeIdx: Math.min(timeIdx, 95), kwh: kwh }); }
                }
                
                let apiCache = {};
                for(let date of Array.from(datesToFetch)) {
                    try {
                        let res = await fetch("https://nirmaier.com/get_prices.php?date=" + date); let json = await res.json();
                        let prices = new Array(96).fill(0);
                        // HIER WURDE DIE ZEITKORREKTUR BEHOBEN:
                        if(json.daily) for(let it of json.daily) { let dt = new Date(it.timestamp.replace(" ","T") + "Z"); let idx = (dt.getHours()*4)+Math.floor(dt.getMinutes()/15); if(idx>=0 && idx<96) prices[idx]=parseFloat(it.preis_mwh)/10; }
                        apiCache[date] = prices;
                    } catch(e) { apiCache[date] = new Array(96).fill(0); }
                }

let totalKwh = 0, totalNetto = 0, dailySum = {}, monthlySum = {};
                window.globalDetailedData = {};

for (let item of parsedData) {
                    let basePrice = apiCache[item.date][item.timeIdx];
                    let cost = item.kwh * (basePrice / 100);
                    totalKwh += item.kwh; totalNetto += cost;
                    
                    let mo = item.date.substring(0, 7);
                    if(!dailySum[item.date]) dailySum[item.date] = { kwh: 0, netto: 0 };
                    if(!monthlySum[mo]) monthlySum[mo] = { kwh: 0, netto: 0 };
                    
                    dailySum[item.date].kwh += item.kwh; dailySum[item.date].netto += cost;
                    monthlySum[mo].kwh += item.kwh; monthlySum[mo].netto += cost;

if(!window.globalDetailedData[item.date]) window.globalDetailedData[item.date] = {};
                    if(!window.globalDetailedData[item.date][item.timeIdx]) window.globalDetailedData[item.date][item.timeIdx] = { kwh: 0, costNetto: 0, price: basePrice };
                    
                    window.globalDetailedData[item.date][item.timeIdx].kwh += item.kwh;
                    window.globalDetailedData[item.date][item.timeIdx].costNetto += cost;
                }

let overallAvgNetto = totalKwh > 0 ? (totalNetto / totalKwh * 100) : 0;

// Berechnung der Netzbetreiber-Preise
                let swBuchenNetto = overallAvgNetto + aufschlagSWBuchen;
                let netzeBWNetto = overallAvgNetto + aufschlagNetzeBW;
                
                // Setze Werte in die Info-Boxen - OHNE DIE VERKLEINERUNGSKLASSE <span class="val-sub">
                document.getElementById("resSWBuchen").innerHTML = formatMoney(swBuchenNetto) + " ct/kWh netto (" + formatMoney(swBuchenNetto * mw) + " ct/kWh brutto)";
                document.getElementById("resNetzeBW").innerHTML = formatMoney(netzeBWNetto) + " ct/kWh netto (" + formatMoney(netzeBWNetto * mw) + " ct/kWh brutto)";
                
                // Schreibe den individuellen Börsen-Preis dynamisch in den Erklär-Text!
                document.getElementById("explAvgPrice").innerText = formatMoney(overallAvgNetto) + " ct/kWh";

// Zeige den Bereich an
                document.getElementById("operatorExplanation").style.display = "block";
                document.getElementById("gridOperators").style.display = "grid";

let daySelect = document.getElementById("daySelect");
                daySelect.innerHTML = "";
                for (let day of Object.keys(dailySum).sort()) {
                    let p = day.split("-"); 
                    let niceDate = p[2] + "." + p[1] + "." + p[0];
                    let opt = document.createElement("option");
                    opt.value = day; opt.text = niceDate;
                    daySelect.appendChild(opt);
                }
                
                daySelect.onchange = () => renderQuarterTable(daySelect.value);
                
                if(daySelect.options.length > 0) renderQuarterTable(daySelect.value);

document.getElementById("loading").style.display = "none"; document.getElementById("resultArea").style.display = "block";
            } catch (e) { showError("Fehler: " + e.message); }
        }
    </script>
</body>
</html>

Börsenstrompreise Dashboard

Preise inkl. Börsenstrompreis, Vermarktungsentgelt, Netzentgelte, Umlagen bzw. Abgaben und Steuern

Tages- & Langzeit-Durchschnitte

Transparente Preisvergleiche.

Individuelle Spartipps.

Umfassende Marktübersicht.