1. Metals try to capitalize in market weakness with dollar weakness ie choppy
    Dismiss Notice
  2. Good Thur Morning! Gold is down 1.3 to 1248. Silver is flat at 1757. Crude +16 to 4820. The USD is up 17 to 9964.
    Dismiss Notice
  3. Week of 3/18/2017 Closing prices & Chg Over Last Wk---- Gold $1230.20-- UP 28.8 Silver $17.41-- UP 49 Oil $49.31-- UP 82 TICS USD $100.11 -- DOWN 100 tics Based on near term futures contract--- At JMB Current price AGE 2017 $1299.09 (1), SAE $20.54 (20)

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