The value of Coins & Currency is more of Demand Vs Supply Situation.
The value of Coins is not just due to it being old, but also
- due to how many are available in the market Vs how many people want to buy that.
- The condition of the coin
- The perceived historical importance
- The metal used. Older coins were based on Gold/Silver
- The design, how pleasing it looks
For example the 1876 US Nickel around 300,000 were minted. The 1916 US Nickel around 400,000 were minted. However the 1916 Nickel is at more premium than the 1876. This is because there are many collectors who want to complete the collection post 1900. They can never complete the 1800 to 1900 collection as other year coins are not available.
It is hard to tell which currency will catch craze amongst collectors. That's what will drive the prize. For example if 50 years from now, Zimbabwe becomes a leading developed country, there will be craze / nostalgia to collect things of past.
Certain coins like the American Double Eagle are a craze because the design is very good, its made of Gold, has history to it. It's sold for USD 7-8 Million, Or the USD 1 Dollar uncut sheets [16 notes in a sheet], the sheet goes for around 1-2 Million USD
As an individual if you have some coins / currencies keep them more as a hobby than as something that would return value.
Investments in Collectibles and Art is an emerging form of investment and needs to be looked at separately and shouldn't be mixed with a simple hobby.