Anyone use excel to track coins?

USMC_6115

Does it automatically total up values as you enter coins?

What else can it do?

CarlWohlforth

Excel is a spreadsheet program. I use it for my coins. You can set it up to keep the total of a column of numbers. It is pretty basic as a database but it does enough for me.

ARCO

I use excel and it can track pretty much anything you want, if know how to program it. My excel has a list of the coins purchased, date of purchase, grade, seller, date of sell (when I sell them) and sell price. Mine is simple, because I am too lazy to get real complex on it. I just put the data in a row and look at it. If I want to add up the totals I just highlight the row and hit the icon that adds them up. Nothing fancy but it works.

Here at work we have complex excel spread sheets that track our payroll data, taxes, loans made and it all ties into some fancy presentation page. somebody much smarter than myself set that up.

Tyler

vega1

I use excel mostly because I'm too cheap to go out and buy a coin-specific program. I keep track of my certified type set and can track purchase price, current value, link to images of the coins, comments, etc. Works great for me!

RonMan

Excel works great for what I want.

It does automatically total up values but you have to tell it initially what to total up using a formula...easy to do. From there, when you add more entry's, the formula is automatically adjusted to include the new entry.

Ron

19Lyds

Yep, I use Excel.

I set up different worksheets for different types of coin. Have one for years sets as well along with current prices vs what I paid! Its pretty cool but like most anything, useless unless you keep it up-to-date and as simple as you need.

CardsFan

I use it to track everything - purchases, sells, grades and fees, crossovers etc. I only have a few formulas in my sheets mainly for totalling coin prices and fees and running totals. I also use a filter alot to view just ceritified or raw coins.

WaterSport

.I use it to both keep inventory, and track purchases and arrivals, it keep totals for what I have invested and what the PCGS price guide claims in value. In fact, PCGS has upgraded the Lincoln prices so I need to update my spread sheet tomorrow.

WS

carl

I tried to make a list with it but found I was spending to much time making a list of what I have. I'm not interested in selling so the prices of coins arn't important except when I want to buy one. I have made list of what I needed and/or want for coins and which ones could be improved. But the list also got to long. I just rely on memory and since I'm getting old and my memory is poor, I really don't know what I have or want so probably one of these days I'll go back to use that program since I have it on my computer. I can't really see buying a program that does the same thing.

Hedger

Yup, works for me just fine.

RYK

I also use Excel, primarily as a database.

Woodwind

I thought about creating a coin database by using Microsoft Access. After taking a course in it, and since I'm only interested in buying coins at this point, I'd have little use for an Access database.

On the other hand, Excel has many features which I think would work just fine. To answer the original question, it will recalculate totals as values are entered or removed. To name a few other features, workbooks can accomodate several sheets and totals can be calculated over several sheets. Hyperlinks can be used so that clicking on a cell can either take you to an image of that particular coin stored on the same computer, a particular website (like a favorite dealer's site) or perhaps to an auction result page, depending on if the auction keeps the results page up for viewing.

Cameonut

I use it to track all my coin purchases. Dates, prices, cert #'s etc. Easy to sort and update. A copy is in my safety deposit box.

Also use it to track populations and market prices.

PreTurb

I use Excel to track every known thing about Flowing Hair half dollars. I've put thousands of hours into it, and it couldn't have been done without with the help of database software!

xbob

I was planning on making an Excel spreadsheet soon to track my collection. CoinValues online has some web application that tracks your portfolio that is free as long as you subscibe. I have yet to even look at it. Has anybody tried their system?

orie

excel