Thanks! This is great.
This can help a few excel macro peeps:
' must have a worksheet (tab) called: "Hexcopy" and I have not figure out how to have it automatically adjust the date yet
sCSVLink = "http://dl.hex.gameforge.com/auctionhouse/AH-Data-2015-01-16.csv"
sfile = "AH-Data-2015-01-16.csv"
ssheet = "Hexcopy"
Set wnd = ActiveWindow
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Application.ScreenUpdating = True
The data from 2015-01-15 missing a comma between name and rarity Sadness on the stack
Edit: nvm. I was able to fix it on my end since there is still a tab between values as well.
Site is in early stages but updates automatically within 30 minutes of the posted time and shows Top 10 Gainers and Losers. Note that the site is in early stages, but wanted to share anyway
I've updated TCGBrowser to get these files and refresh the prices on a daily basis. Another change is that the average AH price is now calculated based on the last 25 transactions. However, I might add the possibility to make this customisable if needed.
Now it's time for me to actually get off my but and fix the parser I wrote oh so long ago. Well, that my classes didn't really want their assignments to be done anyway ;-)
Thanks a lot, Chark and DataDragon. You guys are awesome!
Dylan "DocX" Northrup === IGN: Dylan
My search engine === Orange Tracker (forum posts by Hex employees) === Price data for all Hex cards and equipment and sorted by gold to platinum ratio === My haves/wants list === Rare and Legendary price data for Shards of Fate, Shattered Destiny, and Arena cards === Hex API Parsing Tool (for Windows *and* OS X)
Very happy to see this! I haven't actually had the time to post earlier since I had to go through all the new fun data .
Great, the more numbers the better .
For a promo just add AA at the end
Search will come later this week as well as other stuff.
Would be cool to display for each card a min, max, and average price for last day and last week.