Data Formats and Delivery
How do I access Energy Prices & Markets reports?
Energy Prices & Markets reports are delivered as monthly PDF documents, one per country. To access them, log in at intratec.us, go to My Products, filter by Energy Prices & Markets, select the country you want, then click View to read online or Download PDF to save locally (if your plan allows downloading).
Beyond PDF, Advanced and Ultimate subscribers can also access the same data through Online Charts (interactive, browser-based), the Excel Add-In, Power BI dashboards, and the REST Web API — all available without any additional cost on those plans.
Can I download reports as PDF files?
Whether you can download a PDF depends on your subscription plan:
Starter subscribers can read reports in full through the browser; downloading requires Pro or higher.
Is there an Excel add-in for Energy Prices & Markets?
Yes — the Intratec Excel Add-In is available on Advanced and Ultimate plans. It lets you pull up-to-date energy price data directly into Excel with the press of a button, with no manual data entry and no setup required on existing Excel models. The add-in works on both Windows and Mac.
The Excel Add-In is included at no extra cost with the Advanced or Ultimate subscription. Subscribers on Starter or Pro plans need to upgrade to access it.
Explore Advanced and Ultimate plan options at intratec.us/products/energy-prices-markets.
Can I connect Energy Prices & Markets data to Power BI?
Yes — Power BI integration is available on Advanced and Ultimate plans. We provide pre-configured, open-source .pbix project files that connect directly to your subscription data with no setup required. You can use the dashboards as-is or customise them — since the files are open source, you can modify Power Queries and build entirely custom dashboards to fit your reporting needs.
The integration gives you access to the full historical data available under your plan. Power BI access is included at no extra cost with Advanced or Ultimate.
Is there an API for Energy Prices & Markets?
Yes — Energy Prices & Markets includes a REST Web API on Advanced and Ultimate plans, at no additional cost.
The API provides programmatic access to current energy prices and full historical archives within your plan's depth. It follows standard REST conventions and returns JSON responses, making it straightforward to integrate with any system or language your team already uses. Supported languages include JavaScript, Python, Ruby, C#, PHP, Go, and R.
The API is also compatible with workflow automation tools such as Microsoft Logic Apps, N8N, and Zapier, and can feed data directly into ERP or proprietary systems. A single request can retrieve up to 40 data series simultaneously. Currency and unit selection are supported for energy price assessments.
To get started, subscribe to an Advanced or Ultimate plan, invite your developer user, assign the Developer role through Users Management, and follow the API documentation.
Can I download energy price data as a spreadsheet?
Yes — Monthly Downloadable Spreadsheets are available on Advanced and Ultimate plans for Energy Prices & Markets. Spreadsheets are uploaded monthly so the files stay current, and you can download them directly from your account under Your Products.
This is a separate feature from the Excel Add-In: Downloadable Spreadsheets are ready-made files you save and use locally, while the Excel Add-In connects live to your subscription and refreshes data automatically inside your own models.
For Primary Commodity Prices and Industry Economics Worldwide, Downloadable Spreadsheets are available on the Ultimate plan only. For Energy Prices & Markets, they are included from the Advanced plan onwards.
How many API requests do I get per month?
API request limits for Energy Prices & Markets are set per country per month:
The specific number within the Advanced range (10–500) depends on the automation tier selected. You can expand your limit at any time by adding an Extra Automation Package through Subscriptions Billing > Upgrade Plan.
Requests are non-cumulative — unused allowances do not carry over to the following month. The limit resets when new data is published according to the release schedule.
Do API, Excel, and Power BI share the same request limit?
Yes — the API, Excel Add-In, and Power BI all draw from the same monthly request pool.
The monthly data request limit for Energy Prices & Markets is applied per country across all three delivery channels combined. It does not matter which channel makes the request — every retrieval of actual subscription data counts toward the same allowance.
If your subscription for one country has a limit of 50 requests per month and you retrieve 20 assessments through the Excel Add-In, you have 30 requests remaining for that country — across the API and Power BI as well.
This pooling applies only to core data requests (prices, assessments). Sandbox requests and informational operations (such as checking available series or metadata) do not count toward the limit.
What happens when I run out of data requests?
When the monthly request allowance for a country is exhausted, no further core data can be retrieved for that country until the limit resets. The reset happens automatically when new data is published according to the release schedule — you do not need to take any action.
Requests are non-cumulative, so unused allowance from the current cycle does not carry over.
If you consistently reach the limit before the reset, you can increase your allowance at any time by adding an Extra Automation Package: log in at intratec.us, go to Subscriptions Billing, click Upgrade Plan, and select the Extra Automation Package. You pay only the prorated difference for the remainder of the current billing period.
To avoid consuming your allowance during development and testing, use the sandbox environment. Sandbox requests do not count toward your monthly limit.
Can I convert energy prices to other currencies?
Yes — currency conversion is available on all subscription plans. Through the Online Charts interface, you can switch between currencies (for example, from USD to EUR or JPY) and the displayed prices update accordingly. Currency selection is also available when retrieving data through the REST Web API.
This applies to all 12 energy commodities covered across the 33 countries in the subscription.
Can I change the unit of measure for energy prices?
Yes — unit conversion is available on all subscription plans. The Online Charts interface lets you toggle between units of measurement (for example, kg, lb, or ton), and the data updates to reflect your selection. Unit selection is also supported through the REST Web API for energy price assessments.
This flexibility is built into the platform for all 12 energy commodities, so you can work in the units that match your internal models or procurement workflows without manual conversion.