Data Formats and Delivery

How can I access the price data?

Price data is accessible through four delivery methods, with availability depending on the subscription plan.

Online Charts are available on all plans and allow dynamic data exploration from any browser or device. You can hover over data points, toggle between views, convert currencies and units, and group data by month, quarter, or year.

Excel Add-In and Power BI integration (Advanced and Ultimate) let you pull price data directly into your existing spreadsheet models and dashboards without manual data entry. REST Web API (Advanced and Ultimate) enables programmatic access for ERP systems, automation tools, and custom applications.

All plans also include the ability to download chart images as JPG or PNG files.

Is there an Excel add-in for this product?

The Excel Add-In is available on Advanced and Ultimate plans and lets you retrieve the latest price data directly inside Microsoft Excel with a single button click.

The Add-In integrates with your existing spreadsheet models — no restructuring is required. It works on both Windows and Mac (Excel version 16.0 or later) and supports multiple devices, so any team member with the developer credentials can use it.

Data is organized using templates, each of which can hold up to 40 assessment codes. You select the assessments you want, configure preferred currency and unit settings, and click Get Series Values to populate the template with current data. Connection modes (Enabled, Test, Disabled) let you validate your setup without consuming data requests.

The Add-In uses a ribbon interface rather than cell-level functions. It does not push data in the background — retrieval is user-initiated, which gives you full control over request usage.

The Excel Add-In is included at no additional cost with the Advanced plan.

Can I connect this data to Power BI?

Yes — Power BI integration is available for Primary Commodity Prices on Advanced and Ultimate plans, at no additional cost.

The setup, the open-source .pbix files, the Developer-role assignment, and the customization workflow are identical across Intratec products — see Can I connect Intratec data to Power BI? for the full walkthrough. A courtesy account is included for testing the dashboards before connecting to your actual subscription data.

Power BI requests share the same monthly data-request pool as the Excel Add-In and the API — see How do I get data into Excel or Power BI? for per-plan limits.

Can I download data as a spreadsheet?

Monthly Downloadable Spreadsheets are available exclusively on the Ultimate plan for Primary Commodity Prices. Each month, ready-to-use spreadsheet files are uploaded to your user area — log in, navigate to Your Products, and download the latest files directly.

This is the same feature available across all Intratec subscription products (Ultimate-only on every product). For the full mechanics, the difference from the Excel Add-In, and request-limit treatment, see Can I download Intratec data as a monthly spreadsheet?.

Starter, Pro, and Advanced subscribers do not have access to this feature.

Is there an API for this product?

Yes — Primary Commodity Prices is accessible via Intratec's REST Web API on Advanced and Ultimate plans, at no additional cost. Currency and unit selection are supported per series.

The API conventions, supported languages, workflow-tool compatibility, and Developer-role setup are identical across Intratec products — see Is there a REST API for Intratec data? for the full technical reference.

For per-month request allowances and tier options specific to Primary Commodity Prices, see How do I get data into Excel or Power BI? — the API shares the same monthly pool as the Excel Add-In and Power BI.

How many API requests do I get per month?

API requests are counted per industry per month and are shared across your Excel Add-In, Power BI, and API usage combined.

The Advanced plan includes Tier 10 by default (10 requests per industry per month). Higher tiers are available as upgrades:

The Ultimate plan includes 500+ requests per industry per month, with up to 20 API users.

How limits work:

• The limit is non-cumulative — unused requests do not carry over to the next month.
• Limits reset when new data is published (i.e., on the monthly release day, not on a calendar date).
• Requests are not interchangeable between industries — each industry has its own allowance.
• Excel Add-In, Power BI, and API requests all draw from the same pool.

To add more requests, upgrade to a higher tier via Subscriptions Billing > Upgrade Plan in your account. An Extra Automation Package can also be purchased at any time.

Can I download price data as a PDF?

PDF download is available on Pro, Advanced, and Ultimate plans. The access level varies by plan:

PDFs are generated from the data table view in the online charts interface. On all plans, chart images can also be downloaded as JPG or PNG files.

If you need a portable, offline-ready export of raw data (not just a visual), the Ultimate plan also includes Monthly Downloadable Spreadsheets — pre-built spreadsheet files uploaded each month to your user area.

Can I group price data by quarter or year?

Data grouping is available on all plans. In the online charts interface, you can switch the time interval between monthly, quarterly, and yearly views directly from the chart customization controls below each chart.

This makes it straightforward to aggregate monthly price series into quarterly or annual averages — useful for financial modeling, budget planning, or presenting trends at a higher level of granularity.

The grouping option applies to both chart and table views, so you can also download a quarterly or annual PDF (on Pro and above) or export the grouped chart as a JPG or PNG image.

Can I convert prices to other currencies?

Currency conversion is available on all plans. In the online charts interface, you can switch the display currency for any commodity price directly from the chart customization panel — options include EUR, JPY, GBP, and other major currencies. The conversion applies to both chart and table views.

When using the Excel Add-In, you can also set a preferred currency for each assessment in your templates. The same applies to API requests for Primary Commodity Prices, where currency selection is supported per series. Available currencies for each assessment are listed in the assessment info sheets.

Can I change the unit of measure on the charts?

Unit conversion is available on all plans. In the online charts interface, you can switch the unit of measure for any commodity price from the chart customization panel — common options include kg, lb, and metric ton. Available units vary by commodity.

When using the Excel Add-In, you can specify the desired unit for each assessment in your templates — the available units for each series are listed in the assessment info sheets. Unit selection is also supported for Primary Commodity Prices when using the API.

Does the Excel add-in update automatically?

The Excel Add-In retrieves the most current data available under your subscription when you click Get Series Values in the Intratec Data ribbon. Because data is published monthly, clicking this button after the release date always returns the latest values — there is no need to reconfigure anything or wait for a background sync.

The Add-In does not update in the background automatically. Data retrieval is user-initiated, which gives you full control over when requests are made. This matters because each retrieval counts toward your monthly data request limit, which is shared across Excel Add-In, Power BI, and API usage.

To avoid consuming requests unnecessarily, use Test connection mode when setting up or validating templates — this returns dummy data and does not count against your limit. You can also check the Usage Limits sheet in the Add-In to monitor how many requests remain in the current cycle.