1 files changed, 130 insertions, 0 deletions
diff --git a/most-valuable-materia.ipynb b/most-valuable-materia.ipynb
new file mode 100644
index 0000000..16742b8
--- /dev/null
+++ b/most-valuable-materia.ipynb
@@ -0,0 +1,130 @@
+{
+ "cells": [
+  {
+   "cell_type": "markdown",
+   "id": "c8e634f8-f5b1-4a93-ac99-2124a21183d2",
+   "metadata": {},
+   "source": [
+    "# Most Valuable Materia\n",
+    "\n",
+    "I have a lot of Sacks of Nuts and Cracked Whateverclusters and I'd like to know which materia will give me the most money on the market board.\n",
+    "I don't have any Cracked Whatevercrystals, so I don't care about non-combat materia.\n",
+    "\n",
+    "Powered by [Universalis](https://universalis.app/).\n",
+    "\n",
+    "Set the world and materia tiers you care about:"
+   ]
+  },
+  {
+   "cell_type": "code",
+   "execution_count": null,
+   "id": "bbc35fe7-615a-44ac-81bd-3eb394e10365",
+   "metadata": {},
+   "outputs": [],
+   "source": [
+    "world = 'Jenova'\n",
+    "tiers = [\"VII\", \"VIII\", \"IX\", \"X\"]"
+   ]
+  },
+  {
+   "cell_type": "markdown",
+   "id": "b5a49afe-1a0e-4370-9610-30b975ec6f5b",
+   "metadata": {},
+   "source": [
+    "Then hit Run > Run All Cells, and the two most valuable materia at each tier should show up after all the code.\n",
+    "If you're curious, you can click the hidden code cell below to see how it works."
+   ]
+  },
+  {
+   "cell_type": "code",
+   "execution_count": null,
+   "id": "d87b9ff9-eb2c-403f-9432-20b22112ba93",
+   "metadata": {
+    "jupyter": {
+     "source_hidden": true
+    }
+   },
+   "outputs": [],
+   "source": [
+    "# useful constants\n",
+    "ROMAN_NUMERALS = [\"I\", \"II\", \"III\", \"IV\", \"V\", \"VI\", \"VII\", \"VIII\", \"IX\", \"X\"]\n",
+    "\n",
+    "# grabbed by hand from XIVAPI\n",
+    "MATERIA = {\n",
+    "    \"Piety\": [5629, 5630, 5631, 5632, 5633, 18011, 25186, 26727, 33917, 33930],\n",
+    "    \"Heavens' Eye\": [5664, 5665, 5666, 5667, 5668, 18018, 25187, 26728, 33918, 33931],\n",
+    "    \"Savage Aim\": [5669, 5670, 5671, 5672, 5673, 18019, 25188, 26729, 33919, 33932],\n",
+    "    \"Savage Might\": [5674, 5675, 5676, 5677, 5678, 18020, 25189, 26730, 33920, 33933],\n",
+    "    \"Battledance\": [5679, 5680, 5681, 5682, 5683, 18021, 25190, 26731, 33921, 33934],\n",
+    "    \"Quickarm\": [5714, 5715, 5716, 5717, 5718, 18028, 25197, 26738, 33928, 33941],\n",
+    "    \"Quicktongue\": [5719, 5720, 5721, 5722, 5723, 18029, 25198, 26739, 33929, 33942],\n",
+    "}\n",
+    "\n",
+    "# 1. sort out the items to search for\n",
+    "target_materia = dict()\n",
+    "all_ids = []\n",
+    "for tier in tiers:\n",
+    "    target_materia[tier] = dict()\n",
+    "    index = ROMAN_NUMERALS.index(tier)\n",
+    "    for materia_type in MATERIA:\n",
+    "        item_name = f\"{materia_type} Materia {tier}\"\n",
+    "        item_id = MATERIA[materia_type][index]\n",
+    "        target_materia[tier][item_id] = item_name\n",
+    "        all_ids.append(item_id)\n",
+    "\n",
+    "# 2. get prices\n",
+    "import requests\n",
+    "\n",
+    "if len(target_materia) > 100:\n",
+    "    raise ValueError(\"Can't load market data for more than 100 items at a time\")\n",
+    "\n",
+    "universalis_url = f'https://universalis.app/api/v2/{world}/{\",\".join(str(x) for x in all_ids)}?listings=0&entries=0'\n",
+    "\n",
+    "response = requests.get(universalis_url)\n",
+    "\n",
+    "response.raise_for_status()\n",
+    "\n",
+    "response = response.json()\n",
+    "\n",
+    "if len(response[\"itemIDs\"]) != len(tiers) * len(MATERIA):\n",
+    "    print(\"Got back the wrong number of items for some reason\")\n",
+    "\n",
+    "prices = {item[\"itemID\"]: item[\"minPrice\"] for item in response[\"items\"].values()}\n",
+    "\n",
+    "# 3. sort prices\n",
+    "from IPython.display import Markdown\n",
+    "\n",
+    "for tier in tiers:\n",
+    "    display(Markdown(f\"## Materia {tier}\"))\n",
+    "    targets = target_materia[tier]\n",
+    "    target_ids = list(targets.keys())\n",
+    "    best_ids = sorted(target_ids, key=lambda id: prices[id], reverse=True)\n",
+    "    for this_id in best_ids[:2]:\n",
+    "        name = targets[this_id]\n",
+    "        price = prices[this_id]\n",
+    "        display(Markdown(f\"- {name} - {price}g\"))"
+   ]
+  }
+ ],
+ "metadata": {
+  "kernelspec": {
+   "display_name": "Python 3 (ipykernel)",
+   "language": "python",
+   "name": "python3"
+  },
+  "language_info": {
+   "codemirror_mode": {
+    "name": "ipython",
+    "version": 3
+   },
+   "file_extension": ".py",
+   "mimetype": "text/x-python",
+   "name": "python",
+   "nbconvert_exporter": "python",
+   "pygments_lexer": "ipython3",
+   "version": "3.11.0"
+  }
+ },
+ "nbformat": 4,
+ "nbformat_minor": 5
+}