Precious Metals Spreadsheets

Discussion in 'General Precious Metals Discussion' started by SeverousSilver, Jul 15, 2016.

Page 1 of 2
  1. SeverousSilver

    SeverousSilver Member

    Joined:
    Mar 14, 2016
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hobart
    So I've spent some spare time over the last few weeks creating a spreadsheet to keep track of my precious metals. I've created it so it automatically updates with the latest spot price. Basically you know exactly how much you paid for everything, how much it's currently worth, your P/L in $ and % and the total weight of your stack.

    Does anyone else here use a spreadsheet inventory?

    If anyone wants a copy PM me your email address and ill send it off
     
    SeverousSilver, Jul 15, 2016
    #1
  2. Kinginthecountinghouse

    Kinginthecountinghouse Member

    Joined:
    Jun 24, 2016
    Messages:
    107
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Western Australia

    I would love a copy.
    Please
    King
     
    Kinginthecountinghouse, Jul 15, 2016
    #2
  3. GoldenEye

    GoldenEye Well-Known Member Silver Stacker

    Joined:
    Dec 31, 2014
    Messages:
    2,089
    Likes Received:
    3,132
    Trophy Points:
    113
    Location:
    Melbourne, Australia
    I have a basic one only, and would love a good one that self updates. I'm not sure if you can email this or put it on the SS site somehow?
     
    GoldenEye, Jul 15, 2016
    #3
  4. SeverousSilver

    SeverousSilver Member

    Joined:
    Mar 14, 2016
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hobart
    I'm happy to email them just PM through your email addresses and ill send them off
    If anyone knows a way to put it up on the SS forum let me know
    Also if you guys think there are any changes you deem appropriate ill be happy to modify
     
    SeverousSilver, Jul 15, 2016
    #4
  5. Junk Silver

    Junk Silver Member Silver Stacker

    Joined:
    Sep 28, 2014
    Messages:
    129
    Likes Received:
    8
    Trophy Points:
    18
    Location:
    Victoria
    Yeah I have one that links through to a spreadsheet with my other investments. I have also included date bought so I could work out annual percantage yield.
     
    Junk Silver, Jul 15, 2016
    #5
  6. Sid

    Sid Member

    Joined:
    May 14, 2015
    Messages:
    100
    Likes Received:
    8
    Trophy Points:
    18
    Location:
    Australia
    Excellent! PM sent
     
    Sid, Jul 15, 2016
    #6
  7. silverfry

    silverfry Member

    Joined:
    Jan 31, 2016
    Messages:
    84
    Likes Received:
    20
    Trophy Points:
    8
    Location:
    W.A -Australia
    Hey SeverousSilver, I'd love a copy. I'll pm you my details. Cheers
     
    silverfry, Jul 15, 2016
    #7
  8. SeverousSilver

    SeverousSilver Member

    Joined:
    Mar 14, 2016
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hobart
    Have sent the first round of spreadsheets out hopefully in fully working order! haha
     
    SeverousSilver, Jul 15, 2016
    #8
  9. silverreef

    silverreef Well-Known Member Silver Stacker

    Joined:
    Nov 17, 2014
    Messages:
    1,243
    Likes Received:
    159
    Trophy Points:
    63
    Location:
    sydney
    sounds really good. would appreciate if you could send me a copy SS
     
    silverreef, Jul 15, 2016
    #9
  10. silvestor

    silvestor Member Silver Stacker

    Joined:
    Jan 15, 2015
    Messages:
    291
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Melbourne
    Got it. Will try it when I get on my PC. Thanks SS
     
    silvestor, Jul 15, 2016
    #10
  11. Sound Money

    Sound Money Member

    Joined:
    Apr 16, 2016
    Messages:
    47
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Australia
    I'm interested, my Excel skills are limited.
    PM sent, cheers.
     
    Sound Money, Jul 16, 2016
    #11
  12. Old Codger

    Old Codger Active Member Silver Stacker

    Joined:
    May 13, 2011
    Messages:
    4,782
    Likes Received:
    5
    Trophy Points:
    38
    I first bought silver in about 2010 or 2011.

    Prices were about $24 for an ASE, I think

    I lost count of average cost by about 2012, and never bothered with it since! Given that I will sell my first ASE about a year after SHTF Day dawns, the past cost is of no interest to me.

    JMO


    OC
     
    Old Codger, Jul 16, 2016
    #12
  13. Topherclaus

    Topherclaus Active Member

    Joined:
    Nov 15, 2015
    Messages:
    618
    Likes Received:
    110
    Trophy Points:
    43
    Location:
    Northern Rivers, NSW
    Usually you can use office stuff on mac, just not the other way around.
     
    Topherclaus, Jul 17, 2016
    #13
  14. Killface

    Killface Well-Known Member Silver Stacker

    Joined:
    Jan 7, 2016
    Messages:
    983
    Likes Received:
    43
    Trophy Points:
    48
    Location:
    Nunya
    I'd love a copy, hopefully it will get me kickstarted re-learning Excel for myself :)

    PM sent.
     
    Killface, Jul 17, 2016
    #14
  15. Bosse68

    Bosse68 Well-Known Member Silver Stacker

    Joined:
    Mar 26, 2014
    Messages:
    795
    Likes Received:
    268
    Trophy Points:
    63
    Location:
    Sweden
    PM sent
     
    Bosse68, Jul 17, 2016
    #15
  16. westminstrel

    westminstrel Member

    Joined:
    Jun 1, 2016
    Messages:
    65
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Australia
    PM sent :)
     
    westminstrel, Jul 17, 2016
    #16
  17. SeverousSilver

    SeverousSilver Member

    Joined:
    Mar 14, 2016
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Hobart
    have sent another round of spreadsheets off this morning
    has anyone had a chance to give it a whirl yet? all working ok?
     
    SeverousSilver, Jul 18, 2016
    #17
  18. raven

    raven Well-Known Member Silver Stacker

    Joined:
    Apr 27, 2014
    Messages:
    1,558
    Likes Received:
    512
    Trophy Points:
    113
    Location:
    Victoria
    Are these spread sheets a goer ?
     
    raven, Aug 16, 2016
    #18
  19. r1lee

    r1lee New Member

    Joined:
    Jul 30, 2016
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Canada
    would love a copy :)

    right now, i keep every single thing in my head.
    For gold, i know what i paid for my purchases.
    For Silver, i know the average of my stack and which one i would need to get rid of when the time is right.
     
    r1lee, Aug 16, 2016
    #19
  20. mmissinglink

    mmissinglink Active Member

    Joined:
    Sep 30, 2012
    Messages:
    6,009
    Likes Received:
    10
    Trophy Points:
    38
    Location:
    Everywhere...simultaneously


    I would have guessed the Old Codger bought his first silver in 1910, not 2010! :D



    .
     
    mmissinglink, Aug 16, 2016
    #20
Page 1 of 2

Share This Page