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.
123Next pageLast page
 

EVE Mogul [v2] - Profit Tracking & More

Author
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#1 - 2012-09-16 01:54:23 UTC  |  Edited by: Jeronica
Greetings Space Pilot!
EVE Mogul
I'm here to introduce you to an EVE-Online web application that is designed to help traders keep track of their market transactions.

Current Features

  • Tracks transactions and journal entries
  • Keeps track of your stock, per user account. Meaning if you buy on one character, and sell on another and both are added to the system, it will use the same stock pool.
  • Displays your profit, per transaction.
  • Built off an open source framework, known for it's security, XSS and query sanitation built in.
  • Public investing reports



~Update~
I've gotten a lot of headway on Mogulv3, you can track my progress here: https://bitbucket.org/jeronica-admin/eve_mogul/wiki/Home

Some key features I'll be adding in:

  • Contracts!
  • Broker fees will be included
  • New reporting pages
  • Selectable hub, which is used when you have no stock and sell an item.


The Beta URL:
https://trade.eve-mogul.com

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Makro SSRI
The Grey Eagles
#2 - 2012-09-16 15:22:13 UTC
Looks very interesting, the investor report is quite nice! Additional information which could be of interest:
-total volume
-sell/buy volume
-returns on total volume/NAV
-returns/volume for each of the 10 items with highest volume+returns and of the 10 items with lowest volume+returns

A few issues I noticed:
-Log-in form says Email/Username, however only logging in using Email works
-I get an annoying browser security warning because of url mismatch of the certificate used I think

Ideas:
I understand that while this started with open source eve-profit and has evolved into your own project, there are still some features of eve-profit that could not only be useful but also be expanded upon, for example:
-filter by item/items
-viewing of different timeframes
-table of items and possibility to sort in various ways (profit %/ISK, volume ISK/units, etc.)
-stats on taxes and fees
-more filtering/sorting in general, for example by region/system/station, price/volume/profit of items or locations and probably more stuff
-option to add/remove graphs to investor reports
-include assets at some point


All in all your project looks very promising and I hope you keep working on it!
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#3 - 2012-09-16 17:16:47 UTC
Thanks for the suggestions Makro!
The information is all there, all I have to do is code the modules to display it.

The issues:
Login username: I will see what I can do to allow for either the username or email. I'm almost positive it can be done.
SSL: I'm still working on getting the certificates. The web panel for the site didnt do that great of a job creating the self signed certificates. I created a cert on another service, but having errors importing it in. Will keep working on it during the week.

Your ideas:
Let me first say that while the original eve-profit was a decent service, I did not like the way it was coded. I didn't use their code in any way. I will probably rename the whole project once all the kinks are worked out.
I love the ideas about the timeframe, and seeing each individual item's statistics. Again I will be working on the code end of that over the next week.

Thanks for reply!

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

I Was There
Habemus
#4 - 2012-09-16 17:19:36 UTC
I really LOVE this. The investor report makes it easy to see the traders capabilities. I've been using this since july(?).
Kivorno
Myanapa Corsica
#5 - 2012-09-17 11:51:26 UTC
I was a big fan of eveprofit and when the code got released I uploaded it on to my own server but never had the time to get round to developing on it.

Like previously mentioned some of the things you have added are a great assets to such a program.

What would be nice would be, if you know the price bought, what would be the RRP to sell the item to keep it above your threshold or the minimum needed to sell at so that you at least break even.

Otherwise keep up the good work, its fantastic!

Proud creator and developer of Eve-Merchant / Eve-Merchant Sprint

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#6 - 2012-09-17 15:02:58 UTC
Kivorno wrote:
I was a big fan of eveprofit and when the code got released I uploaded it on to my own server but never had the time to get round to developing on it.

Like previously mentioned some of the things you have added are a great assets to such a program.

What would be nice would be, if you know the price bought, what would be the RRP to sell the item to keep it above your threshold or the minimum needed to sell at so that you at least break even.

Otherwise keep up the good work, its fantastic!


I've been thinking of adding a page like that, one that displays your current stock as far as the database sees. With a preference for your desired return percentage would be pretty easy to add, and using that could calculate the RRP/minimum price. I will keep that in mind when I develop that module.

Thank you I Was There, your help the past 3 months has been invaluable.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Salpad
Carebears with Attitude
#7 - 2012-09-18 07:21:32 UTC
Can your software take into account refining/reprocessing of materials? That is, if I buy a lot of meta 1/2 loot and refine it, and sell the minerals, does it still track profit, somehow? Same with ices and ores.
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#8 - 2012-09-18 13:50:15 UTC
Salpad wrote:
Can your software take into account refining/reprocessing of materials? That is, if I buy a lot of meta 1/2 loot and refine it, and sell the minerals, does it still track profit, somehow? Same with ices and ores.


