Posted 01/17/2015 07:54 am
It took some trial and error, but I think I was able to make something that might help.
1. Open up excel, and go to the "Data" tab in the top ribbon.
2. Click the "Get External Data From The Web" Button.
3. Enter the kitco webpage (http://www.kitco.com/market/) and press GO.
4. If you don't see the Yellow Icons on the webpage, click the Show Icons button.
5. Scroll down, and select (Using the yellow icon shown above) the chart showing spot prices for Silver, Gold and Platinum. The click Import.
NOTE: Make sure you click the correct yellow icon, as two are overlapped.
6. You should now have something that looks like this.
7. Now to get rid of the less important information, you will hide the unwanted rows. First select the rows you want to hide.
NOTE: You can't just delete the information in the unwanted cells. When you refresh the page to update the spot prices, all of the information will come back if the cells are not hidden.
8. Under the "Home" tab, click "Format" and change the Row Height to 0 .
9. Your spreadsheet should look like this now. Select the unwanted columns.
10. Under the "Home" tab, click "Format" and change the Column Width to 0.
11. You should be left with all of the information you need.
12. The most important step will be how to update all of this information. Under the "Data" tab, click "Refresh All" and everything will update instantly.
It may not be the best way, but it was the easiest solution I found. Hope this helps.
1. Open up excel, and go to the "Data" tab in the top ribbon.
2. Click the "Get External Data From The Web" Button.
3. Enter the kitco webpage (http://www.kitco.com/market/) and press GO.
4. If you don't see the Yellow Icons on the webpage, click the Show Icons button.
5. Scroll down, and select (Using the yellow icon shown above) the chart showing spot prices for Silver, Gold and Platinum. The click Import.
NOTE: Make sure you click the correct yellow icon, as two are overlapped.
6. You should now have something that looks like this.
7. Now to get rid of the less important information, you will hide the unwanted rows. First select the rows you want to hide.
NOTE: You can't just delete the information in the unwanted cells. When you refresh the page to update the spot prices, all of the information will come back if the cells are not hidden.
8. Under the "Home" tab, click "Format" and change the Row Height to 0 .
9. Your spreadsheet should look like this now. Select the unwanted columns.
10. Under the "Home" tab, click "Format" and change the Column Width to 0.
11. You should be left with all of the information you need.
12. The most important step will be how to update all of this information. Under the "Data" tab, click "Refresh All" and everything will update instantly.
It may not be the best way, but it was the easiest solution I found. Hope this helps.
Edited by Canadian-Banknotes
01/17/2015 08:02 am
01/17/2015 08:02 am
