By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,088 Members | 1,326 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,088 IT Pros & Developers. It's quick & easy.

Realtime gold price on website

P: n/a
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.

I found a website that's doing it, but don't know where to start in reverse
engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks
Jul 22 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.

I found a website that's doing it, but don't know where to start in reverse
engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks

you try a VIEW SOURCE to see what's rendered? There may be a clue in it.

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com
Jul 22 '05 #2

P: n/a
I'd already picked through the source, but I can't find anything that looks
like it's doing a query.

"Curt_C [MVP]" <software_at_darkfalz.com> wrote in message
news:Og**************@TK2MSFTNGP09.phx.gbl...
TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.
I found a website that's doing it, but don't know where to start in reverse engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks

you try a VIEW SOURCE to see what's rendered? There may be a clue in it.

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

Jul 22 '05 #3

P: n/a


TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.

I found a website that's doing it, but don't know where to start in reverse
engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Here you go. Free Gold price in XML feed.

http://dgcsc.org/goldprices.htm

Jul 22 '05 #4

P: n/a


TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.

I found a website that's doing it, but don't know where to start in reverse
engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks


Oh, prices are in grams.

1 ounce = 28.3495231 grams

Jul 22 '05 #5

P: n/a
la**********@yahoo.com wrote:


TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.

I found a website that's doing it, but don't know where to start in reverse
engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks


Oh, prices are in grams.

1 ounce = 28.3495231 grams


I believe that's one avoirdupois ounce. But precious metals are sold
in Troy ounces.....

According to http://en.wikipedia.org/wiki/Troy_weight, one Troy ounce
is 31.103477 gram.

--
Tim Slattery
MS MVP(DTS)
Sl********@bls.gov
Jul 22 '05 #6

P: n/a
I can't quite figure out this last part. How do I pull the value for:
<Price currencyname="United States Dollar"
currencycode="USD">14.0788</Price>
from http://dgcsc.org/goldprices.xml and use it in my ASP code for the
variable GoldPrice_Gram? Thanks.

<%@ LANGUAGE="VBSCRIPT" %>
<%
GoldPrice_Gram = 14.0788
GramsPerTroyOunce = 31.103477
GoldPrice_Ounce = GoldPrice_Gram * GramsPerTroyOunce

response.write "Gold Price: " & round(GoldPrice_Ounce,4)
%>

"Tim Slattery" <Sl********@bls.gov> wrote in message
news:a8********************************@4ax.com...
la**********@yahoo.com wrote:


TR****@hotmail.com wrote:
Does anyone know an easy way to put a current gold price on your own
website? I've seen the graphic methods that Kitco.com offers, but I'd
rather have it pull the value from some gold market system in text format.
I found a website that's doing it, but don't know where to start in reverse engineering the code:
http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp

Thanks


Oh, prices are in grams.

1 ounce = 28.3495231 grams


I believe that's one avoirdupois ounce. But precious metals are sold
in Troy ounces.....

According to http://en.wikipedia.org/wiki/Troy_weight, one Troy ounce
is 31.103477 gram.

--
Tim Slattery
MS MVP(DTS)
Sl********@bls.gov

Jul 22 '05 #7

P: n/a
<TR****@hotmail.com> wrote in message
news:uC**************@TK2MSFTNGP14.phx.gbl...
I can't quite figure out this last part. How do I pull the value for:
<Price currencyname="United States Dollar"
currencycode="USD">14.0788</Price>
from http://dgcsc.org/goldprices.xml and use it in my ASP code for the
variable GoldPrice_Gram? Thanks.

<%@ LANGUAGE="VBSCRIPT" %>
<%
GoldPrice_Gram = 14.0788
GramsPerTroyOunce = 31.103477
GoldPrice_Ounce = GoldPrice_Gram * GramsPerTroyOunce

response.write "Gold Price: " & round(GoldPrice_Ounce,4)
%>

"Tim Slattery" <Sl********@bls.gov> wrote in message
news:a8********************************@4ax.com...
la**********@yahoo.com wrote:


TR****@hotmail.com wrote:
> Does anyone know an easy way to put a current gold price on your own
> website? I've seen the graphic methods that Kitco.com offers, but I'd> rather have it pull the value from some gold market system in text format.>
> I found a website that's doing it, but don't know where to start in reverse> engineering the code:
> http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp
>
> Thanks

