So I am using the Bloomberg Excel add in but can also use the API. My dilemma is I have a list of tickers containing SP500 historical constituents and I have retrieved 600 of them from an alternative source who supply fundamental data such as revenue.
However, for the delisted ones Bloomberg seems the only place that holds fundamentals for delisted tickers, but the problem is how do I feed it the tickers I am looking for, firstly the tickers are structured as so 'PBG-201002' so ticker and year it delisted.
But Bloomberg doesn't understand this so I am wondering how I can translate this into Bloomberg, fairly new to it too so any help will go a long way. :)