I currently do not have any way of tracking reprocessing items and getting that profit. I may take a look at it down the line, but it's not currently a priority.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

March rabbit
Aliastra
Gallente Federation
#9 - 2012-09-18 15:15:43 UTC
i had 1 problem with "old" EveProfit.

This is: putting some item (or amount of items) into IGNORE for tracking of sell. Example: i bought 1MN MWD for 1 mil for myself, then i bought 100 MN MWD for 10k and started to sell for 500k. Then i will get info "bought for 1mil, sold for 500k, loss - 50%". Putting that first 1MN MWD into IGNORE i will have info "bought for 10k, sold for 500k, you'r rich!"

The Mittani: "the inappropriate drunked joke"

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#10 - 2012-09-18 15:26:29 UTC
March rabbit wrote:
i had 1 problem with "old" EveProfit.

This is: putting some item (or amount of items) into IGNORE for tracking of sell. Example: i bought 1MN MWD for 1 mil for myself, then i bought 100 MN MWD for 10k and started to sell for 500k. Then i will get info "bought for 1mil, sold for 500k, loss - 50%". Putting that first 1MN MWD into IGNORE i will have info "bought for 10k, sold for 500k, you'r rich!"


From what I understand, is that the old program wouldn't differentiate between the 1mn and 100mn items? Not sure how that happened.

My script works on item ids, not names. Even if the names are similar, to the programs eyes, they would be very different. I don't see any scenario where that would happen in my program from what you're explaining.

Whenever I develop the stock module, showing your current stock/value/etc, I will have a way to remove stock without "selling" it. For example you purchase a hurricane for personal use, but you're also trading hurricanes, you can remove one hurricane from your stock. This is what I think you meant to mean, am I correct?

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

March rabbit
Aliastra
Gallente Federation
#11 - 2012-09-18 16:14:07 UTC
Jeronica wrote:
March rabbit wrote:
i had 1 problem with "old" EveProfit.

This is: putting some item (or amount of items) into IGNORE for tracking of sell. Example: i bought 1MN MWD for 1 mil for myself, then i bought 100 MN MWD for 10k and started to sell for 500k. Then i will get info "bought for 1mil, sold for 500k, loss - 50%". Putting that first 1MN MWD into IGNORE i will have info "bought for 10k, sold for 500k, you'r rich!"

Whenever I develop the stock module, showing your current stock/value/etc, I will have a way to remove stock without "selling" it. For example you purchase a hurricane for personal use, but you're also trading hurricanes, you can remove one hurricane from your stock. This is what I think you meant to mean, am I correct?

You got it right, thanks! I meant exactly this. Just failed at writing... Oops

It's not good to post in forums while your SIP library is building... Lol

The Mittani: "the inappropriate drunked joke"

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#12 - 2012-09-18 16:31:13 UTC
March rabbit wrote:
Jeronica wrote:
March rabbit wrote:
i had 1 problem with "old" EveProfit.

This is: putting some item (or amount of items) into IGNORE for tracking of sell. Example: i bought 1MN MWD for 1 mil for myself, then i bought 100 MN MWD for 10k and started to sell for 500k. Then i will get info "bought for 1mil, sold for 500k, loss - 50%". Putting that first 1MN MWD into IGNORE i will have info "bought for 10k, sold for 500k, you'r rich!"

Whenever I develop the stock module, showing your current stock/value/etc, I will have a way to remove stock without "selling" it. For example you purchase a hurricane for personal use, but you're also trading hurricanes, you can remove one hurricane from your stock. This is what I think you meant to mean, am I correct?

You got it right, thanks! I meant exactly this. Just failed at writing... Oops

It's not good to post in forums while your SIP library is building... Lol


In that case, expect to see that function in the coming week, the stock module is high up on my priority list to complete.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

sinamrali
School of Applied Knowledge
Caldari State
#13 - 2012-09-18 19:35:41 UTC
Wait, are you saying that this has the ability to track profits per transaction now? I thought that was nearly impossible to do.

So if I had a buy order for a Cap Recharger II at 500,000, and I sold it days later for 555,000, it would report the exact profit of that item at 55,000? And not some average or anything? And can you export this data to Excel?
Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#14 - 2012-09-18 23:08:45 UTC  |  Edited by: Jeronica
sinamrali wrote:
Wait, are you saying that this has the ability to track profits per transaction now? I thought that was nearly impossible to do.

So if I had a buy order for a Cap Recharger II at 500,000, and I sold it days later for 555,000, it would report the exact profit of that item at 55,000? And not some average or anything? And can you export this data to Excel?


