Re: Re: newbie q-n about FinancialData

*To*: mathgroup at smc.vnet.net*Subject*: [mg105281] Re: [mg105235] Re: newbie q-n about FinancialData*From*: Michael Stern <nycstern at gmail.com>*Date*: Wed, 25 Nov 2009 23:03:11 -0500 (EST)*References*: <hegeut$1fd$1@smc.vnet.net> <200911250732.CAA05469@smc.vnet.net>

If you have access to a Bloomberg license, you can get higher quality data with the Mathematica link to Bloomberg, which is available for free at http://library.wolfram.com/infocenter/MathSource/7357/ The code to call up the P/E ratios for your list of stocks would be BBGetCurrent[{"MSFT Equity", "GE Equity", "XOM Equity", "XRX Equity","UPS Equity"},"PE_Ratio"] If you wanted to use next year's consensus estimated P/E, which most people would probably find more useful, the call is BBGetCurrent[{"MSFT Equity", "GE Equity", "XOM Equity", "XRX Equity","UPS Equity"},"Est_PE_Nxt_Yr"] You can combine this with he Export command if you like, as demonstrated by others. Cheers, Michael Sjoerd C. de Vries wrote: > 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. >> > > >

**References**:**Re: newbie q-n about FinancialData***From:*"Sjoerd C. de Vries" <sjoerd.c.devries@gmail.com>