How To Track Your Stack: Use Google Sheets to always know the amount & value of your precious metals
Автор: Metal Scholar
Загружено: 2023-06-18
Просмотров: 5434
Описание:
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.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: