TSM Forum Feed

Subscribe to TSM Forum Feed feed TSM Forum Feed
Discuss TSM with the developers and suggest new features
Updated: 1 hour 6 min ago

[Question] Auc-Stat-AuctionDB help

Tue, 07/22/2014 - 20:25
I discovered TSM after looking around this site more and more after finding out TUJ data is discontinued and I love the app. The only issue I have is that I really can't work without Auctioneer. I tried TSM and it's beyond me and Auctioneer has just what I need. I found this stat module on Curse by someone else, but it hasn't been updated to use TSM 2.0's new module api. I have some coding experience, but not with lua. I'm wondering if it would be possible to have some assistance to give this addon a little patch, assuming it just needs a little tweaking and not a whole rewrite.

The error in-game:

Code: Interface\\AddOns\\auc-stat-auctiondb\\AuctionDB.lua:90: attempt to call method 'GetData' (a nil value) Doing some research, TSMAPI:GetData was the old API. While looking at 2.0's new API, I'm not sure how to replace the code. It seems far too different.

The code block applicable to line 90:

Code: local array = {}
local seen
local confidence
function lib.GetPriceArray(id, serverKey)
        confidence = get("stat.auctiondb.confidence") or 1
        seen = TSMAPI:GetData("seenCount", TSMAPI:GetItemID(id)) -- line 90
        local price = TSMAPI:GetData("market", id)
        local scans = TSMAPI:GetData("adbScans", id)
        if not scans or not price then return end
        local variance, n = 0, 0
        local day = lib.GetDay()
        local i, x
        for i=0, 14 do
                local data = scans[day-i]
                if data then
                        if type(data) == "table" then
                                for _, x in pairs(data) do
                                        variance = variance + (x-price)^2
                                        n = n + 1
                                variance = variance + (data-price)^2
                                n = n + 1
        array.price = price
        array.seen = seen
        variance = variance * sqrt(seen / n) -- central limit theorem (simplifying assumption that scans are equal-size independent samples)
        local minvariance = get("stat.auctiondb.minerrorpct")*.01*price
        if variance < minvariance then variance = minvariance*price end
        if variance <= 0 then return end
        if n >= 2 then
                array.stddev = sqrt(variance)/(confidence*(n-1))
        return array
end Link to the addon: http://wow.curseforge.com/addons/auc...files/8-1-1-0/

Rest of the lua file if you don't want to download the addon: http://pastebin.com/zttDM1d2

[Question] How to block out an unwanted convert source?

Tue, 07/22/2014 - 09:52
Looks like somebody decided to put a small quantity of [Desecrated Herb] on the AH today at a very low price point. Normally this wouldn't be a problem, but as it can be milled, it now affects the matcost for [Shadow Pigment] via convert(). As the herb doesn't have any direct crafting use, it's not possible to alter its material cost in the Crafting-Materials menu as usual.

My question is, is there any other way than modifying the lua files to block out this otherwise insignificant herb from the convert calculations? As a quick fix, I switched to using convert(wowuctionmarket) instead of convert(dbmarket), but this isn't really a long-term solution, as I would like to use dbmarket as the price source for conversions.

[Question] "Shopping" shows items not on my list ??

Tue, 07/22/2014 - 06:06
I have a list of items for called "To Buy":
Cape of the Whale
Cape of the Thief

When I am on the "Shopping" tab and use this list for my search it returns not only
Cape A of the Whale
Cape A of the Thief

but also

Cape A of the Wolf

If I hover over "Cape A of the Wolf" in the Shopping window it shows that it belongs to the "To Buy" list but once I buy it that same item will show up in TSM as not being assigned to a group. I am at a loss for why this happens and how to stop it. I do NOT want to buy the Cape A of the Wolf for any reason. I only want to buy just what is on my exact list.

Any suggestions on correcting this would be appreciated.

[Important] TSM Website Has Moved (sort of...)!

Mon, 07/21/2014 - 22:06
Don't worry, the URL is still the same. However, under the hood we've changed to a different domain name and name service provider, which means that you might not be able to access the website until you clear your DNS cache (or just wait a while). Instructions here: http://t.co/KyOekgwDJ5

[Question] Need Help with Setting Up an Operation's Minimum Price Setting

Mon, 07/21/2014 - 16:34
This is the path to the area I am asking for help in:

Right Click TSM Minimap Icon> Click Module Operations/ Options Icon> Click the Auctioning Tab> Select a Specific Operation> Click the Post Tab> Look Down at Posting Price Settings> Minimum Price Setting text box

