Jump to content
  • The above Banner is a Sponsored Banner.

    Upgrade to Premium Membership to remove this Banner & All Google Ads. For full list of Premium Member benefits Click HERE.

  • Join The Silver Forum

    The Silver Forum is one of the largest and best loved silver and gold precious metals forums in the world, established since 2014. Join today for FREE! Browse the sponsor's topics (hidden to guests) for special deals and offers, check out the bargains in the members trade section and join in with our community reacting and commenting on topic posts. If you have any questions whatsoever about precious metals collecting and investing please join and start a topic and we will be here to help with our knowledge :) happy stacking/collecting. 21,000+ forum members and 1 million+ forum posts. For the latest up to date stats please see the stats in the right sidebar when browsing from desktop. Sign up for FREE to view the forum with reduced ads. 

Current Silver Price


Diogo

Recommended Posts

I have a Google sheet which i use to track spot prices from bullion by post against my stack.

For the spot price i use the formula =Dollar((Index(ImportHTML("https://www.bullionbypost.co.uk/silver-price/live-silver-price/","table",1),3,2))) to pull the current spot price through so i can "Live value" my stack (by wieght) automatically just by looking at the spreadsheet.

Edit: This also helps me keep track of how much i have paid for each piece of silver and works out my "Average cost per Oz" and shows Profit/Loss based on the live spot price.

If you're interested i could send you a template to set something similar up for yourself.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Cookies & terms of service

We have placed cookies on your device to help make this website better. By continuing to use this site you consent to the use of cookies and to our Privacy Policy & Terms of Use