Dirtbikepilot
Active Member
Looks like a great program. Just starting out with a collection and didn't even think about keeping records like this. Makes sense, obviously
. PM sent
. PM sent
Silver Spreadsheet Available Here!
- Thread starter haveblue
- Start date
silver dragon
New Member
Thanks for the spread sheet haveblue. I have been playing around with it as much as I can to enable me to add my current stuff and it is all going ok. A few little hiccups but it does the job I wanted so well done.
Being able to add rows would be helpful. Ha Ha now I'm just planning on needing lots and lots of rows as my stack grows
Being able to add rows would be helpful. Ha Ha now I'm just planning on needing lots and lots of rows as my stack grows
Dirtbikepilot
Active Member
Great stuff Haveblue, thanks. You obviously put a lot of time and effort into this and should be appropriately congratulated. Silver log 1.1 did not appear to update, spot prices stayed at $43 (just for info). Could well be my computer or me. Apart from that it works perfectly well. Silver log is spot on. Gives me all the info I feel I would need at this stage. Not hard to put the spot price in yourself, takes about 2 seconds. It is people like you offering something you spent so much time on to others for their benifit that makes this such a great site.
Great work and thanks heaps. Never could have done this myself.
Great work and thanks heaps. Never could have done this myself.
Dirtbikepilot said:
No problem, people help me out everyday on this site they just don't know it. I read and compare posts both in the silver and gold section to improve my own knowledge, so me sharing the spreadsheet is my way trying to help out I guess, cheers anyhow. You'll have to let me know if version 1.1 doesn't update the prices automatically, the master copy still updates so I don't know why your copy isn't.
Hi all,
I have just finished work on Silver Log 2.0. The main differences from version 1.0 is that fact that I have added 1000 rows, which should hopefully prevent anyone from running out of space to record entries. Also the headings at the top of the 1st sheet remain fixed so that when you scroll down those 1000 rows you don't forget what you're looking at.
On the 2nd sheet I have added some new boxes as outlined below:
You can find the 2nd sheet and your data summary by clicking on the 2nd tab at the bottom left hand corner of the screen
Also all the headings are editable such as changing the name from "Your Silver Log" to "Haveblue's Silver Log" etc
As with the first versions all the formulas remained locked so you can't edit them by mistake, and the formulas work out all of the information on the 2nd sheet automatically for you. The sheet also automatically updates the current price of silver from the Perth Mint website. Pretty much all you have to do is enter the spot price in $Aust and $US, how many oz's you brought, from where and when and that's it. The sheet will work out the rest for you.
Cheers
HB.
I have just finished work on Silver Log 2.0. The main differences from version 1.0 is that fact that I have added 1000 rows, which should hopefully prevent anyone from running out of space to record entries. Also the headings at the top of the 1st sheet remain fixed so that when you scroll down those 1000 rows you don't forget what you're looking at.
On the 2nd sheet I have added some new boxes as outlined below:
You can find the 2nd sheet and your data summary by clicking on the 2nd tab at the bottom left hand corner of the screen
Also all the headings are editable such as changing the name from "Your Silver Log" to "Haveblue's Silver Log" etc
As with the first versions all the formulas remained locked so you can't edit them by mistake, and the formulas work out all of the information on the 2nd sheet automatically for you. The sheet also automatically updates the current price of silver from the Perth Mint website. Pretty much all you have to do is enter the spot price in $Aust and $US, how many oz's you brought, from where and when and that's it. The sheet will work out the rest for you.
Cheers
HB.
zygote said:I have a sheet in my spreadsheet to fetch the current spot price from kitco on demand - have a look here if you want to add it to your sheet. Very nicely laid out, yours is.
http://cl.ly/6Bev
im looking for something like this for the live gold prices. any ideas?
LTEK4NZ said:zygote said:I have a sheet in my spreadsheet to fetch the current spot price from kitco on demand - have a look here if you want to add it to your sheet. Very nicely laid out, yours is.
http://cl.ly/6Bev
im looking for something like this for the live gold prices. any ideas?
I've got a Gold spreadsheet that automatically updates the price if thats what you looking for,
Cheers,
HB