API tools faq
paste
Advertisement
Sheyrah

Custom Prices (Sheymin, Sheynorm, Sheymax)

Sheyrah
Aug 28th, 2017 (edited)
179,209
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.94 KB | None | 0 0
raw download clone embed print report
  1. For those looking to set up sheymin, sheynorm, and sheymax custom prices:
  2.  
  3. Go to settings, then custom prices and build these 3 custom prices below:
  4.  
  5. Step 1:
  6.  
  7. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymin" and hit enter.
  8. Then in the box "Custom Price for this Source" type in exactly this"
  9.  
  10.  
  11. max(first (105% Max(Crafting, AvgBuy)/0.95, 70% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical)), 110% VendorSell/0.95)
  12.  
  13. Step 2:
  14.  
  15. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheynorm" and hit enter.
  16. Then in the box "Custom Price for this Source" type in exactly this"
  17.  
  18.  
  19. max(200% Max(Crafting, AvgBuy)/0.95, 150% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical), 110% VendorSell/0.95)
  20.  
  21.  
  22. Step 3:
  23.  
  24. In the box Custom Price Source Name" type exactly this with no quotations, all lower case, "sheymax" and hit enter.
  25. Then in the box "Custom Price for this Source" type in exactly this"
  26.  
  27. max(500% Max(Crafting, AvgBuy)/0.95, 500% first(min(DBMarket, 150% DBRegionMarketAvg), DBRegionHistorical), 110% VendorSell/0.95)
  28.  
  29.  
  30.  
  31. 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.
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39. Legion Custom Prices: You must have at least one recipe that uses this material for it to show up in the materials tab.
  40.  
  41. Blood Of Sargeras Custom Price:
  42.  
  43. 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)
  44.  
  45.  
  46.  
  47.  
  48. Primal Sargerite Custom Price:
  49.  
  50. 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)
  51.  
  52.  
  53.  
  54.  
  55. Material Price for Roseaste Pigments and Sallow Pigments: This one is from Bilis, see link for details.
  56.  
  57. DBMarket * (matPrice(i:124102) / (0.45 * DBMarket(i:129032) + 0.1 * DBMarket(i:129034)))
  58.  
  59. https://www.reddit.com/r/woweconomy/comments/71wqu5/tsminscription_a_way_to_value_your_pigments/
  60.  
  61.  
  62.  
  63.  
  64. Primal Spirit Custom Price:
  65.  
  66. 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
  67.  
  68. 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.
  69.  
  70.  
  71.  
  72.  
  73. Temporal Crystal Fix:
  74.  
  75. 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:
  76.  
  77. min(dbmarket, vendorbuy, convert(dbmarket))
  78.  
  79.  
  80. "minprice"
  81.  
  82. max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)
  83.  
  84.  
  85.  
  86.  
  87.  
  88. "darkmooncard"
  89.  
  90. (first((avgbuy(item:43123)*5), crafting(item:43123)*5, dbmarket(item:43123)*5) + first(vendorbuy(item:39354), dbmarket(item:39354))*8)
  91.  
  92.  
  93.  
  94.  
  95. "warpaints"
  96.  
  97. 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)
  98.  
  99.  
  100.  
  101.  
  102. "darkmooncardofdestruction"
  103.  
  104. 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))
  105.  
  106.  
  107.  
  108.  
  109. "darkmooncardofdraenor"
  110.  
  111. 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)
  112.  
  113.  
  114.  
  115.  
  116.  
  117. "darkmooncardofmists"
  118.  
  119. 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)
  120.  
  121.  
  122.  
  123.  
  124. "darkmooncardofthenorth"
  125.  
  126. 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))
  127.  
  128.  
  129.  
  130.  
  131. "greaterdarkmooncard"
  132.  
  133. (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)
  134.  
  135.  
  136.  
  137.  
  138. "scribecards"
  139.  
  140. (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)
  141.  
  142.  
  143.  
  144.  
  145. "scribetrinkets"
  146.  
  147. ((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)
  148.  
  149.  
  150.  
  151.  
  152.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!