Gold Price Sources
Moderator: Global Moderator
- dualstow
- Executive Member
- Posts: 14292
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Gold Price Sources
This morning, one of my google sheets said 1270 per ounce. Had Bloomberg on in the background: 1248. So I checked my iphone app: 1245-48. And so on.
No big deal when I'm watching, but I'd hate to think gold was up $50, call my dealer and sell at up $0. I guess I'll have to ask him to read the price out loud when it's time to sell.
No big deal when I'm watching, but I'd hate to think gold was up $50, call my dealer and sell at up $0. I guess I'll have to ask him to read the price out loud when it's time to sell.
9pm EST Explosions in Iran (Isfahan) and Syria and Iraq. Not yet confirmed.
- Cortopassi
- Executive Member
- Posts: 3338
- Joined: Mon Feb 24, 2014 2:28 pm
- Location: https://www.jwst.nasa.gov/content/webbL ... sWebb.html
- dualstow
- Executive Member
- Posts: 14292
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Gold Price Sources
I can't remember, what source do you use, Cortopassi?
I forgot to mention, I also used kitco dot com, which is good because it shows the range.
I also forgot to say that a different google sheet said 1260 at the same time that my primary one showed 1270! In fact, they've always been different even though I have the same formula in both cells!
I forgot to mention, I also used kitco dot com, which is good because it shows the range.
I also forgot to say that a different google sheet said 1260 at the same time that my primary one showed 1270! In fact, they've always been different even though I have the same formula in both cells!
9pm EST Explosions in Iran (Isfahan) and Syria and Iraq. Not yet confirmed.
- Cortopassi
- Executive Member
- Posts: 3338
- Joined: Mon Feb 24, 2014 2:28 pm
- Location: https://www.jwst.nasa.gov/content/webbL ... sWebb.html
Re: Gold Price Sources
I use Apmex in my google sheet. But I generally look at Kitco otherwise. Both site's graphs show a pop to 1270 about 9AM NY time.
For the price from Apmex:
=Index(ImportHTML("http://www.apmex.com/","table",1),2,2)
For the price from Apmex:
=Index(ImportHTML("http://www.apmex.com/","table",1),2,2)
Test of the signature line
- dualstow
- Executive Member
- Posts: 14292
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Gold Price Sources
That's what I have in my google sheets.
9pm EST Explosions in Iran (Isfahan) and Syria and Iraq. Not yet confirmed.
Re: Gold Price Sources
Looks like the price went from $1270 to $1250 quite quickly, Dualstow. Maybe all your sources are not in real time. Just a guess.
- dualstow
- Executive Member
- Posts: 14292
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Gold Price Sources
Yeah, in the time it took me to go from one source to another.barrett wrote: Looks like the price went from $1270 to $1250 quite quickly, Dualstow.
I think so, too. The only really bizarre thing is the two google sheets w/ the same formula. I'll probably never get to the bottom of that one.Maybe all your sources are not in real time. Just a guess.
9pm EST Explosions in Iran (Isfahan) and Syria and Iraq. Not yet confirmed.
- Cortopassi
- Executive Member
- Posts: 3338
- Joined: Mon Feb 24, 2014 2:28 pm
- Location: https://www.jwst.nasa.gov/content/webbL ... sWebb.html
Re: Gold Price Sources
That pop to 1270 corresponds exactly with the drop in the dollar at the same time. Wonder what caused that.
Test of the signature line
- MachineGhost
- Executive Member
- Posts: 10054
- Joined: Sat Nov 12, 2011 9:31 am
Re: Gold Price Sources
Just out of curiosity, can this work for the personal coin holdings entered into Apmex? It would save time having the latest prices pulled automatically.Cortopassi wrote: I use Apmex in my google sheet. But I generally look at Kitco otherwise. Both site's graphs show a pop to 1270 about 9AM NY time.
For the price from Apmex:
=Index(ImportHTML("http://www.apmex.com/","table",1),2,2)
"All generous minds have a horror of what are commonly called 'Facts'. They are the brute beasts of the intellectual domain." -- Thomas Hobbes
Disclaimer: I am not a broker, dealer, investment advisor, physician, theologian or prophet. I should not be considered as legally permitted to render such advice!
Disclaimer: I am not a broker, dealer, investment advisor, physician, theologian or prophet. I should not be considered as legally permitted to render such advice!
- Cortopassi
- Executive Member
- Posts: 3338
- Joined: Mon Feb 24, 2014 2:28 pm
- Location: https://www.jwst.nasa.gov/content/webbL ... sWebb.html
Re: Gold Price Sources
Not sure exactly what you're asking but part of my google sheet takes the current gold and silver prices and applies it to my coin holdings (also in google sheets) and rolls up an up to date value.
Test of the signature line
- Mark Leavy
- Executive Member
- Posts: 1950
- Joined: Thu Mar 01, 2012 10:20 pm
- Location: US Citizen, Permanent Traveler
Re: Gold Price Sources
I have a tab in my Google doc labeled "Gold Prices"
It just has this entry in the A1 cell
=importhtml("http://www.coloradogold.com/htsell.php","table",5)
These are the colorado gold BID prices. The price they will pay to buy each different type of coin.
In my other tabs, I reference these prices against my individual holdings. That gives me an up to date number of what I could sell everything for.
It just has this entry in the A1 cell
=importhtml("http://www.coloradogold.com/htsell.php","table",5)
These are the colorado gold BID prices. The price they will pay to buy each different type of coin.
In my other tabs, I reference these prices against my individual holdings. That gives me an up to date number of what I could sell everything for.
-
- Senior Member
- Posts: 126
- Joined: Sat Sep 24, 2016 5:39 pm
- Location: NJ and India
Re: Gold Price Sources
^ Excellent. Thx for sharing.