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.

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

"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.

"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!

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.