具有ISIN的彭博BDH功能 [英] Bloomberg BDH function with ISIN

问题描述

我必须下载日末历史数据才能获取大量股票.我在Bloomberg excel插件中发现了非常有用的功能BDH.那就是我所需要的，但是有一个问题:我的股票被ISIN识别，并且我已经尝试了很多方法将ISIN放在函数的第一个字段中，但是它不起作用.尽管该函数无法通过ISIN识别安全性，尽管事实已在Bloomberg公式语法中报告为安全性标识符:请在此处查看幻灯片24 http://lgdata.s3-website-us-east-1.amazonaws.com/docs/205/56376 /bloomberg%20excel%20desktop%20guide.pdf

I have to download historical end of day data for a huge list of stocks. I found on the bloomberg excel add-in the function BDH that is very useful. That is what I need but there is an issue: my stocks are identified by ISINs and i have tried in many way to put the ISINs in the first field of the function but it doesn't work. The function isn't able to identify the security by the ISIN despite the fact that is reported as security identifier in the bloomberg formula syntax: look at slide 24 here http://lgdata.s3-website-us-east-1.amazonaws.com/docs/205/56376/bloomberg%20excel%20desktop%20guide.pdf

推荐答案

问题在于，isin不能识别交易所，而只能识别发行者.

The problem is that an isin does not identify the exchange, only an issuer.

假设您的isin是US4592001014(IBM)，一种实现方法是:

Let's say your isin is US4592001014 (IBM), one way to do it would be:

• 获取代码(在A1中):

• get the ticker (in A1):

=BDP("US4592001014 ISIN", "TICKER") => IBM

获取正确的符号(在A2中)

get a proper symbol (in A2)

=BDP("US4592001014 ISIN", "PARSEKYABLE_DES") => IBM XX Equity

其中XX取决于您的终端设置，您可以在CNDF <Go>上进行检查.

where XX depends on your terminal settings, which you can check on CNDF <Go>.

获取主要交易所综合股票行情收录器，或获取满足您需要的任何内容(在A3中):

get the main exchange composite ticker, or whatever suits your need (in A3):

=BDP(A2,"EQY_PRIM_SECURITY_COMP_EXCH") => US

最后是

and finally:

=BDP(A1&" "&A3&" Equity", "LAST_PRICE") => the last price of IBM US Equity

这篇关于具有ISIN的彭博BDH功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！