Trading Performance Statistics by Meta Level

Since 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.

Profit % By Meta Level with Standard Deviation

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.

Advertisements

May Financial Report

tl;dr Charts

Things are going great!

May Challenges

Since I missed my April update, this report will contain some events from April.

Overall the Inferno patch cycle brought a large amount of change in the form of market speculation:

Drone mineral drops were removed, market and macro bots were banned, RMT was again cracked down on, Vanguard sites were nerfed, Technetium prices were controlled, faction/deadspace/officer items were added to the market, Nocxium’s artifical price ceiling was removed, and datacores were moved to Faction Warfare. Whew.

All these changes combined with the Burn Jita and Hulkageddon V event meant that prices were volatile.

Major Points

I have joined TEST and have been working with their market division, which seems to be a perfect fit for me. TEST has a very savvy development group that has no trouble coding up sites to manage our efforts.

In April at a Eve meetup, I met another trader who mainly operates in the North with an operation about 8x my size. It was a lot of fun to talk shop with another trader. I think we bored the PVP’ers while we rambled on about margins, hauling, bulk orders, and general logistics. I have apparently made a name for myself because she said, “oh you’re the Blake I’ve heard about — yes, I know about you.”

Order highlighting has improved the speed and accuracy at which I can update orders. I spend about 20 minutes a day total broken into two sessions updating prices. I tend to update after downtime and around 23:00, which is US prime.

Stats @CCP_Diagoras Style

172,592,790,045 sold so far in 2012.
35,912,308,945 profit so far in 2012.
12,340 transactions so far in 2012.
2,921,500.42 average profit per transaction in 2012.
10,843,867.01 standard deviation per transaction in 2012.
Top item by quantity was Tritanium with 90,272,146 sold for a profit of 306,018,174.
Worst profitable item was 1600mm Reinforced Rolled Tungsten Plates I where I lost 49,869,884.
Best trading day on May 5th with a total profit of 1.24 B beating out Oct 24, 2011 at 793 M when I sold a Jump Freighter I build from scratch.

The Future

Keep doing what I am doing and keep putting liquid ISK back into the market.

I spent some money and picked up 305 Tech 3 Subsystem BPCs. The return isn’t that high, so I might put this project off for a later date or work with a production partner to complete the batch.

The addition of officer/deadspace/faction items has opened up new area of trading. I have been having good success with these and am slowing building my list of items to watch.

New modules are almost always insanely profitable. The addition of the new Inferno modules have so far proven to be very lucrative.


Mass Tech 3 Subsystem Production

tl;dr

I spent 4 B on a bulk deal and aquired 305 T3 Subsystem BPCs. It will cost 38 B to buy the components to build 46 B worth of Subsystems. After the blueprint investment cost, the production run will result in a 4.1 B profit (9.13%)

Note: this profit estimation does not take in account for POS fuel or taxes. Additionally, there is the hauling, build, and trading time factor that I have not calculated. Time is money and the minerals you mine are not free.

Before Inferno Unified Inventory

Tech 3 in General

Another complicated production chain greeted my eyes as I started to learn the depth of the production process. Sleeper drops/salvage, gas reactions, and POS limited production oh my.

I found that the general price of Tech 3 hulls and Subsystems have been declining in line with the build Materials over the past year. Melted Nanoribbons, which account for a large percentage of Tech 3 items, are on the decline.

This price decline can be attributed to the general movement into Wormhole space over the past two years and that people have learned how to efficiently farm Sleeper sites.

Build Requirements

SQL all the things!

I’ve got a bunch of Subsystem BPCs which need Hybrid Components. These Hybrid Components are made from Materials (Salvage and Polymers). My level in the production chain will be to buy the Salvage and Polymers, make Hybrid Components and put these together to make Subsystems.

I needed to work with a custom table to get a master list of Materials that will go into the production run from my list of BPCs.

Using my custom typeBuildReqs table (creation details here in section 301), the following query will take the typeID of the Subsystem blueprint and give you a quantity and price of Materials needed. I have a price table called assetValues, so take that section or modify as needed.

SELECT typeBuildReqs.requiredTypeID, SUM(typeBuildReqs.quantity) AS totalQuantity, invTypes.typeName, (SUM(typeBuildReqs.quantity) * assetValues.value) AS totalValue FROM typeBuildReqs
JOIN (
 SELECT invBlueprintTypes.blueprintTypeID as componentBlueprintID
 FROM typeBuildReqs
 JOIN invBlueprintTypes ON (invBlueprintTypes.productTypeID = typeBuildReqs.requiredTypeID)
 WHERE typeBuildReqs.blueprintTypeID = 30227 AND activityID = 1
) AS comp ON (comp.componentBlueprintID = typeBuildReqs.blueprintTypeID)
JOIN invTypes ON (invTypes.typeID = typeBuildReqs.requiredTypeID)
JOIN assetValues ON (assetValues.typeID = typeBuildReqs.requiredTypeID)
GROUP BY typeBuildReqs.requiredTypeID

The Spreadsheet Magic

Breakdown of BPCs by race and what Hybrid Components are needed.

