Michael Meade

Silver Stack Manger

—

by

Michael Meade
in , , , ,

The Silver manager can be found on GitHub.

The Origin Story.

Please check this article named “Silver Stacking Terminology and information“

I have a spread sheet which I use to manage my Silver stack and also my cash balances. The spreadsheet is nice to way to log my stack. The spreadsheet is managed in these three categories:

  • Bullion
  • Junk
  • Bars
  • Cash

I created a Silver Stack Manager in Ruby, it uses SQLite3 database to store the information about the items. With this I have two ways to view my stack, the spreadsheet and this manager. The Stack Manager is currently set up with tables of the three categories mentioned earlier. With this manager I can perform queries that can easily show information about my stack. The GitHub project does not include the Database as that would be bad operational security and could make me a target.

Anyways, with this program I can also easily add, remove or change own status if I choose to ever sell some of the bullion.

The menu of the program.

This is the menu of the program, there are two ways of accessing this information. The first way is via the program that you run on your computer. The second method is accessing the website. I would recommend to only run this locally. You do not want all you stack information to be public on the internet.

Select Total

total oz table, it has the price in usd on the right

Remember that this is not my real holdings of silver. I entered random information into the database to use as test data.

The “$1560.31” data uses DuckDuckGo API to convert the silver amount into USD. The middle row is the amount of silver in oz. The rows on the right show the price in USD.

Show Average Price

average price of junk, bullion and junk

Notice the red text above the table, this will rescue any errors that occur because it cant divide the number by 0. Which is shown that the “Bullion Price AVG” is non existing.

Select Cash

Shows the selections of cash by the amount and person . Of course this is all fake data.

displaying the cash rows

Sold Total

sold total table

The sold total is used to calculate how much a piece of silver was sold for. With the fake data inside the table, it shows that I have made a total of $330 dollars from selling my silver.

Update Sold Value

changing the status of a certain row id.

Before running this command, you will need to run the “select table” option to get the certain row id that you want to label as sold. After entering the row ID and the amount that the item was sold for, the status column of the row will be changed from “own” to “sold” and the ‘sold_amount’ column will now have the value of 100.

The Web Manager

By default the web manager runs on port 4567 and uses Sinatra. The first table on the site shows the current stats of my silver stacking. Please note that these are not real numbers. This site should be ran locally not on the internet. I personally hosted it on my server where I can VPN into my local network and access this site.

Please do not host this site on the internet, if you are so inclined on hosting it online, please consider modifying the code to have a login screen or make the site password protected. This might become a feature at a later time. You might need to install a couple of other Ruby gems for the website to work.

The silver stats landing page. showing four tabs of Bar silver, Junk Silver, bullion Silver and Cryptocurrency.

Below the Silver stats table are the different tabs where different tables are shown based on the type of silver. There are four different tabs, Bar silver, Junk silver, Bullion silver and finally cryptocurrency.

Select Junk Silver Web

The junk silver list in a nice little table

Franklin Half Dollars Stats

The Franklin Half Dollar table is under the Junk tab which is because Franklin Halves are considered Junk silver. The third row shows the amount of silver worth in USD.

Shows the amount of franklin half dollars and the amount of silver it contains

Silver Bar Section

Select Methods of Purchases

The image below shows a table where the different methods of purchases are show in a nice HTML table that includes the count.

The Bar silver page where it shows all the different stats.

In the next table shows the total shipping total. Some of data is not accurate as I was not recording the shipping total when I first began stacking silver.

The next table is the average price table which takes all the data in the price column and averages the data.

The last table shows the bars sold total data which shows the total of what I have sold. Once again, please note that all the data shown on this page is fake data that I used to test the programs and website.

Average Spot Price

Spot price is the current price of a oz of silver. This code will take all the spot prices and do some math to find the average, which it will display in a nice HTML table. Please not hat not every entry in my databases have spot price. In the beginning I did not record the spot price. Also not every site tells you the spot price when you purchase the silver.

Cryptocurrency

Note: these are fake amounts not my real holdings of Cryptocurrency.

shows the cryptocurrency tab which shows a nice table to display the data

Once again, the information in the table is a fake amounts that I am using with a test database. The amount of crypto is stored in a JSON file named status.json. In the future I will add features to the site where you cand add or subtract amounts for the cryptocurrencies.

The program will take the data from the JSON file and use one of my other projects named CryptoPriceFinder and use the DuckDuckGo API to get what the certain cryptocurrency is worth in USD.

Entering Junk

The junk silver table shows the silver contents of different junk silver contents

The first thing on the enter junk page shows a table with the silver content from a bunch of different types of junk silver.

The forms where the user enter information that will be added to the database.

The enter page where you can choose to enter Bar, Junk and Bullion. The Method from has a drop down menu where you can choose popular methods of purchase. If you have a new method of purchase you can easily type in the method. By default the Status is set to own.

The enter silver tab. The blue button will allow you to enter silver, green will allow you to change status, and the red button will allow you to delete a certain row

The “change status” button will allow the user to enter the ID of the row that they want to change the status to. If the current status is own it will automatically change it to sold. There is also a form where you have to enter the sold_price.

The status page, the user enters the row id and give the sold price

The image above shows the form, after pressing submit the page will redirect to the main page.

Shows graphs that displays the different amounts of types of silver

The graph tab will show a pie chart of the different types of silver you own. Below that is another pie graph that shows the different cryptocurrencies that you own. Every time you visit the graph tab a new pie chart will be generated. They are stored in the “public” folder.