Stack Tracker

[Orpster]

Was editing a blank version of the spread sheet I use to track my stack for another member and thought it would be useful to share to see if anyone else could use it
I also thought other members may have something similar or better others could make use of.

Inventory Blank.xlsx

This will allow you to add your coins in, enter price paid and the premium you believe they should be worth (currently all set to 5%).  If you then update spot it will work out their current value and your profit/loss on current prices.  You can add in new rows and the calculations will pick them up, but always add to the middle of a section not the first or last row.  If you do not have any of a particular type you can just delete the rows from both the top and the body of the spreadsheet and it should keep on working.  Its not super complex and the formula's are pretty easy to follow if you wanted to add in any different types, but I am always happy to help out a fellow member if they are not very IT literate or cannot follow what I have done.  No guarantee I have got everything 100% but I am happy to update and re-attach to this thread should anyone find a bug, or if others with more IT skills than I can make improvements even better

@Earthmetal as promised 

[Earthmetal]

Top man thank you! I use a Windows Excel sheet every day but it's been set up by my company not me. I use a Mac at home.

[Wilburwombat]

If using GoogleSheets you can use the following function to live track the spot price for gold:

Quote

=Index(ImportHTML("https://www.bullionbypost.co.uk","table",1),2,2)

For silver, change the first '2' to a 3. For platinum change that 2 for a 4.

These prices will be in GBP. For USD, change the last '2' to a 3, for Euro swap that 2 for a 4.

It should work in newer versions of Excel too (older ones didn't support live stock prices), but I can't guarantee it.

Edited December 16, 2023 by Wilburwombat
Added more info.

[ozzie456]

15 hours ago, Orpster said:

You can add in new rows and the calculations will pick them up, but always add to the middle of a section not the first or last row.

If you're prepared to compromise on visual style, then include a blank row between each section, and set up your SUM(...) formulae to include that blank line. Then you can safely insert new rows at the top/bottom of each group, not just in the middle, and the formulae will update correctly.

But I don't know how to make your fancy thick/thin borders work if you do this - I never bother with borders because I have so many blank lines everywhere that separate things out 🙂