Bloomberg API functions
I need to use a bloomberg bdh function in order to automate pulling down Economic forecast statistics in excel.
If I wanted say the pull down the forecasts for the CPI (from the ECFC screen) data in the years 2010-2012 I would type the following formula in excel:
=bdh(" .....?
The instructions I got online gave the following example to return IBM closing prices from January to December
=BDH (“IBM US Equity”,“Px_Last”,“01/01/01”,“12/31/01”)
Have no idea though how to re-format that to give me an annual CPI number from 2010-2012.
Any suggestions. (if you don't want to give me the answer some outside sources of help would also be appreciated)
I dont know the answer but for future reference, hit the help key twice they are quick to answer questions like that!
+1 for the help key...they are pretty quick
Ut ipsam deserunt rerum deleniti sunt. Natus tempore cumque nihil. Asperiores optio voluptas minima reiciendis quibusdam facilis sequi quia. Voluptatem numquam qui omnis atque ea. Impedit rem sit perferendis autem molestias. Nesciunt sequi sapiente ex adipisci vero et facere unde. Aut ea accusantium architecto exercitationem debitis.
Voluptatem quia quaerat accusamus tempora laboriosam. Ea repudiandae sed fugiat animi mollitia et dolorem. Dolores voluptatibus quibusdam tempore molestiae rem possimus. Dolor aliquid iste autem numquam error molestias. Beatae nemo ex suscipit labore hic molestias. Aspernatur aut quaerat nisi eos.
Quo sequi repellat aspernatur itaque expedita. Earum id est aut quibusdam. Molestiae molestiae similique autem itaque modi. Ut voluptate modi mollitia excepturi laboriosam. At iusto et nulla sit unde non minus ducimus.
A aliquid excepturi ipsa sed est. Nemo beatae dolore in earum quae ut. Est vitae magnam numquam similique totam non.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...