Back to data
Day-ahead spot prices
CAISO — NP15/SP15/ZP26 electricity market clearing price (USD/MWh) per delivery period. Native 15-min for ES/PT (OMIE) and hourly for the EU cluster (ENTSO-E A44). CAISO is a live external feed (daily cron, runs current) in native USD; the read path also returns value_eur.
Zone: CAISO — NP15/SP15/ZP26Source: CAISO OASISSince: 2001See all 12 Electricity Prices metrics in the catalog →
Last 30 Days
Daily average price
=ED.DAYAHEAD.RANGE(,, 2, , "CAISO_NP15")— Last 30 days dailyMonthly Averages
Last 2 years
=ED.DAYAHEAD.RANGE("2024-01-01",, 3, , "CAISO_NP15")— Monthly since 2024Annual Averages
Historical annual average prices
=ED.DAYAHEAD.RANGE("2001-01-01",, 6, , "CAISO_NP15")— Annual averagesCountry
CAISO — NP15/SP15/ZP26
Resolution
Hourly
Currency
USD (native) · value_eur
Excel Formulas
=ED.DAYAHEAD()— Latest 15-min spot price (ES)=ED.DAYAHEAD("2025-07-01", 14)— Specific date and hour=ED.DAYAHEAD("2025-07-01", 14, , "PT")— Portugal price=ED.DAYAHEAD("2025-07-01", 14, , "FR")— France price (ENTSO-E)=ED.DAYAHEAD.RANGE("2025-01-01",, 3)— Monthly range