Oh, prices are in grams.

1 ounce = 28.3495231 grams


I believe that's one avoirdupois ounce. But precious metals are sold
in Troy ounces.....

According to http://en.wikipedia.org/wiki/Troy_weight, one Troy ounce
is 31.103477 gram.

--
Tim Slattery
MS MVP(DTS)
Sl********@bls.gov



Will this help? Watch for word-wrap.

<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC
iPRC = 0.0000
'*
Dim oXML
Set oXML = CreateObject("Microsoft.XMLDOM")
oXML.async = "false"
oXML.load(cURL)
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

This assumes that "USD" is always at the same offset in the XML file.
Jul 22 '05 #8

P: n/a
Almost there, but it won't read the XML data if I try HTTP:
oXML.load("http://dgcsc.org/goldprices.xml")
'* Doesn't work. I hardcoded the URL just to make sure it was calling the
correct location.

oXML.load(Server.MapPath("goldprices.xml"))
'* Works perfectly. For testing purposes I copied the goldprices.xml file
from dgcsc.org into the same directly on the server as the ASP file.

Anyone got any ideas how to get this last bit to work?
Here's the complete code:

<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC
iPRC = 0.0000
'*
Dim oXML
Set oXML = CreateObject("Microsoft.XMLDOM")
oXML.async = "false"
'* oXML.load(cURL)
oXML.load(Server.MapPath("goldprices.xml"))
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

"McKirahan" <Ne**@McKirahan.com> wrote in message
news:i7********************@comcast.com...
<TR****@hotmail.com> wrote in message
news:uC**************@TK2MSFTNGP14.phx.gbl...
I can't quite figure out this last part. How do I pull the value for:
<Price currencyname="United States Dollar"
currencycode="USD">14.0788</Price>
from http://dgcsc.org/goldprices.xml and use it in my ASP code for the
variable GoldPrice_Gram? Thanks.

<%@ LANGUAGE="VBSCRIPT" %>
<%
GoldPrice_Gram = 14.0788
GramsPerTroyOunce = 31.103477
GoldPrice_Ounce = GoldPrice_Gram * GramsPerTroyOunce

response.write "Gold Price: " & round(GoldPrice_Ounce,4)
%>

"Tim Slattery" <Sl********@bls.gov> wrote in message
news:a8********************************@4ax.com...
la**********@yahoo.com wrote:

>
>
>TR****@hotmail.com wrote:
>> Does anyone know an easy way to put a current gold price on your own >> website? I've seen the graphic methods that Kitco.com offers, but I'd >> rather have it pull the value from some gold market system in text

format.
>>
>> I found a website that's doing it, but don't know where to start in

reverse
>> engineering the code:
>> http://www.goldinvestment.com/Purchasing/Scrap_Gold.asp
>>
>> Thanks
>
>Oh, prices are in grams.
>
>1 ounce = 28.3495231 grams

I believe that's one avoirdupois ounce. But precious metals are sold
in Troy ounces.....

According to http://en.wikipedia.org/wiki/Troy_weight, one Troy ounce
is 31.103477 gram.

--
Tim Slattery
MS MVP(DTS)
Sl********@bls.gov



Will this help? Watch for word-wrap.

<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC
iPRC = 0.0000
'*
Dim oXML
Set oXML = CreateObject("Microsoft.XMLDOM")
oXML.async = "false"
oXML.load(cURL)
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

This assumes that "USD" is always at the same offset in the XML file.

Jul 22 '05 #9

P: n/a
<TR****@hotmail.com> wrote in message
news:#c**************@TK2MSFTNGP15.phx.gbl...
Almost there, but it won't read the XML data if I try HTTP:
oXML.load("http://dgcsc.org/goldprices.xml")
'* Doesn't work. I hardcoded the URL just to make sure it was calling the
correct location.

oXML.load(Server.MapPath("goldprices.xml"))
'* Works perfectly. For testing purposes I copied the goldprices.xml file
from dgcsc.org into the same directly on the server as the ASP file.

Anyone got any ideas how to get this last bit to work?
Here's the complete code:

<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC
iPRC = 0.0000
'*
Dim oXML
Set oXML = CreateObject("Microsoft.XMLDOM")
oXML.async = "false"
'* oXML.load(cURL)
oXML.load(Server.MapPath("goldprices.xml"))
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

"oXML.load(cURL)" works for me.

