Hi
I'm glad to have discovered this awsome game. After using data from this helpful wiki page for some time I decided to make a spreadsheet out of it. Here it is. The spreadsheet makes use of some macros. The fields on yellow background are intended to be changed by user. Type in economy levels for current and target systems and current system prices for furs and narcotics (these two prices are used to determine the random factor). The calculation should work as long as default MARKET_MASK_PRICE remains 63 for furs and 120 for narcotics and no other commodity has masks greater than these. This seems to function well at least for main stations and rock hermits. Should you get wrong results, try to add 64 or 128 to the A1 cell on the second sheet ('market'), i.e. make A1 '=rnd+64' or '=rnd+128'.
I copied min/max prices from this page at Elite Wiki.
Although I'm not using any dockables from OXPs yet, I've included price tables for some of them on the 'market' sheet. Don't know if I got them right though. Some data look pretty suspicious like all commodities apart from slaves being exactly the same quantities at constores, or gems and precious metals measured in tons at taxi stations.
Feel free to change or adapt this spreadsheet as you like.
Trading Profit Calculator
Moderators: winston, another_commander
-
Smivs
- Retired Assassin
- Posts: 8408
- Joined: Tue Feb 09, 2010 11:31 am
- Location: Lost in space
- Contact:
Re: Trading Profit Calculator
Hi Cdr. Jettison, and welcome to the friendliest board this side of Riedquat.
That's a nice piece of work and I'm sure it will be really useful to many of us.
Excellent start to your 'forum career'.
That's a nice piece of work and I'm sure it will be really useful to many of us.
Excellent start to your 'forum career'.
Commander Smivs, the friendliest Gourd this side of Riedquat.
Re: Trading Profit Calculator
Wow. Now I feel really lame about my first post!
-
Smivs
- Retired Assassin
- Posts: 8408
- Joined: Tue Feb 09, 2010 11:31 am
- Location: Lost in space
- Contact:
Re: Trading Profit Calculator
Don't worry, I think mine was where I'd broken something and needed help 
Commander Smivs, the friendliest Gourd this side of Riedquat.
-
CommonSenseOTB
- ---- E L I T E ----
- Posts: 1397
- Joined: Wed May 04, 2011 10:42 am
- Location: Saskatchewan, Canada
Re: Trading Profit Calculator
Welcome Cdr.Jettison... and SeaDog to. 
It's nice to see someone working on that end of oolite. Perhaps in time you'll learn javascript and come out with a related ship's equipment oxp. Good starting post.And good name to. Makes me think you're a Contrabandista!
It's nice to see someone working on that end of oolite. Perhaps in time you'll learn javascript and come out with a related ship's equipment oxp. Good starting post.And good name to. Makes me think you're a Contrabandista!
Take an idea from one person and twist or modify it in a different way as a return suggestion so another person can see a part of it that can apply to the oxp they are working on.
CommonSense 'Outside-the-Box' Design Studios Ltd.
WIKI+OXPs
CommonSense 'Outside-the-Box' Design Studios Ltd.
WIKI+OXPs
Re: Trading Profit Calculator
Something to keep in mind is the huge price swings in a particular system can significantly change how profitable some items are.
Furs for instance vary wildly. Computers change very little.
Some OXP stations have pretty messed-up market prices and amounts of items.
I supplied the commodities prices for Random Hits Space Bar OXP, so it's not as crazy as some...though slaves are pretty ridiculous on it, from all the captured bounties.
Furs for instance vary wildly. Computers change very little.
Some OXP stations have pretty messed-up market prices and amounts of items.
I supplied the commodities prices for Random Hits Space Bar OXP, so it's not as crazy as some...though slaves are pretty ridiculous on it, from all the captured bounties.