That's a bit annoying - about to head off to bed. Google Apps (from what I'm reading in the forums) doesn't allow you to set the USERAGENT, so I'll probably have to load a script up onto my server to mirror the MTGOX feed, and then try to load that in as a data source to Google Apps.
If I have time to do this tomorrow, I'll update the thread as to whether it works. I was having issues getting Curl to grab and mirror the data when using MTgox as a direct source, or using this as a source: http://btc.jalder.com/mtgox.php
(which, theoretically, wouldn't be subject to the USERAGENT limitation).
Incidentally, I also had problems getting Google to not time out on the Jalder.com source as well. The only conclusion that I can reach is that Google hates MTgox.
That this is the only conclusion I can reach is a sure-fire sign I need some sleep. I'll attack it again in the morning.
Thanks for the pointers.
(incidentally, this is the simple Curl script I was using:<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
//curl_setopt($ch, CURLOPT_URL, "http://btc.jalder.com/mtgox.php");
curl_setopt($ch, CURLOPT_URL, "http://mtgox.com/code/data/ticker.php");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
What you're saying is to simply add:curl_setopt($ch, CURLOPT_USERAGENT, "php bot");
And I should be copacetic?)