| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Proton Power
Amarr
Power Corrupts Trading Inc
   |
Posted - 2006.10.29 23:30:00 -
[1]
I am looking for a spread sheet for Trading Market Goods. If anyone has any I would appriciate it. Thanks. (Not NPC Goods).
-----------------------------------------------
Keep the Game Rolling. |
Calladen Nimitz
Caldari
Sovereign Labs
|
Posted - 2006.10.29 23:59:00 -
[2]
Are you looking for one where you can enter prices from various regions for items and track trends? Ive got one (currently revising it tonight) where I track market prices in multiple regions to find the best markets for our sales. You have to visit the region and enter the prices from the market but the sheet does the rest and tells you where to sell. Im revising it tonight trying to add a graph to it that'll track certain items I'm most interested in.
Calladen 
SOVEREIGN ENTERPRISES WEBPAGE AND FORUMS |
Proton Power
Amarr
Power Corrupts Trading Inc
|
Posted - 2006.10.30 00:08:00 -
[3]
That would be great for now. Just want somthing to record what I paid, where at, and what I am selling for.
-----------------------------------------------
Keep the Game Rolling. |
Divorce
|
Posted - 2006.10.31 00:33:00 -
[4]
Scam!!! |
Ramblin Man
Empyreum
|
Posted - 2006.10.31 04:40:00 -
[5]
 Originally by: Divorce
Scam!!!
*blinks*
|
Calladen Nimitz
Caldari
Sovereign Labs
|
Posted - 2006.11.01 01:19:00 -
[6]
Here you go Proton I wasnt able to get the charts working (yet) but here is the early version of it. It should work for you for now and I'll post the updated one once the charts and tables are all working properly.
SALES_LOG_001a.xls
Calladen
SOVEREIGN ENTERPRISES WEBPAGE AND FORUMS |
Calladen Nimitz
Caldari
Sovereign Labs
|
Posted - 2006.11.01 01:21:00 -
[7]
Edited by: Calladen Nimitz on 01/11/2006 01:53:04
Edit:
Here is the trade log I think this is what you need.
TRADE_LOG_001a.xls
Calladen
SOVEREIGN ENTERPRISES WEBPAGE AND FORUMS |
Orchid Ix
Celestial Security Corps
|
Posted - 2006.11.03 03:01:00 -
[8]
Originally by: Calladen Nimitz
Here you go Proton I wasnt able to get the charts working (yet) but here is the early version of it. It should work for you for now and I'll post the updated one once the charts and tables are all working properly.
SALES_LOG_001a.xls
Calladen
These links don't work, getting 503 Server connection failed errors 
|
Vix3n
|
Posted - 2006.11.16 15:53:00 -
[9]
I'm not sure if this will be useful to you or not. (But for the sake of the topic name I'll put it here for whoever wants it)
Its a spread sheet that I am working on that calculates profit while looking at buy/sell orders. I open the market, with this spread sheet next to me.
Look for higher buy orders than average sell orders.
I put in my max ship cargo.
I look at the weight of the item, type that in. It calculates how many of that item I can haul at once. Put in the buy order price, and the cheapest sell order price and it calculates a rough profit margin. If it seems worth it, I gather up the items and drop them off. Im currently working on the "Trade Log" part at the bottom.
Trade Log.xls
*note* This host is only active for 7 days as of November 16th.
|
Angelina Starchild
Skroten
|
Posted - 2006.11.16 21:19:00 -
[10]
Edited by: Angelina Starchild on 16/11/2006 21:32:54
Edited by: Angelina Starchild on 16/11/2006 21:25:04
Originally by: Vix3n
I'm not sure if this will be useful to you or not. (But for the sake of the topic name I'll put it here for whoever wants it)
Trade Log.xls
*note* This host is only active for 7 days as of November 16th.
You got me inspired to do my own one which was a little bit more advanced. However, I skipped a specific Log part, but instead put in room for a total of 30 routes, so it could be used in that way aswell.
Also features:
Ship-decider (up to 3 different ships to maximize Isk/h, it will tell you which)
Isk/H
Isk/J
Conditional Color formatting
Transaction tax
It's not 100% complete, are some more stuff that can be thrown in, but that would be done at some other point, feel free to send any ideas or things you might want in it, and I might get my butt to it faster :)
Feel free to have a lookie:
Angelina Starchild's Public Spreadsheet v.1
|
Vix3n
|
Posted - 2006.11.16 21:30:00 -
[11]
Edited by: Vix3n on 16/11/2006 21:32:46
Originally by: Angelina Starchild
Edited by: Angelina Starchild on 16/11/2006 21:25:04
Originally by: Vix3n
I'm not sure if this will be useful to you or not. (But for the sake of the topic name I'll put it here for whoever wants it)
Trade Log.xls
*note* This host is only active for 7 days as of November 16th.
You got me inspired to do my own one which was a little bit more advanced. However, I skipped a specific Log part, but instead put in room for a total of 30 routes, so it could be used in that way aswell.
Also features:
Ship-decider (up to 3 different ships to maximize Isk/h, it will tell you which)
Isk/H
Isk/J
Conditional Color formatting
Transaction tax
It's not 100% complete, are some more stuff that can be thrown in, but that would be done at some other point, feel free to send any ideas or things you might want in it, and I might get my butt to it faster :)
Feel free to have a lookie:
Angelina Starchild's Public Spreadsheet v.1
Haha, wow. Nicely done! I have no idea how you did the "Use Ship" Fields,  /awe.
I'd like to figure out how you set all of this up...
*bravo*
|
Angelina Starchild
Skroten
|
Posted - 2006.11.16 21:35:00 -
[12]
Originally by: Vix3n
Haha, wow. Nicely done! I have no idea how you did the "Use Ship" Fields, /awe.
I'd like to figure out how you set all of this up...
*bravo*
Excel (2003 atleast) has got a very very very very very good tutorial built in.
Press F1 and search for the vlookup function, and read read read and experiment.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |