Very, very impressive. However, have you considered waiting until a bit more information on how the non-IG access to the AH will work is available? Odds are it will work in some way like the armory, and could make your job far easier.
Regardless, I'm quite impatient to see this spreadsheet live!
I'm personally very interested in the spreadsheet you're working on manapaws and will be awaiting the release!
One niche market that I haven't seen discussed in about a year is the "Insane in the Membrane" niche. If you happen to have a couple of these guys on your server you can really make a killing by doing farming for them. If you happen to have a level55+ rogue you can pickpocket Junkboxes. The feat requires 1400 and most people after this will pay 10g/box, I haven't put much time into this but it's easily more than 50+ boxes/hour. You can also have a go at farming Pristine Black Diamonds from humanoid heavy areas- Scholomance and ZG have been the best in my experience (albeit it's pretty random).
In reference to the posts from several months past about bans for AH manipulation. GM policies may have changed but it is definitely possible to be banned for "aggressive AH economy manipulation." Several members of the US-Kel'Thuzad Horde guild Ministry were banned for that same reason. This was in classic in the days prior to actual guild banks and a few key members were in charge of the guilds gold and mats store and were aggressively controlling the AH for extended periods of time.
Light, in the absence of eyes, illuminates nothing.
In reference to the posts from several months past about bans for AH manipulation. GM policies may have changed but it is definitely possible to be banned for "aggressive AH economy manipulation." Several members of the US-Kel'Thuzad Horde guild Ministry were banned for that same reason. This was in classic in the days prior to actual guild banks and a few key members were in charge of the guilds gold and mats store and were aggressively controlling the AH for extended periods of time.
Emphasis added. I don't expect the GMs to hit you with a banstick if you're operating alone, unless you manage to, on your very own, become an actor of such weight that you can single-handedly control an entire portion of the market. In the example you gave, it was an entire guild doing so. Also, I'd add that there is the "grievance factor" to take into consideration: in your example, one could easily argue that what Ministry's members were doing was pure grieving. On the other hand, one person playing on one specific item for a short period of time wouldn't risk that. Typically, I've been buying off all the illusion dust on the AH for the past two weeks and reselling it at 10g/dust. I've made a nice bit of coin, and now that other players have barged in on my niche, I'll be moving on to another one, no GM action required.
In short: unless you really, really go out of your way to mess with people's AH life, I can see NO reason - and have never seen any examples for that matter - to get banned by a GM.
I had somehow bought around 200 stacks of primal shadow before the drop rate was lowered and then some until people realized the nerf was severe. I put them for 30g for over two months, buying out anything lower. Because I also had time, I was in full control of primal shadows during the entire black temple era.
I know that farming the primal shadow costed some progression at Shahraz. Hell I might have cause one guild disband. If it was against some rule I'm quite certain I would be the first to go.
I don't know if they were Banning people per say, but I do know that they actively put an end to people setting AH prices. Also, it wasn't really the small timers working Primal Shadow or what have you. They took out the AH Trade Prince types, people who were buying every profession scroll, every gem, every scrap of leather, every shard and so on.
I don't know how it was on the EU servers, but just about every high populated and/or progressed US server had at least one AH tycoon.
One niche market that I haven't seen discussed in about a year is the "Insane in the Membrane" niche. If you happen to have a couple of these guys on your server you can really make a killing by doing farming for them. If you happen to have a level55+ rogue you can pickpocket Junkboxes. The feat requires 1400 and most people after this will pay 10g/box, I haven't put much time into this but it's easily more than 50+ boxes/hour. You can also have a go at farming Pristine Black Diamonds from humanoid heavy areas- Scholomance and ZG have been the best in my experience (albeit it's pretty random).
A word on the timing of this: as one of the nutcases who's working towards the title, the combination of the perceived amount of time it takes, the perceived closeness of the Cataclysm changes, and a lack of certainty as to whether the title will still be possible to earn in Cataclysm has me at least feeling pressure to get it done soon. This creates an opportunity that has a limited lifetime.
At some point either an official statement will be made, or information will leak out of alpha, or an NDA-free beta will start. At that point we'll have a much stronger clue whether, for example, changes relating to the Shendralar rejoining Darnassus will impact the earning (or even existence -- cf. "Wildhammer") of Shendralar rep, or whether any changes to Blackrock Mountain will have an impact on pristine black diamond availability, and so on. If the information indicates that getting the title will become easier, the market for this stuff may crash at that time. If the information indicates that it'll become harder or even impossible, I expect the main result to be the craziest folks redoubling their efforts (which might mean for example leveling their own rogue to guarantee a certain junkbox acquisition rate).
So, make your guesses (on both the nature and timing of the leaked Cataclysm information) and "place your bets".
I don't know how common this is or how long it will last but after 3.3.3 was released I immediately used all of my frozen orbs to make Moonshroud, Ebonweave and Spellweave and listed them on the AH. Surprisingly the cost has not decreased and I have sold about 2000g worth, with more to come. Like I said I have no idea how long this will last for, but for now any tailor should jump on this opportunity to make some very easy cash.
Good healers keep people alive that are taking damage.
Resto druids heal them before they take damage and do the other healers job for them.
At a guess, many tailors are still on cooldown. The patch didn't remove the cooldown from people who have made cloth recently, it just removed it from new cloth transmutes.
As opposed to just selling the cloth I made a few of the epics (merlin's robe and such) to put on the ah and have made a decent amt. But will more than likely be short lived since the cooldowns are now gone. :/ sigh
As the price of primordial saronite continues to drop you will continue to see increased demand on the cloth crafted items.
Cloth prices aren't determining their own demand, Primordial Saronite and Crusader Orbs are. So for the time being an increase of supply will be countered by a short term increase in demand for the crafted items that consume them.
I think there is a short term opportunity in the flask market due to 3.3.3. With the ability to trade frozen orbs for frost lotuses, there will be an immediate availability of flasks/lotuses at a lower prices due to oversupply/unloading from the masses (and old herb stockpiles from previous farming).
With the ability to obtain frost lotuses this way, I've experience a sharp uptick in herb prices (i.e. lichbloom has gone from 20g/stack to 85g++/stack). This is likely due to the lack of incentive to herb for frost lotuses anymore combined with the stockpiling of old herbs used to make flasks. I've started buying mass flasks very cheap this morning (13-14g/flask) in the hopes that herb prices will stay at considerably higher levels than before, and push flask prices higher.
Similarly, I've seen a nice uptick in Glyph prices, likely owing to more limited herb supply.
Obviously, the key driver will be to what extent do these higher herb prices provide enough incentive to for people to farm herbs. I would also think that any sort of arrangements with farmers to get mats at cheap prices may be doubly beneficial in this short term market re-adjustment
I am on a similar quest as manapaws creating an Excel parser for AH data. I currently have a somewhat working version of it, and would love to get some feedback on what utilities might be useful.
Warning ! This is still under heavy development !
Download link: [2shared]2shared - download Parser.xlsm - download Parser.xlsm[/url] (you need that tiny Save file to your PC: click here).
What it currently does:
- Parses AH data form Auctioneer data files (Auc-ScanData.lua) into Excel (the only public visible macro does that).
- Calculates best profit crafts (from all available crafted items).
- Finds whats missing on the AH from crafted items and determines the best profit ones based on historical data.
- Monitors competition activity based on given thresholds.
What it currently does not do / soon-to-do-list:
- Lacks user friendly controls.
- Deleting data currently is done only manually ("Data" Sheet) note: if you delete some data, make sure you import new one right after, so you can trigger the recalculations of all tables.
- Lack controls for changing the reported period (currently this is only the last period).
- Does not have a "Watch list" - a list of top interest items.
What it is supposed to do in the distant future :
- Get AH data form the online auction house when it goes live.
- Get crafting data online.
Every spreadsheet parser I've ever seen only lasts a fairly short amount of time. Apparently the addon devs for auctioneer have no control over the format that the data file is stored in, and it changes (source: question 18 here). If you are going to do this parser, please be prepared to keep it up to date so it continues to work!
Every spreadsheet parser I've ever seen only lasts a fairly short amount of time. Apparently the addon devs for auctioneer have no control over the format that the data file is stored in, and it changes (source: question 18 here). If you are going to do this parser, please be prepared to keep it up to date so it continues to work!
Well, my intentions is to get to work with the online AH as soon as it goes live, so I pretty much need to support any file format changes up to this point (and pray the online formats wont change all that often).
In your "cost for reagents" calculation, on the Recipies tab, you are using minimum of AH price and crafting price (cost to craft the reagent). I really think the opportunity cost of a reagent is never less than the AH price (minus the cost of listing). Example:
Ametrine sells for 244, but can be made for only 42.
Accurate Ametrine sells for 227.
Your profit sheet says Accurate Ametrine has a profit of 185. It should really have a loss of 17 (doing the crafting loses value).
Other features I'd like to see built-in:
1) %Profit on an item (Sell Price / Cost). Higher values here imply lower risk (or may mean I should be willing to spend more on "overhead" to increase volume).
2) Ability to limit available professions (both for the reagents I can produce, and the finished products I can sell).
3) Do you check vendor prices for crafted products (rather than just reagents)? On occasion it can be profitable to craft something and then vendor it.
Whats new:
- Friendly (hopefully) user interface.
- Filters for professions / items.
- Watch list.
- Options to change calculation options for reagents / crafts based on period.
- % Profit on an item (as suggested by Erdluf).
- Some performance optimizations.
- Hopefully better looks.
On the to-do list:
- Help / Tips.
- "Opportunity cost of a reagent" (as suggested by Erdluf).
- Vendor prices (as suggested by Erdluf).
- Data consistency checks.
- Stress tests.
Edit: I would be grateful if people could send me some data extracts (Auc-ScanData.lua files) from different dates in order to perform some stress tests and data consistency checks. I'm aware I could manufacture some extracts manually, but I'd rather work with actual data. Mail them to s1lence@abv.bg. Thanks in advance.
Originally Posted by Erdluf
In your "cost for reagents" calculation, on the Recipies tab, you are using minimum of AH price and crafting price (cost to craft the reagent). I really think the opportunity cost of a reagent is never less than the AH price (minus the cost of listing). Example:
Ametrine sells for 244, but can be made for only 42.
Accurate Ametrine sells for 227.
Your profit sheet says Accurate Ametrine has a profit of 185. It should really have a loss of 17 (doing the crafting loses value).
I agree with you on this one, however there is a problem: I'd like to keep the current functionality as well as add options to filter cases like the one you described. Out of the top of my head I see some circular calculations and speed is already an issue. But this definitely goes on my to-do list.
Originally Posted by Erdluf
1) %Profit on an item (Sell Price / Cost). Higher values here imply lower risk (or may mean I should be willing to spend more on "overhead" to increase volume).
Added it to the latest update.
Originally Posted by Erdluf
2) Ability to limit available professions (both for the reagents I can produce, and the finished products I can sell).
This was actually on my to-do list, but forgot to put it down here. It is added in the latest update.
Originally Posted by Erdluf
3) Do you check vendor prices for crafted products (rather than just reagents)? On occasion it can be profitable to craft something and then vendor it.
I'd love to do this, but I need to get my hands on an extractable DB with the vendor prices. Would really hate to add them by hand.
Just loaded parser.xlsm using Excel 2007 (trial version.) The error message is: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I had just loaded Excel 2007 from Microsoft, so it's probably good (only loaded Excel, not the rest of Office, but I'm assuming that's not the problem.)
> Follow on: indeed I had not loaded VBA. There's no issue with the parser.xlsm file.
Just loaded parser.xlsm using Excel 2007 (trial version.) The error message is: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I had just loaded Excel 2007 from Microsoft, so it's probably good (only loaded Excel, not the rest of Office, but I'm assuming that's not the problem.)
Most likely the problem is that you have not installed the VBA module of the office package. Take a look at this solution.
Fixed a bug that caused the Prospecting calculations to fail for WoTLK ores and made some performance optimizations. You can get the file from the link below. I suggest copying you "CraftFilters and Data sheets form the old version to retain your settings/data.
Alright, got a somewhat final version of the parser. You can get it from here.
So what does "somewhat final" mean : It means I finally got all the functionality I want in, but it is still untested (volunteers anyone?). The reason I am releasing it like that is because there was a somewhat significant bug (only the gold portion of the buyout was calculated) in the previous version and because I have a quite heavy business schedule over the next week or two and I'm not sure when I can fully test it this month. As always any help with checking data is appreciated.
So whats new:
- Prospecting and Icy Prism calculation sheet.
- Some new controls including:
Setting to calculate craft price solely on AH price (exclude sub-crafting).
Settings to clean data based on % (for example - delete all data that's 500% over Average Buyout).
Updated controls for deleting date data.
- Help/tips system.
- Some new conditional formatting on the "ItemsOverall" sheet to monitor the moving of prices.
- Changed the name and added version.
To-do:
Testing, testing, testing.
Originally Posted by Amadisthemage
Just downloaded your latest file - using the latest Excel 2010 beta, get the following error when clicking on the Import button:
"Run-time error '-2147467259 (80004005)':
Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus"
If I then click on End and try the import again, get the following:
"method 'FileDialog' of object_'Application' failed.
Going into the VBA debugger, both errors point to line 109:
Set fd = Application.FileDialog(msoFileDialogOpen)
Hope this helps in some way!
Unfortunately I can't be of much help here. The line that generates the error is a standard build in dialog. Some forums suggest this bug occurs when using Windows Vista in combination with some Add-ins.
This command requires atleast 2 rows of source data. You cannot use the command on a section on only one row.
Also I might be wrong, but the file itself isn't called auc-scandata.lua but just scandata.lua in the auc-scandata map. Maybe it's different for other people I don't know.
Lately, we've been having 'gem bots' on the server. Pretty much a bot using an addon to non-stop cancel and list gems. This bot is online 24/7 until he gets banned (usually quickly), and then it takes about 3 hours for a new one to pop up, with the exact same gems.
Is there any way to counter this? I've been doing ok by simply ignoring the cuts it has in stock, but I would love to get rid of it.
Are you 100% sure it's a bot? Try to check if it has a lower limit on price: post a gem at a ludicrously low price and see if he undercuts you; if he does then start buying out his gems until he runs out of stock and then repost them for a profit.
Probably won't work and you might just lose the gem you post, I can't see any other solution besides selling something else though.
This command requires atleast 2 rows of source data. You cannot use the command on a section on only one row.
Also I might be wrong, but the file itself isn't called auc-scandata.lua but just scandata.lua in the auc-scandata map. Maybe it's different for other people I don't know.
Maybe a solution, but have you tried doing a full disk search for "auc-scandata.lua"? Without the quotes of course.
03/21/10, 6:44 AM
:
Similar Threads
