You are totally correct, my main reason for saying the “opposite” was so people will know to be cautious when presented with physical coins and they tend to be a scam. But yeah, they can be technically physical as you mentioned.
Hi, you can use the “ GOOGLEFINANCE(“CURRENCY:USDEUR”)” function. I’ve made an example for you: check out the EUR sheet tab in the lower left side.
Note: take into consideration that both google finance and coinmarket cap will make the prices not as precise as they might really be.
I hope that helps.