Please upgrade your browser for the best possible experience.

Chrome Firefox Internet Explorer
×

Creating a Galactic Trade Network Database

STAR WARS: The Old Republic > English > Community Content
Creating a Galactic Trade Network Database

spreadred's Avatar


spreadred
05.16.2014 , 04:09 PM | #1
Coming from a WoW and EVE background, I found myself a little disappointed with the lack of information pertaining to pricing and trends on the Galactic Trade Network. In order to somewhat remedy this, I have began to keep track of what items I have sold, the date and the price. I was thinking about writing a program that would allow users to enter their individual sales, throw this information into a database and then show some statistics, reports, graphs, trends, etc.

Obviously without any API, this information can not be pulled straight from the game and must be manually entered by players. Although this is less than ideal, I am confident that creating a program to allow entries would make things much easier on a lot of users. I (and I assume, others) have been keeping track of this information in spreadsheet programs like Excel and using it to manipulate the data and generate reports. While this is effective and fairly efficient, I believe such skills might be beyond the grasp of many other players.

I will be moving forward with this app for personal use regardless of whether there is support in the user community, however, I thought that since I am currently in the planning phase of development, I would reach out to the community at large for suggestions/features that I might incorporate into the program.

This project's main focus is to be data processing and visualization for the Galactic Trade Network. Therefore, suggestions/features that are not related to this central idea will not be particularly helpful and I would ask that you refrain from such suggestions. Examples of this would be integrating a skill calculator or some such other functionality which is already provided by other applications.

I have yet to determine which language the application will be coded in. Obviously it will be written in a graphical language supported by Windows. Currently I am leaning towards Java because I am familiar with it and it is also cross-platform. The app should then be able to run on any device that supports java: windows, *nix, android, etc.

I have also considered doing this as a web service, but the possibility for abuse seems extremely high and mitigating that might not be worth the convenience and portability of the web.

Any constructive suggestions would be helpful. In addition to that, I would thoroughly appreciate if anyone who is currently keeping a database of their auctions would forward those over to me to get an idea of what information people are keeping track of and also to use in testing.

In addition to positing in this thread, people can feel free to contact me directly at rohn.adams@gmail.com

JeepWithGuy's Avatar


JeepWithGuy
05.18.2014 , 04:23 AM | #2
Some kind of feature to request a 'price check' on items maybe? Even if it's just scrolling text, giving contributors a specific item price to enter might make it more useful. Please keep the thread updated with your progress. I'd like to see how it turns out.
Constant Warfare: MMO helpsite. You just have to ask.
Pylan Traitine

Celwinn's Avatar


Celwinn
05.18.2014 , 05:11 AM | #3
This will be interesting.

I do support something like this, but at the same time, since each server's economy is different, I can see this being a HUGE project, that can cause alot of headache.
Don't let the past define you

spreadred's Avatar


spreadred
05.18.2014 , 11:07 AM | #4
Quote: Originally Posted by JeepWithGuy View Post
Some kind of feature to request a 'price check' on items maybe? Even if it's just scrolling text, giving contributors a specific item price to enter might make it more useful. Please keep the thread updated with your progress. I'd like to see how it turns out.
I'm not sure what you mean with your suggestion. Users would be using this program to log all of their GTN sales. They will be able to look up specific items and see what it has previously sold for. Both what they have sold it for and also what other users of the program have sold it for.

spreadred's Avatar


spreadred
05.18.2014 , 11:09 AM | #5
Quote: Originally Posted by Celwinn View Post
This will be interesting.

I do support something like this, but at the same time, since each server's economy is different, I can see this being a HUGE project, that can cause alot of headache.
The hardest part of the project will be creating a user base large enough to contribute and continue to contribute the data needed to build the database. Separating out each server is easy, but to become a truly powerful tool it will need lots of data from all servers, which means lots of users actively using the application.

Irongut's Avatar


Irongut
05.19.2014 , 06:19 AM | #6
Interesting idea. As a fellow EVE player myself I'm always looking for more out of game tools to help with SWTOR.

My feature request would be graphs, lots of them. Graphs of my sales prices over time, server minimum sales price over time, server average sales price over time, showing median, etc. Basically if you think you can graph it please do! Numbers are great but graphs make it easier to spot trends and I find them easier to work with at 1am.
◄[|||||||█[☼]█[███████████████████████████████████)

spreadred's Avatar


spreadred
05.19.2014 , 03:30 PM | #7
Quote: Originally Posted by Irongut View Post
Interesting idea. As a fellow EVE player myself I'm always looking for more out of game tools to help with SWTOR.

My feature request would be graphs, lots of them. Graphs of my sales prices over time, server minimum sales price over time, server average sales price over time, showing median, etc. Basically if you think you can graph it please do! Numbers are great but graphs make it easier to spot trends and I find them easier to work with at 1am.
The finished program will definitely include many graphing/chart options. The main hurdle for development, as I have said before is obtaining test data. If you would like to participate by logging your GTN sales, and sending them over to me, that would be very helpful.

JeepWithGuy's Avatar


JeepWithGuy
05.27.2014 , 04:29 AM | #8
Did you post this to Reddit? Same person/program?
Constant Warfare: MMO helpsite. You just have to ask.
Pylan Traitine

Ludwig_VanCover's Avatar


Ludwig_VanCover
06.01.2014 , 02:06 AM | #9
Hey,

I just saw this thread and wanted to respond to the post above this one - I am the guy who made the reddit thread! I was actually unaware of this thread until I went browsing today
░▒ General Ludwig VanCover - The Army of Light ▒░
░▒ "The Time is Always Right to Do What is Right." ▒░
Acting Grandmaster of The Army of Light | Recruiting Tanks, and Healers
Commando Healer Extraordinaire - TEH Server

JouerTue's Avatar


JouerTue
06.02.2014 , 08:29 AM | #10
while i see this working on mats and consumables, maybe also the endgame crafted stock ( augmentation kits, augments, mods) and maybe mounts..the amount of cartel market shells is ridicolous and ridicolously bouncy in terms of prices..