davespil
Recruit
I was thinking about a way to trade horses without having to rely on the Green-Yellow-Red system that Bannerlord uses. I don't like it and have seen instances of it contradicting itself. So, I thought if I can capture price data from the game and make a formula I can make a price list. This would tell me what prices I should buy horses at and what prices I should sell them at. Here is my plan:
I get one of each horse in my inventory and hit up every city on the map and as many caravans as I can, though I may scratch the caravan idea and just focus on cities. I record the amount each city will pay for one horse.
With those numbers I can do some number crunching in Excel. First, I get the lowest and highest price for each horse. Subtract the lowest from the highest and get the range of prices. I'm thinking I want to buy horses at the lowest 25% and sell above the highest 50%. that way I ensure that I always make a profit. So lets pretend the lowest price is 50 and the highest price is 250. The range will be 200. 25% of 200 is 50 and 50+50 = 100. So I will not buy horses that cost more than 100. 50% of 200 is 100, 100 -250 is 150. So I will not sell a horse unless its 150 or over.
If I do that for each horse I will have a range for when to buy and sell that specific horse, ensuring that it doesn't matter where I bough the horse I will always make a profit. Here is an example of what the list will look like:
Name.......Max Buy....Min Sell
Aserai.......900............1200
Steppe......100.............175
So, using that list I wouldn't buy a Steppe horse for more than 100 and would never sell them for less than 175. This way I always know that I am buying cheap and selling for a profit.
How does this sound? It's not perfect at all, but dummy proof. And that's what I'm going for. This process could also be used for every other traded commodity, too.
I get one of each horse in my inventory and hit up every city on the map and as many caravans as I can, though I may scratch the caravan idea and just focus on cities. I record the amount each city will pay for one horse.
With those numbers I can do some number crunching in Excel. First, I get the lowest and highest price for each horse. Subtract the lowest from the highest and get the range of prices. I'm thinking I want to buy horses at the lowest 25% and sell above the highest 50%. that way I ensure that I always make a profit. So lets pretend the lowest price is 50 and the highest price is 250. The range will be 200. 25% of 200 is 50 and 50+50 = 100. So I will not buy horses that cost more than 100. 50% of 200 is 100, 100 -250 is 150. So I will not sell a horse unless its 150 or over.
If I do that for each horse I will have a range for when to buy and sell that specific horse, ensuring that it doesn't matter where I bough the horse I will always make a profit. Here is an example of what the list will look like:
Name.......Max Buy....Min Sell
Aserai.......900............1200
Steppe......100.............175
So, using that list I wouldn't buy a Steppe horse for more than 100 and would never sell them for less than 175. This way I always know that I am buying cheap and selling for a profit.
How does this sound? It's not perfect at all, but dummy proof. And that's what I'm going for. This process could also be used for every other traded commodity, too.
Last edited: