Simple Trade Route App - Seeing if any Interest (Game Overlay)

Most of you probably already use TCE - Trade Computer Extention, which is an exceptional add-on and amazing piece of coding.

About the same time TCE was released I was working on my own personal app that I used for myself which was simply a visual database/list of a trade route. It is simply a table of what system to jump to, which station and which items to buy and sell.

You are able to cycle through (as well as edit the route items) in game, when you dock you simply read what you need to buy/sell on the overlay, do so and then click the next button to pull up the next plot in the route. It auto copies the system name to the clipboard and then you can go into galaxy map, paste it in and go from there.

The colors are customizable to match your own UI colors and you can also manually edit the route in Excel or do it right in game. It is a very simple app, and I wrote it/am writing it just for myself but definitely wanted to post here and see if there was any interest.

The only requirements to run it (so far) are Excel 2003+ 32bit (64bit version not working, yet). It is a work in progress so I wanted to get the communities views before I did too much "extra" work on it that I don't require myself.

This is not meant to compete with TCE or any other app. It doesn't pool ANY outside data but only makes trading via set route lists that you create, more convenient (for me anyways).

Currently everything is functional, with ability to add to or change the route while in game (or out of game in excel) and the colors are customizable using Excel default palette, and in excel you can also set your own custom colors if you do not have a desired color in the default palette. I am currently working to get this working in 64 bit as well as adding options to save routes so that you can save/load multiple routes.

Tips, ideas, interest or general comments appreciated. Keep in mind I wrote this SPECIFICALLY for me so it is tailored TO ME therefore anything that sucks about it, is because I am a) not a programmer b) didn't intend to release this to public :)

Addition things of use are autohotkey (for grabbing app focus or even macroing commands, and also Voice Attack to do the same)

Attached are some screenshots.
 

Attachments

  • 4.jpg
    4.jpg
    543.2 KB · Views: 890
  • 3.jpg
    3.jpg
    553.9 KB · Views: 808
  • 2.jpg
    2.jpg
    526.3 KB · Views: 692
  • 1.jpg
    1.jpg
    372.8 KB · Views: 866
Last edited:
Interesting screens. I like to use simple things and in this case, I only need informations that you provide. What to buy , where to sell and maybe, when can I find "X" comodity for trade/delivery missions. I am not interested in planets, distance, economy, population, etc ...
Installed TCE and still fighting with to make it work ...I see no reason why not to share this addon with commanders :) +1 rep for this :)
 
I have a technical question. How do you make the screen overlay panels and buttons? Is this done by Excel, or by a feature of ED? How do you make it match the ED font and colours?
 
Interesting screens. I like to use simple things and in this case, I only need informations that you provide. What to buy , where to sell and maybe, when can I find "X" comodity for trade/delivery missions. I am not interested in planets, distance, economy, population, etc ...
Installed TCE and still fighting with to make it work ...I see no reason why not to share this addon with commanders :) +1 rep for this :)

Yeah TCE was a little too much information for me and a bit overwhleming (albeit amazing for what it does)

Personally, I plotted my routes when I fond them and wrote them in notepad, which I was alt-tabbing back and forth (or using second monitor which made my FPS choppy) and that was mega tedious, and thus came up with this. I will work on getting a release out soon.

The thing about this though is it has no pooled data, you still have to manually find routes. So it might not be exactly what you thought. I've found through the internet or personal exploration some routes that I use which I put in the program. It doesn't have and trade data in it by default..that's way beyond my expertise.

I have a technical question. How do you make the screen overlay panels and buttons? Is this done by Excel, or by a feature of ED? How do you make it match the ED font and colours?

It's all done in Excel through VBA coding. By default it doesn't work so much like this, it takes a lot of coding with API calls to make it work with transparency, always on top and able to click through to the game. By default if you were to just code the buttons in Excel/VBA if would have a colored background. Once you add in the proper code to make it transparent, the window doesn't stay on top. Then you add that code and have the issue that you can't click through to apps under the userform..so it requires more code to make that work.

Being as that I am NOT a programmer (at all) this took me some time to get going and help of others.

The colors are set by the user in the options (see screenshots 3 and 4) You can set whatever colors you like to match your GUI. This doesn't run any weird code or apps or mess with ED's files at all. It's just an Excel Workbook that overlays the game.
 
