2011 Trading and Industry ReportPosted: 2012-01-13
This post serves as an expansion on the 2011 Trading and Industry Reflection post where I outline some of the high level items that brought success to my efforts in 2011. After some further database work, I created a page that shows items in groups on a more granular level.
Q: How was your list created?
I spent a lot of time looking at items that are consumed for mission runners, PVP, and nullsec fleet doctrines.
Q: I might want to take a stab at creating a report of my own. How did you create this page?
All the items have been manually entered into an array.
... '12773', //Barrage M '191',//Fusion M '193',// EMP M ...
The array is then used in a very non-optimized query to produce volume and profit numbers over the past 365 days.
$eveDate = $this->getEveTimeSql(); $sql = ('SELECT typeID, typeName, sum( profit ) AS totalProfit, sum( quantity ) AS totalVolume FROM wallet WHERE DATE( transactionDateTime ) > DATE_SUB( DATE( :eveDate ), INTERVAL 365 DAY ) AND personal = 0 AND transactionType = "sell" AND typeID = :typeID GROUP BY typeID ORDER BY totalProfit DESC');
956 x 2993 report page:
Q: What happened with the Improved Cloaking Device II?
I fat fingered the sell price and was off by a power. Whoops.
Q: Surprises or unexpected trends?
I was completely floored by the amount of Capital Shield Transports that I was able to move in 2011. The new Tier3 BCs did not sell as well as I expected.
Q: Why didn’t you trade xxx or yyy?
There are still a lot of markets that I need to test out.
If you have any more questions, please ask!