Realtime gold price on website

G

Guest

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
 
C

Curt_C [MVP]

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

Guest

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

larrybud2002

L

larrybud2002

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
 
G

Guest

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)
%>
 
M

McKirahan

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 said:
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.

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

Guest

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

 
M

McKirahan

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.)
 
G

Guest

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"
%>
 
M

McKirahan

Adding Response.Write "nodeName = " & oXML.documentElement.nodeName &
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.
 
G

Guest

W2K Server SP4 & IE 6 (all updates)
XPpro SP2 & IE 6 (all updates)

McKirahan said:
Adding Response.Write "nodeName = " & oXML.documentElement.nodeName &
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.
 
Joined
Oct 22, 2012
Messages
1
Reaction score
0
Since the service for precious metal prices has disconntinued i found a new one: Precious Metals XML Price Feed ( http :// www .xmlcharts.com/precious-metals.html ) - Good luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top