[R-SIG-Finance] Rbbg:::bdh Override Field Question

[John Laing]

Hi Chao,

Can you send the Excel formulas you're using to get different results? For
me these return the same:
=BDH("IBM Equity","TRAIL_12M_EPS","1/1/2000","8/27/2014")
=BDH("IBM
Equity","TRAIL_12M_EPS","1/1/2000","8/27/2014","BEST_FPERIOD_OVERRIDE=1GQ")

-John


On Wed, Aug 27, 2014 at 12:04 PM, Chao Zhang <zhangchao at gmail.com> wrote:

> Hey Guys,
>
> I am trying to use the code below to run a BDH call with override
> fields/values. However, the results I get are the same with or without the
> overrides.
>
> But if I do the same BDH call in Excel, the override fields/values will be
> effective and I will get the results I want. Can someone point out to me
> what's wrong with my code below? Thanks,
>
> library(Rbbg)
>
> conBBG <- blpConnect(throw.ticker.errors = FALSE)
>
> res <- bdh(conn=conBBG,
>            securities='IBM equity',
>            fields='TRAIL_12M_EPS',
>            start_date=as.Date('2000-01-01'),
>            override_fields='BEST_FPERIOD_OVERRIDE',
>            override_values='1GQ'
> )
>
> - Chao
>
>         [[alternative HTML version deleted]]
>
> _______________________________________________
> R-SIG-Finance at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-sig-finance
> -- Subscriber-posting only. If you want to post, subscribe first.
> -- Also note that this is not the r-help list where general R questions
> should go.
>

	[[alternative HTML version deleted]]