• Visit Rebornbuddy
  • Visit Panda Profiles
  • Visit LLamamMagic
  • [Professionbuddy] AHBuddy - Full Auction House Bot

    Discussion in 'Archives' started by zakanator, May 7, 2012.

    Thread Status:
    Not open for further replies.
    1. Gleeky

      Gleeky Member

      Joined:
      Dec 19, 2013
      Messages:
      173
      Likes Received:
      4
      Trophy Points:
      18
      Having got my 1st set of chars to 90 via botting, I have now turned my attention more to AH botting, and am playing around with this and other AH tools.

      As part of this process, I'm attempting to develop a spreadsheet that updates my latest realm prices from wowuction and The Undermine journal, then runs through various logic to generate buying and posting strings to import into AH buddy.

      It's not massively sophisticated (i.e. no auto generation of a fresh AH buddy xml, just the creation of the strings you need to cut and paste in manually, I'm no programmer) but I want a model that allows for some dynamic pricing in the same way that TSM can, based on realm realm median data. So I've dusted off my excel skills and given it a stab that way, and if others wish to collaborate, we could perhaps automate it a little better.

      It's very beta at this stage, but the basics of creating demand based buying and selling groups is in place. I wouldn't mind sharing it with a couple of people to test the logic a little, firstly to start giving a little back to the community, instead of just lurking, and secondly to test the logic.

      The base spreadsheet data import uses this a useful import process by Stede, a gold blogger I discovered via the Consortium forums. Find the process and related instructions at:
      Late Nite With Stede: UPDATED! Stede's Spreadsheeting Sandbox - Now with BOTH Wowuction & TUJ data!
      if you are interested.

      PM me if you have some experience with excel and are interested in having a look at the very beta version of my spreadsheet.

      TLDR: Working on spreadsheet to import dynamic realm prices and related buying/selling prices into AH buddy.

      ---------------------
      EDIT:
      Also, if anyone knows of a way to import Region based pricing from wowuction, I'd be very interested, I can see the string in my wowuction.lua file, but it's just a set of numbers, no easy way to convert to a *.csv, With this I would be able to strengthen the logic even further to avoid those peskies who post boar meat at 2000g a stack to trick people (and processes) into thinking they're a bargain at 1g each.
       
    2. zakanator

      zakanator New Member Buddy Store Developer

      Joined:
      Feb 19, 2012
      Messages:
      676
      Likes Received:
      23
      Trophy Points:
      0
      Try removing items from cancelfromah subroutine that you don't sell, the pause is probably it checking each item to cancel.
       
    3. Arm

      Arm New Member

      Joined:
      Aug 23, 2012
      Messages:
      214
      Likes Received:
      0
      Trophy Points:
      0
      I just did that and I can confirm its much faster now.
       
    4. Manwe

      Manwe New Member

      Joined:
      Jan 14, 2014
      Messages:
      31
      Likes Received:
      0
      Trophy Points:
      0
      Is the Undermine price data base project still going or it's frozen?
       
    5. Bendecks

      Bendecks New Member

      Joined:
      Sep 1, 2013
      Messages:
      7
      Likes Received:
      0
      Trophy Points:
      0
      I am very curious about this aswell :D
       
    6. Gleeky

      Gleeky Member

      Joined:
      Dec 19, 2013
      Messages:
      173
      Likes Received:
      4
      Trophy Points:
      18
      Are you guys referring to my post on the previous page? Or something else. If it's referring to my post, I invited people with some experience of excel to help me with testing, but I've only had 1 PM so far, and that was from someone with pretty poor English and no reference to their excel experience, so I haven't followed up with them.

      In terms of the project, yes it's still ongoing, I've got it all up and running for my server, but the import of buying and selling datastrings into AH buddy is still manual. Testing is ongoing.

      EDIT: From reading back the last 20 pages I can see now that you guys are referring to Zakanthor's plan's to incorporate some form of Undermine Journal pricing into AH Bot itself, something I'd also love to see. I'll keep my little project going for now though, if anyone with some excel/programming knowledge wants a sneak peak, just send me a PM.
       
    7. Michael Poulsen

      Michael Poulsen New Member

      Joined:
      Jul 19, 2012
      Messages:
      34
      Likes Received:
      0
      Trophy Points:
      0
      A wiered thing is that i choose the profile to buy Ores from the AH for a MaxBuyout price of 40g - nothing more, but it keep buying ores that is even more expensive, ores that cost like 99g???
       
    8. zakanator

      zakanator New Member Buddy Store Developer

      Joined:
      Feb 19, 2012
      Messages:
      676
      Likes Received:
      23
      Trophy Points:
      0
      The prices are the individual price for the item.
       
    9. Michael Poulsen

      Michael Poulsen New Member

      Joined:
      Jul 19, 2012
      Messages:
      34
      Likes Received:
      0
      Trophy Points:
      0
      So what do i have to change? View attachment 119590
       
    10. Aicd99

      Aicd99 New Member

      Joined:
      Sep 6, 2010
      Messages:
      100
      Likes Received:
      2
      Trophy Points:
      0
      There are 20 ore in one stack, so you want to get stacks of ore for 40g or less, so the price for item would be 40(price)/20(number of individual ore in 1 stack).

      So, you want your maximum price to be 2g per item. This will make it buy stacks of 20 ore which cost 40g, since 2g*20 = 40, or less.
       
    11. 2Fast

      2Fast New Member

      Joined:
      Oct 30, 2012
      Messages:
      14
      Likes Received:
      0
      Trophy Points:
      0
      Oh wow....


      PB 1.637: Selling Goldlotus for 0g0s0c. Competition is at 39g75s0c

      It just posted 124 gold lotus for FREE

      not sure if i like this....
       
    12. 2Fast

      2Fast New Member

      Joined:
      Oct 30, 2012
      Messages:
      14
      Likes Received:
      0
      Trophy Points:
      0
      Stupid question... Why not grab prices from Auctioneer scans?

      Everybody should have it installed, it definitely stores the data SOMEWHERE and it's always the right data for your server.... no need for huge 'api' projekts
       
    13. thehut10

      thehut10 New Member

      Joined:
      Apr 8, 2013
      Messages:
      3
      Likes Received:
      0
      Trophy Points:
      0
      Or wowuction.com
       
    14. Wowgoldmaster

      Wowgoldmaster New Member

      Joined:
      Jan 20, 2013
      Messages:
      8
      Likes Received:
      0
      Trophy Points:
      1
      Hi, Zakanator, thanks for this excellent profile!

      I got a painful question: Is there a way to post an item to AH ignoring <Random enchantment> of that item?

      For example, "Jade Epaulets" ItemID="14921" on AH costs:
      <Jade Epaulets ... of Dodge> - 1000 gold
      <Jade Epaulets ... of Stamina> - 500 gold

      How to ignore all of this <Random enchantments> and sell my <Jade Epaulets of the Boar> for 499 gold?

      P.S. Sorry for my english, it's not my primary language.
       
    15. defzone

      defzone New Member

      Joined:
      Dec 25, 2013
      Messages:
      122
      Likes Received:
      0
      Trophy Points:
      0
      Does this one will check the minimum price in AH and then it will undercut it or it will just rely on the maxbuyout price? First time will use it.
       
    16. Ghost99

      Ghost99 New Member

      Joined:
      Dec 8, 2013
      Messages:
      81
      Likes Received:
      0
      Trophy Points:
      0
      Is it possible to set somehow a buyout price automatically?
      I mean set the undercut price as a BO price so it wont do it like this:

      PB 1.641: Selling Champion's Vermilion Onyx for 0g0s0c. Competition is at 11g62s99c
       
    17. zakanator

      zakanator New Member Buddy Store Developer

      Joined:
      Feb 19, 2012
      Messages:
      676
      Likes Received:
      23
      Trophy Points:
      0
      It will already ignore the random suffix since it's not part of the item id.
       
    18. future

      future New Member

      Joined:
      Jan 14, 2012
      Messages:
      68
      Likes Received:
      0
      Trophy Points:
      0
      Hey, can i use this "tool" to snipe the nah?
       
    19. defzone

      defzone New Member

      Joined:
      Dec 25, 2013
      Messages:
      122
      Likes Received:
      0
      Trophy Points:
      0
      Is it possible to close the auction house after posting the items, I think it continoeusly searching the auction house.
       
    20. Wowgoldmaster

      Wowgoldmaster New Member

      Joined:
      Jan 20, 2013
      Messages:
      8
      Likes Received:
      0
      Trophy Points:
      1
      Hey, Zakanator, thanks for the fast reply!

      I still got this problem.

      Competition is beetwen one kind of Random enchantment.
      e.g. <Jade Epaulets of the Boar> competes only with <Jade Epaulets of the Boar>, but not with <Jade Epaulets ... of Dodge>.

      Did you ever tested any items with random suffixes on AH?
      I try to understand is it an error in my profile or it's a plain profile's work.

      P.S. Is't normal that items posts on AH with rounding prices?
      e.g. in profile MaxBuyout="4999g99s99c", but in AH price is 5000g.
       
    Thread Status:
    Not open for further replies.

    Share This Page