🛠️ Mining Material Prices with ESI API (CSV + Graphs)

Industry Gameplay Center Mining & Extraction
1

Hey everyone,

I’ve been building a tool to help analyze market prices for mining materials using the EVE Online ESI API, mainly focused on Jita 4-4 for now (it’s where I do all my trading). It pulls data automatically and generates a CSV plus graphs you can interact with. I’m sharing it to get feedback and improve it with the community.

What does it do?

  • Connects to the ESI API to get current buy and sell prices from Jita 4-4
  • Pulls historical max buy prices (last 7 and 31 days)
  • Calculates percentage change over time
  • Generates a clean CSV file
  • Creates a set of graphs to help visualize prices by Tier and Material Type

Input file: materials_id_classified.csv

It contains all the materials (Ore, Ice, Gas, etc.) along with their type IDs and a “tier” classification (from T1 to T7).
This part is still a work-in-progress — I’d really appreciate help fine-tuning the tier assignment, especially for more exotic materials.

Output file: mining_market_jita_v3.csv

The script creates a CSV with all the data pulled from the API.
It’s formatted with ; as the delimiter and , as the decimal separator so it works out-of-the-box with Excel and Google Sheets.

mining-market-jita-v3
mining-market-jita-v3639×253 164 KB

Graph Generator Notebook

Once you have the CSV, you can load it into the graph generator and select a Tier and Material Type.

You’ll get:

  • A horizontal bar chart with current buy prices
  • A logarithmic line chart showing price evolution (31 days, 7 days, now)

This part is where I could use some help — the log chart works, but it’s hard to make small price differences visible without distorting the chart. If anyone has experience visualizing this kind of economic data, I’m open to suggestions!

GitHub Repo

You can find the full project here:

It’s all set up for Google Colab so you don’t have to install anything locally. The only thing needed is the jedi package.

Thanks

Thanks to Adam4EVE (A4E - Commodity IDs & names) — their data helped a lot when building the initial material list and classification.

I’d love feedback, ideas for new features, or just help organizing and visualizing things better.
Feel free to fork it or use it however you like.

o7 Fly safe!

1 Like