get_historical() returns data in arbitrary order

[csuecb]

When importing historical price data for several securities using get_historical(), the ordering of securities is not as specified in the function. I have found it to be arbitrary which is annoying. Sample code here below.

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

mgr = dm.BbgDataManager()
sids = mgr[['SPGCCIP Index', 'SPGCCLP Index', 'SPGCGCP Index', 'SPGCSIP Index']]

df = sids.get_historical('PX_LAST', '1-Jan-2014', '31-Jan-2014')

#Problem is the order of columns in Dataframe is not consistent with order of sids
print df

[drlima]

Hi, apart from the columns ordering, is the data consistent?

[csuecb]

I have not found any erroneous values. Can you tell me whether there is a function to retrieve static properties rather than historical prices. Eg. last_tradeable_dt Thanks

…

On Thu, 16 May 2019 at 10:28, Daniel Lima ***@***.***> wrote: Hi, apart from the columns ordering, is the data consistent? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#53?email_source=notifications&email_token=AL7SJE2NRVGBKG5CRXZXRU3PVUSKTA5CNFSM4HKZTAHKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODVRHNNA#issuecomment-492992180>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AL7SJE4SPVY34SJ2M6O5HETPVUSKTANCNFSM4HKZTAHA> .