In-Development TradeDangerous: power-user trade optimizer
- Thread starter kfsone
- Start date
First few new locations calculated - but don't use SagA*!
https://docs.google.com/spreadsheets/d/1dNvJV2CnRLU9BqaTpR-lV4D8AW1PfMzOcKzlqIe5aJg/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1dNvJV2CnRLU9BqaTpR-lV4D8AW1PfMzOcKzlqIe5aJg/edit?usp=sharing
ShadowGar
Banned
I'll add those into the database. I don't know if kfsone will pull my updates into the main repository but my fork is slowly adding systems from the far end of the pill towards core systems. I'm able to do about 4 systems a day due to my schedule. So if you do use my fork, use at your own risk. Until Kfsone looks over my updates, I wouldn't consider it safe.
ShadowGar
Banned
They have all been added. I'll add my account to the document and add them to the database as you get them done.
Fork is here https://bitbucket.org/ShadowGar/tradedangerous
Fork is here https://bitbucket.org/ShadowGar/tradedangerous
Last edited:
Well, wow, awesome work. I'll try and get caught up tomorrow. Shadow/codec, feel free to email me at oliver@kfs.org I'd there is anything I can do to facilitate. Boot camp at my new job is 6 weeks and I think it's going to be full intensity for the remaining 5 so no promises on my available time until then 
Oliver
Oliver
The rest seems to be quite ok.
Just got back in-game after taking a break, this GUI looks interesting and will be very useful to me
iv'e downloaded it and gave it a quick test (i get a lot of graphic glitches) and it really needs a TO Destination data field
Are you still updating it or have you abandoned it now??
Do you have a Thread i can subscribe to about updates?, or are you posting updates in this thread?
Some more stations (not all with market):
Code:
INSERT INTO "Station" VALUES(96,'Hirase Platform',(SELECT system_id FROM System WHERE System.name = 'WISE 1647+5632'),0.0);
INSERT INTO "Station" VALUES(97,'Adams Dock',(SELECT system_id FROM System WHERE System.name = '44 chi Draconis'),0.0);
INSERT INTO "Station" VALUES(98,'Ferguson Platform',(SELECT system_id FROM System WHERE System.name = '44 chi Draconis'),0.0);
INSERT INTO "Station" VALUES(99,'Horowitz City',(SELECT system_id FROM System WHERE System.name = 'G 203-47'),0.0);
INSERT INTO "Station" VALUES(100,'Hopkins Settlement',(SELECT system_id FROM System WHERE System.name = 'G 203-47'),0.0);
INSERT INTO "Station" VALUES(101,'Zhen Outpost',(SELECT system_id FROM System WHERE System.name = 'G 203-47'),0.0);
INSERT INTO "Station" VALUES(102,'Sy Base',(SELECT system_id FROM System WHERE System.name = 'LHS 3262'),0.0);ShadowGar
Banned
Those have been added. Thank you
I have another 213 systems with stations to add. Will be pushed in a few days. Then we will be done till Gamma. Unless Brookes gives us the non-market stars so we can complete out jump routing. Without them, some of the navigation will be incomplete in a bunch of systems.
Last edited:
ShadowGar
Banned
As that we can no longer pull data from the network you will have to manually enter each stations market data. So this tool is very much usable. At this point the mass majority of systems and stations in the core systems are still working properly.
I am in the process of adding all of the beta 2 stars with their current station markets. The downside is that planning routes will be incomplete. We only have the star systems that currently have markets. The systems without markets, we don't have the proper coordinates yet. But there is people working on calculating the missing systems.
Other than bad routes. Once I have all the systems in, you can just set a higher jump number like 25 and it will tell you want systems to trade to. You'll just have to plan the route manually. Unless someone can get Brookes to give us the rest of the systems.
It would be nice for them to hand over the master list. XD Or spit an api out so we can populate our data faster than doing it by hand.
I have have used a few trading tools and I just downloaded TD today to give it a try. I have to congratulate you kfsone for this tool. It is very impressive.
I was very happy when I managed to parse and import my data from another tool (Theo20185's Trade Route Assistant) that I went back to using when Beta 2 came through. I noticed while I was going through that process that there are two commodities that are in the wrong categories - Beryllium and Gallium were in Minerals in the TradeDangerous.sql . I changed these lines as follows:
...
INSERT INTO "Item" VALUES(68,'Gallium',6);
INSERT INTO "Item" VALUES(69,'Beryllium',6);
...
also I had to add Battle Weapons at the end of the list:
...
INSERT INTO "Item" VALUES(76,'Battle Weapons',10);
...
and then I shifted all the Gallium and Beryllium in my TradeDangerous.prices file up to the Metals sections of stations that had them.
[Q] Am I right in surmising that the TradeDangerous.sql file is globally distributed with each version and therefore need to advise of changes that are required for you to add?
[Q] I have added some stations. Do I need to advise you of the stations so you can add them into the TradeDangerous.sql?
I think this tool comes closest to being the most comprehensive. As such, I think it is probably the closest to having the required data to perform calculations for the one feature that I think is missing from all trading tools - Optimal Time trading. ie: The best way to spend your time to maximise credits per minute or hour.
The optimal time function would take each system jump and the station supercruise time into consideration to provide the best credits/hr. Am I right in that the last argument of the Station lines in the TradeDangerous.sql file are the distance of the station from the nav beacon in Ls? If that is the case, then the data is there. A transform function would be needed to convert that distance to a supercruising time. Is something like this possible? How hard do you think it would be?
I was very happy when I managed to parse and import my data from another tool (Theo20185's Trade Route Assistant) that I went back to using when Beta 2 came through. I noticed while I was going through that process that there are two commodities that are in the wrong categories - Beryllium and Gallium were in Minerals in the TradeDangerous.sql . I changed these lines as follows:
...
INSERT INTO "Item" VALUES(68,'Gallium',6);
INSERT INTO "Item" VALUES(69,'Beryllium',6);
...
also I had to add Battle Weapons at the end of the list:
...
INSERT INTO "Item" VALUES(76,'Battle Weapons',10);
...
and then I shifted all the Gallium and Beryllium in my TradeDangerous.prices file up to the Metals sections of stations that had them.
[Q] Am I right in surmising that the TradeDangerous.sql file is globally distributed with each version and therefore need to advise of changes that are required for you to add?
[Q] I have added some stations. Do I need to advise you of the stations so you can add them into the TradeDangerous.sql?
I think this tool comes closest to being the most comprehensive. As such, I think it is probably the closest to having the required data to perform calculations for the one feature that I think is missing from all trading tools - Optimal Time trading. ie: The best way to spend your time to maximise credits per minute or hour.
The optimal time function would take each system jump and the station supercruise time into consideration to provide the best credits/hr. Am I right in that the last argument of the Station lines in the TradeDangerous.sql file are the distance of the station from the nav beacon in Ls? If that is the case, then the data is there. A transform function would be needed to convert that distance to a supercruising time. Is something like this possible? How hard do you think it would be?
ShadowGar
Banned
I haven't changed Gallium and Beryllium in the database because if someone is using the old prices has or manually entered a lot systems like me, they will have to go in and change all systems again. Which would be more of a pain than to just flip flop the system categories. So at the moment, its just a minor inconvenience. That's up to kfsone if that change is made and how to do it.
Yes the .sql is global. One issue with this is that if your adding your own things and update, you need to keep track of what your doing. But I don't see a need for a user adding systems and stations into the database. By tomorrow I should have all systems with all stations that have markets. I opted not to add all stations as that this is trade dangerous and not station dangerous.
If you want to see what has changed, just look here https://bitbucket.org/kfsone/tradedangerous/commits/all
At least having stations /systems with markets is better now coming out faster than waiting a month for me to add all stations.
If you added stations, post them here and I will see if they are already in. More than likely they will be by tomorrow. I am having to go to each system in game and then manually enter the system, station into the sql file. It takes a while with this many stations. ;p
Now when the game launches, there is no way with our current methods of logging all 400 Billion systems. At that point we will have to use an API or scrape method to populate all 400 Billion stars. But then the question is, how do we hold that data and what is the cost performance behind it? IT will be a major undertaking. Something that two or twenty people can not do with current methods.
But if we can at least get in under a thousand stars with systems and an API to populate those stars, traders will have a place to use this tool and trade.
As for your question about distances, that's a question kfsone would have to answer. I'm just a database junkie. Python isn't my thing.
Thanks ShadowGar for that information. I will look forward to your station list - that sounds like a huge job. I added in the following stations myself:
Was I right that the last arg is the distance in Ls? I started entering that on some. That's what I used it for anyway - if it isn't the distance then pls zero it. Let me know if I can help with others.
Have you had problems getting to any WREDGUIA* systems? I crash as soon as I come out of hyperspace to any of those systems. I wonder if there are any markets on your list that are in those systems.
Is there an organised sharing of accumulated station market data somewhere for this?
Code:
INSERT INTO "Station" VALUES(96,'Low Landing',(SELECT system_id FROM System WHERE System.name = 'V1090 Herculis'),42046.0);
INSERT INTO "Station" VALUES(97,'Gelfand Survey',(SELECT system_id FROM System WHERE System.name = 'Dharai'),0.0);
INSERT INTO "Station" VALUES(98,'Hobaugh Beacon',(SELECT system_id FROM System WHERE System.name = 'LP 45-128'),0.0);
INSERT INTO "Station" VALUES(99,'Al-Khalili Refinery',(SELECT system_id FROM System WHERE System.name = 'Wolf 1409'),1116.0);
INSERT INTO "Station" VALUES(100,'Fowler Estate',(SELECT system_id FROM System WHERE System.name = 'Nimba'),0.0);
INSERT INTO "Station" VALUES(101,'Springer Port',(SELECT system_id FROM System WHERE System.name = 'LP 102-320'),0.0);
INSERT INTO "Station" VALUES(102,'Volterra Refinery',(SELECT system_id FROM System WHERE System.name = 'Ao Qin'),0.0);
INSERT INTO "Station" VALUES(103,'Williams Point',(SELECT system_id FROM System WHERE System.name = '21 Draco'),0.0);
INSERT INTO "Station" VALUES(104,'Ejeta Station',(SELECT system_id FROM System WHERE System.name = '14 Herculis'),3203.0);
INSERT INTO "Station" VALUES(105,'Paul-Freidrichs Expedition Base Camp',(SELECT system_id FROM System WHERE System.name = 'Paul-Friedrichs Star'),233.0);Was I right that the last arg is the distance in Ls? I started entering that on some. That's what I used it for anyway - if it isn't the distance then pls zero it. Let me know if I can help with others.
Have you had problems getting to any WREDGUIA* systems? I crash as soon as I come out of hyperspace to any of those systems. I wonder if there are any markets on your list that are in those systems.
Is there an organised sharing of accumulated station market data somewhere for this?
Please update this spreadsheet with any findings about stations and systems.
https://docs.google.com/spreadsheets/d/1pAMXNLpDe2jn3fVRzkNG_sykn_jJcp97Q0FA1SAdnLI/edit?usp=sharing
There is no current market sharing that I know of, although a similar spreadsheet could be made, and I'm sure imported into tradedangerous.
If you want to keep the old one, just add two new ones:
Code:
INSERT INTO "Item" VALUES(77,'Gallium',6);
INSERT INTO "Item" VALUES(78,'Beryllium',6);ShadowGar
Banned
Once I get all of the stars in, I'll look at that.
v 4.0.1 pushed - which imports more data from ShadowGar (THANKS!) and provides support for Sublime Text 2 when using --sublime.
Regards to Item/Categories...
Item names have to be unique within their category; I did this because there was some metal which showed up as both a metal and a mineral.
If I just add a duplicate entry for them, you'll experience problems with, e.g, --avoid requiring you to specify metal or mineral.
What I'll do is add some behavior to cope with the situation where all item names are unique whereby if it sees an item listed in the wrong category, it just ports it to the correct category
-Oliver
Regards to Item/Categories...
Item names have to be unique within their category; I did this because there was some metal which showed up as both a metal and a mineral.
If I just add a duplicate entry for them, you'll experience problems with, e.g, --avoid requiring you to specify metal or mineral.
What I'll do is add some behavior to cope with the situation where all item names are unique whereby if it sees an item listed in the wrong category, it just ports it to the correct category
-Oliver