How do you know "it won't read"?

Try adding this line after "oXML.load(cURL)"

Response.Write "nodeName = " & oXML.documentElement.nodeName & "<br>"

(Watch for word-wrap.)
Jul 22 '05 #10

P: n/a
Adding Response.Write "nodeName = " & oXML.documentElement.nodeName & "<br>"
after oXML.load(cURL) gives me an error:
Object required: 'documentElement'

It seems like I had to add an extra step to get it to work, which I don't
like as your's is cleaner. Do you have any ideas as to why this was
necessary or any further steps in trouble shooting?

set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")

objHTTP.open "GET", cURL, false
objHTTP.send
set objXML = objHTTP.responseXML

Complete code:
<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC, objHTTP, objXML, oXML
iPRC = 0.0000
'*

set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")

objHTTP.open "GET", cURL, false
objHTTP.send
set objXML = objHTTP.responseXML

set oXML=CreateObject("Microsoft.XMLDOM")
oXML.async= "false"
oXML.load(objXML)
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

"McKirahan" <Ne**@McKirahan.com> wrote in message
news:E7********************@comcast.com...
<TR****@hotmail.com> wrote in message
news:#c**************@TK2MSFTNGP15.phx.gbl...
Almost there, but it won't read the XML data if I try HTTP:
oXML.load("http://dgcsc.org/goldprices.xml")
'* Doesn't work. I hardcoded the URL just to make sure it was calling the correct location.

oXML.load(Server.MapPath("goldprices.xml"))
'* Works perfectly. For testing purposes I copied the goldprices.xml file from dgcsc.org into the same directly on the server as the ASP file.

Anyone got any ideas how to get this last bit to work?
Here's the complete code:

<%@ LANGUAGE="VBSCRIPT" %>
<% Option Explicit
'*
Const cOZT = 31.103477
Const cURL = "http://dgcsc.org/goldprices.xml"
'*
Dim iPRC
iPRC = 0.0000
'*
Dim oXML
Set oXML = CreateObject("Microsoft.XMLDOM")
oXML.async = "false"
'* oXML.load(cURL)
oXML.load(Server.MapPath("goldprices.xml"))
iPRC = oXML.getElementsByTagName("Price").item(21).text
Set oXML = Nothing
'*
Response.Write "Gold Price: $" & Round(iPRC * cOZT,4) & " per ounce"
%>

"oXML.load(cURL)" works for me.

How do you know "it won't read"?

Try adding this line after "oXML.load(cURL)"

Response.Write "nodeName = " & oXML.documentElement.nodeName & "<br>"

(Watch for word-wrap.)

Jul 22 '05 #11

P: n/a
<TR****@hotmail.com> wrote in message
news:ep**************@TK2MSFTNGP10.phx.gbl...
Adding Response.Write "nodeName = " & oXML.documentElement.nodeName & "<br>" after oXML.load(cURL) gives me an error:
Object required: 'documentElement'

It seems like I had to add an extra step to get it to work, which I don't
like as your's is cleaner. Do you have any ideas as to why this was
necessary or any further steps in trouble shooting?

set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")

objHTTP.open "GET", cURL, false
objHTTP.send
set objXML = objHTTP.responseXML


[snip]

What's your O/S (+ version) and browser (+ version)?

For example, Win98SE and IE5.5 or WinXPPro and IE6.0.
Jul 22 '05 #12

P: n/a
W2K Server SP4 & IE 6 (all updates)
XPpro SP2 & IE 6 (all updates)

"McKirahan" <Ne**@McKirahan.com> wrote in message
news:Ec********************@comcast.com...
<TR****@hotmail.com> wrote in message
news:ep**************@TK2MSFTNGP10.phx.gbl...
Adding Response.Write "nodeName = " & oXML.documentElement.nodeName &

"<br>"
after oXML.load(cURL) gives me an error:
Object required: 'documentElement'

It seems like I had to add an extra step to get it to work, which I don't like as your's is cleaner. Do you have any ideas as to why this was
necessary or any further steps in trouble shooting?

set objHTTP = Server.CreateObject("Microsoft.XMLHTTP")

objHTTP.open "GET", cURL, false
objHTTP.send
set objXML = objHTTP.responseXML


[snip]

What's your O/S (+ version) and browser (+ version)?

For example, Win98SE and IE5.5 or WinXPPro and IE6.0.

Jul 22 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.