Reply to thread

I am wondering if there is a way in Excel, using Bloomberg API, to find if tickers have changed or acquired by other firms.

For example, given these values,

BOFI US (Axos Financial Inc)

EVHC US (Envision Healthcare Corp)

COOL US (PolarityTE Inc)

it should return

AX US (ticker change on 2018/10/01)

Acquired by KKR on 2018/10/11

PTE US (ticker change on 2018/09/18)

respectively.