the syntax of your BDP formula is correct and different fields work fine for securities that are SSAP protected and out of preliminary status, but not for securities that are SSAP protected and in preliminary status. Anyone seen this before. All the data is available and populated on bloomberg, but I get the #N/A Invalid Security error.
Image includes code from excel, where column C AND D ARE THE PRELIM SSAP SECURITIES AND NOT POPULATING THE SECURITY NAME IN CELL C2 / D2 BUT WILL POPULATE SECURITY NAME IN E2
for example : i have included in my screenshot the BDP formulas and verified the syntax is fine and works when exchanging cusips and the data is populated already in bbg but cannot pull using the bdp formula.
