These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

EVE Mogul [v2] - Profit Tracking & More

Author
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#81 - 2012-11-28 03:35:22 UTC
API pulls are working pretty well now, all ready for more users to test!
We've also finished migrating to our new server, and

Some cool facts:
So far we've calculated 120 bil worth of profit for our members.
Give us a try, we're constantly improving and always listening to feedback.
There are almost 200 thousand transactions tracked.
Users currently have 338 bil across all characters

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Dei
Cosmic Core Industries
#82 - 2012-11-28 12:08:26 UTC  |  Edited by: Dei
Does this only handle char keys and not corp keys?

The service isn't updating for me.

Also, I'm assuming that the functionality to work out the profit from industry jobs is not there, and profit is only calculated from orders of the same item that you've bought and sold?
Ronix Aideron
Zymurgy Corp.
#83 - 2012-11-28 13:31:27 UTC
So far I like the tool and the features that are being added.

Start the day off slow and taper off from there.

http://eveboard.com/pilot/Ronix_Aideron

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#84 - 2012-11-28 16:33:10 UTC
Dei wrote:
Does this only handle char keys and not corp keys?

The service isn't updating for me.

Also, I'm assuming that the functionality to work out the profit from industry jobs is not there, and profit is only calculated from orders of the same item that you've bought and sold?


Corp API is my top priority, and should be integrated by this weekend.

And you're correct, profit is only calculated from buy transactions, adding stock to the inventory. I'm looking at solutions to offer an other way to apply profit to sell orders using player supplied prices, however it's open to abuse so when I integrate it I want it to be well thought out.

I added some code to the script, added a column to a table that might have throwing errors when adding character information. It should auto-generate soon.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Dei
Cosmic Core Industries
#85 - 2012-11-28 21:03:40 UTC
Yeah, I've been stuck on this for a while. There are three sources of income that I can figure out:


  1. Buy item from market, sell for higher price (trade)
  2. Buy minerals from market, manufacture item and sell (manufacture)
  3. Receive gift of either materials to manufacture or sell directly (gift)


It's impossible to tell at the moment where you received an item (because they could've trashed some items and then you have orphan stock records). The cases where 'gift' comes into play is when a character gets minerals from mining or moon mining (or PI).

You can then cost the transaction at opportunity cost, so you calculate profit with each buy order and each industry job. Since we can't do 'proper' accounting, we have to frig the profit and calculate it at each step. For instance, I mine 20 trit, I build a Raven (let's say that is how much trit it takes to build it). The profit I make is the Raven minus 20 trit at Jita sell price.

If I buy 20 trit, then the profit is the above calculation plus the profit I made on buying that 20 trit (so we buy 20 trit @ 6 ISK when Jita is selling for 7 ISK - that makes 20 ISK profit from buying that trit at the lower price). We can always sell that trit at sell price now, but we decided to make a Raven and sell it, hoping that we could get more than 7 ISK per trit for our time and skill.

By calculating the profit at each step, that makes it easier for us to track - as we don't have to keep track of items we've bought and then check them off, instead we compare everything to market prices and assume all our assets are that price. If we buy something, we profit; if we sell something, we profit, and so forth. This method makes it easier for us and we don't have to do FIFO or whatever. In a perfect world, I guess FIFO would be unnecessary as there would be a global market index of every item in the world, and our accounting systems would use that to calculate profits instead.

The above is my thoughts on getting profit on a per item basis. Global profit day per day is easy in comparison since we only have to compare our assets to the last API call, and the difference in the account balance. I'd be interested if anyone else had some thoughts on how to get a true profit figure for a char/corp?
Ronix Aideron
Zymurgy Corp.
#86 - 2012-11-29 15:00:02 UTC
I do not know enough about the API so my questions may be strange.

Does each item within your inventory have a unique ID? In such a way that you could track the purchase and sell price?

The gift thing could be straight forward if you were able to associate a device missing from inventory that did not have a corresponding sell order. Maybe a user could associate it with a contract or something.

Start the day off slow and taper off from there.

http://eveboard.com/pilot/Ronix_Aideron