Is there a way to make items post at (for example: 100g OR 50% dbmarket (whichever comes first in terms of most gold return upon the item being sold)) so that it will not post items affected by this operation for less than 100g, even if 50% dbmarket is below 100g at that time? Also, vice versa, if 50% dbmarket is higher than 100g, it will post the item at a minimum of 50% dbmarket, which is greater than 100g.

please help, thank you in advance. :D

Edit: These are the things I have tried: min(100g) (50% dbmarket)
min(100g, 50% dbmarket)
(100g) (50% dbmarket)
100g, 50% dbmarket

All of them have caused items to be posted below 100g, instead of minimum 100g or minimum 50% dbmarket (as long as it is >100g).

[Question] Quick posting withouth Enchant

Mon, 07/21/2014 - 03:54

I have this problem with quick posting items like High Rollers Gloves of the Intellect. It looks up with the /exact tag.
Any possible way to remove the enchant besides putting it in a group like I do now or aren't there any options to quick posting?


[General] Custom Prices for Elminating Outlying (Bad) Realm Data

Sun, 07/20/2014 - 16:22
I have been tinkering with these custom prices (newish to TSM stuff, props to Ord for his various posts here which have been informative) and I am using the following custom prices:

Region - A general Region based price that averages RegionMarket and RegionMedian

Code: Avg(WoWuctionRegionMarket, WoWuctionRegionMedian)

Realm - A general Realm based price that averages Market, Median, and DBMarket

Code: Avg(DBMarket, WoWuctionMarket, WoWuctionMedian)

RealmSmoothed - A 'smoothed' price that checks if my custom Realm price is more than 3 times my custom Region price, and if so, defaults to the Region price. It also checks if the Realm price is 1/3 or less than the Region price, and if so, defaults to the Region price. Otherwise it uses the Realm price. This is designed to eliminate outlying bad data. If someone has artificially inflated the price of an item on a Realm to an absurd level, or if the Realm is under priced to an absurd level, this will default to Region data, which is more stable.

Code: check((Realm-3*Region), Region,
check((Region-3*realm), Region, Realm))

GeneralSmoothed - This is my general, weighted formula that I base all of my marketvalue upon. Region is weighted more heavily than Realm, which uses the smoothed Realm data to eliminate bad data.

Code: (3*First(RealmSmoothed, Region)+5*First(Region, RealmSmoothed))/8

I am fairly new to this stuff, so I'm wondering if anyone sees any areas I could improve these formulas?

[Question] How to post below current min buyout price?

Sun, 07/20/2014 - 15:38
When posting an item, how do you set it to post below the current lowest buyout price?

DBMinBuyout sets the price based on the database price, not the up-to-the-minute price.

(Additionally, if you use Shopper(?), left click on the item and get the up-to-the-minute price, the DB price is not updated. It continues to show outdated data for that item.)

[Question] Price sources

Sat, 07/19/2014 - 15:21
Hi everybody, I'm new here and no native speaker, so plz don't give me animal names if I missed something. I swear I asked Google before!

My problem is, I can't figure out over what period of time the different price sources (dbmarket/wowuctionmarket/median/...) are calculated?
Is this all only over the last hour or are some of them longtime calculations?
And if I use wowuction whit the app saves it the data to auctiondb?

I'm confused ^^

[Question] TSM_App Realm Updating

Fri, 07/18/2014 - 20:50
I've been using this app for the last 3 weeks and haven't noticed any changes in it's updating behavior. Typically I keep the application open all day but maybe only once a day will it actually pull data.

Right now I'm monitoring 2 realms - Kel'thuzad - Alliance and Area52-Horde. Neither realm has seen an update for 19 hours and 36 minutes. When I try to force an update, nothing happens.

I've tried uninstalling the application and reinstalling it but I keep having the same issues.

Thanks for any help / suggestions!

[Question] TSM - Warehousing Inquiry

Fri, 07/18/2014 - 18:45
Is there a way to grab items from my guild vault and move them to my bags based on their TSM AuctionDB Min Buyout?

Edit: To clarify - I would like to move all items below my 30g threshold to the vault, and all items above my 30g threshold to the vault.

[Question] Exporting qty on hand to Excel

Fri, 07/18/2014 - 17:53
Hi there,

Is it possible to export qty available from Itemtracker to Excel? I would like to generate an Excel sheet with all the items and quantity I have in inventory.


[Question] Critique my custom pricing algorithms please!

Thu, 07/17/2014 - 13:49
First of all, I recently came back to WoW after a 3+ year break, and I'm still new to TSM. Gotta say that I love it so far. Would you guys be kind enough to give me some input on my custom pricing for Auctioning? I use the TSM desktop app, but even still, I found the DBmarket price alone to be very inaccurate at times (usually grossly inflated). So, this is what I've come up with:

Min Price: min(80% dbmarket, 80% avg(wowuctionmarket, wowuctionmedian))

