MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Re: Financial Data - Currencies

  • To: mathgroup at
  • Subject: [mg106142] Re: [mg106086] Re: Financial Data - Currencies
  • From: "E. Martin-Serrano" <eMartinSerrano at>
  • Date: Sat, 2 Jan 2010 05:08:17 -0500 (EST)
  • References: <hhhmok$obj$> <>



The Import/connection

euData1 = Import["
  dat00_eu.txt", "Data"]

fails to work in my computer and returns $Failed plus the following message:

**FetchURL::conopen: The connection to URL
dat00_eu.txt cannot be opened. If the URL is correct, you might need 
to configure your firewall program, or you might need to set a proxy 
in the Internet Connectivity tab of the Preferences dialog (or by 
calling SetInternetProxy).**

My SetInternetProxy setting in the *preferences* tab is: *Use Proxy settings
from my system or browser*

However, the direct connection via browser works fine, so it should work
inside the Mathematica expression too, I think. And I do not see any
semicolon after the URL, as you warn, in the MathGroup post.

E. Martin-Serrano

-----Original Message-----
From: Chris Degnen [mailto:degnen at] 
Sent: Friday, January 01, 2010 11:34 AM
To: mathgroup at
Subject: [mg106142] [mg106086] Re: Financial Data - Currencies

On 31 Dec, 08:18, robert prince-wright <robertprincewri... at>
> Does anyone know how to get the names corresponding to the currencies
available from FinancialData? If you use the command below you get a list of
153 currencies - some of which are obscure so i was hoping to generate the
> currencyTickers = FinancialData["Currencies"]
> Also, why does FinancialData not give historical data for say GBP/USD?
EUR/USD works, albeit over a limited time span, so you would think the data
would be there for sterling. Several others don't work either.... perhaps
this is a data server issue?
> R

Here's some code for getting exchange rate history.  Note the pages on
the Fed have slightly differing formats and are parsed accordingly.
Fortunately they don't change over time.
(If you're reading this post on the MathGroup beware the posting
program may have inserted semi-colons after the URLs.  If so, they
should be deleted.)

(* Extract EUR/USD exhange rate *)
euData2={StringReplace[#," "<>" "..->","]}&/@euData1;
(* Extract GBP/USD exhange rate *)
ukData2={StringReplace[#[[1]]," "<>" "..->","]}&/@ukData1;
ukData4=First[StringSplit[#,", "]]&/@ukData3;
(* Plot exchange rates *)
["\nExchange Rate History",20],Joined->True,Epilog->{Inset[Style["GBP/

  • Prev by Date: Re: Re: Financial Data - Currencies
  • Next by Date: Re: Re: Financial Data - Currencies
  • Previous by thread: Re: Re: Financial Data - Currencies
  • Next by thread: Re: Financial Data - Currencies