You are correct. It would actually be 55k, minus the transaction tax.

The one thing the program does not track, is the broker fee when setting up the order. I could not find a quick and viable way to apply that tax to every transaction.

I would also like to state that the automatic API pull has been disabled for the past few hours. I have to optimize some database queries to reduce the strain on the hardware. I expect it to be finished in 6 hours at the latest.

EDIT: Was done quicker than I expected. It'll run for now but I will be having a close eye on the usage. You may be missing a few transactions/journal entries due to downtime and possible corrupted api pulls. From now on it should be pretty accurate.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Vera Algaert
Republic University
Minmatar Republic
#15 - 2012-09-18 23:30:38 UTC
Jeronica wrote:
sinamrali wrote:
Wait, are you saying that this has the ability to track profits per transaction now? I thought that was nearly impossible to do.

So if I had a buy order for a Cap Recharger II at 500,000, and I sold it days later for 555,000, it would report the exact profit of that item at 55,000? And not some average or anything? And can you export this data to Excel?


You are correct. It would actually be 55k, minus the transaction tax.

how do you calculate this? FIFO? LIFO?

.

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#16 - 2012-09-18 23:40:48 UTC
Vera Algaert wrote:
Jeronica wrote:
sinamrali wrote:
Wait, are you saying that this has the ability to track profits per transaction now? I thought that was nearly impossible to do.

So if I had a buy order for a Cap Recharger II at 500,000, and I sold it days later for 555,000, it would report the exact profit of that item at 55,000? And not some average or anything? And can you export this data to Excel?


You are correct. It would actually be 55k, minus the transaction tax.

how do you calculate this? FIFO? LIFO?


It is calculated using FiFo logic.

If you want more indepth, here is my logic.

  1. Transactions and journal entries are pulled and stored into the database.
  2. For every transaction, I figure out if its buy or sell, if its a buy I go into the "stock" function. It then looks up journal entries and calculates the total price you paid (transaction tax + unit price * quantity not the exact formula, close enough though). It stores that new unit price, and quantity for work later.
  3. For every sale, I pull up the oldest "stock", figure out how much I need to use of the row of stock (if I need another row, depletes it completely, or uses partial). I then calculate profit with the (sell price - buy price) * quantity, and I store that as profit. Then it removes the amount of stock I used from the database.
  4. The profit percentages on screen are all calculated and rendered from that information.

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Jeronica
The Terrifying League Of Dog Fort
Deepwater Hooligans
#17 - 2012-09-20 03:18:13 UTC
I have moved sub domains, and have been coding for the past day. I'll have some new features before this weekend to unveil.

I have also changed the name to Market Mogul, as not to mislead people that this is eve-profit's code.

Has anyone encountered any bugs? Errors? Anything looking not right?

EVE-MOGUL.COM

Trade Profit Tracking&Analytics

Offering Sotiyo Services In

New Caldari | Ashab

IPOs & Investments

Kari Juptris
Dreddit
Test Alliance Please Ignore
#18 - 2012-09-20 15:42:08 UTC  |  Edited by: Kari Juptris
If one of you signs up for this and doesn't get a confirmation email, check your spam folder.

edit: I get an HTTP 500 error when I click the wallet refresh button on the character page. My buyer character is listed as having 0 isk but he has billions.
March rabbit
Aliastra
Gallente Federation
#19 - 2012-09-20 15:48:21 UTC
Jeronica wrote:
Has anyone encountered any bugs? Errors? Anything looking not right?

just logged in, entered API and chosen character. Pressed "Submit" button (upper one) a got long timeout and this error message:
A PHP Error was encountered

Severity: Warning

Message: file_get_contents(http://api.eveonline.com//char/AccountBalance.xml.aspx?keyID=.......&vCode=...............&characterid=........): failed to open stream: HTTP request failed!

Filename: models/charactersmodel.php

Line Number: 102


Pressed back and "submit" again - looks like operation succeded.
Checking now

The Mittani: "the inappropriate drunked joke"

JohnathanGalt
Northern Sky Industries
#20 - 2012-09-20 15:53:58 UTC
One thing that would be a great help would be the ability to ignore a buy. For example, I recently bought about 2 Billion in items to resell, which were then blown up when getting hauled by a hauling company. I got the collateral back, so I did not lose anything in the deal, but now my profits are going to be all off, becasue when I re buy the modules it will be at different prices. So it might show a loss on the items when I sell them if they sell for less then what I paid for the modules that were destroyed. This would also help with items that are for personal use. That way they just would not be in the stacks that you pull inventory out of.
123Next pageLast page