Help calculating spot %

[D4N]

Hi, please can someone assist me in my math!

I am trying to calculate how much I have paid above/below spot as a financial value and as a percentage.

I think all my math is correct to this point but not sure how to get the percentages! And could do with someone having a quick check over what I have done.

I have attached a screen shot of my spreadsheet so far.

Thank you in advance!

 

[Mariner1961]

Calculate the price per ounce you paid.

Subtract spot price per ounce from that. That gives you what you've paid above or below spot.

Divide the answer by Spot price per ounce and then multiply by 100 will give you the percentage over/under spot.

I think...lol

 

[D4N]

Thanks  so I have done this....

Price per oz 891.80

Spot price 954.89 - Price per oz 891.80 = -63.09

-63.09/954.89*100= -6.61

Does this then mean I have paid about 6.6% under spot?

[D4N]

Just to clarify for anyone else wondering, I believe the above is correct, but also, to calculate into this the postage you would need to account for repeated postage costs to make 1oz for example I paid 6.65 postage for 1/20 oz coin, so for 1oz 6.65 x 20 + price per oz and so on as detailed above. I know I am not guaranteed to pay same postage on a future purchase but was interested to know how this cost impacted the %.

[sixgun]

51 minutes ago, D4N said:

Thanks  so I have done this....

Price per oz 891.80

Spot price 954.89 - Price per oz 891.80 = -63.09

-63.09/954.89*100= -6.61

Does this then mean I have paid about 6.6% under spot?

You paid £891.80/oz

Quoted spot price £954.89/oz

So you paid £63.09 under spot

You got a discount of 63.09.

As a percentage of spot price the discount = {discount/spot} x 100 = {63.09/954.89} X 100 = 6.6%

If you want to factor in postage. 

{Price Paid + Postage} x 20 = Equivalent price with postage per ounce

{£44.59 + £6.65} x 20 = £1024.80

The premium is  £69.91 over spot 

As a percentage of spot price the premium = {premium/spot} x 100 = {-69.91/954.89} X 100 = -7.3%

So with the postage you paid 7.3% over spot price when scaled up to a full ounce. Since 1/20oz coins trade at a premium to spot depending on the actual coin you probably still came out ahead. 

 

[D4N]

9 hours ago, sixgun said:

You paid £891.80/oz

Quoted spot price £954.89/oz

So you paid £63.09 under spot

You got a discount of 63.09.

As a percentage of spot price the discount = {discount/spot} x 100 = {63.09/954.89} X 100 = 6.6%

If you want to factor in postage. 

{Price Paid + Postage} x 20 = Equivalent price with postage per ounce

{£44.59 + £6.65} x 20 = £1024.80

The premium is  £69.91 over spot 

As a percentage of spot price the premium = {premium/spot} x 100 = {-69.91/954.89} X 100 = -7.3%

So with the postage you paid 7.3% over spot price when scaled up to a full ounce. Since 1/20oz coins trade at a premium to spot depending on the actual coin you probably still came out ahead. 

 

Thank you very much for clarifying this  And yes I think I did do well considering it's 1/20... I bought a 2000 kangaroo, which I saw goldsiver.be were asking nearly €130 for.

 

 

[Mariner1961]

Good result :-)