1. Stocks flat after recent runs. Metals flat to up.
    Dismiss Notice
  2. Good Thur Am. Gold is up slightly, +.5 to 1264, while Silver is up 2 to 1739. Crude is down 44 to 4918. The USD is down 5 to 9887.
    Dismiss Notice
  3. Week of 4/22/2017 Closing prices & Chg Over Last Wk---- Gold $1289.10-- UP 0.60 Silver $17.85-- down 66 Oil $49.62-- down 3.80 USD $99.88 -- down 58

Testing Zone

Discussion in 'Test postings' started by Silver Buck, Apr 17, 2011.



  1. Silver Buck

    Silver Buck Gold Member Gold Chaser

    Joined:
    Oct 22, 2010
    Messages:
    2,351
    Likes Received:
    1,506
    Trophy Points:
    113
    Occupation:
    Gin Bottler
    Location:
    Western Shores of Lake Erie
    Here's a pic of the basic structure of the sheet.

    [​IMG]

    I simply copy the info from CoinInfo and 'Paste Special - Text' onto the indicated cell in the sheet.

    [​IMG]

    [​IMG]

    The sheet will update all information.

    To add new purchase entries, simply highlight the row under the metal you purchased and 'Insert' a fresh row. In this case you would be clicking on '13'.

    [​IMG]

    Right Click and select 'Insert'.

    [​IMG]

    You will now have a fresh row to enter your information.

    [​IMG]

    As you enter your info, it will be bolded and will look like this.

    [​IMG]

    Once you are satisfied that your info is correct, you can un-bold your entry by highlighting the row and clicking on the 'Bold' button (you may have to click it twice).

    [​IMG]

    [​IMG]

    Here's your updated purchase with the sheet automatically updating the rest of your data.

    [​IMG]

    I can customize this sheet some more. I created it with entering all of the data by hand; however, I can have the sheet do any desired calculations.

    Any input is greatly appreciated.
     

Share This Page