Re: newbie q-n about FinancialData
- To: mathgroup at smc.vnet.net
 - Subject: [mg105235] Re: newbie q-n about FinancialData
 - From: "Sjoerd C. de Vries" <sjoerd.c.devries at gmail.com>
 - Date: Wed, 25 Nov 2009 02:32:30 -0500 (EST)
 - References: <hegeut$1fd$1@smc.vnet.net>
 
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",
   "UPS"}].
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 gmail.com> 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.
- Follow-Ups:
- Re: Re: newbie q-n about FinancialData
- From: DrMajorBob <btreat1@austin.rr.com>
 
 - Re: Re: newbie q-n about FinancialData
- From: Michael Stern <nycstern@gmail.com>
 
 
 - Re: Re: newbie q-n about FinancialData