EVE Search - EVE-Profit

Check My IP Information

All Channels

Market Discussions

EVE-Profit

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Nomad Quento	Posted - 2010.08.14 15:20:00 - [1] Hi guys. My EVE-Profit webpage is still going strong - now with astonishing 7 active users - lol ;-) EVE-Profit will show your profit on your market orders - nice and simple. It will though require your _full_ API key or else the wallet transactions will not be visible - please have that in mind, if your paranoia forbids to create an account then (remember that it can always be changed). All it takes is for you to try it out and see if it is something you can use. Personally I like it (well, dough) and I have had some positve feedbacks on it also, so I would say it is okay. It has for sure helped me showing my most profitable items and it just makes it more fun to follow ones progress. Webpage is http://eve-profit.com/ (or just http://eveprofit.com/) Comments are always welcome to let me know if this is good or useless. // Nomad Quento
Ray McCormack Nordar Innovations.	Posted - 2010.08.14 15:24:00 - [2] How do you calculate the profit? Follow My EBANK Chatter
Nomad Quento	Posted - 2010.08.14 15:31:00 - [3] Originally by: Ray McCormack How do you calculate the profit? By looking at the buy and sell price. First buy in list is the first sell etc. // Nomad Quento
Estel Arador	Posted - 2010.08.14 15:33:00 - [4] How are broker fees and sales tax handled? Free jumpclone service\|1092 stations!
Nomad Quento	Posted - 2010.08.14 15:36:00 - [5] Originally by: Estel Arador How are broker fees and sales tax handled? They are not - yet. Some day I will calculate those based on skills. It is not perfect but as there is no way to match the journal with transactions, this is currently the best option I think. // Nomad Quento
Ray McCormack Nordar Innovations.	Posted - 2010.08.14 16:11:00 - [6] Originally by: Nomad Quento By looking at the buy and sell price. First buy in list is the first sell etc. Okay, let's look at some transaction logs and see if we can't make that a bit better. Type; Qty; Item; Price; Profit Sell; 15; Some Item; 1,000; 999 Buy; 1; Some Item; 1; NA Buy, 14, Some Item, 998, NA If this is how you're currently doing it, can you see how the profit is misrepresented on the sell line? I'm not sure of your familiarity with concepts of LIFO, FIFO, etc, but these are things you need to look at. I presume your query is something like "SELECT TOP 1 Amount FROM Transactions WHERE Item = 'Item' AND TransactionType = 'BUY' ORDER BY DateTime DESC"? You could improve on that by doing a "SELECT AVG(t2.Amount) FROM Transactions t LEFT JOIN Transactions t2 ON t2.Item = t.Item AND t2.DateTime <= t.DateTime WHERE t.PrimaryKey = '@SellRowPrimary' AND TransactionType = 'BUY' GROUP BY t.DateTime HAVING SUM(d2.Quantity) >= '@SellQuantity' ORDER BY t.DateTime DESC" That will give you the average buy price for the quantity you have just sold and a truer reflection of actual profit. Follow My EBANK Chatter
Scott McClellan Forum Posters Anonymous	Posted - 2010.08.14 16:12:00 - [7] Originally by: Nomad Quento Originally by: Estel Arador How are broker fees and sales tax handled? They are not - yet. Some day I will calculate those based on skills. It is not perfect but as there is no way to match the journal with transactions, this is currently the best option I think. // Nomad Quento If you pull from the Journal instead of the transaction log you should be able to see broker's fees and transaction tax. It's going to get messed up when people adjust market orders though.
Halborn Celtic Technologies Inc.	Posted - 2010.08.14 16:56:00 - [8] Profit = sell price minus buy price (tax and broker cost must be factored) If you want to work out the Return of Investment % you take profit and divide it by the buy price it will give you a 0. Something value and the 2 figures after the point is your ROI%. ------------------------------ CEO Celtic Technologies Inc.
Rasz Lin Caldari Ender's Project	Posted - 2010.08.14 19:00:00 - [9] ah yes, let me register and give you all my traderoutes and best selling item info oh wait
Estel Arador	Posted - 2010.08.14 19:27:00 - [10] Originally by: Nomad Quento They are not - yet. Some day I will calculate those based on skills. It is not perfect but as there is no way to match the journal with transactions, this is currently the best option I think. I've never worked directly with the api so I'm not sure how hard it is. At the very least you could provide the total broker fees and transaction tax paid in the daily/monthly statistics, and subtract them from the 'profit' to get a more accurate measure of the actual profit. Free jumpclone service\|1092 stations!

Titus Phook Amarr	Posted - 2010.08.14 20:12:00 - [11] I use eve-profit and I have to say, its extremely useful for me to be able to see how my trade character is doing no matter where I am. Judging from the overview, some biggish traders are also using it, 12 chars with approx 40 billion in liquid isk and 60 billion in profit is nothing to be sneezed at even without taking into account broker fees and taxes. --------------------------------------------- Proudly posting with my Alt since 2009
Estel Arador	Posted - 2010.08.14 20:20:00 - [12] Originally by: Titus Phook 60 billion in profit is nothing to be sneezed at even without taking into account broker fees and taxes. The fees/taxes are related to turnover, not to profit, so there's no way to tell how much (if anything) of that 60B "profit" would remain after taxes. Free jumpclone service\|1092 stations!
Nomad Quento	Posted - 2010.08.14 22:17:00 - [13] Originally by: Ray McCormack Originally by: Nomad Quento By looking at the buy and sell price. First buy in list is the first sell etc. Okay, let's look at some transaction logs and see if we can't make that a bit better. Type; Qty; Item; Price; Profit Sell; 15; Some Item; 1,000; 999 Buy; 1; Some Item; 1; NA Buy, 14, Some Item, 998, NA What? Where do you get that idea from? No, the profit on this is 1.027 ISK and not 999. I am not sure how you can get that different than that (except for the missing broker cost)? // Nomad Quento
Nomad Quento	Posted - 2010.08.14 22:21:00 - [14] Originally by: Scott McClellan Originally by: Nomad Quento Originally by: Estel Arador How are broker fees and sales tax handled? They are not - yet. Some day I will calculate those based on skills. It is not perfect but as there is no way to match the journal with transactions, this is currently the best option I think. // Nomad Quento If you pull from the Journal instead of the transaction log you should be able to see broker's fees and transaction tax. It's going to get messed up when people adjust market orders though. You can see the exact brokers fee on the journal, yes - but you cannot assign this exact broker fee to an exact transaction. For this to happen we would need a database ID or alike to glue those together. // Nomad Quento
Nomad Quento	Posted - 2010.08.14 22:25:00 - [15] Originally by: Estel Arador Originally by: Titus Phook 60 billion in profit is nothing to be sneezed at even without taking into account broker fees and taxes. The fees/taxes are related to turnover, not to profit, so there's no way to tell how much (if anything) of that 60B "profit" would remain after taxes. It is on my TODO to make some kind of broker fee and tax cost, so it gives an even more detailed view. // Nomad Quento


Pages: [1] :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.