Breakdown of Materials needed to build Hybrid Components and total build cost.

Melted Nanoribbons account for 71.5% of the material cost.

Bottom Line

Production Strategy

For me 38 B is a lot of liquid ISK to be tied up while these Subsystems are constructed. Since Melted Nanoribbons account for such a large portion of the cost, I plan on purchasing all of the materials in totality but initially only 25% or 33% of the total number of Nanoribbons needed.

Everything minus Nanoribbons – 10.8 B
25% Nanoribbons –  6.7 B or 33% Nanoribbons – 8.9 B

My Kingdom for a POS

Subsystems cannot be made at a NPC station and must be installed in a Subsystem Assembly Array anchored at a POS. Since I do not currently have a POS up and running, I have a few options for producing these items:

  1. Grind standing with the appropriate Faction. I do not like mission grinding. I might revisit this option once we have the (rumored) ability to change standings by trading in tags.
  2. Pay a highsec POS anchoring service to drop a tower for me after joining my corporation. Probably the easiest option and I would get a anchored tower out of the deal.
  3. Setup a POS in lowsec and hope not to be discovered. Risky as some bored gang could reinforce the tower, locking your assets until the timer is up.
  4. Contract out the Subsystem production to a corporation that can build them. Higher risk for scams, less profit due to them taking a portion of the profit, but I wouldn’t have to deal with he production line.

Conclusion

I am going to put a hold on this project as I am going to put my liquid reserve into other ventures. The return is not high enough for the time invested. I’ll keep the BPCs in my hangar and revisit in a few months.


Eve Dust Integration Begins

We’re starting to see the beginnings of the Dust world in Eve.

Included in the Inferno Image dump are a bunch of Dust asset images. What’s interesting to me is that they are included in the image set that is used for icons — like the Neocom icon or the Science & Industry icon. There is a different image series for all the unique assets such as the Drake or a 1MN MicroWarpdrive II.

These images are from Inferno_1.0_Icons.zip in the Community Toolkit. (Ninja edit: I also found these icons in the Escalation image dump)

Another interesting item is that there is now a ‘Mercenary Bases’ type on the Overview filter.

I haven’t found any Dust related items in the static SQL data so if you find something, let me know. Time to put on your tinfoil hats and let the speculation game begin!


No New Taxes

Increased taxes are coming with the Inferno patch.

Market tax has been increased from 1% to 1.5% as a part of our initiative to keep the EVE economy healthy.
Inferno Patch Notes

This change won’t be too detrimental for me. I do fear for the smaller trader that has to work with <5% margins.

This change is part of their desire to add more ISK sinks to the game as noted during the 2012 Fanfest Economy presentation. During this presentation CCP showed that 50 T ISK was flowing in and 26 T out resulting in a net flow of +24 T ISK per month.

Adjusting a tax value is a very easy change with a large impact. More low-hanging fruit items to check off their list.


What’s In Your Hangar?

I’m following the trend that Rixx Javix started and posting my goods. As mainly a trader and researcher, I don’t feel like I have a large fleet of PVP ships as I try to maintain a lean operation. ISK goes back into trading and manufacturing operations instead of sitting as a rusting Minmatar hull in a hangar.

I’ve blanked out the majority of my ship name but I’ll let you know that I name them all after Babylon 5 ship classes.

Trade Alt

This character sits in Jita 4-4 and moves and/or ships items around. I think of this guy as the holding account.

(396) Various capital part BPCs left over from copying capital part BPOs for passive income
(293) Various Tech1 BPCs left over when I used to do Invention
(14) Invented Tech2 module BPCs
(5) Invented Anshar (ME -1) BPCs for JF building
Ishtar, Onyx, Phobos, Pilgrim Invented BPCs

(1) Freighter
(2) Jump Freighter
(1) Orca
(5) Iteron Mark V

Long-term Storage

Research Alt

This character is working with around 290 BPOs worth around 13.59 B. I’ve always wanted to be able to produce anything in the game so I bought up the majority of the common module, frigate, and cruiser prints. The only Battlecruiser prints that I own is a set of the Tier3 ones.  I have no intention to ever produce Drakes/Hurricanes due to their small profit margin. I also don’t own any Battleship prints as I like to fly T1/T2 cruiser hulls.

Awaiting ME/PE research

Getting things done

Research alt junk drawer

Capital Bittervet Pilot

Capitals in lowsec and random Bombers

Random PVP ships

Random PVP gear

Subcapital Pilot

I’m training this character to fly all four racial Interceptors, Recons, Logistics, and standard BCs. I also have him trained for the standard T2 Alpha Maelstrom because it is such a common request in nullsec fleets.

Nullsec PVP ships

Random PVP gear

Other Posts

Rixx Javix
Ardent Defender
Jester’s Trek
Kirith Kodachi
reddit.com/r/eve post


Inferno Bomb Animations

The art department did an amazing job with the new bomb animations. Each bomb has a very unique explosion and these screenshots barely do them justice. Time to dust off the old, er — new Nemesis. The new Bomber models also give the bombing experience a fresh feel.

[update] Video below!