xiaohongshu
xiaohongshu
eptr2-price-analysis
Query and analyze Turkish electricity market prices including MCP (PTF/Piyasa Takas Fiyatı), SMP (SMF/Sistem Marjinal Fiyatı), WAP (Ağırlıklı Ortalama Fiyat), and imbalance prices. Use when asking about electricity prices, market clearing prices, day-ahead prices, system marginal prices, weighted...
Full skill instructions
This skill helps you query and analyze electricity market prices from Turkey's EPIAS Transparency Platform using the eptr2 Python library.
from eptr2 import EPTR2
# Initialize with environment variables (recommended)
eptr = EPTR2(use_dotenv=True, recycle_tgt=True)
# Get Market Clearing Price (MCP/PTF)
mcp = eptr.call("mcp", start_date="2024-07-29", end_date="2024-07-29")
print(mcp)
| Call | Alias | Description (EN) | Description (TR) |
|---|---|---|---|
mcp | ptf | Market Clearing Price (Day-Ahead) | Piyasa Takas Fiyatı |
smp | smf | System Marginal Price | Sistem Marjinal Fiyatı |
wap | - | Weighted Average Price (Intraday) | Ağırlıklı Ortalama Fiyat |
imbalance-price | - | Positive/Negative Imbalance Prices | Dengesizlik Fiyatları |
interim-mcp | - | Interim MCP (before finalization) | Kesinleşmemiş PTF |
mcp-smp-imb | - | Combined MCP, SMP and Imbalance | PTF, SMF ve Dengesizlik |
For complete price and cost analysis including imbalance costs:
from eptr2.composite import get_hourly_price_and_cost_data
df = get_hourly_price_and_cost_data(
eptr,
start_date="2024-07-29",
end_date="2024-07-29",
include_wap=True, # Include IDM weighted average price
add_kupst_cost=True # Calculate KUPST deviation costs
)
| Column | Description |
|---|---|
date | Datetime in ISO format (+03:00 timezone) |
mcp | Market Clearing Price (TL/MWh) |
smp | System Marginal Price (TL/MWh) |
wap | Weighted Average Price (TL/MWh) |
system_direction | Enerji Açığı (deficit), Enerji Fazlası (surplus), Dengede (balanced) |
sd_sign | -1 (deficit/up-regulation), 1 (surplus/down-regulation), 0 (balanced) |
pos_imb_price | Positive imbalance price (TL/MWh) |
neg_imb_price | Negative imbalance price (TL/MWh) |
pos_imb_cost | Positive imbalance cost = MCP - pos_imb_price |
neg_imb_cost | Negative imbalance cost = neg_imb_price - MCP |
kupst_cost | KUPST unit deviation cost |
mcp_df = eptr.call("mcp", start_date="2024-07-29", end_date="2024-07-29")
smp_df = eptr.call("smp", start_date="2024-07-29", end_date="2024-07-29")
# Merge for comparison
import pandas as pd
comparison = mcp_df.merge(smp_df, on="date", suffixes=("_mcp", "_smp"))
# Day-ahead price
mcp_df = eptr.call("mcp", start_date="2024-07-29", end_date="2024-07-29")
# Intraday weighted average price
wap_df = eptr.call("wap", start_date="2024-07-29", end_date="2024-07-29")
# Compare DAM vs IDM
comparison = mcp_df.merge(wap_df, on="date")
comparison["dam_idm_spread"] = comparison["price"] - comparison["wap"]
imb_df = eptr.call("imbalance-price", start_date="2024-07-29", end_date="2024-07-29")
# Returns: positiveImbalancePrice, negativeImbalancePrice columns
Always use ISO format: YYYY-MM-DD (e.g., "2024-07-29")
Set credentials in .env file:
[email protected]
EPTR_PASSWORD=your_password
Then initialize with:
eptr = EPTR2(use_dotenv=True, recycle_tgt=True)
xiaohongshu
technical spec
product ux expert
database patterns
Conduct multi-agent task orchestration and workflow coordination.
Initialize project with Conductor artifacts (product definition,
Expert in web animations, transitions, and motion design using Framer Motion and CSS
Creates Mermaid and ASCII diagrams for flowcharts, architecture, ERDs, state machines, mindmaps, and more. Use when user mentions diagram, flowchart, mermaid, ASCII diagram, text diagram, terminal diagram, visualize, C4, mindmap, architecture diagram, sequence diagram, ERD, or needs visual docume...
PostgreSQL bindings for H3 hexagonal grid system. Use when working with H3 cells in Postgres, including spatial indexing, geometry/geography integration, and raster analysis.
Context-Driven Development skill for projects using Conductor. Use this skill when you detect a `conductor/` directory in the project, when working on tasks defined in a `plan.md` file, or when the user asks about tracks, specs, or plans. Automatically applies TDD workflow, tracks task completion...
Display project status, active tracks, and next actions
Official Stakpak application containerization standard operating procedure, a step-by-step guidline to properly dockerize applications. This is a rule book curated by the Stakpak Team.
Generate, edit, and beat-sync AI video with leading models in one workspace.
The world's fastest calendar for remote work
Transform Your Design with AI Designer by ImgCreator.ai
Revolutionizing Video Production with AI-Powered Creativity
Extend an image past the frame and let AI fill the new aspect ratio.
Discover your celebrity doppelgänger with StarByFace!
ChainClarity explains 700+ crypto whitepapers in plain English, with layered summaries, comparisons, research tools, alerts, and a $4.99 Pro plan.
Opus.ai: Revolutionize Your Web Experience