Gleeky
Member
- Joined
- Dec 19, 2013
- Messages
- 173
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.
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.
