- Joined
- 9/19/15
- Messages
- 100
- Points
- 28
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.
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.