Services & ResourcesWolfram ForumsMathGroup Archive

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

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>