2011 Trading and Industry Report

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!