In-Development TradeDangerous: power-user trade optimizer
- Thread starter kfsone
- Start date
I hacked together a page to share TradeDangerous.prices data. It will accept a .prices file, look for any updated prices not already in the database, and let you download a new .prices file.
BUT I now foresee a problem with timezones. I am in +11:00 at the moment and the timestamp for each price doesn't account for timezone.
Anyway, the address is http://www.davek.com.au/td/default.asp .
Currently 75 Stations, 2981 Prices. If someone could give it a test I'd like to know how it goes.
BUT I now foresee a problem with timezones. I am in +11:00 at the moment and the timestamp for each price doesn't account for timezone.
Anyway, the address is http://www.davek.com.au/td/default.asp .
Currently 75 Stations, 2981 Prices. If someone could give it a test I'd like to know how it goes.
using UTC as timestamp
Before I modified tradedangerous I always used the ingame time for the timestamp. To get the data I use screenshost, so my first screenshot was of the station display (which includes the date/time) and than the item list (It helps to have a two monitor setup, one side screenshot and the other the editor).
Now I automaticly use CURRENT_TIMESTAMP (which is always UTC) for new entries with the "update" command of tradedangerous.
Before I modified tradedangerous I always used the ingame time for the timestamp. To get the data I use screenshost, so my first screenshot was of the station display (which includes the date/time) and than the item list (It helps to have a two monitor setup, one side screenshot and the other the editor).
Now I automaticly use CURRENT_TIMESTAMP (which is always UTC) for new entries with the "update" command of tradedangerous.
Sorry, I didn't follow that much. Are you saying that you use some switch in trade.py which includes the UTC timestamp? Did you edit that yourself or is that standard? I didn't see a switch for that in "trade.py update -h". Could you run me through the procedure to get UTC timestamps?
I don't take screenshots, I just have ED running on one screen and sublime and cmd running on another screen. I run ED in windowed mode but use "Borderless Gaming" so that it is effectively full screen - that lets me switch easily to other apps with ED running but taking up a full screen.
Yes, I changed it myself and added an "--all" switch to the update command, which exports all price columns and update the timestamp. It also creates a list of all items if the station is new (no prices available).
I made an Bitbucket account and plan to create a clone of tradedangerous and commit my changes, so everyone can take a look and use it if they want (you're not the first to ask). When it's done I'll let you know.
wolverine2710
Tutorial & Guide Writer
Wolverine: Take a look at "SourceTree" from Atlassian, I use command-line git in the easy command-line cases. When I run into a problem or I know I'm likely to, I bring up SourceTree
-Oliver
Works like a charm. Thanks for the hint. Now I have to do some git reading. Using cvs and svn so far at work.
tradedangerous clone
@maddavo (and anyone interrested):
I've created a clone of tradedangerous on bitbucket and commited my changes for the "update" command.
Q: How do I get it?
A: Use git (add my repository and pull from it)
I've tagged the changes, so only this will get merged.
@maddavo (and anyone interrested):
I've created a clone of tradedangerous on bitbucket and commited my changes for the "update" command.
- changes to the "update" command:
- new [--all] switch - Generates the temporary file with all columns and new timestamp.
- if the station is unknown it will generate a list of all items with "0" prices/demand/stock
Q: How do I get it?
A: Use git (add my repository and pull from it)
Code:
$ git remote add bgol https://bitbucket.org/bgol/tradedangerous.git
$ git pull bgol update_all_switchI've tagged the changes, so only this will get merged.
Can someone catch me up on the progress of Trade Dangerous?
Have been busy recently..
If I understand correctly... the program still works.. except for the auto updates of the actual commodity prices.
Which has to be completed manually??
Also.. work is still in progress of adding new systems and their commodities?
Is there any hope in a screen cap of the commodity then transferred to a file to be shared?
Have been busy recently..
If I understand correctly... the program still works.. except for the auto updates of the actual commodity prices.
Which has to be completed manually??
Also.. work is still in progress of adding new systems and their commodities?
Is there any hope in a screen cap of the commodity then transferred to a file to be shared?
Ah great! Got it working. Update does all columns and gives a UTC timestamp - excellent. I really needed to update the supply column and with the UTC timestamp then price sharing is feasible.
Please try up/downloading a .prices file at http://www.davek.com.au/td/
Harbinger
Volunteer Moderator
Here are some additional star systems I've mapped the estimated coordinates for:
Code:
INSERT INTO "System" VALUES(327,'Perkwunos',-40.500125,46.749916,6.749930,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(328,'LP 274-8',-29.738246,44.949649,20.326609,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(329,'Rho Coronae Borealis',-29.874378,42.095439,22.217774,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(330,'LP 386-49',-25.530545,33.376693,25.999697,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(331,'LP 329-18',-26.624757,39.874844,23.280697,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(332,'LHS 3124',-26.281543,43.432673,24.188797,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(333,'LHS 399',-13.562117,36.157422,25.780629,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(334,'LHS 396',-9.875744,30.840733,20.469069,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(335,'OT Serpentis',-11.125686,30.341506,18.407225,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(336,'DE Bootis',-7.437122,32.625116,16.999972,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(337,'Veren''s Stop',-12.968789,21.967734,20.281170,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(338,'G 181-6',-20.312616,20.312786,14.062621,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(339,'Marcov''s Point',-22.342586,14.626760,17.655981,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(340,'LP 229-17',-23.031609,9.032729,8.970076,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(341,'G 203-51',-15.874793,12.031296,5.343640,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(342,'Bidmere',-7.436494,13.219486,1.904265,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(343,'Wise 1405+5534',-8.030538,13.438036,-1.844549,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(344,'LHS 455',-16.905804,10.219086,-3.437526,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(345,'LP 71-165',-20.906919,11.092810,-2.218044,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(346,'LHS 465',-23.937852,12.217715,-0.623736,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(347,'Austern',-25.155543,15.344502,9.374928,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(348,'G 202-48',-15.531001,14.375125,1.875516,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(349,'2MASS 1503+2525',-6.187486,17.999670,8.124526,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(350,'DG Canum Venaticorum',-3.125089,25.529649,2.687266,'2014-10-15 00:00:00');
INSERT INTO "System" VALUES(351,'LP 378-541',1.187879,20.719592,2.343413,'2014-10-15 00:00:00');
Last edited:
Thanx Harbinger. How did you estimate the coordinates? Do you know about the 1/32LY quantisation? I read somewhere all the x/y/z positions are rounded to 1/32LY .
Harbinger
Volunteer Moderator
I use a php script that was written by Snuble and modified by myself. I take the distances from the star I'm mapping to 9 specific reference stars which produces 126 sets of possible coordinates which all vary by a tiny margin due to the lack of precision in the distances on the galaxy map.
The final coordinates are averaged from all 126 results.
You can test the script out for yourself here:
http://coords.is-found.org/
you need to check the distances for at least 4 of the reference stars.
Last edited:
Nice, I added them to my fork. I have made a plot here
Got some other coords from JesusFreke and Wolverine2710.
Got up to 386 systems now!
Are all these forks and branches reintegrated into the master at some point?
I fail go get an impression what is the most feature- and data-complete version.
I fail go get an impression what is the most feature- and data-complete version.
Yep, being pushed back bit by bit.
Thank you for this compilation.
I wonder if it would make sense to create a github/bitbucket project where system coordinates could be kept with this information. Perhaps in json format that can be parsed by anyone easily. I guess most people interested in using them are programmers anyway.
Well they are in bitbucket, but in SQL format. My fork is HERE and this is file you need TradeDangerous.sql. However separating the data from the code is probably a good idea.
Well, json would be easier to use, but at some point there will be too many systems for that anyway. I am sure I have kfsone's project around here somewhere, I could have just pulled the new data. Thank you for pointing me in the right direction.
Maybe it is time to switch to sqlite for me too.
What I miss is the frameshift drive exponent values used for the jump calculations. Until someone figures these values out, I am stuck with sub-optimal route calculation that estimates more fuel used than what is really necessary.
I've just pushed v4.1.0 which provides much better feedback when there is missing/no data either for a given station or the entire database, and merged Bernd Gollesch's feature change which removes the ".prices" file from the repository. Downside: it means there's no data by default, so we may want to provide some kind of default .prices file somewhere that people can obtain.