live feed gold/silver prices

Afternoon All,

Hope you can help,

Been doing some reading on the forum and noticed a few members obtaining spot prices from perth mint for a live feed to an excel spreadsheet or access database.

Is anyone using any other source that updates by the minute and is a 24hr AUD price.

Been looking at Goldprice.org however html code is only for displaying live chart. I am just after the individual spot price for my spreed-sheet calculations

Thanks

 

iv been looking for a while and cant find the number figure by its self.

 

..besides, do you really want to have a bot insert data into your excel?

 

Was looking for something similar myself but couldn't find anything that suited exactly what I needed. To that end I put together the following which should do the trick.

http://coww.ws/pmprices/ will give you the live silver oz price in AUD.
http://coww.ws/pmprices/?view=details will give you the silver price with price change and time/date (in NY), also
http://coww.ws/pmprices/?metal=gold will give you the live gold oz price in AUD.
http://coww.ws/pmprices/?metal=gold&view=details will give you the gold price with price change and time/date (in NY).

These prices are lifted, err I mean sourced from http://www.24hgold.com and should be available within a minute or two of being live on their site, but if they get cranky about too much traffic coming from my server I might have to pull the page down/find another source.

I will be adding a few more options soon-ish (like specifying the date/time that you want returned).

Feel free to use but keep in mind this was a 20 minute project so it may behave as such...

Moo.

 

Thanks cowwws. Didn't know about 24hgold, using it now myself

Here's a quick thingy in PHP I whipped up to parse the page on 24hgold and pull the metal spot prices, thought I'd share (15 minute crap job, but it works ).

Not as comprehensive as cowwws' but I don't need all of that anyway heh.

Code:

<?php
$search = "http://www.24hgold.com/english/allmetalsdata.aspx";

$lines = file($search);

foreach ($lines as $line_num => $line) {
$count = preg_match('/(.*Gold.*?)(\d{1,4}\.\d{1,3})(\$.*?td.*)/i', $line, $matches);
$goldprice = $matches[2];
echo $goldprice . "<br>";
$count = preg_match('/(.*Silver.*?)(\d{1,4}\.\d{1,3})(\$.*?td.*)/i', $line, $matches);
$silverprice = $matches[2];
echo $silverprice . "<br>";
$count = preg_match('/(.*Platinum.*?)(\d{1,4}\.\d{1,3})(\$.*?td.*)/i', $line, $matches);
$platinumprice = $matches[2];
echo $platinumprice . "<br>";
$count = preg_match('/(.*Palladium.*?)(\d{1,4}\.\d{1,3})(\$.*?td.*)/i', $line, $matches);
$palladiumprice = $matches[2];
echo $palladiumprice . "<br>";
}

?>

They run autorefresh on their site anyway so I don't think they'd care too much if you retrieve data every 15-30 minutes.

 

Dunno if people still interested in this or found a better way of doing it, but i found this way works well for me.

Using excel 2010

Data tab
- From web
- http://abcbullion.com.au/products-pricing
- Choose the chart (Provides Silver/gold/platinum/paladium price is USD/AUD and the exchange rate)
- Can set desired refresh rate after that

Hope this helps

 

Hi

The spreadsheet at http://investexcel.net/4333/historical-gold-silver-prices-excel/ pulls in historical gold and silver prices from a webserve. You can also choose the currency as well

tyrian

 

I just use the one on https://www.bullionlist.com.au/ , it updates ever couple of seconds. I open it up on a different page so i can see it all the time, its excellent lol

 

Greg, if you're after live pricing without wanting to integrate the data into an application etc, and just simply want to view it - this might be worth a browse: http://applications.kitco.com/supportcenter/

 

in excel I use exchangerates.org.uk


this is the code: