SHARE
TWEET

Custom Prices (Sheymin, Sheynorm, Sheymax)

Sheyrah Aug 28th, 2017 (edited) 150,842 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sheymin, sheynorm and sheymax are at the bottom of this paste. It's at the bottom because eventually people won't need to make these 3 custom prices once the feature is implemented in TSM4, for now you still have to make sheymin, sheynorm, sheymax)
  2.  
  3.  
  4.  
  5.  
  6. Legion Custom Prices: You must have at least one recipe that uses this material for it to show up in the materials tab.
  7.  
  8. Blood Of Sargeras Custom Price:
  9.  
  10. max(dbmarket(i:124118) * 10, dbmarket(i:124119) * 10, dbmarket(i:124120) * 10, dbmarket(i:124121) * 10, dbmarket(i:124107) * 10, dbmarket(i:124108) * 10, dbmarket(i:124109) * 10, dbmarket(i:124110) * 10, dbmarket(i:124111) * 10, dbmarket(i:124112)* 10, dbmarket(i:124101) * 10, dbmarket(i:124102) * 10, dbmarket(i:124103) * 10, dbmarket(i:124104) * 10, dbmarket(i:124105) * 3, dbmarket(i:123918) * 10, dbmarket(i:123919) * 5, dbmarket(i:124113) * 10, dbmarket(i:124115) * 10, dbmarket(i:124438) * 20, dbmarket(i:124121) * 20, dbmarket(i:124437) * 10, dbmarket(i:124440) * 10, dbmarket(i:124441) * 3)
  11.  
  12.  
  13.  
  14.  
  15. Primal Sargerite Custom Price:
  16.  
  17. max(dbmarket(i:151565) * 10, dbmarket(i:151564) * 10, dbmarket(i:151566) * 10, dbmarket(i:151567) * 10, dbmarket(i:151579) / 10, dbmarket(i:151722) / 10, dbmarket(i:151720) / 10, dbmarket(i:151718) / 10, dbmarket(i:151721) / 10, dbmarket(i:151719) / 10)
  18.  
  19.  
  20.  
  21.  
  22. Material Price for Roseaste Pigments and Sallow Pigments: This one is from Bilis, see link for details.
  23.  
  24. DBMarket * (matPrice(i:124102) / (0.45 * DBMarket(i:129032) + 0.1 * DBMarket(i:129034)))
  25.  
  26. https://www.reddit.com/r/woweconomy/comments/71wqu5/tsminscription_a_way_to_value_your_pigments/
  27.  
  28.  
  29.  
  30.  
  31. Primal Spirit Custom Price:
  32.  
  33. avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*5
  34.  
  35. What this does is, it will look at the average price you pay for current expansion herbs to determine a price for your primal spirit. Because primal spirits are soulbound, they can't exist on the AH, so tsm can't determine a value for it. Since trading in 5 herbs will give you a primal spirit, you work around this problem this way. If you just installed my profile, you will have no accounting data, so  you will need to go buy at least 1 of every current expansion herb and collect those bought herbs from your mailbox for tsm to register your average buy price of herbs. For those of you that don't go buy 1 of each current expansion herb, I have a backup in the string to just reference the market value of herbs on your server. I had to put this back up in there because too many people were getting lost with tsm not showing a price for primal spirits because they didn't know they had to buy 1 of each current expansion herb. Now in  your profession window you will see a price/profit for all those items that are made with primal spirits, ie upgrade tokens and epic armor/weapons.
  36.  
  37.  
  38.  
  39.  
  40. Temporal Crystal Fix:
  41.  
  42. Next, type in "Temporal Crystal" without the quotations in the same box you had typed "Primal Spirts". The default setting is this, min(dbmarket, crafting, vendorbuy, convert(dbmarket)), you want to delete the crafting part, because the only way you can craft a temporal crystal is the daily CD, so it appears a temporal crystal is worth the same as a luminous shard, which is not the case, so you have to take the crafting part out or you will lose a lot of gold. make it look like this:
  43.  
  44. min(dbmarket, vendorbuy, convert(dbmarket))
  45.  
  46.  
  47. "minprice"
  48.  
  49. max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)
  50.  
  51.  
  52.  
  53.  
  54.  
  55. "darkmooncard"
  56.  
  57. (first((avgbuy(item:43123)*5), crafting(item:43123)*5, dbmarket(item:43123)*5) + first(vendorbuy(item:39354), dbmarket(item:39354))*8)
  58.  
  59.  
  60.  
  61.  
  62. "warpaints"
  63.  
  64. avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129))))*2.5 + ((avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*5)
  65.  
  66.  
  67.  
  68.  
  69. "darkmooncardofdestruction"
  70.  
  71. first((avgbuy(item:61981)*10), crafting(item:61981)*10, dbmarket(item:61981)*10) + first(avgbuy(item:52329)*30, crafting(item:52329)*30, dbmarket(item:52329)*30) + first(vendorbuy(item:39354), dbmarket(item:39354))
  72.  
  73.  
  74.  
  75.  
  76. "darkmooncardofdraenor"
  77.  
  78. avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127), dbmarket(item:109127)),first(avgbuy(item:109128), dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*2.5) + (avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127), dbmarket(item:109127)),first(avgbuy(item:109128), dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*5)*10  + first(vendorbuy(item:39354), dbmarket(item:39354)
  79.  
  80.  
  81.  
  82.  
  83.  
  84. "darkmooncardofmists"
  85.  
  86. first((avgbuy(item:79255)*10), crafting(item:79255)*10, dbmarket(item:79255)*10) + first(avgbuy(item:79254)*3, crafting(item:79254)*3, dbmarket(item:79254)*3) + first(vendorbuy(item:39354)*2, dbmarket(item:39354)*2)
  87.  
  88.  
  89.  
  90.  
  91. "darkmooncardofthenorth"
  92.  
  93. first((avgbuy(item:43127)*6), crafting(item:43127)*6, dbmarket(item:43127)*6) + first(avgbuy(item:35625), crafting(item:35625), dbmarket(item:35625)) + first(vendorbuy(item:39354), dbmarket(item:39354))
  94.  
  95.  
  96.  
  97.  
  98. "greaterdarkmooncard"
  99.  
  100. (first((avgbuy(item:43125)*3), crafting(item:43125)*3, dbmarket(item:43125)*3) + first(avgbuy(item:21886), crafting(item:21886), dbmarket(item:21886)) + first(vendorbuy(item:39354), dbmarket(item:39354))*8)
  101.  
  102.  
  103.  
  104.  
  105. "scribecards"
  106.  
  107. (avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129))))*2.5 + ((avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*5)*10)
  108.  
  109.  
  110.  
  111.  
  112. "scribetrinkets"
  113.  
  114. ((avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129))))*2.5 + ((avg(first(avgbuy(item:109124), dbmarket(item:109124)),first(avgbuy(item:109125), dbmarket(item:109125)),first(avgbuy(item:109126), dbmarket(item:109126)),first(avgbuy(item:109127),dbmarket(item:109127)),first(avgbuy(item:109128),dbmarket(item:109128)),first(avgbuy(item:109129), dbmarket(item:109129)))*5)*10)*8)
  115.  
  116.  
  117.  
  118.  
  119.  
  120.  
  121.  
  122.  
  123.  
  124.  
  125. TSM4 users will no longer have to make sheymin, sheynorm, sheymax when they are importing my groups. Any custom prices referred to in the imports will just come with the imports now. Anyone still using TSM3 will have to make these 3 custom prices below: (Edit:This is technically not implemented yet in the TSM4 beta but it will be implemented eventually, so for now you still have to make sheymin, sheynorm and sheymax)
  126.  
  127. Go to settings, then custom prices and build these 3 custom prices below:
  128.  
  129. Step 1:
  130.  
  131. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymin" and hit enter.
  132. Then in the box "Custom Price for this Source" type in exactly this"
  133.  
  134.  
  135. max(first (105% Max(Crafting, AvgBuy)/0.95, 70% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical)), 110% VendorSell/0.95)
  136.  
  137. Step 2:
  138.  
  139. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheynorm" and hit enter.
  140. Then in the box "Custom Price for this Source" type in exactly this"
  141.  
  142.  
  143. max(200% Max(Crafting, AvgBuy)/0.95, 150% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical), 110% VendorSell/0.95)
  144.  
  145.  
  146. Step 3:
  147.  
  148. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymax" and hit enter.
  149. Then in the box "Custom Price for this Source" type in exactly this"
  150.  
  151. max(500% Max(Crafting, AvgBuy)/0.95, 500% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical), 110% VendorSell/0.95)
  152.  
  153.  
  154.  
  155. I decided to replace "dbmarket" with "min(DBMarket, 150% DBRegionMarketAvg)" to control/account for those situations where dbmarket continuously inflates to outrageously high values. By replacing with "min(DBMarket, 150% DBRegionMarketAvg)", any time dbmarket climbs higher than 150% dbregionmarketavg, it will just use 150% dbregionmarketavg. This will prevent dbmarket from climbing to ridiculously high values. You can adjust the 150% if you like. I've had lots of people ask me ways to account for this/prevent this from happening. There are many ways to do this but this is an easy solution.
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top