Custom Price Data: Calculating Coin Value from Gold/Silver Prices

English Import/export
1

Hello,

I would like to know if there is a way to apply custom calculations to historical and real-time price data in Portfolio Performance. Specifically, I want to derive the value of a specific commodity—gold and silver coins—based on the spot price of gold and silver.

For example, I track gold and silver prices per ounce from various sources. However, instead of managing raw metal weights, I prefer to track the value per coin. A 10 Cóndores Chilean gold coin contains 18.3 grams of 24k gold, but the market price is quoted per troy ounce (31.1g). Ideally, I’d like to dynamically calculate the per-coin value by converting the ounce price accordingly.

I know this can be achieved using an external solution, such as a spreadsheet or an automation tool, but I was wondering if Portfolio Performance has a built-in way to handle such calculations directly.

Thanks in advance for any guidance!

2

Nope not in this way.

More information can be found here: Retrieving gold and other precious metals prices - Portfolio Performance Manual

1 Like
3

Okay, I solved the issue thanks to the URL you provided. I had missed the ‘Factor for Quotes’ field. The JSON file I was receiving contained prices per kilogram of gold. By entering 0.0183 (the coin’s pure gold weight 18,3 grams, divided by 1000) in that field, I was able to get the correct value of the coin. I knew there had to be some easy way. Thanks!