Page 3 of 15 FirstFirst 1234513 ... LastLast
Results 21 to 30 of 146

Thread: Daily Auction House data

  1. #21

  2. #22
    Master Theorycrafter
    Join Date
    Feb 2013
    Location
    Euless, TX
    Posts
    628
    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

    Sub Hexcopy()
    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
    Sheets(ssheet).Cells.ClearContents
    Workbooks.Open Filename:=sCSVLink
    Windows(sfile).Activate
    ActiveSheet.Cells.Copy
    wnd.Activate
    Sheets("Hexcopy").Paste
    Application.DisplayAlerts = False
    Windows(sfile).Close False
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
    End Sub
    HexHunterMokog:

    My Latest Video: DeckTech: Elemental Storms!
    @ YouTube @ Facebook @ Twitter @ Twitch.tv

    Learn from Failure. Be Humble in Success.

  3. #23
    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.
    Last edited by Kroan; 01-17-2015 at 07:03 AM.


    Hex Price - For all your price information!

    Hex Rock League - Join the free to play Hex Rock League now!

  4. #24
    Announcing: http://hexprice.com

    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


    Hex Price - For all your price information!

    Hex Rock League - Join the free to play Hex Rock League now!

  5. #25
    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.

  6. #26
    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!

  7. #27
    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 .

  8. #28
    Great, the more numbers the better .

  9. #29
    Quote Originally Posted by Kroan View Post
    Announcing: http://hexprice.com

    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
    Just updated it, you can now find data for individual cards through entering their name directly like this:
    http://www.hexprice.com/Card/Storm%20Cloud

    For a promo just add AA at the end
    http://www.hexprice.com/Card/Extinction%20AA

    Search will come later this week as well as other stuff.


    Hex Price - For all your price information!

    Hex Rock League - Join the free to play Hex Rock League now!

  10. #30
    Would be cool to display for each card a min, max, and average price for last day and last week.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •