TSM4 Beta: My first impressions and what you need to know

Our TSM Premium Affiliate Link: https://www.tradeskillmaster.com/prem...
Stream Link:   / xionikandsheyrah  
Twitter:   / sheyrahstream  
Website: http://xionikandsheyrah.wix.com/gaming
Support Xionik & Sheyrah: http://xionikandsheyrah.wixsite.com/g...

Sign up for the TSM beta (free):
http://tradeskillmaster.com/beta

If you want to support us as well as the TSM team you can sign up for TSM premium through our affiliate link. We will get a portion of the cut through our link:
https://www.tradeskillmaster.com/prem...

Add this to your macro if you want cancelling, eventually it will be implemented automatically but may be of use for early beta users"
/click TSMCancelAuctionBtn

Link to all my TSM groups if you want them:
https://pastebin.com/u/Sheyrah

Link to my 3 custom prices for sheymin, sheynorm, sheymax if interested. Recently improved:
https://pastebin.com/daY86gjr

Extended sniper formula as promised in the video: I ask that you don't make a video using this work as I plan on making a video using this extended string when TSM4 is live. Thank you

ifgt(ItemQuality, 0, check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 250000g, 80% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)), check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 100000g, 70% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)), check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 50000g, 60% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)), check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 10000g, 50% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)), check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 5000g, 30% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)), check((max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)) - 1000g, 10% (max(first(min(DBHistorical, DBRegionMarketAvg, DBRegionHistorical), min(DBGlobalMarketAvg, DBGlobalHistorical)), VendorSell)))))))))




Video walk through for sniper, how to set it up, how it works, and how you should use it. It is older but still relevant. I will be making a new sniper video when TSM4 is out of beta:
   • TSM 3 - How to Set up and use Sniper ...  

Logic Functions:

ifgt() – “If Greater Than”
ifgte() – “If Greater Than or Equal To”
iflt() – “If Less Than”
iflte() – “If Less Than or Equal To”
ifeq()- “If Equal”
round() – “Standard Rounding”
roundup() – “Always Round Up – aka Ceiling”
rounddown() – “Always Round Down – aka Floor”

Value Sources:

DBRegionSaleRate
DBRegionSoldPerDay
NumExpires
ItemQuality
ItemLevel
RequiredLevel

round(DBRegionMarketAvg, ifeq(ItemRarity, 4, 1000g, 1g))

DBRegionMarketAvg + ifeq(ItemLevel, 25, 3000g, 0c)

10000g * (1.2 ^ ((ItemLevel - 885) / 5))

ifgt(DBRegionMarketAvg, 250g, 1000g)

ifgt(DBRegionSaleRate, 0.05, ifgt(DBRegionMarketAvg, 250g, 1000g))

(105% Crafting + (1 / DBRegionSaleRate - 1) * 60% VendorSell) / 0.95

New Antorus BOE shopping string: not mentioned in the video but very important for the new raid, watch for cheap BOE's to flip, easy gold but watch those ilvls closely. ilvl 915-985:

i:152084;i:152085;i:153018;i:151993;i:152087;i:152413;i:152088;i:152089;i:152682;i:152090;i:152091;i:153019

Nov 28 Normal and Heroic and New PVP Season (930+ & 945+)
Dec 5 Mythic and Raid Finder Wing 1 (960+ & 915+)
Dec 19 Raid Finder Wing 2 (915+)
Jan 2 Raid Finder Wing 3 (915+)
Jan 16 Raid Finder Wing 4 (915+)

Check muffins stuff for updates on all the variations of the Antorus BOEs when he gets a chance:
github: https://github.com/tehmufifnman/tsm_i...