| Author |
 Replies: 11 / Views: 3,043 |
|
|
Pillar of the Community
United States
2120 Posts |
Made it for me to track my own stuff. I got rather tired of having a physical ledger, and wanted something that I could use to provide me detailed information, and act as a historical record for me. I figured I would share, took me about 3 hours to make, so if someone finds it useful, then I'm Happy. Only real stipulation is, you need to use Google docs. Some of the logic and formulas are specific to Google Docs. I'm sure if you're savvy enough you could translate the logic to Excel / OOO. You can view it without an account, and if you want you can save a copy for yourself. You must be logged into a Google account though. Enjoy! With Dummy Data - https://docs.google.com/spreadsheet...0MF9fX3pENVEClean (no Data) - https://docs.google.com/spreadsheet...MaFBPTXIwb0E |
|
|
|
Pillar of the Community
United States
2424 Posts |
i like!
any way to have the current spot values automatically update?
|
|
Pillar of the Community
 United States
2120 Posts |
They do. They are imported from coininfo.com. Its the same imported table as what is on their front page, right side.
On the data tab, find the table, and look at the formula for the cell "Metal"
Edited by Namachieli
05/20/2012 11:51 am
|
|
Pillar of the Community
United States
2120 Posts |
Made an update. Cleaned up a couple things, Added gain/loss info for current holdings and sales.
v0.7
|
|
Pillar of the Community
United States
2120 Posts |
Hmmm, doesn't seem to be much interest.
|
|
Bedrock of the Community
 United States
12845 Posts |
I like it. Spreadsheets for me are personal creations; part of the fun of collecting -- you tailor your tracker/spreadsheet to your needs. As such I like to create my own, but I think yours is very serviceable. I do like the detail you include such as premiums, spot prices, etc. How about tax and shipping, credit card fees, etc. where applicable? Do you factor that into the premium? How about purchase method/location (APMEX, ebay, local dealer, CraigsList, etc)? I like to keep track of where I bought my booty. And how would you handle trades/gifts? I guess you could/would zero out purchase price & premium or sold price & premium. |
|
Pillar of the Community
United States
2120 Posts |
well you proved the point of for myself. I dont buy online, so I didnt even think about it.
thanks for the feedback!
|
|
Pillar of the Community
United States
863 Posts |
wow that is pretty cool. I think I'm gonna have to try it
|
|
Pillar of the Community
United States
2120 Posts |
Quote:
any way to have the current spot values automatically update? Yes, literally just added it. Kind of a work around, but I couldn't find a better way to do it. |
|
Moderator
 United States
189311 Posts |
Per request, links in original topic post should always point to latest version.
|
|
Pillar of the Community
United States
2120 Posts |
Thanks!
BTW 0.7.2 available with Auto updating Spot prices.
|
|
Pillar of the Community
United States
2120 Posts |
0.7.3
Added a Current S:G ratio indicator
Added "What If?" field that reflects across the entire summary page.
Added "location" field on the inventory pages to track if an item resides in separate physical locations.
Considering what a pain this is to "update" as I make changes, I'm considering rewriting it as a desktop or web app, that points to some external data source. Either a spreadsheet or database.
If you want to update from an older version, all you need to do is add the location column to your old version. Add the required number of rows to the new version. Copy and past the inventory lists to the appropriate tabs. Make sure the rows you add are above the hidden row. This is to make sure the formatting, data ranges, etc stay intact for subsequent rows.
|
| |
Replies: 11 / Views: 3,043 |
|
Posted 05/20/2012 11:50 am
