[ruforumczspam]

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?

[k1ePRlda]

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

[konanoileaski]

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.

[Hlennisal]

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....

[Zzvukttz]

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.

[Mappaindy]

What gold and silver!

[botagozzz]

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 )

[CefGemYAffews]

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.

[Doctor-CTAC]

My spreadsheet sank with the boat

[ValintinoV]

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:

[wmcelesta]

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)

[ElegeExcest]

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

[exiceJetLip]

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

[Pypeassesty]

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

[Stappipsy]

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-)

[colmedindustry]

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.

[TeftyJokip]

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.

[WrigleyMike]

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.

[hjyAMqqT]

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.

[wrbwrbwrb]

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.