Software to keep track of gold and silver I hold

[Celtic Rogue]

I am looking for a program that will allow me to keep track of my PM's

I want to plug in what I have and be able to open the program and see the net worth. Is there such a program?

[Twisted Titan]

Dont know but the IRS goons would love to have a copy so they can easily tabulate " your fair share"

Get a old ledger and right the debits and credits accordingly

[madfranks]

I made an excel spreadsheet to track the value of my junk silver collection. Put in how many of each coin you have, enter the spot value and it gives you the total troy ounces as well as FRN value. If you want it, PM me and I'll email it to you.

[AndreaGail]

Dont know but the IRS goons would love to have a copy so they can easily tabulate " your fair share"

Get a old ledger and right the debits and credits accordingly

I use the pen and paper method as well....

[Twisted Titan]

I made an excel spreadsheet to track the value of my junk silver collection. Put in how many of each coin you have, enter the spot value and it gives you the total troy ounces as well as FRN value. If you want it, PM me and I'll email it to you.

I remember that format help validate you were a victim of crime when you stuff got snagged.....

Not that the keystone cop did anything to solve the crime.

[po boy]

What gold and silver!

[Heimdhal]

Make an xcel spread, thats what I did.

I can update with type of silver (bar, round, SAE, generic, etc) put in how mnay ounces and it tells me how many total ounces I have and their value (if you put it in the current spot price and you can put in a sale price for actual value). It also gives me my dollar average over all ounces (how much I paid total over how many ouces I have total).

Easy enough to do if you know excel (which I dont, but my wife does ;) )

[Ponce]

I simply multiply the thou of silver that I have by today's price and and take away the $5.16 per that I paid and that's it......If you need a software it only means that you have to little of it and you want to make it grow by magic.

[StreetsOfGold]

My spreadsheet sank with the boat

[Shami-Amourae]

Yeah I made my own Excel Spreadsheet myself. That's the best way to do it. I like to record a lot of things, like I lay out all my purchases/prices and then calculate the current price by the weight multiplied by the spot price. I then can keep tabs on my profits/losses.

This is an example of what mine looks like:

[Heimdhal]

I simply multiply the thou of silver that I have by today's price and and take away the $5.16 per that I paid and that's it......If you need a software it only means that you have to little of it and you want to make it grow by magic.



.................................................. ...................................sigh........... ........................................ (roll eyes smiley insert here)

[Ponce]

LOL, my philosofy is that when you try to make something simple into something hard then there is something wrong somewhere.

:) <-------- and here is your smiley.

[vacuum]

So after the subtotal, are these spreadsheets showing massive losses due to boating accidents?

[Heimdhal]

So after the subtotal, are these spreadsheets showing massive losses due to boating accidents?

mine has a boating accident formula factored in already. Basicaly, you take the total of all expenditures to date, minus the sub total of the mean average spot price over the last 6 months and divide by zero.

This gives you the "boating accident" figure.


:P

[Celtic Rogue]

OK Thanks for all of your replies. I guess I will just still do the math the old fashion way. I dont have a clue anything about the use and set up of a spreadsheet. Thanks again... still recovering from T day! 8-)

[Heimdhal]

OK Thanks for all of your replies. I guess I will just still do the math the old fashion way. I dont have a clue anything about the use and set up of a spreadsheet. Thanks again... still recovering from T day! 8-)

PM me your email, I can email you over a copy of the spread I use with the forumlas already put in if you'd like. Then you just have to plug in the numers.

[Ponce]

You guys are nuts.......write down what ever you paid per oz and add it up........today's price multiply by the number of oz that you have and then subtract what you paid for your silver and the left over is your profit..................anything else is just Midas playing with his gold.

[Heimdhal]

You guys are nuts.......write down what ever you paid per oz and add it up........today's price multiply by the number of oz that you have and then subtract what you paid for your silver and the left over is your profit..................anything else is just Midas playing with his gold.

some people invest, some people collect, some people trade and play the numismatics game as well. Its not so simple to just write it down for some people. Silver Eagles and Prospectors pull premiums in the market, so if you decide to sell, you might want to know how much of either you have for maximum profit, not just the amount of silver or gold on hand.

[Ponce]

OK and thanks........we are riding a different kind of a train.....my train will go from A to Z without stopping.....the other "investors" will make many stops.......I'd rather taking a nap till I reach my final distination.

[k-os]

I use an excel spreadsheet to document my profit/loss (read: profit). I also keep track of my preps in an excel spreadsheet to know what I have or don't have.

[zap]

I keep it all in my mind, its just like a steel trap. lol you'd be amazed the memory and ram I have ;)

I like to keep round numbers 5000,10000 those numbers are easy to keep in your mind.

[k-os]

I keep it all in my mind, its just like a steel trap. lol you'd be amazed the memory and ram I have ;)

I like to keep round numbers 5000,10000 those numbers are easy to keep in your mind.

See, as you may know, memory is not one of my strong suits. If I don't have something written down somewhere, I may not remember it at all. That can be good, and that can be bad. :)

[zap]

LOL K_os, I do Have a piece of paper somewhere, but I have memorized the average of both and the amounts of both. If I just knew where to find the product?

HAHHA

[Neuro]

I can barely remember where it all sunk... It may have been in the Mediterranean somewhere, or was it the North Sea? Or did it fall into a mineshaft in the Ural's?...

There now I don't remember at all...

[Ponce]

Well, to tell you the truth I really don't know how much silver I have, or nickels or loose change or ammo.......and as long as I don't need them I really don't care..............what's more, I hope to die at 132 without ever knowing.

[mick silver]

if i had not sold it all i would also write it down .............. oh well