Hi All,
As some of you know I've been developing/evolving a silver spreadsheet over the last year that automatically calculates variables such as cost over spot, the $Aust:$US, profit and loss etc, and updates prices automatically from the Perth Mint Website...
Since it's inception the silver log has been emailed to people all over the country, and the feedback received has been great. Most however, have asked if a sales component could be included in the next version of the log. Well now that version exists
I have to say that I'm pretty pleased how it's evolved, in the beginning I would have never thought I could construct something like this, so if nothing else I'm happy that I've learned something new! It's changed quite a bit from V2.0...so here are the changes.
Firstly the "purchases" format will be familar to those that have the previous logs:
As before all you have to enter is the price in both $aust and $us, how much you paid with and without postage, how many oz's you brought, the date and from where. Please note when entering the date you must enter it as dd/mm/yy. This is so that when you enter the sold date the sheet will automatically work out how long you held that item for in years, months and days. Entering the date by a means other than said format may cause excel to crack a
After you have entered this information the sheet will work automatically work out the $$ conversion rate and the margin over spot.
The Sales Info
Ok so here is the part thats been added, to get to the sales columns you will have to use the scroll bar at the bottom of the screen.
When you scroll across you will see these columns have been added:
Now by now you will have noticed that there are columns for oz's sold, remaining, profit/loss$, and profit/loss%. The sheet works out the oz's remaining and profit/loss $%. Now the cool part about this is that if you don't sell anything these columns/rows remain blank and don't affect anything. The other cool part is that if you do sell provision has been made for fractional sales (i.e half an oz) AND... the sheet only works out the profit/loss $% on what has been sold.
Now to bring up the real stats and data you will need click on the "Cost Information" sheet at the bottom LH corner of the program:
And you will bring up this: All of this information is calculated automatically
Also on this page:
Notice that there I have a profit/loss$% with and without sales I have left this in so that you can see if your ahead with your sales, or if you should have held! haha cruel I know
And finally on this page which is pretty self explanaitory I hope:
So there you have it, it's a sheet thats 90% automated and provides quite a bit of information. AND IT"S ONLY $750!!!! Bargain!!!....Just kidding...it's still free
PM with your email address if you would like a copy,
Cheers,
HB.
P.S I have a GOLD version as well...it's identical to the silver sheet if anyones interested in that one also.
As some of you know I've been developing/evolving a silver spreadsheet over the last year that automatically calculates variables such as cost over spot, the $Aust:$US, profit and loss etc, and updates prices automatically from the Perth Mint Website...
Since it's inception the silver log has been emailed to people all over the country, and the feedback received has been great. Most however, have asked if a sales component could be included in the next version of the log. Well now that version exists
I have to say that I'm pretty pleased how it's evolved, in the beginning I would have never thought I could construct something like this, so if nothing else I'm happy that I've learned something new! It's changed quite a bit from V2.0...so here are the changes.
Firstly the "purchases" format will be familar to those that have the previous logs:
As before all you have to enter is the price in both $aust and $us, how much you paid with and without postage, how many oz's you brought, the date and from where. Please note when entering the date you must enter it as dd/mm/yy. This is so that when you enter the sold date the sheet will automatically work out how long you held that item for in years, months and days. Entering the date by a means other than said format may cause excel to crack a
After you have entered this information the sheet will work automatically work out the $$ conversion rate and the margin over spot.
The Sales Info
Ok so here is the part thats been added, to get to the sales columns you will have to use the scroll bar at the bottom of the screen.
When you scroll across you will see these columns have been added:
Now by now you will have noticed that there are columns for oz's sold, remaining, profit/loss$, and profit/loss%. The sheet works out the oz's remaining and profit/loss $%. Now the cool part about this is that if you don't sell anything these columns/rows remain blank and don't affect anything. The other cool part is that if you do sell provision has been made for fractional sales (i.e half an oz) AND... the sheet only works out the profit/loss $% on what has been sold.
Now to bring up the real stats and data you will need click on the "Cost Information" sheet at the bottom LH corner of the program:
And you will bring up this: All of this information is calculated automatically
Also on this page:
Notice that there I have a profit/loss$% with and without sales I have left this in so that you can see if your ahead with your sales, or if you should have held! haha cruel I know
And finally on this page which is pretty self explanaitory I hope:
So there you have it, it's a sheet thats 90% automated and provides quite a bit of information. AND IT"S ONLY $750!!!! Bargain!!!....Just kidding...it's still free
PM with your email address if you would like a copy,
Cheers,
HB.
P.S I have a GOLD version as well...it's identical to the silver sheet if anyones interested in that one also.
