Advertisements

K162 Trade Index

As a trader you continually ask yourself, what are the best items that I need to be working with?

This is a hard question to answer as there are many ways of using statistics to derive an answer. A common method is to use weights on criteria to come up with an index. The better this number, the better the item performs.

My trading partner James and I put weight on an items total profit, profit per transaction, profit per itemvolumeopportunity cost. We have 35,852 transactions dating back to October of 2010, but I wanted a current snapshot of my trading performance so we limited the interval to 3 months of history.

$sql = ('SELECT SUM(wallet.quantity) as totalQuantity, invTypes.volume, wallet.typeName, wallet.typeID,
 (SUM(wallet.profit) / 100000000) +
 (AVG(wallet.profit) / 100000000) +
 ((SUM(wallet.profit) / SUM(wallet.quantity)) / 40000000) +
 ((SUM(wallet.profit) / (SUM(wallet.quantity) * invTypes.volume)) / 1000000) -
 (((SUM(wallet.price) - SUM(wallet.profit)) / SUM(wallet.quantity)) / 500000000)
 as ticketWeight
 FROM wallet
 JOIN invTypes ON (wallet.typeID = invTypes.typeID)
 WHERE wallet.transactionDateTime > DATE_SUB(CURDATE(), INTERVAL 120 DAY)
 AND transactionType = "sell"
 GROUP BY wallet.typeID
 ORDER BY ticketWeight DESC');

We’re open to critiques of our method, as this is our first attempt to come up with more intelligence beyond ‘what items have the most profit on average per time period’.

K162 2012 Q1 Trade Index 50

Note that PLEX is very over-weighted due to its extremely small size (0.01 m3). We are not currently eliminating outliers.

Advertisements

One Comment on “K162 Trade Index”

  1. Bede says:

    its integrating that theres quite a large selection of minitar ships vrs other racial ship types.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s