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