We Need More Writers!
Friday, April 26, 2013
"Hi! I really enjoy your blog, and you asked for questions/places we're having problems. Here's mine:I feel like I spend more time looking things up/updating my spreadsheet than buying/selling or playing the game. I don't have a subscription to any of the trading post sites that ask for them, though several of them allow you a free list to save of your favorites anyway. My big problem is that my buying/selling spreadsheet (simple open office doc) is a mess. I'm not sure how I should set it up - currently I have one line per item per transaction 'group' (i.e., buying a bunch of items), but it's hard to find info I want and some of the data gets obsolete fast. For my usual purchases/sales it's not too bad, but any time I want to try out something new or diversify, it takes forever to keep the data updated.
First off, figure out what data you actually need. What gives you a real edge that makes it worth keeping? You definitely need to reduce how much you track, and you can replace some of the data with sites like gw2spidy.
Second, you probably need to simplify the data you do collect. All I personally write down in my spreadsheet are the name of the market and then two columns to the right: day + profit. That's it. And the profit is a percentage, not a copper/silver/gold value. This allows me to track real progress in markets based on different days.
I used to track the high and lows for the market, but what I quickly learned is that when there was a low profit amount, the market was also usually really low (or the price dropped quickly thereafter when nothing sold due to competition).