Hey everyone!
I have made a file that automatically creates a valuation based on the market cap and the resources of every stock in the GDX, GDXJ, SIL and SILJ. It's free for everyone. I have made one for my personal portfolio as well, that one is only for paying members (coming soon). Feel free to use this one to take a quick look at where we are in the valuations of these gold and silver mines!
I made it in Numbers for Mac, hopefully it works for Excel as well... we'll see...
https://drive.google.com/file/d/1eCRaPM6gJ0AfnqHYvlJI4I8DRN-3GKmY/view?usp=drive_link
Let me know what you think.
Enjoy!
Edit: I have heard the spreadsheets doens't work well in Excel, apparently you can convert it with this program https://cloudconvert.com/numbers-converter. I will be working on an Excel version in the coming days, stay tuned for that!