Suns of Gold - Trade Calculator v2

This chart uses input variables
  • Buy_World_Chart
  • Sell_World_Chart
  • Expertise
  • Buy_Friction
  • Sell_Friction
  • Buy_Roll
  • Sell_Roll
Result

{# Importing Charts... #}
{% tradeChart = get_chart name:"Standard Trade Charts" %}
{% standardCommodities = get_chart name:"Standard Commodities" %}
{% commodityModifiers = get_chart name:"Commodity Modifiers" %}
{% worldModifiers = get_chart name:"World Modifiers" %}

{# Loading up the ten trade goods that make up our charts #}
{% tradeChartFiltered = filter cols:1 pattern:Buy_World_Chart source:tradeChart %}
{% tradeItemTypes1 = filter pattern:tradeChartFiltered.1.2 source:standardCommodities %}
{% tradeItemRarity1 = tradeItemTypes1.1.3 %}
{% tradeItemTypes1a = tradeItemTypes1.1.5 %}
{% tradeItemTypes1b = tradeItemTypes1.1.6 %}
{% tradeItemTypes1c = tradeItemTypes1.1.7 %}
{% tradeItemTypes2 = filter pattern:tradeChartFiltered.1.3 source:standardCommodities %}
{% tradeItemRarity2 = tradeItemTypes2.1.3 %}
{% tradeItemTypes2a = tradeItemTypes2.1.5 %}
{% tradeItemTypes2b = tradeItemTypes2.1.6 %}
{% tradeItemTypes2c = tradeItemTypes2.1.7 %}
{% tradeItemTypes3 = filter pattern:tradeChartFiltered.1.4 source:standardCommodities %}
{% tradeItemRarity3 = tradeItemTypes3.1.3 %}
{% tradeItemTypes3a = tradeItemTypes3.1.5 %}
{% tradeItemTypes3b = tradeItemTypes3.1.6 %}
{% tradeItemTypes3c = tradeItemTypes3.1.7 %}
{% tradeItemTypes4 = filter pattern:tradeChartFiltered.1.5 source:standardCommodities %}
{% tradeItemRarity4 = tradeItemTypes4.1.3 %}
{% tradeItemTypes4a = tradeItemTypes4.1.5 %}
{% tradeItemTypes4b = tradeItemTypes4.1.6 %}
{% tradeItemTypes4c = tradeItemTypes4.1.7 %}
{% tradeItemTypes5 = filter pattern:tradeChartFiltered.1.6 source:standardCommodities %}
{% tradeItemRarity5 = tradeItemTypes5.1.3 %}
{% tradeItemTypes5a = tradeItemTypes5.1.5 %}
{% tradeItemTypes5b = tradeItemTypes5.1.6 %}
{% tradeItemTypes5c = tradeItemTypes5.1.7 %}
{% tradeItemTypes6 = filter pattern:tradeChartFiltered.1.7 source:standardCommodities %}
{% tradeItemRarity6 = tradeItemTypes6.1.3 %}
{% tradeItemTypes6a = tradeItemTypes6.1.5 %}
{% tradeItemTypes6b = tradeItemTypes6.1.6 %}
{% tradeItemTypes6c = tradeItemTypes6.1.7 %}
{% tradeItemTypes7 = filter pattern:tradeChartFiltered.1.8 source:standardCommodities %}
{% tradeItemRarity7 = tradeItemTypes7.1.3 %}
{% tradeItemTypes7a = tradeItemTypes7.1.5 %}
{% tradeItemTypes7b = tradeItemTypes7.1.6%}
{% tradeItemTypes7c = tradeItemTypes7.1.7%}
{% tradeItemTypes8 = filter pattern:tradeChartFiltered.1.9 source:standardCommodities %}
{% tradeItemRarity8 = tradeItemTypes8.1.3 %}
{% tradeItemTypes8a = tradeItemTypes8.1.5%}
{% tradeItemTypes8b = tradeItemTypes8.1.6%}
{% tradeItemTypes8c = tradeItemTypes8.1.7%}
{% tradeItemTypes9 = filter pattern:tradeChartFiltered.1.10 source:standardCommodities %}
{% tradeItemRarity9 = tradeItemTypes9.1.3 %}
{% tradeItemTypes9a = tradeItemTypes9.1.5%}
{% tradeItemTypes9b = tradeItemTypes9.1.6%}
{% tradeItemTypes9c = tradeItemTypes9.1.7%}
{% tradeItemTypes10 = filter pattern:tradeChartFiltered.1.11 source:standardCommodities %}
{% tradeItemRarity10 = tradeItemTypes10.1.3 %}
{% tradeItemTypes10a = tradeItemTypes10.1.5%}
{% tradeItemTypes10b = tradeItemTypes10.1.6%}
{% tradeItemTypes10c = tradeItemTypes10.1.7%}

{# Loading up the World Modifiers for the Buy and Sell Mod Lookups #}
{% worldBuyModifier = filter pattern:Buy_World_Chart source:worldModifiers %}
{% worldSellModifier = filter pattern:Sell_World_Chart source:worldModifiers %}

{# Cross reference Commodity Types associated with the items
{$tradeChartFiltered.1.2} - {$tradeItemTypes1a} {$tradeItemTypes1b} {$tradeItemTypes1c}
{$tradeChartFiltered.1.3} - {$tradeItemTypes2a} {$tradeItemTypes2b} {$tradeItemTypes2c}
{$tradeChartFiltered.1.4} - {$tradeItemTypes3a} {$tradeItemTypes3b} {$tradeItemTypes3c}
{$tradeChartFiltered.1.5} - {$tradeItemTypes4a} {$tradeItemTypes4b} {$tradeItemTypes4c}
{$tradeChartFiltered.1.6} - {$tradeItemTypes5a} {$tradeItemTypes5b} {$tradeItemTypes5c}
{$tradeChartFiltered.1.7} - {$tradeItemTypes6a} {$tradeItemTypes6b} {$tradeItemTypes6c}
{$tradeChartFiltered.1.8} - {$tradeItemTypes7a} {$tradeItemTypes7b} {$tradeItemTypes7c}
{$tradeChartFiltered.1.9} - {$tradeItemTypes8a} {$tradeItemTypes8b} {$tradeItemTypes8c}
{$tradeChartFiltered.1.10} - {$tradeItemTypes9a} {$tradeItemTypes9b} {$tradeItemTypes9c}
{$tradeChartFiltered.1.11} - {$tradeItemTypes10a} {$tradeItemTypes10b} {$tradeItemTypes10c}
#}

{# --------------------------------------- ROW 1 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod1a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes1a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod1b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes1b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod1c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes1c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod1 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity1}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal1 = {{$tradeChartBaseMod1a} + {$tradeChartBaseMod1b} + {$tradeChartBaseMod1c} + {$tradeChartBaseRarityMod1}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice1 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal1}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod1a = {$worldBuyModifier.1.$tradeItemTypes1a} %}
{% tradeChartBuyMod1b = {$worldBuyModifier.1.$tradeItemTypes1b} %}
{% tradeChartBuyMod1c = {$worldBuyModifier.1.$tradeItemTypes1c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod1a = {$worldSellModifier.1.$tradeItemTypes1a} %}
{% tradeChartSellMod1b = {$worldSellModifier.1.$tradeItemTypes1b} %}
{% tradeChartSellMod1c = {$worldSellModifier.1.$tradeItemTypes1c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal1 = {{$tradeChartBuyMod1a}+{$tradeChartBuyMod1b}+{$tradeChartBuyMod1c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll1= {3d6} %} {%else%} {% tradeChartBuyRoll1 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal1 = {{$tradeChartBuyRoll1}+{$tradeChartBuyModTotal1}} %}
{% tradeBuyMultiplier1a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal1}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier1b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal1}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice1 = {{$tradeChartBasePrice1} * {$tradeBuyMultiplier1b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll1= {3d6} %} {%else%} {% tradeChartSellRoll1 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal1 = {{$tradeChartSellMod1a}+{$tradeChartSellMod1b}+{$tradeChartSellMod1c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal1 = {{$tradeChartSellRoll1}+{$tradeChartSellModTotal1}} %}
{% tradeSellMultiplier1a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal1}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier1b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal1}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice1 = {{$tradeChartBasePrice1} * {$tradeSellMultiplier1b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss1 = {{$tradeCalculatedSellPrice1} - {$tradeCalculatedBuyPrice1}} %}

{# --------------------------------------- ROW 2 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod2a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes2a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod2b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes2b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod2c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes2c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod2 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity2}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal2 = {{$tradeChartBaseMod2a} + {$tradeChartBaseMod2b} + {$tradeChartBaseMod2c} + {$tradeChartBaseRarityMod2}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice2 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal2}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod2a = {$worldBuyModifier.1.$tradeItemTypes2a} %}
{% tradeChartBuyMod2b = {$worldBuyModifier.1.$tradeItemTypes2b} %}
{% tradeChartBuyMod2c = {$worldBuyModifier.1.$tradeItemTypes2c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod2a = {$worldSellModifier.1.$tradeItemTypes2a} %}
{% tradeChartSellMod2b = {$worldSellModifier.1.$tradeItemTypes2b} %}
{% tradeChartSellMod2c = {$worldSellModifier.1.$tradeItemTypes2c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal2 = {{$tradeChartBuyMod2a}+{$tradeChartBuyMod2b}+{$tradeChartBuyMod2c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll2= {3d6} %} {%else%} {% tradeChartBuyRoll2 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal2 = {{$tradeChartBuyRoll2}+{$tradeChartBuyModTotal2}} %}
{% tradeBuyMultiplier2a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal2}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier2b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal2}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice2 = {{$tradeChartBasePrice2} * {$tradeBuyMultiplier2b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll2= {3d6} %} {%else%} {% tradeChartSellRoll2 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal2 = {{$tradeChartSellMod2a}+{$tradeChartSellMod2b}+{$tradeChartSellMod2c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal2 = {{$tradeChartSellRoll2}+{$tradeChartSellModTotal2}} %}
{% tradeSellMultiplier2a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal2}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier2b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal2}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice2 = {{$tradeChartBasePrice2} * {$tradeSellMultiplier2b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss2 = {{$tradeCalculatedSellPrice2} - {$tradeCalculatedBuyPrice2}} %}

{# --------------------------------------- ROW 3 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod3a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes3a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod3b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes3b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod3c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes3c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod3 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity3}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal3 = {{$tradeChartBaseMod3a} + {$tradeChartBaseMod3b} + {$tradeChartBaseMod3c} + {$tradeChartBaseRarityMod3}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice3 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal3}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod3a = {$worldBuyModifier.1.$tradeItemTypes3a} %}
{% tradeChartBuyMod3b = {$worldBuyModifier.1.$tradeItemTypes3b} %}
{% tradeChartBuyMod3c = {$worldBuyModifier.1.$tradeItemTypes3c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod3a = {$worldSellModifier.1.$tradeItemTypes3a} %}
{% tradeChartSellMod3b = {$worldSellModifier.1.$tradeItemTypes3b} %}
{% tradeChartSellMod3c = {$worldSellModifier.1.$tradeItemTypes3c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal3 = {{$tradeChartBuyMod3a}+{$tradeChartBuyMod3b}+{$tradeChartBuyMod3c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll3= {3d6} %} {%else%} {% tradeChartBuyRoll3 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal3 = {{$tradeChartBuyRoll3}+{$tradeChartBuyModTotal3}} %}
{% tradeBuyMultiplier3a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal3}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier3b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal3}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice3 = {{$tradeChartBasePrice3} * {$tradeBuyMultiplier3b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll3= {3d6} %} {%else%} {% tradeChartSellRoll3 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal3 = {{$tradeChartSellMod3a}+{$tradeChartSellMod3b}+{$tradeChartSellMod3c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal3 = {{$tradeChartSellRoll3}+{$tradeChartSellModTotal3}} %}
{% tradeSellMultiplier3a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal3}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier3b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal3}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice3 = {{$tradeChartBasePrice3} * {$tradeSellMultiplier3b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss3 = {{$tradeCalculatedSellPrice3} - {$tradeCalculatedBuyPrice3}} %}

{# --------------------------------------- ROW 4 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod4a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes4a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod4b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes4b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod4c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes4c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod4 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity4}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal4 = {{$tradeChartBaseMod4a} + {$tradeChartBaseMod4b} + {$tradeChartBaseMod4c} + {$tradeChartBaseRarityMod4}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice4 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal4}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod4a = {$worldBuyModifier.1.$tradeItemTypes4a} %}
{% tradeChartBuyMod4b = {$worldBuyModifier.1.$tradeItemTypes4b} %}
{% tradeChartBuyMod4c = {$worldBuyModifier.1.$tradeItemTypes4c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod4a = {$worldSellModifier.1.$tradeItemTypes4a} %}
{% tradeChartSellMod4b = {$worldSellModifier.1.$tradeItemTypes4b} %}
{% tradeChartSellMod4c = {$worldSellModifier.1.$tradeItemTypes4c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal4 = {{$tradeChartBuyMod4a}+{$tradeChartBuyMod4b}+{$tradeChartBuyMod4c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll4= {3d6} %} {%else%} {% tradeChartBuyRoll4 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal4 = {{$tradeChartBuyRoll4}+{$tradeChartBuyModTotal4}} %}
{% tradeBuyMultiplier4a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal4}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier4b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal4}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice4 = {{$tradeChartBasePrice4} * {$tradeBuyMultiplier4b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll4= {3d6} %} {%else%} {% tradeChartSellRoll4 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal4 = {{$tradeChartSellMod4a}+{$tradeChartSellMod4b}+{$tradeChartSellMod4c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal4 = {{$tradeChartSellRoll4}+{$tradeChartSellModTotal4}} %}
{% tradeSellMultiplier4a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal4}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier4b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal4}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice4 = {{$tradeChartBasePrice4} * {$tradeSellMultiplier4b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss4 = {{$tradeCalculatedSellPrice4} - {$tradeCalculatedBuyPrice4}} %}

{# --------------------------------------- ROW 5 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod5a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes5a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod5b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes5b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod5c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes5c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod5 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity5}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal5 = {{$tradeChartBaseMod5a} + {$tradeChartBaseMod5b} + {$tradeChartBaseMod5c} + {$tradeChartBaseRarityMod5}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice5 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal5}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod5a = {$worldBuyModifier.1.$tradeItemTypes5a} %}
{% tradeChartBuyMod5b = {$worldBuyModifier.1.$tradeItemTypes5b} %}
{% tradeChartBuyMod5c = {$worldBuyModifier.1.$tradeItemTypes5c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod5a = {$worldSellModifier.1.$tradeItemTypes5a} %}
{% tradeChartSellMod5b = {$worldSellModifier.1.$tradeItemTypes5b} %}
{% tradeChartSellMod5c = {$worldSellModifier.1.$tradeItemTypes5c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal5 = {{$tradeChartBuyMod5a}+{$tradeChartBuyMod5b}+{$tradeChartBuyMod5c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll5= {3d6} %} {%else%} {% tradeChartBuyRoll5 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal5 = {{$tradeChartBuyRoll5}+{$tradeChartBuyModTotal5}} %}
{% tradeBuyMultiplier5a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal5}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier5b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal5}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice5 = {{$tradeChartBasePrice5} * {$tradeBuyMultiplier5b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll5= {3d6} %} {%else%} {% tradeChartSellRoll5 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal5 = {{$tradeChartSellMod5a}+{$tradeChartSellMod5b}+{$tradeChartSellMod5c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal5 = {{$tradeChartSellRoll5}+{$tradeChartSellModTotal5}} %}
{% tradeSellMultiplier5a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal5}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier5b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal5}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice5 = {{$tradeChartBasePrice5} * {$tradeSellMultiplier5b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss5 = {{$tradeCalculatedSellPrice5} - {$tradeCalculatedBuyPrice5}} %}

{# --------------------------------------- ROW 6 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod6a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes6a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod6b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes6b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod6c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes6c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod6 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity6}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal6 = {{$tradeChartBaseMod6a} + {$tradeChartBaseMod6b} + {$tradeChartBaseMod6c} + {$tradeChartBaseRarityMod6}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice6 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal6}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod6a = {$worldBuyModifier.1.$tradeItemTypes6a} %}
{% tradeChartBuyMod6b = {$worldBuyModifier.1.$tradeItemTypes6b} %}
{% tradeChartBuyMod6c = {$worldBuyModifier.1.$tradeItemTypes6c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod6a = {$worldSellModifier.1.$tradeItemTypes6a} %}
{% tradeChartSellMod6b = {$worldSellModifier.1.$tradeItemTypes6b} %}
{% tradeChartSellMod6c = {$worldSellModifier.1.$tradeItemTypes6c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal6 = {{$tradeChartBuyMod6a}+{$tradeChartBuyMod6b}+{$tradeChartBuyMod6c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll6= {3d6} %} {%else%} {% tradeChartBuyRoll6 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal6 = {{$tradeChartBuyRoll6}+{$tradeChartBuyModTotal6}} %}
{% tradeBuyMultiplier6a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal6}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier6b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal6}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice6 = {{$tradeChartBasePrice6} * {$tradeBuyMultiplier6b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll6= {3d6} %} {%else%} {% tradeChartSellRoll6 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal6 = {{$tradeChartSellMod6a}+{$tradeChartSellMod6b}+{$tradeChartSellMod6c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal6 = {{$tradeChartSellRoll6}+{$tradeChartSellModTotal6}} %}
{% tradeSellMultiplier6a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal6}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier6b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal6}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice6 = {{$tradeChartBasePrice6} * {$tradeSellMultiplier6b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss6 = {{$tradeCalculatedSellPrice6} - {$tradeCalculatedBuyPrice6}} %}

{# --------------------------------------- ROW 7 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod7a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes7a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod7b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes7b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod7c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes7c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod7 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity7}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal7 = {{$tradeChartBaseMod7a} + {$tradeChartBaseMod7b} + {$tradeChartBaseMod7c} + {$tradeChartBaseRarityMod7}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice7 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal7}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod7a = {$worldBuyModifier.1.$tradeItemTypes7a} %}
{% tradeChartBuyMod7b = {$worldBuyModifier.1.$tradeItemTypes7b} %}
{% tradeChartBuyMod7c = {$worldBuyModifier.1.$tradeItemTypes7c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod7a = {$worldSellModifier.1.$tradeItemTypes7a} %}
{% tradeChartSellMod7b = {$worldSellModifier.1.$tradeItemTypes7b} %}
{% tradeChartSellMod7c = {$worldSellModifier.1.$tradeItemTypes7c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal7 = {{$tradeChartBuyMod7a}+{$tradeChartBuyMod7b}+{$tradeChartBuyMod7c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll7= {3d6} %} {%else%} {% tradeChartBuyRoll7 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal7 = {{$tradeChartBuyRoll7}+{$tradeChartBuyModTotal7}} %}
{% tradeBuyMultiplier7a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal7}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier7b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal7}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice7 = {{$tradeChartBasePrice7} * {$tradeBuyMultiplier7b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll7= {3d6} %} {%else%} {% tradeChartSellRoll7 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal7 = {{$tradeChartSellMod7a}+{$tradeChartSellMod7b}+{$tradeChartSellMod7c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal7 = {{$tradeChartSellRoll7}+{$tradeChartSellModTotal7}} %}
{% tradeSellMultiplier7a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal7}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier7b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal7}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice7 = {{$tradeChartBasePrice7} * {$tradeSellMultiplier7b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss7 = {{$tradeCalculatedSellPrice7} - {$tradeCalculatedBuyPrice7}} %}

{# --------------------------------------- ROW 8 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod8a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes8a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod8b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes8b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod8c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes8c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod8 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity8}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal8 = {{$tradeChartBaseMod8a} + {$tradeChartBaseMod8b} + {$tradeChartBaseMod8c} + {$tradeChartBaseRarityMod8}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice8 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal8}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod8a = {$worldBuyModifier.1.$tradeItemTypes8a} %}
{% tradeChartBuyMod8b = {$worldBuyModifier.1.$tradeItemTypes8b} %}
{% tradeChartBuyMod8c = {$worldBuyModifier.1.$tradeItemTypes8c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod8a = {$worldSellModifier.1.$tradeItemTypes8a} %}
{% tradeChartSellMod8b = {$worldSellModifier.1.$tradeItemTypes8b} %}
{% tradeChartSellMod8c = {$worldSellModifier.1.$tradeItemTypes8c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal8 = {{$tradeChartBuyMod8a}+{$tradeChartBuyMod8b}+{$tradeChartBuyMod8c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll8= {3d6} %} {%else%} {% tradeChartBuyRoll8 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal8 = {{$tradeChartBuyRoll8}+{$tradeChartBuyModTotal8}} %}
{% tradeBuyMultiplier8a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal8}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier8b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal8}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice8 = {{$tradeChartBasePrice8} * {$tradeBuyMultiplier8b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll8= {3d6} %} {%else%} {% tradeChartSellRoll8 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal8 = {{$tradeChartSellMod8a}+{$tradeChartSellMod8b}+{$tradeChartSellMod8c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal8 = {{$tradeChartSellRoll8}+{$tradeChartSellModTotal8}} %}
{% tradeSellMultiplier8a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal8}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier8b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal8}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice8 = {{$tradeChartBasePrice8} * {$tradeSellMultiplier8b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss8 = {{$tradeCalculatedSellPrice8} - {$tradeCalculatedBuyPrice8}} %}

{# --------------------------------------- ROW 9 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod9a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes9a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod9b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes9b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod9c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes9c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod9 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity9}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal9 = {{$tradeChartBaseMod9a} + {$tradeChartBaseMod9b} + {$tradeChartBaseMod9c} + {$tradeChartBaseRarityMod9}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice9 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal9}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod9a = {$worldBuyModifier.1.$tradeItemTypes9a} %}
{% tradeChartBuyMod9b = {$worldBuyModifier.1.$tradeItemTypes9b} %}
{% tradeChartBuyMod9c = {$worldBuyModifier.1.$tradeItemTypes9c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod9a = {$worldSellModifier.1.$tradeItemTypes9a} %}
{% tradeChartSellMod9b = {$worldSellModifier.1.$tradeItemTypes9b} %}
{% tradeChartSellMod9c = {$worldSellModifier.1.$tradeItemTypes9c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal9 = {{$tradeChartBuyMod9a}+{$tradeChartBuyMod9b}+{$tradeChartBuyMod9c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll9= {3d6} %} {%else%} {% tradeChartBuyRoll9 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal9 = {{$tradeChartBuyRoll9}+{$tradeChartBuyModTotal9}} %}
{% tradeBuyMultiplier9a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal9}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier9b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal9}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice9 = {{$tradeChartBasePrice9} * {$tradeBuyMultiplier9b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll9= {3d6} %} {%else%} {% tradeChartSellRoll9 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal9 = {{$tradeChartSellMod9a}+{$tradeChartSellMod9b}+{$tradeChartSellMod9c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal9 = {{$tradeChartSellRoll9}+{$tradeChartSellModTotal9}} %}
{% tradeSellMultiplier9a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal9}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier9b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal9}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice9 = {{$tradeChartBasePrice9} * {$tradeSellMultiplier9b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss9 = {{$tradeCalculatedSellPrice9} - {$tradeCalculatedBuyPrice9}} %}

{# --------------------------------------- ROW 10 VALUES --------------------------------------- #}
{# ---------------- Lookup Commodity Type Mods ---------------- #}
{% tradeChartBaseMod10a = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes10a}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod10b = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes10b}", filter_cols="1", cols="2")} %}
{% tradeChartBaseMod10c = {CHART(name="Commodity Modifiers", filter="{$tradeItemTypes10c}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Rarity Mod ---------------- #}
{% tradeChartBaseRarityMod10 = {CHART(name="Rarity Modifier", filter="{$tradeItemRarity10}", filter_cols="1", cols="2")} %}
{# ---------------- Calculate Base Mod Total ---------------- #}
{% tradeChartBaseModTotal10 = {{$tradeChartBaseMod10a} + {$tradeChartBaseMod10b} + {$tradeChartBaseMod10c} + {$tradeChartBaseRarityMod10}}%}
{# ---------------- Lookup Base Price ---------------- #}
{% tradeChartBasePrice10 = {CHART(name="Commodity Prices" filter_cols="1" filter_exact="{$tradeChartBaseModTotal10}", cols="2")} %}
{# ---------------- Lookup Buy Price Mods ---------------- #}
{% tradeChartBuyMod10a = {$worldBuyModifier.1.$tradeItemTypes10a} %}
{% tradeChartBuyMod10b = {$worldBuyModifier.1.$tradeItemTypes10b} %}
{% tradeChartBuyMod10c = {$worldBuyModifier.1.$tradeItemTypes10c} %}
{# ---------------- Lookup Sell Price Mods ---------------- #}
{% tradeChartSellMod10a = {$worldSellModifier.1.$tradeItemTypes10a} %}
{% tradeChartSellMod10b = {$worldSellModifier.1.$tradeItemTypes10b} %}
{% tradeChartSellMod10c = {$worldSellModifier.1.$tradeItemTypes10c} %}
{# ---------------- Calculate Buy Price Mods ---------------- #}
{% tradeChartBuyModTotal10 = {{$tradeChartBuyMod10a}+{$tradeChartBuyMod10b}+{$tradeChartBuyMod10c}+{$Buy_Friction}-{$Expertise}} %}
{# ---------------- Calculate Buy Roll ---------------- #}
{%if Buy_Roll == "Random"%} {% tradeChartBuyRoll10= {3d6} %} {%else%} {% tradeChartBuyRoll10 = Buy_Roll %} {%end%}
{# ---------------- Calculate Buy Multiplier ---------------- #}
{% tradeBuyRollTotal10 = {{$tradeChartBuyRoll10}+{$tradeChartBuyModTotal10}} %}
{% tradeBuyMultiplier10a = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal10}", filter_cols="1", cols="2")} %}
{% tradeBuyMultiplier10b = {CHART(name="Price Multiplier", filter_exact="{$tradeBuyRollTotal10}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Buy Price ---------------- #}
{% tradeCalculatedBuyPrice10 = {{$tradeChartBasePrice10} * {$tradeBuyMultiplier10b}} %}
{# ---------------- Calculate Sell Roll ---------------- #}
{%if Sell_Roll == "Random"%} {% tradeChartSellRoll10= {3d6} %} {%else%} {% tradeChartSellRoll10 = Sell_Roll %} {%end%}
{# ---------------- Calculate Sell Price Mods ---------------- #}
{% tradeChartSellModTotal10 = {{$tradeChartSellMod10a}+{$tradeChartSellMod10b}+{$tradeChartSellMod10c}-{$Sell_Friction}+{$Expertise}} %}
{# ---------------- Calculate Sell Multiplier ---------------- #}
{% tradeSellRollTotal10 = {{$tradeChartSellRoll10}+{$tradeChartSellModTotal10}} %}
{% tradeSellMultiplier10a = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal10}", filter_cols="1", cols="2")} %}
{% tradeSellMultiplier10b = {CHART(name="Price Multiplier", filter_exact="{$tradeSellRollTotal10}", filter_cols="1", cols="3")} %}
{# ---------------- Calculate Sell Price ---------------- #}
{% tradeCalculatedSellPrice10 = {{$tradeChartBasePrice10} * {$tradeSellMultiplier10b}} %}
{# ---------------- Calculate Profit or Loss ---------------- #}
{% tradeCalculatedProfitLoss10 = {{$tradeCalculatedSellPrice10} - {$tradeCalculatedBuyPrice10}} %}

{# --------- !!!!!RENDER THE RESULTS IN NICE TABLES!!!! --------- #}

Quick Instructions

  • Select the World Type Commodities are Purchased from with the BuyWorldChart
  • Select the World Type Commodities are Sold to with the SellWorldChart
  • Determine BuyFriction and SellFriction (Starting Friction is usually 2 to 5).
  • Determine Expertise to Improve Trade Results (Trade Skill + Connect & Highest Intelligence or Charisma Modifier)
  • BuyRoll and SellRoll are 3d6, however if you enter in desired value it will override the roll.
  • It may take a moment to calculate (it is a lot to calculate!) so be patient!
  • Sometimes errors crop up, just reroll it and it usually always work.

Available {$Buy_World_Chart} Trade Commodities

1d10 Commodity Types Rarity Bulk Base Mod Base Price
1 {$tradeChartFiltered.1.2} {$tradeItemTypes1a} {%if tradeItemTypes1b == "None"%} {%else%}, {$tradeItemTypes1b}{%end%} {%if tradeItemTypes1c == "None"%} {%else%}, {$tradeItemTypes1c}{%end%} {$tradeItemRarity1} {$tradeItemTypes1.1.8} {$tradeChartBaseModTotal1} {$tradeChartBasePrice1}
2 {$tradeChartFiltered.1.3} {$tradeItemTypes2a} {%if tradeItemTypes2b == "None"%} {%else%}, {$tradeItemTypes2b}{%end%} {%if tradeItemTypes2c == "None"%} {%else%}, {$tradeItemTypes2c}{%end%} {$tradeItemRarity2} {$tradeItemTypes2.1.8} {$tradeChartBaseModTotal2} {$tradeChartBasePrice2}
3 {$tradeChartFiltered.1.4} {$tradeItemTypes3a} {%if tradeItemTypes3b == "None"%} {%else%}, {$tradeItemTypes3b}{%end%} {%if tradeItemTypes3c == "None"%} {%else%}, {$tradeItemTypes3c}{%end%} {$tradeItemRarity3} {$tradeItemTypes3.1.8} {$tradeChartBaseModTotal3} {$tradeChartBasePrice3}
4 {$tradeChartFiltered.1.5} {$tradeItemTypes4a} {%if tradeItemTypes4b == "None"%} {%else%}, {$tradeItemTypes4b}{%end%} {%if tradeItemTypes4c == "None"%} {%else%}, {$tradeItemTypes4c}{%end%} {$tradeItemRarity4} {$tradeItemTypes4.1.8} {$tradeChartBaseModTotal4} {$tradeChartBasePrice4}
5 {$tradeChartFiltered.1.6} {$tradeItemTypes5a} {%if tradeItemTypes5b == "None"%} {%else%}, {$tradeItemTypes5b}{%end%} {%if tradeItemTypes5c == "None"%} {%else%}, {$tradeItemTypes5c}{%end%} {$tradeItemRarity5} {$tradeItemTypes5.1.8} {$tradeChartBaseModTotal5} {$tradeChartBasePrice5}
6 {$tradeChartFiltered.1.7} {$tradeItemTypes6a} {%if tradeItemTypes6b == "None"%} {%else%}, {$tradeItemTypes6b}{%end%} {%if tradeItemTypes6c == "None"%} {%else%}, {$tradeItemTypes6c}{%end%} {$tradeItemRarity6} {$tradeItemTypes6.1.8} {$tradeChartBaseModTotal6} {$tradeChartBasePrice6}
7 {$tradeChartFiltered.1.8} {$tradeItemTypes7a} {%if tradeItemTypes7b == "None"%} {%else%}, {$tradeItemTypes7b}{%end%} {%if tradeItemTypes7c == "None"%} {%else%}, {$tradeItemTypes7c}{%end%} {$tradeItemRarity7} {$tradeItemTypes7.1.8} {$tradeChartBaseModTotal7} {$tradeChartBasePrice7}
8 {$tradeChartFiltered.1.9} {$tradeItemTypes8a} {%if tradeItemTypes8b == "None"%} {%else%}, {$tradeItemTypes8b}{%end%} {%if tradeItemTypes8c == "None"%} {%else%}, {$tradeItemTypes8c}{%end%} {$tradeItemRarity8} {$tradeItemTypes8.1.8} {$tradeChartBaseModTotal8} {$tradeChartBasePrice8}
9 {$tradeChartFiltered.1.10} {$tradeItemTypes9a} {%if tradeItemTypes9b == "None"%} {%else%}, {$tradeItemTypes9b}{%end%} {%if tradeItemTypes9c == "None"%} {%else%}, {$tradeItemTypes9c}{%end%} {$tradeItemRarity9} {$tradeItemTypes9.1.8} {$tradeChartBaseModTotal9} {$tradeChartBasePrice9}
10 {$tradeChartFiltered.1.11} {$tradeItemTypes10a} {%if tradeItemTypes10b == "None"%} {%else%}, {$tradeItemTypes10b}{%end%} {%if tradeItemTypes10c == "None"%} {%else%}, {$tradeItemTypes10c}{%end%} {$tradeItemRarity10} {$tradeItemTypes10.1.8} {$tradeChartBaseModTotal10} {$tradeChartBasePrice10}

Deal Information

Expertise: {$Expertise}, Buy Friction: {$Buy_Friction}, Sell Friction: {$Sell_Friction}

{$Buy_World_Chart} Buy Modifiers: Roll on "World Modifiers" (cols="2", filter="{$Buy_World_Chart}", filter_cols="1")
{$Sell_World_Chart} Sell Modifiers: Roll on "World Modifiers" (cols="2", filter="{$Sell_World_Chart}", filter_cols="1")
Commodity Buy Roll Buy Mod Buy Total Buy Multiplier Buy Price Sell Roll Sell Mod Sell Total Sell Multiplier Sell Price Profit or Loss
{$tradeChartFiltered.1.2} {$tradeChartBuyRoll1} {$tradeChartBuyModTotal1} {$tradeBuyRollTotal1} {$tradeBuyMultiplier1a} Roll round({$tradeCalculatedBuyPrice1}) {$tradeChartSellRoll1} {$tradeChartSellModTotal1} {$tradeSellRollTotal1} {$tradeSellMultiplier1a} Roll round({$tradeCalculatedSellPrice1}) Roll round({$tradeCalculatedProfitLoss1})
{$tradeChartFiltered.1.3} {$tradeChartBuyRoll2} {$tradeChartBuyModTotal2} {$tradeBuyRollTotal2} {$tradeBuyMultiplier2a} Roll round({$tradeCalculatedBuyPrice2}) {$tradeChartSellRoll2} {$tradeChartSellModTotal2} {$tradeSellRollTotal2} {$tradeSellMultiplier2a} Roll round({$tradeCalculatedSellPrice2}) Roll round({$tradeCalculatedProfitLoss2})
{$tradeChartFiltered.1.4} {$tradeChartBuyRoll3} {$tradeChartBuyModTotal3} {$tradeBuyRollTotal3} {$tradeBuyMultiplier3a} Roll round({$tradeCalculatedBuyPrice3}) {$tradeChartSellRoll3} {$tradeChartSellModTotal3} {$tradeSellRollTotal3} {$tradeSellMultiplier3a} Roll round({$tradeCalculatedSellPrice3}) Roll round({$tradeCalculatedProfitLoss3})
{$tradeChartFiltered.1.5} {$tradeChartBuyRoll4} {$tradeChartBuyModTotal4} {$tradeBuyRollTotal4} {$tradeBuyMultiplier4a} Roll round({$tradeCalculatedBuyPrice4}) {$tradeChartSellRoll4} {$tradeChartSellModTotal4} {$tradeSellRollTotal4} {$tradeSellMultiplier4a} Roll round({$tradeCalculatedSellPrice4}) Roll round({$tradeCalculatedProfitLoss4})
{$tradeChartFiltered.1.6} {$tradeChartBuyRoll5} {$tradeChartBuyModTotal5} {$tradeBuyRollTotal5} {$tradeBuyMultiplier5a} Roll round({$tradeCalculatedBuyPrice5}) {$tradeChartSellRoll5} {$tradeChartSellModTotal5} {$tradeSellRollTotal5} {$tradeSellMultiplier5a} Roll round({$tradeCalculatedSellPrice5}) Roll round({$tradeCalculatedProfitLoss5})
{$tradeChartFiltered.1.7} {$tradeChartBuyRoll6} {$tradeChartBuyModTotal6} {$tradeBuyRollTotal6} {$tradeBuyMultiplier6a} Roll round({$tradeCalculatedBuyPrice6}) {$tradeChartSellRoll6} {$tradeChartSellModTotal6} {$tradeSellRollTotal6} {$tradeSellMultiplier6a} Roll round({$tradeCalculatedSellPrice6}) Roll round({$tradeCalculatedProfitLoss6})
{$tradeChartFiltered.1.8} {$tradeChartBuyRoll7} {$tradeChartBuyModTotal7} {$tradeBuyRollTotal7} {$tradeBuyMultiplier7a} Roll round({$tradeCalculatedBuyPrice7}) {$tradeChartSellRoll7} {$tradeChartSellModTotal7} {$tradeSellRollTotal7} {$tradeSellMultiplier7a} Roll round({$tradeCalculatedSellPrice7}) Roll round({$tradeCalculatedProfitLoss7})
{$tradeChartFiltered.1.9} {$tradeChartBuyRoll8} {$tradeChartBuyModTotal8} {$tradeBuyRollTotal8} {$tradeBuyMultiplier8a} Roll round({$tradeCalculatedBuyPrice8}) {$tradeChartSellRoll8} {$tradeChartSellModTotal8} {$tradeSellRollTotal8} {$tradeSellMultiplier8a} Roll round({$tradeCalculatedSellPrice8}) Roll round({$tradeCalculatedProfitLoss8})
{$tradeChartFiltered.1.10} {$tradeChartBuyRoll9} {$tradeChartBuyModTotal9} {$tradeBuyRollTotal9} {$tradeBuyMultiplier9a} Roll round({$tradeCalculatedBuyPrice9}) {$tradeChartSellRoll9} {$tradeChartSellModTotal9} {$tradeSellRollTotal9} {$tradeSellMultiplier9a} Roll round({$tradeCalculatedSellPrice9}) Roll round({$tradeCalculatedProfitLoss9})
{$tradeChartFiltered.1.10} {$tradeChartBuyRoll10} {$tradeChartBuyModTotal10} {$tradeBuyRollTotal10} {$tradeBuyMultiplier10a} Roll round({$tradeCalculatedBuyPrice10}) {$tradeChartSellRoll10} {$tradeChartSellModTotal10} {$tradeSellRollTotal10} {$tradeSellMultiplier10a} Roll round({$tradeCalculatedSellPrice10}) Roll round({$tradeCalculatedProfitLoss10})

Subcharts

Commodity Modifiers (d21)

d21 Type Price Modifier

1

Agricultural

-2

2

Alien

+2

3

Astronautic

+1

4

Biotech

+1

5

Consumer

0

6

Cultural

0

7

Livestock

0

8

Low_Tech

-1

9

Luxury

+2

10

Maltech

+4

11

Medical

+2

12

Military

+1

13

Mineral

-1

14

Postech

0

15

Pretech

+3

16

Religious

0

17

Sapient

+2

18

Survival

0

19

Tools

+1

20

Vehicle

+1

21

None

0

Rarity Modifier (1d3)

1d3 Result Modifier

1

Rare

1

2

Normal

0

3

Common

-1

Standard Commodities (1d34)

1d34 Commodity Base Price Rarity Rarity Mod Type1 Type2 Type3 Bulk

1

Clothing

1000

Common

-1

Low_Tech

Cultural

None

Normal

2

Colonial Materials

2000

Common

-1

Survival

Postech

None

Normal

3

Colonial Supplies

1000

Normal

0

Agricultural

Survival

None

Normal

4

Drugs, Raw Materials

2000

Normal

0

Agricultural

Biotech

None

Bulky

5

Drugs, Recreational

50000

Normal

0

Luxury

Biotech

None

Compact

6

Exotic Jewels

25000

Rare

1

Mineral

Luxury

None

Compact

7

Fine Liquor

10000

Normal

0

Luxury

Low_Tech

None

Compact

8

Fusion Plants

10000

Normal

0

Postech

Tools

None

Bulky

9

Ghoul Immortality Tech

400000

Normal

0

Medical

Maltech

None

Compact

10

Housewares, Basic

2000

Normal

0

Low_Tech

Consumer

None

Normal

11

Housewares, Postech

5000

Normal

0

Postech

Consumer

None

Normal

12

Housewares, Pretech

20000

Normal

0

Pretech

Consumer

None

Normal

13

Livestock, Common

2000

Common

-1

Livestock

None

None

Normal

14

Livestock, Gengineered

10000

Normal

0

Livestock

Biotech

None

Normal

15

Livestock, Luxury

25000

Normal

0

Livestock

Luxury

None

Normal

16

Medical Supplies, Postech

25000

Normal

0

Medical

Postech

None

Compact

17

Medical Supplies, Pretech

20000

Normal

0

Medical

Pretech

None

Compact

18

Metal Ingots, Common

1000

Common

-1

Mineral

None

None

Bulky

19

Metal Ingots, Rare Alloys

5000

Rare

1

Mineral

None

None

Bulky

20

Metawheat

500

Common

-1

Agricultural

None

None

Bulky

21

Native Artwork

10000

Normal

0

Cultural

Luxury

None

Normal

22

Parts, Basic Industry

5000

Normal

0

Low_Tech

Tools

None

Normal

23

Parts, Pretech Industry

100000

Normal

0

Pretech

Tools

None

Normal

24

Parts, Starship Maintenance

25000

Rare

1

Postech

Astronautic

None

Normal

25

Postech Building Material

10000

Normal

0

Tools

Postech

None

Bulky

26

Pretech Junk

50000

Normal

0

Pretech

None

None

Normal

27

Slaves

25000

Normal

0

Sapient

None

None

Normal

28

Small Arms, Energy

10000

Normal

0

Military

Postech

None

Normal

29

Small Arms, Pretech

100000

Normal

0

Military

Pretech

None

Normal

30

Small Arms, Projectile

5000

Normal

0

Military

Low_Tech

None

Normal

31

Tools, Astronautic

25000

Normal

0

Tools

Postech

Astronautic

Normal

32

Tools, Basic Hand Tools

5000

Normal

0

Tools

Low_Tech

None

Normal

33

Tools, Industrial

10000

Normal

0

Tools

Postech

None

Normal

34

Tools, Medical Equipment

50000

Normal

0

Tools

Postech

Medical

Normal

Standard Trade Charts (d8)

d8 Agricultural Result Result Result Result Result Result Result Result Result Result

1

Agricultural

Clothing

Drugs, Raw Materials

Fine Liquor

Housewares, Basic

Livestock, Common

Livestock, Gengineered

Livestock, Luxury

Metawheat

Native Artwork

Tools, Basic Hand Tools

2

Alien

Clothing

Drugs, Raw Materials

Housewares, Postech

Livestock, Common

Livestock, Gengineered

Metawheat

Native Artwork

Pretech Junk

Small Arms, Energy

Tools, Industrial

3

Cosmopolitan

Clothing

Colonial Supplies

Drugs, Raw Materials

Exotic Jewels

Housewares, Postech

Medical Supplies, Postech

Parts, Basic Industry

Small Arms, Energy

Small Arms, Projectile

Fine Liquor

4

Decadent

Clothing

Drugs, Raw Materials

Drugs, Recreational

Exotic Jewels

Fine Liquor

Livestock, Gengineered

Livestock, Luxury

Medical Supplies, Postech

Slaves

Tools, Medical Equipment

5

Industrial

Colonial Supplies

Fusion Plants

Housewares, Postech

Native Artwork

Parts, Basic Industry

Postech Building Material

Small Arms, Energy

Small Arms, Projectile

Tools, Basic Hand Tools

Tools, Industrial

6

Primitive

Clothing

Drugs, Raw Materials

Housewares, Basic

Livestock, Common

Metal Ingots, Common

Metal Ingots, Rare Alloys

Metawheat

Native Artwork

Slaves

Tools, Basic Hand Tools

7

Savage

Drugs, Raw Materials

Housewares, Basic

Livestock, Common

Metawheat

Native Artwork

Pretech Junk

Slaves

Small Arms, Projectile

Tools, Basic Hand Tools

Fine Liquor

8

Tyrannical

Drugs, Raw Materials

Housewares, Basic

Metal Ingots, Common

Metal Ingots, Rare Alloys

Parts, Basic Industry

Postech Building Material

Slaves

Small Arms, Energy

Small Arms, Projectile

Tools, Industrial

World Modifiers (d8)

d8 Result Description Agricultural Alien Cosmopolitan Biotech Consumer Cultural Livestock Low_Tech Luxury Maltech Medical Military Mineral Postech Pretech Religious Sapient Survival Tools Vehicle None

1

Agricultural

-2 Agricultural, -1 Livestock, +1 Biotech, +2 Tools

-2

0

0

+1

0

0

-1

0

0

0

0

0

0

0

0

0

0

0

+2

0

0

2

Alien

-2 Alien, -1 Medical, +1 Biotech, +2 Cultural

0

-2

0

+1

0

+2

0

0

0

0

-1

0

0

0

0

0

0

0

0

0

0

3

Cosmopolitan

-2 Cultural, -1 Military, +1 Luxury, +2 Pretech

0

0

0

0

0

-2

0

0

+1

0

0

-1

0

0

+2

0

0

0

0

0

0

4

Decadent

2 Sapient, -1 Biotech, +1 Maltech, +2 Luxury

0

0

0

-1

0

0

0

0

-1

+2

0

0

0

0

0

0

-2

0

0

0

0

5

Industrial

-2 Consumer, -1 Tools, +1 Agricultural, +2 Mineral

0

0

0

0

-2

0

0

0

0

0

0

0

+2

0

0

0

0

0

-1

0

0

6

Primitive

-2 Agricultural, -1 Livestock, +1 Tools, +2 Postech

-2

0

0

0

0

0

-1

0

0

0

0

0

0

+2

0

0

0

0

+1

0

0

7

Savage

-2 Agricultural, -1 Sapient, +1 Tools, +2 Military

-2

0

0

0

0

0

0

0

0

0

0

+2

0

0

0

0

-1

0

+1

0

0

8

Tyrannical

-2 Mineral, -1 Sapient, +1 Military, +2 Medical

0

0

0

0

0

0

0

0

0

0

+2

+1

-2

0

0

0

-1

0

0

0

0

Commodity Prices (d20)

d20 Result Unit Price

1

-9

1

2

-8

10

3

-7

25

4

-6

50

5

-5

100

6

-4

250

7

-3

500

8

-2

1000

9

-1

2000

10

0

5000

11

1

10000

12

2

25000

13

3

50000

14

4

100000

15

5

200000

16

6

400000

17

7

800000

18

8

1600000

19

9

3200000

20

10

6400000

Price Multiplier (d27)

d27 Result Result Result

1

-2

-90%

.1

2

-1

-90%

.1

3

0

-90%

.1

4

1

-90%

.1

5

2

-90%

.1

6

3

-70%

.3

7

4

-60%

.4

8

5

-50%

.5

9

6

-40%

.6

10

7

-30%

.7

11

8

-20%

.8

12

9

-10%

.9

13

10

0%

1

14

11

0%

1

15

12

+10%

1.1

16

13

+20%

1.2

17

14

+40%

1.4

18

15

+60%

1.6

19

16

+80%

1.8

20

17

+100%

2

21

18

+150%

2.5

22

19

+200%

3

23

20

+200%

3

24

21

+200%

3

25

22

+200%

3

26

23

+200%

3

27

24

+200%

3