Spreadsheet direct link: (removed, Reddit Hugged it to death) This is the barrier I want to remove for new creators, I have created a fairly hassle free script with good (almost foolproof) instructions. Both learning Javascript and how the script worked (to be fair he had some really good comments in the code) were the two main reasons why it was so slow for me to improve upon it. While his script was a good baseline it was fairly limited, it can only load one category of item at a time. However I only really got into it when I wanted a better version of EggBaron's sheet. they can change far easier and far more dramatically as the fundamental rules governing them can change.What has prompted me to release this is EggBaron's post a few days ago, it got me thinking that if the scripting is easier to access and use then more people would be able to create their own sheets to their liking and in general make this small ecosphere that much richer (literally and figuratively).Ī few of you may know me as the person who has done a few spreadsheets about the tradepost/gemstore. Or perhaps some other change to the game might ripple through and affect pricing in some other way. They didn't add much this year, so there may not be as many players going for the off-season titles and items if they stockpiled them during the holidays and the price might not rise as much or as high as it did last year. But this assumes the price will follow roughly the same pattern as last year. So if this year is a repeat of last, you will see the price slowly climb into the summer then more or less level off. Looking at gw2tp (since spidey is missing the data), you can see the price slowly started dropping in October then plummeted during the holiday as gifts poured into the market faster than players were buying them. Looking at either site, you'll see the buy and sell lines reach a high point in July then fluctuated a bit for the next few months, occasionally spiking up to a high point but then coming back down soon after. This is basic supply-and-demand economics in action as the supply during the holiday exceeded the demand, thus causing the price to drop. does have that "missing" data, displaying that price went down during wintersday while volume (the green line in gw2tp) went up. When the data did come back in JanuaryYou do see the price dropped due to Wintersday. I think this was due to ANet changing the item to differentiate between old and new gifts. If you drag this out far to the left, you see that there's a gap in data from mid-October to January. Now, you can change the time span by looking at the very bottom and grabbing and dragging the little ovalish icons superimposed over the dates and an outline in blue of the average overall price. They don't seem to be fluctuating much, but if you saw one or the other change dramatically, it could tell you that players are massively selling or buying the items. They tell you just how many buy and sell orders are listed. Now the red and blue bars that stick up from the bottom of the graph are volume. They buy out the lowest sell orders, bumping the lowest sell order up to 6.44, causing the green line to rise. Then a player decides to buy themselves some gifts. A couple hours later, someone undercuts the sell order, placing the lowest at 5.48, thus the green line dips. So you can instantly sell one for 5.25 or buy one for 5.84 at that time. So let's say this morning, it sees that the lowest sell listing is 5.84 and the highest buy order is 5.25. The lines are generated by polling the TP data periodically. Likewise, the blue line is average of the highest buy order. Purple is an averaging of the green line, thus evens out the day-to-day fluctuations to give an indicator of the real direction the price is moving.
The green line is the lowest sell price and the orange is the highest buy listing. The lines going up and down across the chart are the buy and sell values over time.
0 kommentar(er)