Normal Price: same thing but 300%

Max Price: same thing but 500%

So far it seems to do well at eliminating the crazy huge prices I was seeing on some items using DBmarket alone, which in turn, eliminates accidentally posting a bunch of listings with stupid high prices that would NEVER sell.

What do you guys think? Any input or suggestions? Thanks!

(I play on Tichondrius-A btw)

[General] Incorrect crafting cost on vendor purchasable items

Wed, 07/16/2014 - 18:14
Hello all,

Got back into gold making and running into an issue. My TSM is set up to use dbmarket for all crafting materials. I noticed however that it is also applying this rule of using dbmarket to items that I can actually purchase from a vendor (eg. enchanting vellum, light parchment). The issue I am having is that because people on my server are selling vellums and parchments to 4-5g a piece this is actually messing up some of my crafting ques as this 4-5g difference is sometimes enough to drive a certain item into an unprofitable range. Is there an option I am missing somewhere in TSM where I can flip it to NOT use dbmarket for those trade goods that can simply be bought at the vendoe, eg vellums, red dye, light parchments, thread. Or do I need to manually go into TSM crafting>materials> set each ones price manually to the vendor price. Thanks kindly.

[Question] Tooltips on mouseover in destroying

Wed, 07/16/2014 - 07:56
I can't seem to find an option, and if there isn't - it would be extremely handy if i could see how much an item is worth when i have the mouse over it in the destroying box when it pops up, so i dont have to look through my almost full bags for it to see if it's something that i should sell on ah instead >n<

[Question] Where is the dealfinding?

Wed, 07/16/2014 - 04:47
I looked up a guide on it but the addon interface in every one I've tried is different.

[Question] Help with math, AKA why did this only sell for 6g?

Wed, 07/16/2014 - 01:03
Reference pics here.

I set up the operation in the screenshot today, and even though my min is set to 314g65s in the tooltip, for some reason the Wolffear Harness sold for 6g79s. What the heck did I do wrong? It should be taking the max amount from 80% of the DE value, 110% of vendor value, 70% of wowuction's region median, or 70% of wowuction's realm median, which according to the screenshot would be 449g50s, no? But instead it's ignored that and - from what I can tell - took from wowuction's realm median only as its min value, which is why it listed for so little.

However, even on the TSM Auctioning: Auctioning Prices:, the min is set for 314g. I don't understand how I circumvented that, because max() is supposed to take the largest value from the parameters, no, not to mention the prices thing.

TSM version numbers are posted below, and I am using the TSM app with wowuction to get pricing info. Any help with this issue is fantastic, any help cleaning up my math would be much appreciated as well. I can provide additional details if necessary. (Side note that this addon is fantastic and I love it, I'm just very confused).

TSM Versions:
TradeSkillMaster v2.8.3
Accounting v2.3.1
Additions v2.1.1
AuctionDB v2.3.10
Auctioning v2.3.3
Crafting v2.5.1
Destroying v2.1.1
ItemTracker v2.0.8
Mailing v2.2.1
Shopping v2.3.5
Warehousing v2.0.10
WoWuction v2.0.5

[Question] COD Items

Tue, 07/15/2014 - 14:01
Does TSM include CoD items you purchase when figuring crafting costs?

[Question] Accounting no longerdisplayed in tool tip

Mon, 07/14/2014 - 16:53
After updating the TSM modules the other morning the first alt I logged into threw up a TSM accounting error. I failed to paste the error before trying to reload/restart and get things running smoothly.

My auction tool tip no longer displays any accounting information, and I can't seem to find data older than 4 days ago. (items sold in the last 4 days do not show the data in their tool tip either, I've specifically looked for it)

I have 2 accounts, not linked by bnet. (my sync has been out for a while)

I've tried :
reinstalling both of the new modules I needed to update
reinstalled ALL of the modules - which still did not resolve the issue.
looked in options for a tick box that says "show accounting data" or similar but can't locate one.

I get the feeling I'm missing something obvious here (other than .. never ever forget to save your error messages)

My realm recently got merged, which may or may not be helpful in working out what is wrong.

I am hesitant to drop my old saved variables back on top, as if it were just a loss of data issue, the absence of the display is the primary concern.

Anyone able to assist with where the option to turn this on is that I have missed or with what I can do to restore the function I love seeing so much which is the numbers and % sales?


[Question] Sort by Sale Rate

Mon, 07/14/2014 - 00:56
Is there a way to show a list of everything you have put on the AH and sort it all by the sale rate? I have searched the options, the accounting section, and more and I can't find anything. The only way for me to figure out the sale rate is to look at each individual item and I have hundreds of different items I am always posting. This would help me figure out what is effective in selling and what I should just vendor.