Precious Metals Forum

Go Back   Precious Metals Forum > Precious Metals and Economic News > PM Bug

Reply
 
LinkBack Thread Tools
Old 12-29-2011, 09:04 PM   #1
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
Tracking the eBay / 24hgold.com PM widget

eBay / 24hgold.com PM Widget Tracker

Notes:

1) All premiums are truncated percentages, high precision not necessary IMO
2) I have noticed that premiums widen when PM prices go down.
3) Gold and silver prices are from 24hgold.com.
4) AGE = American Gold Eagle 1 oz, ASE = American Silver Eagle 1 oz.

First column is date (dd.mm.yy)
Second column is AGE premium over spot
Third column is ASE premium over spot
Fourth column are comments
Fifth column is spot gold price (no price captured 28 Dec)
Sixth column is spot silver price (no price captured 28 Dec)

28.12.11 * 13% * 52% * Second day of vicious takedown
29.12.11 * 17% * 74% * at approx. 1:00 AM * $1,554 * $26.95
29.12.11 * 19% * 66% * at approx. 11:00 AM * $1,530 * $26.58
29.12.11 * 16% * 115% * as of 9:00 PM, widget shows eBay/24h offer * $1,558 * $27.59

I have seen VERY HIGH premiums for ASEs to spot silver before, but not over 100%.

Formatting is bad because I tried to cut & paste MS Excel data right into here. Next time I will just post the info on a GoogleDoc spreadsheet (with link) or send the data over to MS Word and see if it comes over here looking better than the above.

RE-EDIT:

I chose AGEs and ASEs as that is what 24hgold.com actually tracks. I do understand that other 1 oz gold coins typically will be spot plus 4%, say as typical vs. an AGE of 8%.

Last edited by DoChenRollingBearing; 12-29-2011 at 09:19 PM. Reason: Unexpected bad formatting, will try to clean it up
DoChenRollingBearing is offline   Reply With Quote
Old 12-29-2011, 09:28 PM   #2
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
A formatting experiment:

Data deleted, format was just as bad as above.

---

Here is a link that shows the widget formatted a little bit better:

https://docs.google.com/spreadsheet/...hl=en_US#gid=0

Last edited by PMBug; 12-30-2011 at 12:35 PM. Reason: fix link
DoChenRollingBearing is offline   Reply With Quote
Old 12-30-2011, 12:05 PM   #3
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
Up-dated today.

http://docs.google.com/spreadsheet/c...hl=en_US#gid=0

EDIT:

Why is the above link not working...? Lemme try again:

Widget


Still not working, I will keep trying to get this figured out...

Let's try again:

https://docs.google.com/spreadsheet/...hl=en_US#gid=0

Still not working....

...

Last edited by PMBug; 12-30-2011 at 12:34 PM. Reason: fixed links
DoChenRollingBearing is offline   Reply With Quote
Old 12-30-2011, 12:18 PM   #4
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
The link DOES work from my blog.

Anyone interested in tracking the eBay / 24hgold.com PM Widget please email me for a link to my blog.

Meanwhile, I will try to find a way to work with our Inestimable PMBug to get this info out in a more user-friendly manner.

---

Or, maybe a Cut & Paste of the below might work???

https://docs.google.com/spreadsheet/...hl=en_US#gid=0

^--- THAT worked! Beats me why though!
DoChenRollingBearing is offline   Reply With Quote
Old 12-30-2011, 12:33 PM   #5
Golden Cockroach
 
PMBug's Avatar
 
Join Date: Oct 2011
Location: In Scrooge McDuck's vault
Posts: 7,103
Liked: 2456 times
DCRB - Not sure how you are posting the links, but every one of them seems to have an extra "http(s)//" at the beginning. I'll fix them.
__________________
The journey of a thousand miles begins with a single step. - Lao Tzu

Important stuff: PMBug 101 * Forum Guidelines * Support PMBug
PMBug is online now   Reply With Quote
Old 01-11-2012, 01:33 AM   #6
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
The below graph is from my eBay / 24hgold.com Widget Tracker:



Each point in the above graph shows the price of gold vs. the AGE Premium at the time I recorded the data. This JUST shows Au price vs. AGE premium ONLY, there is no time series or anything. This DOES show one of the points I mentioned before in another thread: that the spot price of Au is STRONGLY NEGATIVELY correlated with the AGE Premium (that is, when spot price Au goes down, the Premium goes up) at -0.93. <--- That means the data form a down-sloping scatter plot that is almost a line.

I understand this is abstract, but, I am trying to learn how to use these multiple tools.

Another graph derived from the Widget Tracker:



-- The left axis is Premium Percentage (over spot)
-- "Series 1" (blue diamonds) is AGE Premium over spot Au, and this DOES show this in chronological order
-- "Series 2" (red squares) is ASE Premium over spot Ag, in chronological order

Note how the ASE Premium (percentage) is ALWAYS higher than AGE Premium, and that ASE varies MORE.

Also note that I started this Widget Tracker just after they smashed the PM prices down. If you look at the second graph you can see the Premiums are higher than for more recent data. They smack down the PM prices, the retail eBay sellers try to maintain the higher price (and so higher Premium). Then after a few days the Premiums then ease back down to their more normal ranges (say 5.5% - 8.5% for gold).

Last edited by DoChenRollingBearing; 01-11-2012 at 10:46 PM.
DoChenRollingBearing is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ebay premiums for gold and silver DoChenRollingBearing PM Bug 2 12-19-2011 02:58 PM
ebay sales report PMBug Serious Business 2 10-26-2011 12:15 PM


All times are GMT -5. The time now is 04:23 PM.


Powered by vBulletin® from Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.6.0 PL2 ©2011, Crawlability, Inc.
Content of PMBug.com copyright © 2011 - 2019 Measuring Up. All Rights Reserved.