Spreadsheet to track your silver (or other precious metals)

[juansanto7]

Hi all,

just wondering if somebody in "The Silver forum" has some sort of (blank) spreadsheet that you have created or acquired from somebody that has created it (and want to share this spreadsheet) and are using this to track your silver purchases, date when you bought them, price at the time, spot at the time of purchase, total spend, total weight and total value (linked to spot) of silver to date. I have been recording this in a (paper) notebook but after a few hundred coins I feel I am loosing track. I can update a spreadsheet but creating one from scratch with formulae and links to a website to check for daily spot is way over my skills. Any thoughts about this. Thanks in advance. Regards.

Juan

[Rll1288]

I did make one but it wasn't very good... I am getting my son to build one in MS Access as I wanted a form to input buy and sell items and be able to provide some tracking as to total value etc. I can share when he finishes it 🙂

[Seasider]

 

 

[juansanto7]

1 hour ago, Seasider said:

 

 

Thanks Seasider for that, look interesting. I will try to download it.

Regards. Juan

[juansanto7]

1 hour ago, Rll1288 said:

I did make one but it wasn't very good... I am getting my son to build one in MS Access as I wanted a form to input buy and sell items and be able to provide some tracking as to total value etc. I can share when he finishes it 🙂

Hi RII1288,

thanks. We are waiting patiently.😄😄

Regards. Juan