Trading Price Average Script.

Hello!
I wanted to ask if somebody could show me how to go about making a script that when i tell it what item I want it took to look for, it pulls all the realmeye data off that item "selling prices and buying prices" and averages them to give you an average at this time of what an item is worth. I know basic Python and am new to programming so step by step would be best! (If one exists already please link it, aswell as telling me how to go about making one for myself.

Thank You and Happy Easter!

Say you want Giantcatcher Trap.
It's link in realmeye is :
https://www.realmeye.com/offers-to/sell/2860 -> Sell
https://www.realmeye.com/offers-to/buy/2860 -> Buy
Which I assume its ID is 2860. So you can collect all items' ids. Then what you can do is go to the item's site and get html from the site. And then try to scratch the offer off of html. Maybe make your own database to track historical prices?

Although I'd not go with this. I'd set every item a price based on the current economy. (Based on Def Potion. Say Life Potion equals 7 or say Dex Potion equals 0.5 etc..)

Originally Posted by Stacymom

Ya that is the concept of what I was thinking, I just dont know how to program so I cant do it haha. Im a little confused on your last statement, if you are saying that after it gets the price info from the site it than converts it based on life price or def price than I agree, thats what I wanted to do aswell.

Originally Posted by maxhunter2011

What I meant was instead of getting people's offers in realmeye ( because some of them may be some troll offers and they may affect the prices ) I was thinking setting every item's price manually. Although I'm gonna try to do your idea in C# because it looks fun and educational and I've never done such thing before. Gonna get you updated!

Originally Posted by Stacymom

Ya thats why you have to take the data and throw away the outliers (those trolly offers) and than average it out after that. Ill send you a Pm, add me on ******* so we can talk about it more!

Originally Posted by maxhunter2011

Ya thats why you have to take the data and throw away the outliers (those trolly offers) and than average it out after that. Ill send you a Pm, add me on ******* so we can talk about it more!

SWIM already did this. Fetches all buying/selling offers and used stdev and other statistical means to deliver accurate buy sell prices

Output:

Code:

[INFO] Retrieving Offers For Potion of Attack
[INFO] Potion of Attack B>: 0.5, S>: 1.0 B/S: 0.75
[INFO] Retrieving Offers For Potion of Speed
[INFO] Potion of Speed B>: 0.1875, S>: 0.4475490196078431 B/S: 0.31752450980392155
[INFO] Retrieving Offers For Potion of Dexterity
[INFO] Potion of Dexterity B>: 0.3333333333333333, S>: 0.4166666666666667 B/S: 0.375
[INFO] Retrieving Offers For Potion of Wisdom
[INFO] Potion of Wisdom B>: NaN, S>: 0.3074285714285714 B/S: NaN
[INFO] Retrieving Offers For Potion of Vitality
[INFO] Potion of Vitality B>: 0.519298245614035, S>: 0.5 B/S: 0.5096491228070175
[INFO] Retrieving Offers For Potion of Mana
[INFO] Potion of Mana B>: 2.8666666666666663, S>: 4.0 B/S: 3.433333333333333
[INFO] Retrieving Offers For Potion of Life
[INFO] Potion of Life B>: 6.962962962962963, S>: 8.0 B/S: 7.481481481481481
[INFO] Retrieving Offers For Wine Cellar Incantation
[INFO] Wine Cellar Incantation B>: 1.688834422657952, S>: 3.274183006535948 B/S: 2.48150871459695
[INFO] Retrieving Offers For Puppet Master's Encore Key
[INFO] Puppet Master's Encore Key B>: 3.433333333333333, S>: 7.481481481481481 B/S: 5.457407407407407
[INFO] Retrieving Offers For Toxic Sewers Key
[INFO] Toxic Sewers Key B>: 3.433333333333333, S>: 7.481481481481481 B/S: 5.457407407407407

theres some code you can use from SWIM's project
Specifically this class has methods for retrieving all sorts of metrics about items on realmeye and builiding statistical data from them
here

Prices are calculated in terms of def
Explained:
1) get prices of all potions (def: 1.0) then look at just potion prices to determine the rest
2) Parse a list of all items currently for sale(you need the ID of the item to look it up programatically on realmeye)
3) Find offers for the item you want for POTIONS ONLY first. Calculate a rough average from that.
4) Go back and find ALL offers for the item that are also sold for other items and cross reference the prices of both to calculate more data
5) remove any offers 1stdev from average
6) Whatever you want to use the result for...

aside, i put mine in a DB and track it overtime so i can see the price fluctuations on a graph overtime. Collector runs continuously and then sleeps 10-15 seconds random, updates the prices table then continues. Prices can be accessed in time series data through a simple API i built to retrieve the average prices of items

Originally Posted by ruusey

SWIM already did this. Fetches all buying/selling offers and used stdev and other statistical means to deliver accurate buy sell prices

