Latest Diablo 3 News
DiabloWiki Updates
Support the site! Become a Diablo: IncGamers PAL - Remove ads and more!

Auction House Converting Spreadsheet and instructional Video der=

Discussion in 'Diablo 3 Market & Economy Discussion Forum' started by Devldog, Apr 12, 2012. | Replies: 20 | Views: 4159

  1. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
  2. Dyz

    Dyz IncGamers Member

    Joined:
    Jul 16, 2009
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    41
    Re: Auction House Converting Spreadsheet and instructional Video

    Awesome work.
  3. Enlil

    Enlil IncGamers Member

    Joined:
    Mar 9, 2012
    Messages:
    302
    Likes Received:
    0
    Trophy Points:
    0
    Re: Auction House Converting Spreadsheet and instructional Video

    omg, this is so awsome.
    Now I don't have to sit here thinking about all this, Auction house converter does it for me.

    Very Good work, love the price tracking graphs most.
    Been putting beta data into it already : )
  4. FizzyBubbly

    FizzyBubbly IncGamers Member

    Joined:
    Sep 24, 2010
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    42
    Re: Auction House Converting Spreadsheet and instructional Video

    Great work bud, I look forward to see what other content you come up with for your channel.

    Maybe a D3 Crash Course series? Quick 5 min vids that cover specific aspects of the d3 economy and trading vehicles
    -arbitrage
    - gold/usd trade
    - item purchase to salvage and sell
    - optimal crafting, for example: selling your lesser quality rolls for gold to then use the gold to purchase blues from the gender to salvage in turn getting more mats back rather then immediately salvaging the original item
    - trend analysis
    - profiting on patches and expansions: lvl 60+ exp gear would go from crappy to in extreme demand if the level cap gets raised for an expac.
    - gear/ builds for farming gold/mf
  5. FizzyBubbly

    FizzyBubbly IncGamers Member

    Joined:
    Sep 24, 2010
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    42
    Re: Auction House Converting Spreadsheet and instructional Video

    An additional idea came to mind, if you made this a web based tool using php or something similar you could use everyone's input to generate really Awsome data streams. You would be able to see trend formations on different servers maybe even find out that correlations exist between servers, some of which could turn out to be preemptive indicators to market conditions on your own server.

    Now mind's going.. may have to make a phone call to a few friends to make this happen.
  6. skien

    skien IncGamers Member

    Joined:
    Apr 8, 2012
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    26
    Re: Auction House Converting Spreadsheet and instructional Video

    subscribed. you're amazing! good stuff!
  7. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    I dont know how to do that. If you want to teach me or build a prototype using this idea be my guest. I'll give you my input if you need it.
  8. BohemianStalker

    BohemianStalker IncGamers Member

    Joined:
    Aug 9, 2011
    Messages:
    191
    Likes Received:
    5
    Trophy Points:
    43
    Re: Auction House Converting Spreadsheet and instructional Video

    You did some amazing work here man. thanks!
  9. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    Thanks, anybody have any questions??
  10. aHero

    aHero IncGamers Member

    Joined:
    Apr 26, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    It looks like your paypal profit formula is wrong in G11. It should be: "w/out PayPal" - (Sell Price - 1.25)*.029 -.

    e: Also, from what I can tell there is a flat 15% charge on gold/$ transactions instead of $1.25. I messed around with it earlier today, but I'm not sure if all the fees are 100% right.
    Last edited: Apr 26, 2012
  11. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    So is this a pic from a spreadsheet you made using my model? I'm confused. Also can you please link me a thread or wherever you found the info relating to transaction fees. Thanks
  12. galzohar

    galzohar IncGamers Member

    Joined:
    Jul 10, 2003
    Messages:
    1,959
    Likes Received:
    0
    Trophy Points:
    165
    Re: Auction House Converting Spreadsheet and instructional Video

    The paypal fees are just a guess, yes? I haven't found anything official anywhere yet...
  13. aHero

    aHero IncGamers Member

    Joined:
    Apr 26, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    http://www.diabloiiiblog.com/beta/diablo-3-rmah-fees-patch-16/


  14. aHero

    aHero IncGamers Member

    Joined:
    Apr 26, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
  15. galzohar

    galzohar IncGamers Member

    Joined:
    Jul 10, 2003
    Messages:
    1,959
    Likes Received:
    0
    Trophy Points:
    165
    Re: Auction House Converting Spreadsheet and instructional Video

    I've seen many assume that those would be the fees. But then again Blizzard might have a different deal with Paypal, so we can't really know. 0.3$ is a lot when you add it on top of Blizzard's 1.25$. And that's not talking about other possible issues that were already mentioned in other threads, like if I try sell gold for 2$ (choosing to send money to paypal) but I only manage to sell 0.2$ worth of gold - Will Paypal just tell me "thanks for your money" and leave me with nothing?
  16. FizzyBubbly

    FizzyBubbly IncGamers Member

    Joined:
    Sep 24, 2010
    Messages:
    152
    Likes Received:
    0
    Trophy Points:
    42
    Re: Auction House Converting Spreadsheet and instructional Video


    Paypal has this fee for everyone. There is a small possibility that blizzard has obtained another transaction fee option with paypal but for now this is the standard fee for all of paypal's transactions. Since blizzard handles the transactions on the RMAH I'm almost positive that "gains" from the real money AH that would not leave at min $0.01 in the paypal account would default to the blizzard account.

    Again we don't have confirmation but this is the best interpretation so far. Also just because we don't know the fee does not mean it's not worth setting up these tools. The appropriate fees can always be inserted at a later date.


  17. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    I will leave it as is for now, and update it when launch happens so the fees are set in stone. If you have already downloaded it, just change the fees yourself. Its very ez
  18. galzohar

    galzohar IncGamers Member

    Joined:
    Jul 10, 2003
    Messages:
    1,959
    Likes Received:
    0
    Trophy Points:
    165
    Re: Auction House Converting Spreadsheet and instructional Video

    Like I said, if it really ends up working like that, it will cause a lot of trouble for many people who intended to use the RMAH, especially for selling/buying gold (which will likely be the most common use of the RMAH if Bliz don't mess it up).
  19. Azzure

    Azzure IncGamers Member

    Joined:
    Aug 24, 2011
    Messages:
    1,358
    Likes Received:
    0
    Trophy Points:
    261
    Re: Auction House Converting Spreadsheet and instructional Video

    Nice job! The Gold/commodity history graph part might not be necessary, since this site does it all for you and will have all kinds of stats available, updated hourly :)
  20. Devldog

    Devldog IncGamers Member

    Joined:
    Apr 11, 2012
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: Auction House Converting Spreadsheet and instructional Video

    Thanks, are you an admin on the finance side of this site?


Share This Page