Pages: [1] 2 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Scott Petterson
Tribal Liberation Force
|
Posted - 2008.07.07 22:50:00 -
[1]
Ok, So I made a trade alt and have been experimenting with trading. I've got about 20 items I'm buying and reselling all in the same hub making 30-50% on each item (although total ISK figures are only about 15K per item). I'm slowly increasing my volume on each item as I get comfortable with the item and trading in general.
My question is not how do I trade or what should I trade, but what tools do you expert use to track your orders? Specifically how much you paid, how much you sold the item for, etc?
Any advice, tips, or pointers would be appreciated. |
Frenden Dax
|
Posted - 2008.07.07 23:06:00 -
[2]
I use Microsoft Excel to make an unholy amount of spreadsheets, but previously I just used Word tables with "item type" "bought on" "bought for" "sold on" "sold for", etc rows.
|
Isiden Ava
|
Posted - 2008.07.07 23:09:00 -
[3]
my wallet !
*sorry cant resist*
|
Scott Petterson
Tribal Liberation Force
|
Posted - 2008.07.07 23:25:00 -
[4]
I was hoping there was some fancy API program that would use the transactions logs and generate a nice report.
Right now I'm using an excel spreadsheet, but I can see how this could get time consuming, as you have to monitor your buy/sell orders and track everything purchased/sold to get accurate numbers on revenue and profit.
I'm only one day in but so far this trading stuff is kind of interesting.
|
Roguehalo
Caldari RH Ship Brokers
|
Posted - 2008.07.07 23:42:00 -
[5]
Originally by: Scott Petterson I was hoping there was some fancy API program that would use the transactions logs and generate a nice report.
Right now I'm using an excel spreadsheet, but I can see how this could get time consuming, as you have to monitor your buy/sell orders and track everything purchased/sold to get accurate numbers on revenue and profit.
I'm only one day in but so far this trading stuff is kind of interesting.
"seat of the pants" trading is the most fun
just check the wallet occasionally
if it's going up you are doing something right
|
Scott Petterson
Tribal Liberation Force
|
Posted - 2008.07.07 23:54:00 -
[6]
Originally by: Roguehalo
"seat of the pants" trading is the most fun
just check the wallet occasionally
if it's going up you are doing something right
Well right now the problem I have is that I'm setting up buy orders to buy the stuff cheap and the isk is going out faster than it's coming in. This happens because I'm waiting until I have a decent amount of each item to sell, so I'm not putting all the items being purchased up for sale.
|
Roguehalo
Caldari RH Ship Brokers
|
Posted - 2008.07.08 00:06:00 -
[7]
Originally by: Scott Petterson
Originally by: Roguehalo
"seat of the pants" trading is the most fun
just check the wallet occasionally
if it's going up you are doing something right
Well right now the problem I have is that I'm setting up buy orders to buy the stuff cheap and the isk is going out faster than it's coming in. This happens because I'm waiting until I have a decent amount of each item to sell, so I'm not putting all the items being purchased up for sale.
If you aren't selling your stuff faster than it's coming in then your sell prices are too high
On the other hand if stuff is coming in faster than you can sell it your buy order prices are too high.
basically it's just a question of balance
|
Scott Petterson
Tribal Liberation Force
|
Posted - 2008.07.08 00:32:00 -
[8]
Originally by: Roguehalo
Originally by: Scott Petterson
Originally by: Roguehalo
"seat of the pants" trading is the most fun
just check the wallet occasionally
if it's going up you are doing something right
Well right now the problem I have is that I'm setting up buy orders to buy the stuff cheap and the isk is going out faster than it's coming in. This happens because I'm waiting until I have a decent amount of each item to sell, so I'm not putting all the items being purchased up for sale.
If you aren't selling your stuff faster than it's coming in then your sell prices are too high
On the other hand if stuff is coming in faster than you can sell it your buy order prices are too high.
basically it's just a question of balance
Thats a good piece of advice. I just setup my final sell orders of the night so the stuff is actually on the market. I'll see what happens over night and adjust my prices accordingly. I gotta say even if I don't make much ISK it's quite fun learning the workings of the eve market.
|
Ava Santiago
Minmatar
|
Posted - 2008.07.08 04:14:00 -
[9]
I keep track of returns in trading vs running missions by recording my wallet balance pre and post mission - and then everything else is trading.
If your corp gives you access, grab a corp wallet and (assuming you trust your corp mates/found your own corp) run the debits/credits out of that account. Depending on the number of "wallets" you have access to, you could keep track of several income streams that way. |
Pastiche
|
Posted - 2008.07.08 04:33:00 -
[10]
EveMEEP, EMMA, and custom spreadsheets. Knowning your product and market is kinda key though.
|
|
YouGotRipped
Ewigkeit
|
Posted - 2008.07.08 05:01:00 -
[11]
Originally by: Scott Petterson Ok, So I made a trade alt and have been experimenting with trading. I've got about 20 items I'm buying and reselling all in the same hub making 30-50% on each item (although total ISK figures are only about 15K per item). I'm slowly increasing my volume on each item as I get comfortable with the item and trading in general.
My question is not how do I trade or what should I trade, but what tools do you expert use to track your orders? Specifically how much you paid, how much you sold the item for, etc?
Any advice, tips, or pointers would be appreciated.
Whenever I feel like throwing up it's a clear sign I've made enough profit.
Motherships
|
mynnna
Caldari GoonFleet GoonSwarm
|
Posted - 2008.07.08 05:32:00 -
[12]
Edited by: mynnna on 08/07/2008 05:33:31 I wrote a spreadsheet to take the raw wallet dump and turn it into useful information about buy orders, sell orders, a variety of current and projected net values, and how much of a given order is sitting in the hanger (effectively, the net value of goods in the hanger). All I have to do is update the data import, enter my wallet value and make sure the formulas updated correctly, so it's not much of a hassle.
|
Ambo
Dirty Deeds Corp. Axiom Empire
|
Posted - 2008.07.08 08:13:00 -
[13]
Check my sig. --------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Scott Petterson
Tribal Liberation Force
|
Posted - 2008.07.08 11:04:00 -
[14]
Originally by: Pastiche EveMEEP, EMMA, and custom spreadsheets. Knowning your product and market is kinda key though.
So after after eight hours I've finally reached a good balance on purchase rate vs selling rate for all but a couple items. For some reason those items haven't moved at all. My sell price is less than any other item by a decent amount, and when I get the volume of these items moving it shows roughly 200 or so a day.
I'm guessing that the volume shown is purchases not sales. Does anyone have any other insight on the numbers eve displays? Is that a combination of buy/sell orders or only sell or buy orders? |
Rho'varo
Diversified Operational Services
|
Posted - 2008.07.08 11:21:00 -
[15]
Originally by: Scott Petterson I'm guessing that the volume shown is purchases not sales.
Actually, each transaction is at once a sale and a purchase.
Features & Ideas: Winding Up Learning Skills |
SoleDeo Gloria
Minmatar Mission Runners Incorporated
|
Posted - 2008.07.08 11:26:00 -
[16]
I also use Excel.
I download my walletjournal daily, copy it into the master sheet (to keep a running total) and delete duplicates (based on the refID).
From there I quickly create to pivot tables - one for expenses (what my trade alt spent) and one for income (what my trade alt sold). Update totals on my balance sheet tab an viola!
My EVE Online Screen Captures Blog |
jna
Caldari Black Ash Enterprises
|
Posted - 2008.07.08 11:54:00 -
[17]
Originally by: YouGotRipped Whenever I feel like throwing up it's a clear sign I've made enough profit.
Whenever I feel like throwing up it's a clear sign I've missed a decimal place. Again.
To the OP - Custom VB spreadsheets in Excel for me, with a SQL Server 2000 back-end to store transactional data (and lookup tables). ------------------------------------------------- Caeleste naves interretis res gravissimas sunt |
Rho'varo
Diversified Operational Services
|
Posted - 2008.07.08 17:51:00 -
[18]
I'm in the "seat of my pants" camp, not tracking my activities explicitly.
If I feel like I have more ISK each week, I don't worry too much about my SKU mix. If I thought it meaningful to worry about the impact of taxes and fees, I would read that as a sign I was focusing items that offer insufficient margin. I'm sure this approach isn't optimal, but it's easy.
Features & Ideas: Winding Up Learning Skills |
Enihcam Xes
|
Posted - 2008.07.09 16:53:00 -
[19]
3. ???
|
Kazzac Elentria
|
Posted - 2008.07.09 17:33:00 -
[20]
Originally by: Rho'varo I'm in the "seat of my pants" camp, not tracking my activities explicitly.
If I feel like I have more ISK each week, I don't worry too much about my SKU mix. If I thought it meaningful to worry about the impact of taxes and fees, I would read that as a sign I was focusing items that offer insufficient margin. I'm sure this approach isn't optimal, but it's easy.
Thats pretty much how I work. The day to day fees, taxes, etc, even transactional orders are pretty inconsequential to me. At the end of the week I compare the totals, paired into groups (advanced reactions, mins, modules, ships, etc...) and make adjustments accordingly.
Every month I'll spend about 20 minutes getting my monthly report ready and compare to last month and again, make adjustments to my plan from there. |
|
Slanty McGarglefist
|
Posted - 2008.07.09 17:44:00 -
[21]
I wish I could get EMMA to work or I'd use it. I get an error on one character when trying to download transactions, but it works on my other character. When I make a report, it's always blank, no matter how far back I put the date as.
__________________________________________________
Originally by: CCP Wrangler No
Doh! |
Chira Netanru
|
Posted - 2008.07.09 18:51:00 -
[22]
Originally by: SoleDeo Gloria and delete duplicates (based on the refID).
refID is a foreign key, not a primary key. there will be duplicate refids in your transactional data.
|
Rho'varo
Diversified Operational Services
|
Posted - 2008.07.09 19:05:00 -
[23]
Originally by: Chira Netanru
Originally by: SoleDeo Gloria and delete duplicates (based on the refID).
refID is a foreign key, not a primary key. there will be duplicate refids in your transactional data.
The only cases of duplicate refIDs that I recall seeing were instances in which I had filled my own order by accident (and I didn't want to delete any of those rows). I'm curious: do duplicates arise under other circumstances? If yes, what?
Features & Ideas: Winding Up Learning Skills |
Chira Netanru
|
Posted - 2008.07.09 21:17:00 -
[24]
another example is when you transfer from one corp wallet division to another. you get both a positive and negative transaction with identical refids
|
Snasty
|
Posted - 2008.07.10 02:14:00 -
[25]
Edited by: Snasty on 10/07/2008 02:14:40
Originally by: Slanty McGarglefist I wish I could get EMMA to work or I'd use it. I get an error on one character when trying to download transactions, but it works on my other character. When I make a report, it's always blank, no matter how far back I put the date as.
Ditto - I love it but goodness its buggy.. I get error after error. Indeed I have more or less given up trying to use it
(Edit for typo)
|
Kldraina
|
Posted - 2008.07.10 05:41:00 -
[26]
I rely upon memory and my wallet. I actually find it very difficult to tell how much money I make as I tend to gain assets instead of isk. Also, I've discovered that my business has a ton of room to grow so my isk gets reinvested pretty quick. |
KtoJest
Minmatar
|
Posted - 2008.07.10 12:36:00 -
[27]
i download the wallet/journal/asset data using the api. dump it to a db and then access the raw data using php code. this gives me info on items in inventory, profit margins, hi/lo/avg buy/sell prices. output is txt or bar chart. also for npc stuff, info on trading cycles, same solarsystem buy/sell combos and other goodies.
the 'my orders' data, a manual download, is processed the same way. reports on items sold out, items with qty=1 and items not moving. saves a lot of time chasing up and down the transaction list.
|
Ordon Gundar
Caldari Kingfisher Industries
|
Posted - 2008.07.14 15:54:00 -
[28]
Originally by: Scott Petterson
Originally by: Pastiche EveMEEP, EMMA, and custom spreadsheets. Knowning your product and market is kinda key though.
So after after eight hours I've finally reached a good balance on purchase rate vs selling rate for all but a couple items. For some reason those items haven't moved at all. My sell price is less than any other item by a decent amount, and when I get the volume of these items moving it shows roughly 200 or so a day.
I'm guessing that the volume shown is purchases not sales. Does anyone have any other insight on the numbers eve displays? Is that a combination of buy/sell orders or only sell or buy orders?
You need to look at the average price in price history. If the average is closer to the buy order price than the sell order price, then that item is only buying at the moment, and not selling. Fly fast..Rats Die..Buy Low..Sell High- Ordon Gundar, CEO of Gundars Independent Traders - Space (G.I.T.S) |
Raylyn Yu
|
Posted - 2008.07.15 16:28:00 -
[29]
Edited by: Raylyn Yu on 15/07/2008 16:28:44 Eve Graph is an awesome online tool. Nothing to install and it has a boatload of features
|
Shagrath Neptune
Series of Tubes
|
Posted - 2008.07.15 17:47:00 -
[30]
Basically, the only way I know of is when you want to find out how much you made, is to consolidate and liquidate all your assets and then the final total will then be in your wallet. I sometimes do this but admit it is a waste of time. You have to cancel all your buy orders and quick sale anything left in your inventory. {which is a waste of profit margin because you should be putting those items up on the market instead.}
|
|
|
|
|
Pages: [1] 2 :: one page |
First page | Previous page | Next page | Last page |