Trading Performance Statistics by Meta Level
Posted: 2012-05-31 | Author: Blake | Filed under: market | Tags: deadspace, faction, meta 1, meta 14, meta 2, meta 4, meta 6, tech 2, tech 3 | 3 CommentsSince the addition of higher level meta items to the market, I have started to find a few niche markets and experiment with trading them on the open market as opposed to the contract market. I knew they were producing a greater return than standard tech 1/2 items, but I wanted to quantify that value.
I used the following database query to get the average margin by meta level for the past 120 days of trading.
SELECT invMetaTypes.metaGroupID, invMetaGroups.metaGroupName, AVG((profit / (price * quantity))) * 100 as averageMargin FROM wallet JOIN invMetaTypes ON (wallet.typeID = invMetaTypes.typeID) JOIN invMetaGroups ON (invMetaTypes.metaGroupID = invMetaGroups.metaGroupID) WHERE transactionDateTime > DATE_SUB(CURDATE(),INTERVAL 120 DAY) GROUP BY invMetaTypes.metaGroupID ORDER BY metaGroupID
It turns out that trading in Deadspace items has been really profitable. Though the sample base for Deadspace is considerably smaller than tech 1/2, the margins have been consistently high.
I have not worked with any Officer modules yet.
Table data in a nice chart.
Though it did not terribly skew the results, the tech 1 value was influenced by high margins from the new Drone Damage Amplifier I modules that are returning a 92.6% profit.