I've started collecting overstock history data, and you can query this for a chart covering the last 24-hour period for any item. There's currently no front-end you can use to select the item you're interested in (I may be adding this) but you can enter the item and quality IDs if you know them. For example, for keys: http://www.chrishowie.com/tf2wh-charts/index.py/?item_id=5021&quality_id=6 Data has 1-minute granularity. If rendering the chart is really slow... get a faster computer. Update: New overstock/price history chart website is at http://tf2wh-charts.chrishowie.com/ -- the URL above will simply redirect here.
Thats really cool. But. What your army of fans really wants is for you to give that treatment to price changes, with more than 24hr historical data. Nudge nudge, wink wink
That may or may not already be in the works. Note that the overstock data set is not small. The history table is growing by about 114 MB per day (including indexes). I'm going to have to start rolling week-old data off into archived cold storage at some point. Pricing data, since it changes far less frequently, should be able to be retained hot for longer periods of time.
Yeah they added 1000 keys at once looks like. I think the people working the levers don't want folks selling keys or refined metal any time soon! My hopes of getting more credits just went up in smoke.
Sort of. I can omit consecutive equivalent data, but then I don't know if I lost data or not. And right now, the charting solution I'm using doesn't let me specify the width of each data point -- all points on the X axis are spaced equally. So if I didn't have a consistent amount of data points per unit of time, the X axis scaling would be off. I may address this at some point, but it's rather low on my priority list at the moment.
To give an update on this... I am currently collecting pricing data. The amount of data I have is not yet to the point where charts would really be helpful in any way. Additionally, I'm currently performing a major migration on my httpd configuration, switching not only httpds (Apache -> nginx) but also the entire URI site-mapping scheme. This will take some time to test, and I won't be doing much web development while this is ongoing. By the time I'm done, I should have enough historical pricing data that charts will become useful. tl;dr version: I'm doing a bunch of shit, not enough data yet anyway, stay tuned. (I will be working hard to ensure that my existing web services -- including the overstock charts -- are not interrupted during this migration.)
Based on the overstock history data, it appears that this data is updated by TF2WH every 10 minutes. I have therefore altered collection of historical overstock data to occur once every 5 minutes instead of every minute. This should result in faster chart load times, both due to the decrease in the amount of data downloaded to your browser, but because the database won't have to dig up as many pages to fulfill data requests.
All done. http://tf2wh-charts.chrishowie.com/ Overstock charts go back a day, price charts go back a month. (I don't have a month's worth of pricing data yet; right now you only get about one and a half weeks, but this will go up to a month as time passes.) Reply to this thread with any bugs/anomalies.
Ok, I will test with that browser when I get home. I developed mostly on Chrome; if you having that laying around it might be worth a shot.
not the bulk stuff. theyre selling stuff thats understocked by one item. most of the time, its pure chance that someone sells a random weapon, or just a hat that no one sells because its easier just to get a ref for it.
If you guys want to talk about whether the WH is usable or not, take it to another thread. I want to keep this thread for bug reports regarding my charts.
I noticed that the overstock graph for B.M.O.C doesn't seem to work. Is that due to missing data? I recently messed with parsing the CSV file with a Java program I made under a half hour. It was easy enough I'm surprised I hadn't seen more applications of the CSV of the overstock page (well I backpack.tf does use it to grab warehouse prices I suspect).
I'm not sure how that would work... it probably wouldn't be very readable anyway. I might be able to put both charts on one page though. When an item has stock level of 0, sometimes the JSON overstock dump from the WH doesn't include the item at all. Since it hasn't been in stock in the last few days, there is simply no data for the last day. (The last record was at 2012-10-09 16:50:02 UTC.) I'll try to add an error message for this particular case.
I'll probably start working on this soon, but note that the data won't line up perfectly. The granularity of overstock data is much higher (since it changes more frequently). The amount of history shown is also different for the two graphs. To put things in perspective, for an entire day's worth of history (which is the timeframe used for the overstock charts) there are 17,280 overstock data points, and 4 price data points.
Stock weapons seem to have duplicate lines with the overstock/price links separated for each one. How it is: How it should be:
This is because the WH gives me item IDs for the overstock data, but not for the pricing data. I have to manually match up the pricing data with items by searching on the item name, and the stock weapons have duplicates in the schema. The pricing data is therefore associated with whichever stock weapon definition the database finds first. This is not as much a bug with the charts site as it is an unfortunate consequence of (a) having duplicate items in the schema, and (b) the WH not providing a price dump with item IDs. If I am able to get a JSON dump of the pricing data (poke poke, @triddin) then I might be inclined to correct the historical data, but right now it is too much effort for too little benefit. (Even the overstock data doesn't match up completely -- for example, the Strange Rocket Launcher in the overstock data dump has item ID 18, while Strange Rocket Launchers in backpacks have item ID 205.)
I'm not understanding how medi gun gets a price or stock amount since its not tradeable unless I'm missing something very obvious...
You can turn a stock weapon into a tradable item by renaming it then cleaning it to the original name.
You don't even need to clean it. Infact if you're bored you can always put in renamed items for fun onto TF2Wh. Which probably wind up being turned into scrap by users but oh well.
Is not working anymore ? From time to time i check some chart but now look like is not updating anymore
stock chart is up to date. Price chart last update is 12-27-2012 http://tf2wh-charts.chrishowie.com/overstock/1006/11/
Calm down, man. I made the same mistake as you by not realizing it's the wrong link. Confirmed bug on the site tough. There's even an empty part on the left and on the right of the chart.
I've forced a manual update for now. The updating script has been running once every six hours, but it seems to have failed to download the price list since 12/27. I've turned on email monitoring of this script, so if it is failing I should learn why the next time it tries to update.
An interesting trend I've noticed is that prices for some items have jumped since late December. Anyway, a useful tool indeed!
Why are achievement only items in there? I saw the "Lugermorph" then below it "Vintage Lugermorph". I'm fairly certain there was no glitch to make tradeable Lugers.
The warehouse has a price for it for some reason, so it gets graphed along with everything else. While I don't see any tradeable unique lugers anywhere, it was certainly possible with the giftwrap glitch. It would have to have a "gifted by" text though.
I know the Demopan, but that's the most strange usage of it. And the topic did just get a necro-bump, I don't think Sera would kills us just because of a picture.
But I might. The picture was unnecessary, but one thing. The conversation after it was a different matter, but it needs to stop. People have been derailing threads WAY too much lately, and I'm sick of it. Next off topic post and I'm likely to start cutting posts out of here and moving them to trolling. Keep on topic or take it somewhere else.
