Скачать или смотреть How To Track Your Stack: Use Google Sheets to always know the amount & value of your precious metals

In this video, I show precious metals stackers how to leverage the power and convenience of Google Sheets to create and manage an up-to-the-minute inventory to track the amount - as well as a running value - of their precious metals stack. I demonstrate how to import LIVE silver and gold spot price data from the commodities page of a leading business website. I also explain how to stackers can use simple formulas to let the spreadsheet do all the work. Every time a stacker refreshes their Google sheet, the current precious metals values will be refreshed as well.

This is best viewed on a personal computer and intended to flow like a "how to" tutorial. I highly recommend you "do as I do" right along with me. Feel free to pause the video as needed, especially if I go too fast. In addition, if you would prefer to just download the sheet I made and play with it, check out either of the links below. One link is to the sheet with sample data, and the second one is blank.

Words I use in this video are: spreadsheet; import; data; cell; Google Sheets; Google Drive; silver eagle; 90% halves, quarters, and dimes; Britanias; gold ealges; rounds; and coins.

Here's a copy of the Inventory & Value Sheet, similar to the one I created in the video:
https://docs.google.com/spreadsheets/...

Here's a copy of a BLANK Inventory & Value Sheet:
https://docs.google.com/spreadsheets/...

#silver
#gold
#preciousmetals
#silverstacking

For another good video about using spreadsheets to track your precious metals stack, check out @genzstacker2862 and watch his video.

TIP: If viewing this video on a mobile device, you can use the "pinch/zoom" feature to see parts of my computer screen in more of a "close up" mode.