Bullion values of UK coins
Tony Clayton
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 tony.cla...@pem.cam.ac.uk
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.
les.p...@gmail.com
> 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.
>
> 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.
Looks like everything is on sale today... all I see is a '0'.
Bob Johnson
<to...@tclayton.demon.co.uk> 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
mazorj
"Tony Clayton" <to...@tclayton.demon.co.uk> wrote in message
news:e9e3a33050%to...@tclayton.demon.co.uk...
>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.)
mazorj
"Bob Johnson" <gold...@gmail.com> wrote in message
news:ebrtp4dkpi739rdm9...@4ax.com...
Ah, that's far more elegant and effective than my kludge!
Tony Clayton
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 tony.cla...@pem.cam.ac.uk
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.