MathGroup Archive 2009

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

Search the Archive

Re: newbie q-n about FinancialData

  • To: mathgroup at
  • Subject: [mg105235] Re: newbie q-n about FinancialData
  • From: "Sjoerd C. de Vries" <sjoerd.c.devries at>
  • Date: Wed, 25 Nov 2009 02:32:30 -0500 (EST)
  • References: <hegeut$1fd$>

Hi Max,

I'd suggest you read the help docs available from within Mathematica
instead of Googling. FinancialData has an extensive page there.
Something along the following lines should work for you:

Export["C:\\Financialdata.xls", {#,
    FinancialData[#, "PERatio"]} & /@ {"MSFT", "GE", "XOM", "XRX",

This is a compund statement which does all the work at once. /@ is the
shorthand for the infix form of the function Apply, which applies the
FinancialData function (using a "pure function" construction, # &, --
look it up in the help docs) on a whole list of financial ticker
symbols. Export does the rest.

Cheers -- Sjoerd

On Nov 24, 1:10 pm, xamdam <maxkhe... at> wrote:
> Hi,
> I would appreciate some pointer on how to use FinancialData API to
> retrieve fundamentals (e.g. PERatio ) on a list of tickers (all US)
> and export it to a file. One hour of googling did not help!
> Thanks a lot,
> max.

  • Prev by Date: Re: simple question
  • Next by Date: Re: Bug in Plot3D?
  • Previous by thread: Re: newbie q-n about FinancialData
  • Next by thread: Re: Re: newbie q-n about FinancialData