Whats a great camera for photographing finds

I'm looking at buying a new compact camera and I'd like one that takes really good, clear close up pics (macro) for my detector finds - something I can ...

from Google Alert - metal detecting great finds http://ift.tt/1QvwwUx