bpsmith / tia

Toolkit for integration and analysis
BSD 3-Clause "New" or "Revised" License
408 stars 163 forks source link

How to pull out data with extra parameters such as BEST_EPS "2BF" via datamgr.py? #13

Open PaulVilnius opened 7 years ago

PaulVilnius commented 7 years ago

Hello, I want to pull out BEST_EPS data with additional parameters such as "2BF", or 2016Y and so on using tia.bbg.datamgr module. Script:

import pandas as pd import tia.bbg.datamgr as dm

mgr = dm.BbgDataManager() msft = mgr("MSFT US EQUITY") msft.BEST_EPS

Works following too:

msft.get_historical('BEST_EPS', '1/1/2015', '10/4/2016')

The script above is working but still I do not know how to pull out BEST_EPS 2BF, could someone help me. Thanks.

jaredpohl commented 7 years ago

hey

I am also keen to understand how to use overrides properly... im keen to use "BEST_FPERIOD_OVERRIDE=1BF" in bdh to get time series consensus stuff...

jaredpohl commented 7 years ago

ok.. so looks like you use the following code

t['RHC AU EQUITY'].get_historical('BEST_PE',start='2010-06-30', end='2017-06-30', period='MONTHLY',overrides={"BEST_FPERIOD_OVERRIDE=1BF"})

in python3 though i had to change overrides.iteritems() to overrides.items() so that it works, iteritems was depreciated in python3.

now im getting this error

Exception: HistoricalDataResponse = { responseError = { source = "bbdbh2" code = 27 category = "BAD_ARGS" message = "Invalid override field id specified [nid:86] " subcategory = "INVALID_OVERRIDE_FIELD" } }

any help @bpsmith