BEHOLD!!!! Silver Log 3.0 !!!

Discussion in 'Silver' started by haveblue, Jun 5, 2012.

  1. petey

    petey Active Member Silver Stacker

    Joined:
    May 19, 2010
    Messages:
    1,043
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Luxembourg
    Looks like haveblue hasn't been online in a while. Anyone have a copy I can look at?
     
  2. House

    House Well-Known Member Silver Stacker

    Joined:
    May 1, 2012
    Messages:
    9,527
    Likes Received:
    287
    Trophy Points:
    83
    Location:
    Stack City
    I'll see if I can find it and send it on. But if I get a copyright infringement notice...

    Edit: Looks like I can be the unofficial distributor for this until Haveblue returns. PM your email address and I'll send them along.
     
  3. haveblue

    haveblue New Member

    Joined:
    Apr 21, 2011
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0
    Yo House...you stealing my thunder??!!! ...Haven't been on in a awhile because I thought I might take a break, been getting nailed by requests for the sheet....you wouldn't have anything to do with that would you house?? This thing has gone global!

    What do you guys suggest for V4??? I'd love some feedback

    Cheers,
    HB.
     
  4. Phiber

    Phiber Well-Known Member Silver Stacker

    Joined:
    Nov 21, 2012
    Messages:
    1,595
    Likes Received:
    31
    Trophy Points:
    48
    Location:
    Australia
    Hi mate,

    First thanks heaps for the log - it's super duper awesome.
    What I would love to have on the V4 would be the AUD & USD spot price pulled directly from the net based on the purchase date. Would make it a lot easier too when completing the form after the fact.
    I don't know how doable that would be?

    Thanks heaps for that anyway, it's really the best tool for tracking our stacks.

    Cheers
     
  5. House

    House Well-Known Member Silver Stacker

    Joined:
    May 1, 2012
    Messages:
    9,527
    Likes Received:
    287
    Trophy Points:
    83
    Location:
    Stack City
    I...I...I just wanted to feel loved :(
     
  6. hihosilver

    hihosilver New Member

    Joined:
    Sep 23, 2010
    Messages:
    622
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Australia
    how can one get this silver spreadsheet or the gold one too :cool:
     
  7. haveblue

    haveblue New Member

    Joined:
    Apr 21, 2011
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0

    Hiho,
    Sent you a PM re your email address,
    Cheers,
    Hb.
     
  8. Terry88

    Terry88 Member

    Joined:
    Dec 11, 2010
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Australia
    Hi haveblue,

    I've sent you a PM, looking forward to have a play around.

    Thanks in Advance
    Terry
     
  9. m0xty

    m0xty Member

    Joined:
    Feb 7, 2012
    Messages:
    272
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    Indonesia
    Pm ed
     
  10. onthebrink

    onthebrink New Member Silver Stacker

    Joined:
    Aug 10, 2010
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Perth
    Also PMd you thanks
     
  11. petey

    petey Active Member Silver Stacker

    Joined:
    May 19, 2010
    Messages:
    1,043
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Luxembourg
    Out of curiosity, would there be a way to combine the Silver and Gold Logs and show a GSR each time?
     
  12. markcoinoz

    markcoinoz Well-Known Member Silver Stacker

    Joined:
    Apr 29, 2012
    Messages:
    870
    Likes Received:
    556
    Trophy Points:
    113
    Location:
    Melbourne

    I was thinking along the lines of something similar using the GSR as well.

    Possibly using the "What IF" function in excel to help guage your level of risk according to various scenarios.

    Cheers markcoinoz :)
     
  13. haveblue

    haveblue New Member

    Joined:
    Apr 21, 2011
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0
    I'm actually thinking about doing this, combining the 2 sheets...but not everybody as both gold and silver.

    Now are you talking about your GSR or the GSR in general? Either way that's an easy one to put in, I'll add it to the list for V4....I could even put both of them in.
     
  14. haveblue

    haveblue New Member

    Joined:
    Apr 21, 2011
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0
    Hmmm this should be "doable"....I'll have to look into it further for v4. Surely there is a website that has this data somewhere

    I would like to see a drop down table where you can pick your currency in v4, that's my add to the list haha :p
     
  15. Phiber

    Phiber Well-Known Member Silver Stacker

    Joined:
    Nov 21, 2012
    Messages:
    1,595
    Likes Received:
    31
    Trophy Points:
    48
    Location:
    Australia
    Sounds awesome! Wish I could help but I am clueless when it comes to Excel...
     
  16. petey

    petey Active Member Silver Stacker

    Joined:
    May 19, 2010
    Messages:
    1,043
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Luxembourg
    My thoughts were that you could see the GSR of the day when you made each purchase (on each line).

    But yeah, the summary page could be great to see your total GSR and current GSR too.

    RE: those that don't have both, surely they could just leave the page blank?

    Down the bottom you could have a gold page, silver page and the PM prices and the summary page.

    Or potentially on each line you could just state gold/silver? Don't know how hard that would be with all the other calculations though..
     
  17. petey

    petey Active Member Silver Stacker

    Joined:
    May 19, 2010
    Messages:
    1,043
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Luxembourg
    We found this the other day - only gold though. http://www.perthmint.com.au/investment_invest_in_gold_precious_metal_prices.aspx
     
  18. PrettyPrettyShinyShiny

    PrettyPrettyShinyShiny Well-Known Member

    Joined:
    Feb 20, 2011
    Messages:
    1,262
    Likes Received:
    60
    Trophy Points:
    48
    Location:
    NSW
    haveblue --- not sure if you have incorporated it, but dollars are great, but ever thought of incorporating a column that compares the value of the metal when purchased and what the dollar value of the metal could buy (purchasing power) with purchasing power of those dollars today/at time of sale?

    Someone else made a huge spreadsheet with this information -- but it was just comparing purchasing power from one year to the next (not sure if you could add in your silver holdings, the buy and sell values etc.)

    It's great if you buy silver for $20 in year x and sell silver in year y for $40, but if something catastrophic happens in between and $40 in year y buys the same amount of goods in year x, you're only treading water.

    Thoughts?
     
  19. Mimaki

    Mimaki Member

    Joined:
    Oct 23, 2012
    Messages:
    77
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Gold Coast, Australia
    Sounds great! how can I get a copy :)
     
  20. haveblue

    haveblue New Member

    Joined:
    Apr 21, 2011
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0
    G'day mate, yep looked into this one as well...ie time based calculations. There are so many variables thou to take into account, inflation being the biggest one, and the "value" of the dollar being the another. I'll have a play around with my financial calculator to see if it. An provide any clues as to how to come up with the formulas....that and google. But I like the idea and have considered putting it in, if work ever slows down I might actually get a chance to do it!
     

Share This Page