If as early as I. 1/2 of 16. century experienced such volatile prices of spices, then it's obvious that the spices were not as valuable as someone wants to make them out to be. Which I think is an indicator for less number of different spice goods, with low base price; but the speed and the range of it's market price spikes and drops should be alot!
I think that's the wrong reading here. Spices were the most valuable product in this timeperiod after precious metals. Pepper and the rarer spices of saffron, cloves, nutmeg, mace, vanilla, ginger and cinnamon were all region defining goods throughout the game's period and the lifeblood of numerous polities in this period. The prices do rise and fall throughout this timeperiod, but the only real permanent drops come toward the late 17th and early eighteenth centuries as monopolies started to be broken and European tastes started to vary in such a way that spices weren't the prestige goods they once were. Even after that, the trade remains profitable, though not the goldmine it once was.
Many spices in fact remained as expensive as ever throughout the time period and some even grew even into the 18th century - mainly those that countries had retained monopolies on. Take a look at graph 5 in
this paper, for a good view of it, you'll notice no huge drop in prices.
I think it would be best having 2 spices goods: Spices and Rare Spices.
I think that simplifies things too much. There's a good reason we've broken these spices into multiple categories, as you'd be tying most of the market fluctuations in prices together and removing nuance in regional play. You will notice that in my last posted table, this is scenario 7 or 8, the ones I mention as being only barely better than a single spice good. It removes the interplay of having a piquant good, a mid-range aromatic good, and the incredibly priced fine spices good - and the market fluctuations that can affect each separately.
Pepper was one of the most profitable spices the first two-and-a-half centuries of this game's period, and the trade never stopped being lucrative, it just stopped being as lucrative. It had a marked effect on the nations which traded in it, and the structures built to facilitate the trade even helped transition states from feudal to early-modern states (
Source). The goods should be given the room to show that. Cinnamon, ginger and the like were still incredibly expensive until that 17th/18th century decline in the trade, and the fine spices remained expensive beyond that, while some goods like vanilla traced their own route, becoming more and more expensive as taste for it increased. Putting it in the rare spices is ahistorical for more than half the game's runtime and putting it in common spices is ahistorical for the other half.
And much less 'valuable' sugar was always much more valuable because it's easy to mass produces, secondly it has much more uses then any of the spices; and thirdly there is always a demand for more sugar.
There was not always such a large demand for sugar. Sugar was incredibly expensive until the new-world colonies started producing it, and was usually only seen by the richest members of society. Having sugar at social events was as much a show of wealth as having cloves or ginger was at the time. It's only the increased production in the new world and Africa that brought it increasingly toward being a good that more and more people could afford in Europe.
And Rare Spices are rare and expansive because it's highly difficult or almost impossible to cultivate them except where they are naturally found.
The rest are easy to cultivate and adopt to new places, thus why they are cheap and common.
That's not really true. Saffron is and was expensive because the harvesting process is incredibly taxing and produces only minute amounts of actual Saffron thread for each plant. Cloning and growing bulbs is not all that difficult, plucking individual threads of saffron spice from the flower is. Nutmeg and mace were only as expensive as they were because they were confined to a single, tiny set of islands and easily monopolized. The moment the British stole trees and replanted them across their colonial holdings, the price dropped.
Cloves also aren't all that difficult to replant, as seen in Zanzibar and Madagascar. Cloves have become far more accessible as time has gone on, and aren't particularly expensive these days. The reason for their expense was, once more, regional isolation and ease of monopolizing. The moment they were grown elsewhere, cloves became far less valuable. The only expense they retain is from having to be manually harvested.
Vanilla, a final study, only grew in expense because it could not be made to produce outside of its native range until the 1800s. It only grew in expense after that because it has to be manually pollinated outside of that range, and the original Central American crop is becoming sterile - amounting to natural vanilla just not keeping up with demand as it became the most in-demand flavour on Earth.
You might be noticing a trend in what makes spices expensive - manual labor and monopoly.
If you read that article you will learn that's its covering mid 16. century and that's the time of Dutch-Portuguese wars, where they lost the primacy on spice trade. Secondly it goes in deep about how Venetian via Alexandria (re)captured a significant market share of European spice trade.
A few small mistakes here. The Dutch-Portuguese wars (begun in 1598) are half a century after the timeframe of those prices (1538-1544). In addition, the Venetian trade was not recapturing their market share, they were holding it, but losing that hold at the time. Their efforts to retain their previous monopoly on the spice trade was being slowly frustrated by the Portuguese attempts to wrest it into their own hands. The Venetian trade was at its peak during the period of Mamluke control of Alexandria. (
Source,
Another Source) and significantly declined after the Ottoman occupation of Egypt. Unlike the Mamlukes, the Ottoman sultans seemed to have little interest for their early history in controlling the spice trade. This brought a decline in the amount of spice available in Europe and prompted the European powers, particularly Portugal to seek out ways of entering the trade. The article I'd linked mentions that the period it is looking at is after the French get a capitulation from the Ottomans allowing for the spice trade from Alexandira to Marsailles.
The Mamlukes had historically had more of a mercantilist, hands-on approach to their control, largely because the Portuguese control of the Red sea was at a high point. It was only once the Ottomans could contest that control that they really entered the spice market and allowed the Portuguese monopoly to be challenged from the East. (
Source) The most interesting thing is that some portion of what the Ottomans were trading from this point on was sold to them by none other than unsanctioned Portuguese traders.
It helps that the Portuguese are famous for their mismanagement of the trade and failure to capitalise on their monopoly. The Dutch still found the spice trade lucrative when they made their move to enter it, and were somewhat more efficient in managing it, bringing profits up and gradually pushing Portugal out of their monopoly over some spices such as pepper, while largely supplanting it for nutmeg and cloves. (
Source)