Dei
Cosmic Core Industries
#87 - 2012-11-29 17:30:13 UTC
Nope, the item ID changes, plus the IDs themselves are not unique as CCP cycle through them when they're no longer in existance.
SlayerOfArgus
Hermes Enterprises
#88 - 2012-11-29 21:55:06 UTC
API pulls do seem to be working much better. Definitely loving the site. Though it seem to not keep me logged in and I continually need to sign in over and over. I'm not sure if this is an issue with my browser (Chrome) or something else entirely What?What?
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#89 - 2012-11-30 06:41:28 UTC
Dei wrote:
Yeah, I've been stuck on this for a while. There are three sources of income that I can figure out:


  1. Buy item from market, sell for higher price (trade)
  2. Buy minerals from market, manufacture item and sell (manufacture)
  3. Receive gift of either materials to manufacture or sell directly (gift)


It's impossible to tell at the moment where you received an item (because they could've trashed some items and then you have orphan stock records). The cases where 'gift' comes into play is when a character gets minerals from mining or moon mining (or PI).

You can then cost the transaction at opportunity cost, so you calculate profit with each buy order and each industry job. Since we can't do 'proper' accounting, we have to frig the profit and calculate it at each step. For instance, I mine 20 trit, I build a Raven (let's say that is how much trit it takes to build it). The profit I make is the Raven minus 20 trit at Jita sell price.

If I buy 20 trit, then the profit is the above calculation plus the profit I made on buying that 20 trit (so we buy 20 trit @ 6 ISK when Jita is selling for 7 ISK - that makes 20 ISK profit from buying that trit at the lower price). We can always sell that trit at sell price now, but we decided to make a Raven and sell it, hoping that we could get more than 7 ISK per trit for our time and skill.

By calculating the profit at each step, that makes it easier for us to track - as we don't have to keep track of items we've bought and then check them off, instead we compare everything to market prices and assume all our assets are that price. If we buy something, we profit; if we sell something, we profit, and so forth. This method makes it easier for us and we don't have to do FIFO or whatever. In a perfect world, I guess FIFO would be unnecessary as there would be a global market index of every item in the world, and our accounting systems would use that to calculate profits instead.

The above is my thoughts on getting profit on a per item basis. Global profit day per day is easy in comparison since we only have to compare our assets to the last API call, and the difference in the account balance. I'd be interested if anyone else had some thoughts on how to get a true profit figure for a char/corp?


The site doesnt touch the actual inventory of everyone exactly. It works off buy transactions, if you buy 10 units of hurricanes, you have 10 units in stock. Sell it, and those 10 units of stock gets "consumed", and then profit is calculated via sell-price * quantity, then subtract any relevant taxes the script can locate. I see where you're going with your idea, but there are limitations and variables to it. There is no way the script can know exactly what you do with every unit of trit for example, and even if there was an API output, the hardware would not be able to handle the current number of users with that much to calculate.

At that point, it would be more efficient and easier for all users to either a) add/remove stock manually or b) report prices you bought/manufacture an item for.

Down the road, I can see a way to use bought minerals, which now are stock in the site's database, and consume them with a manufacture order that you enter in the mineral usage manually (too many skills, researching variables). Even then, that's not going to be accurate enough unless the end user is 100% on their game with adjusting their stock.

There are a few solutions I have been looking over in regards to non-transaction inlets of stock (contracts, direct trade, manufacture), but I don't currently have a solution I am 100% happy with currently. For the time being, the site only tracks profit for items you sell, that you have purchased and have been tracked before.

@SlayerOfArgus
I will increase the session time, I notice I get logged out as well every few days, but I have autologin set up so I don't really notice it.

I apologize for my absenteeism the past 2 weeks, Thanksgiving was a big event, and I have finals all next week so I have been devoting the majority of my time to studying and classes.
I am hoping to get some code in Saturday evening, when I'll finally have a free few hours.
Once again, thanks everyone for your support!

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Biz Markie
Perkone
Caldari State
#90 - 2012-11-30 16:46:10 UTC

Interesting tool, handy for having some idea what's going on in Eve (well with my orders at least) while I'm at work Big smile

