If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bullion values of UK coins
I have added a page to my website on the Values of UK coins
which lists reasonably recent bullion values for gold and silver coins. Of course, many such coins have a value exceeding their bullion value, but some, and I am thinking of worn sovereigns and pre-1920 silver in particular, have listed values which may be less than the current bullion price, especially as gold is over $990 per ounce. The new page can be found at http://www.coins-of-the-uk.co.uk/values/bull.html, and includes links to the websites that I use for the latest prices. I hope to update this page every few days, as time permits. I would dearly love to know how to make the updating process automatic! -- Tony Clayton Coins of the UK : http://www.coins-of-the-uk.co.uk Sent using RISCOS on an Acorn Strong Arm RiscPC .... I'm leaving my body to science fiction. |
Ads |
#2
|
|||
|
|||
Bullion values of UK coins
On Fri, 20 Feb 2009 15:58:27 +0000, Tony Clayton
wrote: The new page can be found at http://www.coins-of-the-uk.co.uk/values/bull.html, and includes links to the websites that I use for the latest prices. I would dearly love to know how to make the updating process automatic! Use an online spreadsheet program that links to quotes. I have used EditGrid for US and Canadian bullion. http://www.coinsheetlinks.com/melt.htm Best Regards, Bob Johnson |
#3
|
|||
|
|||
Bullion values of UK coins
"Tony Clayton" wrote in message ... I have added a page to my website on the Values of UK coins which lists reasonably recent bullion values for gold and silver coins. Of course, many such coins have a value exceeding their bullion value, but some, and I am thinking of worn sovereigns and pre-1920 silver in particular, have listed values which may be less than the current bullion price, especially as gold is over $990 per ounce. The new page can be found at http://www.coins-of-the-uk.co.uk/values/bull.html, and includes links to the websites that I use for the latest prices. I hope to update this page every few days, as time permits. I would dearly love to know how to make the updating process automatic! In MS Word there's a setting to update field values linked to an outside source every time you open or print the document. I don't know if creating your values page as a Word document would trigger the update every time a visitor clicks to open it, but it may be worth looking into. The hard part will be finding a URL link that points to something that automatically, and only, returns a value such as the current gold quote. I think that other MS Office documents such as an Excel spreadsheet can be rigged to behave the same way, if your website link opens a spreadsheet or database file. At the least, you ought to be able to automate calculating all the subsidiary values once you plug in the day's price for gold and silver. A spreadsheet document would do this. There may be a way to set up a Word document table that behaves the same way. I don't have access to Word right now, or I'd check that now. Note that unless you have good HTML skills, you may have to fall back to using a "Click here to see current values" link that jumps from your main page to a page that just displays spreadsheet tables of the values with their labels (and a small amount of explanatory text in separate spreadsheet cells) along with another link to return back to your main page. (My ISP won't send to the uk group, so I hope that Tony is checking in through rcc.) -- Tony Clayton Coins of the UK : http://www.coins-of-the-uk.co.uk Sent using RISCOS on an Acorn Strong Arm RiscPC ... I'm leaving my body to science fiction. |
#4
|
|||
|
|||
Bullion values of UK coins
"Bob Johnson" wrote in message ... On Fri, 20 Feb 2009 15:58:27 +0000, Tony Clayton wrote: The new page can be found at http://www.coins-of-the-uk.co.uk/values/bull.html, and includes links to the websites that I use for the latest prices. I would dearly love to know how to make the updating process automatic! Use an online spreadsheet program that links to quotes. I have used EditGrid for US and Canadian bullion. http://www.coinsheetlinks.com/melt.htm Best Regards, Bob Johnson Ah, that's far more elegant and effective than my kludge! |
#5
|
|||
|
|||
Bullion values of UK coins
I am particularly grateful to the two suggestions that I have received,
and in particular to Bob Johnson who has set up an example of just what I needed. This will in future be available at http://www.editgrid.com/user/tonyclayton/UKbullion and will be accessible directly from my website before too long. Wonderful! -- Tony Clayton Coins of the UK : http://www.coins-of-the-uk.co.uk Sent using RISCOS on an Acorn Strong Arm RiscPC .... If at first you don't succeed, you're doing about average. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
diameters of bullion coins compared to other coins | yawnmoth | Coins | 9 | December 7th 08 04:58 PM |
Pawn shops and other second hand sources was bullion coin face values & paper money investing | pyotr filipivich | Coins | 0 | November 29th 04 05:37 AM |
bullion coin face values & paper money investing | Jerry Dennis | Coins | 13 | November 29th 04 05:37 AM |
Bullion coins | I am NOT Gene Wood! | Coins | 2 | November 24th 04 06:22 PM |
Need KM values for 2 coins | R. Carvish | Coins | 3 | April 8th 04 04:48 PM |