Output:

Code:

[INFO] Retrieving Offers For Potion of Attack
[INFO] Potion of Attack B>: 0.5, S>: 1.0 B/S: 0.75
[INFO] Retrieving Offers For Potion of Speed
[INFO] Potion of Speed B>: 0.1875, S>: 0.4475490196078431 B/S: 0.31752450980392155
[INFO] Retrieving Offers For Potion of Dexterity
[INFO] Potion of Dexterity B>: 0.3333333333333333, S>: 0.4166666666666667 B/S: 0.375
[INFO] Retrieving Offers For Potion of Wisdom
[INFO] Potion of Wisdom B>: NaN, S>: 0.3074285714285714 B/S: NaN
[INFO] Retrieving Offers For Potion of Vitality
[INFO] Potion of Vitality B>: 0.519298245614035, S>: 0.5 B/S: 0.5096491228070175
[INFO] Retrieving Offers For Potion of Mana
[INFO] Potion of Mana B>: 2.8666666666666663, S>: 4.0 B/S: 3.433333333333333
[INFO] Retrieving Offers For Potion of Life
[INFO] Potion of Life B>: 6.962962962962963, S>: 8.0 B/S: 7.481481481481481
[INFO] Retrieving Offers For Wine Cellar Incantation
[INFO] Wine Cellar Incantation B>: 1.688834422657952, S>: 3.274183006535948 B/S: 2.48150871459695
[INFO] Retrieving Offers For Puppet Master's Encore Key
[INFO] Puppet Master's Encore Key B>: 3.433333333333333, S>: 7.481481481481481 B/S: 5.457407407407407
[INFO] Retrieving Offers For Toxic Sewers Key
[INFO] Toxic Sewers Key B>: 3.433333333333333, S>: 7.481481481481481 B/S: 5.457407407407407

OMG This is crazy useful, can I get links to download his price average swell as your graphing program for the data? I would love to use these and look through the code aswell!

Originally Posted by maxhunter2011

OMG This is crazy useful, can I get links to download his price average swell as your graphing program for the data? I would love to use these and look through the code aswell!

So the Collector runs as it's separate program. I can release this individually, it can be configured to save results to a DB, print them to console, or simply save in a text file.

As I said I save them in a DB and built a webapp for apache tomcat to allow the data to be extracted from the DB and rendered in a google charts graph on a webpage with a drop down for every item with data. The exchange is simply a list of JSON objects representing the items price at a certain Timestamp.

There is a very simple API in this webapp that allows a query GET request that returns the price data for the specified item passed in a query param itemId.

I hosted a Web server running aforementioned webapp from my private desktop for a while. However, i don't like to open port 80 to others and don't want to pay for a domain so it was short lived.

Let me know if you have more questions about it I'm more than happy to release parts of it or help someone fork it for personal use

Ruusey

Originally Posted by ruusey

So the Collector runs as it's separate program. I can release this individually, it can be configured to save results to a DB, print them to console, or simply save in a text file.

As I said I save them in a DB and built a webapp for apache tomcat to allow the data to be extracted from the DB and rendered in a google charts graph on a webpage with a drop down for every item with data. The exchange is simply a list of JSON objects representing the items price at a certain Timestamp.

There is a very simple API in this webapp that allows a query GET request that returns the price data for the specified item passed in a query param itemId.

I hosted a Web server running aforementioned webapp from my private desktop for a while. However, i don't like to open port 80 to others and don't want to pay for a domain so it was short lived.

Let me know if you have more questions about it I'm more than happy to release parts of it or help someone fork it for personal use

Ruusey

Hey, I got to admit I REALLY don't understand computer/programming talk to well, so I only understood like 1/4 of that. From what I believe, you are the one that made the price grabber, so I was wondering if you wouldn't mind sharing the full price grabber release so I could use it.

Originally Posted by maxhunter2011

Hey, I got to admit I REALLY don't understand computer/programming talk to well, so I only understood like 1/4 of that. From what I believe, you are the one that made the price grabber, so I was wondering if you wouldn't mind sharing the full price grabber release so I could use it.

Well that was kinda my point of the previous post is that it's a full stack web application. Only way to get all above mentioned functionality is to deploy the webapp to a server.

I can definitely release the Collector which will allow you to get price avgs and save them to a text doc or something. No way to store the timeseries data and display it without storing in a DB

Originally Posted by ruusey

Well that was kinda my point of the previous post is that it's a full stack web application. Only way to get all above mentioned functionality is to deploy the webapp to a server.

I can definitely release the Collector which will allow you to get price avgs and save them to a text doc or something. No way to store the timeseries data and display it without storing in a DB

Ya, just the collector which stores the data to a text doc would be all I need. Thank You!

Trading Price Average Script.

Post a Reply

Similar Threads

Tags for this Thread