Last edited:
Really great stuff. The one thing I do currently out of game is check my rares trading route by alt-tabbing out, then back in again. So this would stop me doing that! Seems like a perfect little app and fits nicely with the current UI.
 
Really great stuff. The one thing I do currently out of game is check my rares trading route by alt-tabbing out, then back in again. So this would stop me doing that! Seems like a perfect little app and fits nicely with the current UI.

Exactly what it was made for.

Do any of you who've posted have Office 2003+ 32bit? Before releasing I would probably send it to a few people for testing. I am still trying to work out the 64 bit compatibility.
 
I wish someone would do such a nice thing without the need of Excel but get system, station and trade data from TGC, EDDN, EDDB, Auriga and similar.
 
I'm very interested. Where do I sign up?

Lando

I am at work right now, I will PM you tonight :)

I wish someone would do such a nice thing without the need of Excel but get system, station and trade data from TGC, EDDN, EDDB, Auriga and similar.

I wish I could do that. VBA is one of the easier languages to program in, for non programmers like myself. I am actually in no way at all a programmer..I used to build light webpages but all self taught..and this app was all winging it/learning as I go.

I don't even know how to pool data from TGC/EDDN/EDDB that is all way over my head.

My app is definitely a much simpler thing, just to help with trading. I use it daily and it REALLY helps me lol.
 
I don't even know how to pool data from TGC/EDDN/EDDB that is all way over my head.
Oh, from my point of view this is the simple part. Maybe when I get some spare time (hopefully soon) we should start a cooperation. If you are able to poll a specific URL or website, you're half-way done.
 

wolverine2710

Tutorial & Guide Writer
Looks like a very nice program. A while back I've put it on third party tools thread and also in the upcoming EDCodex - coded by biobob. Due to the way the forum works posts are very rapidly snowed under, which is a real shame. Tools are not getting the exposure they truly deserve. My thread but for certain EDCodex could remedy that for a wee bit ;-) EDCodex has just entered the pre-release phase. Meaning its almost done and authors are invited to enhance/edit their entries.

@NewYears1978. I've send you a PM yesterday about EDCodex. I've noticed (in the admin tool) you clicked on the special link which enables you to claim your entry and enhance/edit it. If you deem it useful you can add the download link yourself ;-) Its impossible for biobob and myself to keep track of all tools and threads our selves. Atm 85 tools and 64 threads. We are working on filling the community and video section a bit before the official release ;-)
 
Last edited:
Hi NewYears1978 is there any way to move (re-position) the bar as I have a five screen setup
and it sit's just in the wrong place for me...
thanks..
 

wolverine2710

Tutorial & Guide Writer
In the past your excellent tool, thread has been added to EDCodex. Before EDCodex was released on the 17th of August you have received in the period 5th - 10th of August a PM with an invitation and a special link. After registering and logging in you would automatically become owner of your entry. According to the admin tool(s) you haven't used the special link (yet). Perhaps you have missed the PM or have been (temporarily) away from ED. Its also possible you choose not to claim your entry. Note: Its also possible to assign another commander editing rights for your entry. In either case please send us a PM. You can find your EDCodex entry here.

Alternative way to get ownership
The special link will cease to function in the (near) future, for security reasons. Should you after that point want to become owner of your entry you can use the "Claim ownership" button. In that case please send biobob or myself a PM with the email addressed you used for registration - for verification. You can also use this procedure if you no longer have the PM.

What is EDCodex:
Its a website with a database of currently approx 215+ tools,threads,websites,videos for ED. Any one can and is encouraged to add entries there. EDCodex is and should be community-driven. EDCodex companion thread. Its equally suited for PC's, tablets and smartphones and has RSS feeds.

With kind regards,
Biobob
Wolverine2710
 
Great idea, I have "borrowed" your idea for an overlay and created myself a standalone app(Delphi) that does similar, but you can save/load/edit in game and it will auto update the current system using netlog.log, also you can sort the locations via any of the columns.

[Full View]
2dc91qd.png



[Compact View]
21jcc9c.png



[Route Menu]
2d164q9.png
 
Back
Top Bottom