Optimize jewelry selling in Guild Wars 2™

### imports
import json
import numpy as np
from gw2api import GuildWars2Client

### Rentability calculator
id_object = 13289 
print(gw2_client.items.get(ids={"%05d" %id_object})[0]['name'])
actual_price = gw2_client.commerceprices.get(ids={"%5d" %id_object})[0]['sells']['unit_price']
rentability = 100 - 100*craft_price/actual_price
print("Rentability is : %1.2f%%" %rentability)

### Profitability for the given accessory
class cAccessory():
    def __init__(self, gem='Amber', ore='Copper', accessory_type='Stud', mastercraft=False):
        self.aName = gem + " " + ore + " " + accessory_type + " " + " m"[mastercraft]
        self.aGem = gem
        self.aOre = ore
        self.aType = accessory_type
        self.aIsMastercrafted = mastercraft
        self.aGemSuffix = None
        if ore == "Copper":
            self.aGemSuffix = "Pebble" 
        elif ore == "Silver":
            self.aGemSuffix = "Nugget" 
        elif ore == "Gold":
            self.aGemSuffix = "Lump" 
        self.aId = None
        self.get_data()
        self.mFindId()
    
    def get_data(self):
        with open('data/guild_wars/items-names.json') as data_file:    
            self.data = json.load(data_file)['items']
    def mFindId(self):
        Id = []
        for i in range(len(self.data)):
            obj_name = self.data[i][1]
            if (obj_name == self.aGem + " " + self.aOre + " " + self.aType):
                Id += [self.data[i][0]]
        if(len(Id) > 0): 
            # We hypothetize that master work have always greater ids
            if(self.aIsMastercrafted and len(Id) > 1):
                self.aId = Id[1]
            else:
                self.aId = Id[0]
    
    def mCraftPrice(self):
        ore_id = None
        gem_id = None
        craft_price = None
        
        for i in range(len(self.data)):
            obj_name = self.data[i][1]
            # Search ore name
            if (obj_name == self.aOre + " Ore"):
                ore_id = self.data[i][0]
            # Search gem name
            elif (obj_name == self.aGem + " " + self.aGemSuffix): 
                gem_id = self.data[i][0]
            # exception just for Pearls..........
            elif (self.aGem == "Pearl"):
                if(obj_name == self.aGem): 
                    gem_id = self.data[i][0]
            
        if(ore_id != None and gem_id != None):
            ore_price = gw2_client.commerceprices.get(ids={"%5d" %ore_id})[0]['sells']['unit_price']
            gem_price = gw2_client.commerceprices.get(ids={"%5d" %gem_id})[0]['sells']['unit_price']
            if (self.aType == 'Stud') | (self.aType == 'Earring'):
                craft_price = gem_price + 8*ore_price
            elif self.aType == 'Ring':
                craft_price = gem_price + 10*ore_price
            elif self.aType == 'Amulet':
                craft_price = gem_price + 12*ore_price
            
            # masterwork are more expensive because of filigrees
            if self.aIsMastercrafted == True:
                craft_price = craft_price + 4*ore_price 
        
        return craft_price
    
    def mSellPrice(self):
        if self.aId is None:
            raise Exception("No id found for {}".format(self.aGem + " " + self.aOre + " " + self.aType))
        sell_price = gw2_client.commerceprices.get(ids={"%5d" %self.aId})[0]['sells']['unit_price']
        
        return sell_price
    
    def mRentability(self):
        if self.aId is None:
            raise Exception("No id found for {}".format(self.aGem + " " + self.aOre + " " + self.aType))
        rent = 100 - 100*self.mCraftPrice() / self.mSellPrice()
        
        return rent
    
    def mGain(self):
        if self.aId is None:
            raise Exception("No id found for {}".format(self.aGem + " " + self.aOre + " " + self.aType))
        gain = self.mSellPrice() - self.mCraftPrice()
        
        return gain

### Profitability for gold-based accessories
list_gems = ["Amethyst", "Sunstone", "Topaz", "Carnelian", "Lapis", "Peridot", "Spinel"]   
list_ores = ["Gold"]
list_accessories = ["Earring", "Ring", "Amulet"]
list_mastercraft = [True, False]

res = []
gains = []
names = []
for gem in list_gems:
    for ore in list_ores:
        for accessory in list_accessories:
            for mastercraft in list_mastercraft:
                acc = cAccessory(gem, ore, accessory, mastercraft)
                if acc.aId is not None:
                    names += [acc.aName]
                    res += [acc.mRentability()]
                    gains += [acc.mGain()]

# Sort the gains by decreasing order
print("-------")
print("Accessories:")
for idx in np.argsort(gains)[::-1]:
    print("{}, marginal gain: {}".format(names[idx], gains[idx]))