However, the profit calculations are no longer appearing today. Every transaction is now at 0% profit, with 0 in the profit column. :(

Sirius Troll
Silver Octopus
Infernal Octopus
#91 - 2012-12-02 23:40:02 UTC
Does this just track market related income or for example bounty prizes aswell?

If not, could this be a future feature?
miss eve2006
The New Eden School of trade
Organization of Skill Extracting Corporations
#92 - 2012-12-03 12:12:56 UTC
Severity: Notice

Message: Trying to get property of non-object

Filename: models/charactersmodel.php

Line Number: 63


CharList Retrieved


and a 404 in the title, when trying to manage my character.
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#93 - 2012-12-04 03:17:23 UTC
miss eve2006 wrote:
Severity: Notice

Message: Trying to get property of non-object

Filename: models/charactersmodel.php

Line Number: 63


CharList Retrieved


and a 404 in the title, when trying to manage my character.

Is this still occuring? I hotfixed the file to remove that error.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Romero Kopecz
Viziam
Amarr Empire
#94 - 2012-12-06 04:58:16 UTC
Jeronica wrote:
Mu-Shi Ai wrote:
It doesn't seem like my data is being pulled from the API (though it does have my wallet total). Here's what the management page says:

Orders Cached Until: 0000-00-00 00:00:00
Journal Cached Until: 0000-00-00 00:00:00
Transactions Cached Until: 0000-00-00 00:00:00


Just checked your information, seems like API didnt pull when you checked. It pulled on the next cronjob after you looked.
Your transactions and profit should be populated now.



Having this same issue.
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#95 - 2012-12-06 15:33:40 UTC
Romero Kopecz wrote:
Jeronica wrote:
Mu-Shi Ai wrote:
It doesn't seem like my data is being pulled from the API (though it does have my wallet total). Here's what the management page says:

Orders Cached Until: 0000-00-00 00:00:00
Journal Cached Until: 0000-00-00 00:00:00
Transactions Cached Until: 0000-00-00 00:00:00


Just checked your information, seems like API didnt pull when you checked. It pulled on the next cronjob after you looked.
Your transactions and profit should be populated now.



Having this same issue.


Your api hadn't been pulled when you checked. Your api gets added to the que and should be retrieved on the next api pull. (every 10minutes, unless there's one going already).

Just checked, and your api was pulled and has been pulling since.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Monkey Sandwich
Hedion University
Amarr Empire
#96 - 2012-12-08 12:33:17 UTC  |  Edited by: Monkey Sandwich
I started a mogul account yesterday, but it only seems to import the last 100 transactions. Made a new API key and tried again, but still no graphs generated or orders imported. Am I just too impatient?

It's not the same problem as mentioned above:

API Status
Orders Cached Until: 2012-12-08 14:14:06
Journal Cached Until: 2012-12-08 13:44:31
Transactions Cached Until: 2012-12-08 13:44:28
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#97 - 2012-12-08 23:52:42 UTC
Monkey Sandwich wrote:
I started a mogul account yesterday, but it only seems to import the last 100 transactions. Made a new API key and tried again, but still no graphs generated or orders imported. Am I just too impatient?

It's not the same problem as mentioned above:

API Status
Orders Cached Until: 2012-12-08 14:14:06
Journal Cached Until: 2012-12-08 13:44:31
Transactions Cached Until: 2012-12-08 13:44:28


I only pull the last 100 transactions in the transactions page. I am going to move away from that way of displaying info, and migrate to an order view with more info.

I'm also recoding the orders module, it's being inconsistant and I've seen a few bugs.
As for the no profits displaying, I see it is starting to calculate profit just needed some more data to generate graphs and profit.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Sernum
Infinite Point
Pandemic Horde
#98 - 2012-12-09 19:43:23 UTC
How do i get it to pull?
Monkey Sandwich
Hedion University
Amarr Empire
#99 - 2012-12-09 20:32:15 UTC
Jeronica wrote:

I only pull the last 100 transactions in the transactions page. I am going to move away from that way of displaying info, and migrate to an order view with more info.

I'm also recoding the orders module, it's being inconsistant and I've seen a few bugs.
As for the no profits displaying, I see it is starting to calculate profit just needed some more data to generate graphs and profit.


OK, thx and i'll just wait and see.
Chorus Ambrye
Doomheim
#100 - 2012-12-09 20:36:02 UTC  |  Edited by: Chorus Ambrye
is there any way to reset the stats ?

Also, if I fiddle about with the "Stock WIP" like remove items from there, does it affect the "profit" stats.

It seemed to work great until I started fiddling with the Stock WIP and then the profit tab got pretty messed up, and since then I´ve tried to delete the character and adding a new API and but doesnt seem to reset the stats.

I´m also wondering, in case more then 100 transactions happen between pulls, is the extra info lost ?