Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Results 1 to 6 of 6
  1. #1
    Entrepreneur
    Derriden's Avatar
    Posts
    4
    Reputation
    0
    Tagged in
    1 Posts
    Add to this user's reputation

    Can you use the last 7 days value of avgBuy?

    I've been running with an avgBuy calculation for my Default Material Cost Method and it's been working pretty well.

    However it doesn't track that well with price spikes so when a material price drops rapidly my Min Auction Price on my crafts doesn't go down with it.

    I've looked at the 'Use smart average for purchase price' option but that doesn't really work for me as I don't tend to keep a lot of stock of materials. The prices are either skewed or it just reverts to the regular avgBuy.

    I'm thinking setting the average buy price to the average buy price last 7 days (Accounting > Expenses > Click Item) value would help a lot.

    Is there a way to get this value into my Default Material Cost Method calculation somehow?

    I know I can delete price info older than 30 days but that won't help here. Even if there was an option for 7 days I'd prefer to have the information in the database.

    Thanks

  2. #2
    US-Kel'Thuzad(A)
    Administrator
    Sterling's Avatar
    Posts
    3,107
    Reputation
    282
    Blog Entries
    1
    Tagged in
    1672 Posts
    Add to this user's reputation
    Quote Originally Posted by Derriden View Post
    I've been running with an avgBuy calculation for my Default Material Cost Method and it's been working pretty well.

    However it doesn't track that well with price spikes so when a material price drops rapidly my Min Auction Price on my crafts doesn't go down with it.

    I've looked at the 'Use smart average for purchase price' option but that doesn't really work for me as I don't tend to keep a lot of stock of materials. The prices are either skewed or it just reverts to the regular avgBuy.

    I'm thinking setting the average buy price to the average buy price last 7 days (Accounting > Expenses > Click Item) value would help a lot.

    Is there a way to get this value into my Default Material Cost Method calculation somehow?

    I know I can delete price info older than 30 days but that won't help here. Even if there was an option for 7 days I'd prefer to have the information in the database.

    Thanks
    I don't think it's possible. Not a fan of avgbuy for materials either, consider using a different pricing source (some sort of market price).
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Mastery Series: Sniper | Cross-Faction Trading NEW! | Enchanting | Jewelcrafting | Smelting
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  3. #3
    US-Emerald Dream(Both)
    Your Favorite Goblin
    Kathroman's Avatar
    Posts
    5,254
    Reputation
    279
    Blog Entries
    17
    Tagged in
    2064 Posts
    Add to this user's reputation
    No, there'd be no way to accomplish this aside from modifying the addon code.

    If you're trying to counteract historical averages, you might want to consider using a customized price source. Something like 40%(avgBuy) + 60%(dbminbuyout, or dbmarket, etc.) would allow you to customize the weighting between the two.
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  4. #4
    Ord
    US-Zul'jin (H)
    Wind Trader
    Ord's Avatar
    Posts
    456
    Reputation
    70
    Tagged in
    171 Posts
    Add to this user's reputation
    Good idea, @Kathroman

    I think the weighting might be more effective if used as an average. (EDIT: Just realized that mathematically, your notation is exactly the same as mine just after the distributive property) This example would give you a price that is 30% influenced by AvgBuy, 60% by DBmarket and 10% by DBMinBuyout:
    Code:
    (3*AvgBuy + 6*DBMarket + 1*DBMinBuyout)/10



    Or, you could try to work in a Min() as a fallback to AvgBuy so that if the DBMinBuyout is less than your AvgBuy, it will use that instead:
    Code:
    Min(AvgBuy, DBMinBuyout)



    Or come up with a fancy combination of the two (or anything else you might want) with something like:
    Code:
    (3*Min(AvgBuy, DBMinBuyout) +  2*Min(DBMarket, wowuctionMarket))/5


    P.S. Don't forget to add your coefficients correctly to get the right denominator. This is why I put "1*" when I do weighted averages, so it's easy to see what the denominator should be. Having a denominator off by one number can greatly skew the equation to wildly inaccurate values.
    Last edited by Ord; May 13th, 2014 at 11:03 AM.

  5. #5
    Entrepreneur
    cracklingice's Avatar
    Posts
    829
    Reputation
    18
    Tagged in
    175 Posts
    Add to this user's reputation
    There currently is no price source, but I'd like to see something similar as well. As has already been stated, it would have to be added to the core of the addon (and would likely be processing intensive) The summary page of any item will show you the average of the last 30 or 7 days so I am sure it could be possible to code in a price source that could report that value, but as I said, it'd likely be CPU intensive. You could also use the 'smart' option that only shows what you've paid for how many you have on hand (but in many cases you've already used it in the craft and have none. Not sure if this gives nil or complete average as I don't use it.) If you want to suggest the feature, look in the stickies for the suggestion site.

  6. #6
    Entrepreneur
    Derriden's Avatar
    Posts
    4
    Reputation
    0
    Tagged in
    1 Posts
    Add to this user's reputation
    Thanks for all the suggestions everyone!

 

 

Similar Threads

  1. avgBuy calculation
    By fireymerlin in forum General TradeSkillMaster Discussion
    Replies: 2
    Last Post: May 2nd, 2014, 01:35 PM
  2. Avgbuy in material cost
    By cracklingice in forum General TradeSkillMaster Discussion
    Replies: 6
    Last Post: September 9th, 2013, 08:41 AM
  3. avgbuy incrementing with auctioning operation posts
    By Daeymien in forum General TradeSkillMaster Discussion
    Replies: 9
    Last Post: August 17th, 2013, 03:13 PM