FFXIV Collectible Completion Tools

Posted on Jan 4, 2026

Have you heard of the critically acclaimed MMORPG Final Fantasy 14? With an expanded free trial which you can play through the entirety of A Realm Reborn and the award winning Heavensward, and thrilling Stormblood expansions up to level 70 for free with no restrictions on play time?

Regardless of the answer, there are many tools available to help one keep track of their progress on their quest through the world of Final Fantasy XIV. ARR Triple Triad keeps track of Triple Triad cards specifically, while XIV Collect and XIV ToDo can help keep track of which items, ability, quests and objectives you may have missed.

The Marketboard

While many items and accomplishments in the game can only be obtained through play time, skill, or real money, there remain several hundred Mounts (different kids of creatures or vehicles you can ride around on in the game), Minions (pets of almost purely aesthetic value), Hairstyles (obviously) and Orchestrions (in-game music you can re-play at your house) which are obtainable via in-game currency on the Marketboard.

The Marketboard is available in-game in major cities, and allows items which are not unique / untradeable to be sold to other players for in-game currency. While you may walk up to the marketboard and search by item name and see a list of current prices and availability, this is somewhat tedious for checking the prices on the thousand or so collectibles you may be missing.

A slightly better option would be to use Universalis a website that uses user-reported data to track item prices and availability across all FFXIV servers (the FFXIV player base is divided into a few dozen worlds spread among roughly a half-dozen geographically diverse data centers).

The Programmatic Approach

Conveniently, both XIV Collect and Universalis offer APIs for understanding what you’re missing and checking prices. By finding your character id number from the Lodestone URL for example, you can then write a program to perform the following steps and produce a conveniently formatted list of what to buy:

  1. Query FFXIV Collect API at /api/characters/{id} to get character name, server, data center, and collection counts
  2. Iterate through 6 collection types (minions, mounts, orchestrions, emotes, hairstyles, bardings) calling /api/characters/{id}/{collection}/missing for each
  3. Extract item metadata from each response: name, item_id, sources, tradeable flag, patch
  4. Match the item names to the marketboard ids from the Teamcraft master item list on their GitHub repo.
  5. Filter to only marketable items by querying Universalis /api/v2/marketable endpoint
  6. Query Universalis API with up to 100 items per request to /api/v2/aggregated/{server}/{item_ids}, optionally checking both the data center (all worlds user can easily travel between) or the actual server the character is based on for the {server} argument.
  7. Export the resulting data to Excel via pandas/openpyxl (or use CSV)

Results

So in the end, you get a nicely sorted list like this Excel Screenshot

And what would it cost to buy my way to completion of all marketable items?

  • 💎 Total Cost for All Items (World): 1,650,827,793 gil

Ah well.