Home > OS >  Python / Bloomberg api - historical security data incl. weekends (sat. and sun.)
Python / Bloomberg api - historical security data incl. weekends (sat. and sun.)

Time:10-13

I'm currently working with an blpapi and trying to get a bdh of an index including weekends. (I'll later need to match this df with another date vector.) I'm allready using

con.bdh([Index],['PX_LAST'],'19910102', today.strftime('%Y%m%d'), [("periodicitySelection", "DAILY")])

but this will return only weekdays (mon - fr). I know how this works in excel with the bbg function-builder but not sure about the wording within the blpapi.

Since I'll need always the first of each month,

con.bdh([Index],['PX_LAST'],'19910102', today.strftime('%Y%m%d'), [("periodicitySelection", "MONTHLY")])

wont work as well because it will return 28,30,31 and so.

Can anyone help here? THX!

CodePudding user response:

You can use a combination of:

"nonTradingDayFillOption", "ALL_CALENDAR_DAYS"  # include all days
"nonTradingDayFillMethod", "PREVIOUS_VALUE"     # fill non-trading days with previous value
  • Related