Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.28 02:22:00 -
[1]
I haven't seen anything like this anywhere, and I like being able to see what I could potentially make when messing around with the market, so I threw this spreadsheet together to give me a rough idea of what kind of profit I can stand to make for any item.
It's pretty simple; it does take into account base broker fee and transaction fee for orders. I made it in OpenOffice though, so no guarantees on the formulas being utilized correctly by Microsoft Office.
EVE Online Projected Profit Spreadsheet
|
Royd Crusher
|
Posted - 2009.05.28 07:23:00 -
[2]
Nice little spreadsheet.
|
Purest Heart
|
Posted - 2009.05.28 09:57:00 -
[3]
Thank you! This is just what I have been looking for.
I'm a new trader and have been trying to find something simple to keep track of my profit margins.
After ****ing about for almost an hour trying to get other tools such as EMMA to work and failing miserably, this is just the clean break that I need.
Cheers!
|
carmo pereira
Super Bock Mini
|
Posted - 2009.05.28 11:01:00 -
[4]
good spreadsheet. but it will give to much work on updates. you can give a try with evehq. did you try it?
it as a good asset manager, and you can view also your orders, transactions, journal trhu your own api.
you can manage with ease more than one char.
give it a try!
hug carmo
----
Half the money I spend on advertising is wasted, and the problem is I do not know which half
Lord Leverhulme 1851-1925, British founder of Unilever and philanthropist |
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.28 12:00:00 -
[5]
Edited by: Rozalina Khadiija on 28/05/2009 12:00:45 The thing is carmo, most of these programs use the API to watch your current assets, that being inventory and orders. What I want to do is look at an item on the market, plug in its prices, and figure out if it would be worthwhile to invest in. This spreadsheet lets me do precisely that.
|
Kazzac Elentria
|
Posted - 2009.05.28 12:11:00 -
[6]
Not bad, pretty close in design to the one I use |
Varo Jan
Minmatar
|
Posted - 2009.05.28 17:49:00 -
[7]
Nice, thanks for sharing.
Just one point - what you¦ve calculated is the (net) markup percentage, not the net profit percentage.
For example, 100% Markup = 50.0% Gross Profit
|
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.28 18:20:00 -
[8]
That's a good point - I suppose a better phrase would be "percent profit of cost to myself," because that's really what I care about: return rate of initial investment.
Thanks for pointing it out. Perhaps I'll keep changing and adding more to this sheet; it seems I'm getting quite a bit of feedback.
|
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.29 01:01:00 -
[9]
For those of you that have been getting this, you may or may not have noticed, but I've been making slight changes throughout the day (slow day at work today). Also, for my own sanity, I'll only be updating/modifying the single sheet version (the top link).
Thanks for your interest and comments, folks. More is always welcome.
|
Rudy Gnarl
Gallente University of Caille
|
Posted - 2009.05.29 02:40:00 -
[10]
Edited by: Rudy Gnarl on 29/05/2009 02:42:23 Thanks . . . funny I was going to create a simple spreadsheet tonight to keep track of some stuff, now I simply need to modify yours a bit for my purpose. As it is it is your spreadsheet is great for projecting profits as you purposed it. Thank you!
carmo pereira do you have a link for evehq? (nevermind found it) evehq.net Thanks! --- Am I being targeted, wait, ahh, they're all red now! Why won't it warp, it's not responding. Okay warp to zero. Damn it my pod too. F*****g lag! [lesson learned: log for lag] |
|
carmo pereira
Super Bock Mini
|
Posted - 2009.05.29 10:28:00 -
[11]
Edited by: carmo pereira on 29/05/2009 10:29:33 rozalina, i took a second look to the sheet and i was thinking in other situation.
you put 2 global variables in the top. broker fee, and tax. but the question is, if you have standing with the corp where you make a buy order, your fee/tax is lower than normal.
do you thinked about creating individual broker and tax for orders?
i'm trying to do that in my investment sheet to also. carmo
----
Half the money I spend on advertising is wasted, and the problem is I do not know which half
Lord Leverhulme 1851-1925, British founder of Unilever and philanthropist |
Snasty
Caldari The Hippies House of Mercury
|
Posted - 2009.05.29 11:31:00 -
[12]
Nice. Thank you for sharing.
--------------------------------------- -=Snasty, short for Shagnasty ever since the GM's in SWG made me change it...!=- |
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.29 12:35:00 -
[13]
Originally by: carmo pereira
you put 2 global variables in the top. broker fee, and tax. but the question is, if you have standing with the corp where you make a buy order, your fee/tax is lower than normal.
do you thinked about creating individual broker and tax per order?
As far as I know, the actual formulas for calculating the effect of standings aren't known but are close to being figured out; so at the time I made this I didn't really care, and plus my standings don't really amount to squat anyway :D But if someone can point me to where the correct formulas might be, I'd be happy to throw them in. The numbers seem to be pretty dead on when I put orders up though.
|
Kazzac Elentria
|
Posted - 2009.05.29 12:54:00 -
[14]
Originally by: Rozalina Khadiija
Originally by: carmo pereira
you put 2 global variables in the top. broker fee, and tax. but the question is, if you have standing with the corp where you make a buy order, your fee/tax is lower than normal.
do you thinked about creating individual broker and tax per order?
As far as I know, the actual formulas for calculating the effect of standings aren't known but are close to being figured out; so at the time I made this I didn't really care, and plus my standings don't really amount to squat anyway :D But if someone can point me to where the correct formulas might be, I'd be happy to throw them in. The numbers seem to be pretty dead on when I put orders up though.
Here you go
And here is where it was confirmed that its based standings not modified
I think Mitnal was nice enough to sticky that one in the resource thread at one point. |
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.29 13:15:00 -
[15]
Thank you Kazzac!
As soon as I'm out of my next meeting in 10 minutes, and provided I have nothing else to work on, I'll add this in.
|
Krikx
Gallente Dark Syde Exploration Exxxotic
|
Posted - 2009.05.29 13:21:00 -
[16]
Nice spreadsheet.
I'm glad I checked the forums this morning. I was planning on designing something very similar to this today at work for my trading so I could calculate the broke fees and transaction costs into my profit easily. I guess I don't have to know. :)
Thanks for sharing this with the community.
|
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.29 19:56:00 -
[17]
Edited by: Rozalina Khadiija on 29/05/2009 19:58:10 Ok, I found a nice link for the Broker Fee formula in case anyone else is ever interested:
EVE-lopedia Market Guide
As a result of finding this, I've implemented it in finding your true Broker Fee based on your Broker Relations skill level as well as your Corporation and Faction standings. I just finished uploading the newest version :)
|
Rozalina Khadiija
The Juice Factory
|
Posted - 2009.05.30 00:29:00 -
[18]
Edited by: Rozalina Khadiija on 30/05/2009 00:32:46 Version 1.08
ò Swapped the Quantity and Item Price columns under Buy Orders to line up with the market window ingame ò Removed Quantity column from Sell Orders to decrease amount of input required ò Added a Avg Dly Volume column under Sell Orders for new calculations ò Added an Isk Income / Hour column to help you weigh profit margin vs income rate
|
Marteene
|
Posted - 2009.06.21 13:14:00 -
[19]
To Rozalina Khadiija:
Have you tried using the Wallet Journal and Market Transactions spread sheets in the Personal Data Exports? They're in the EVE Insider category in the "My Character" selection. I use these on the website when I need to check up on the business progress outside of EVE.
They are also in the wallet selection in Neo-com inside EVE labeled transactions and journals on separate tabs. I use these often to check the current balance and history of recent transactions.
Your spreadsheet idea is a good one because it combines transactions and journals and thus gives a whole picture of the record. I would use it in addition to the Personal Data Records in EVE Insider.
|
Katiya Khadiija
|
Posted - 2009.07.01 12:48:00 -
[20]
Originally by: Marteene To Rozalina Khadiija:
Have you tried using the Wallet Journal and Market Transactions spread sheets in the Personal Data Exports?
Yes, I use these quite often. I want to know what made my wallet flash :P
I'm in the process of developing an API-based application that is more market based. Yes, there are all ready tools available for traders, but I haven't come across anything yet that isn't full of bugs and / or robust enough for playing the market. This new application will do everything this spreadsheet does, but also track it against your actual trading performance using the API (wallet data exports). Stay tuned! Until then, I'll keep updating this spreadsheet.
Thanks for your feedback, everyone. |
|
|
CCP WeatherMan
|
Posted - 2009.07.03 06:31:00 -
[21]
Locked temporarily by request.
Weatherman Community Representative CCP Games Contact us |
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |