无法导入bloomberg api

Question

我已经安装了bloomberg Python API并将BLPAPI_ROOT设置为VC++文件夹。

但是，当我导入blpapi时，我得到了以下错误。

如何摆脱这些错误？

非常感谢。

import blpapi
Traceback (most recent call last):
  File "C:\Users\user\AppData\Roaming\Python\Python36\site-packages\blpapi\internals.py", line 39, in swig_import_helper
    return importlib.import_module(mname)
  File "C:\Program Files\WinPython-64bit-3.6.2.0Qt5\python-3.6.2.amd64\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 978, in _gcd_import
  File "<frozen importlib._bootstrap>", line 961, in _find_and_load
  File "<frozen importlib._bootstrap>", line 950, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 648, in _load_unlocked
  File "<frozen importlib._bootstrap>", line 560, in module_from_spec
  File "<frozen importlib._bootstrap_external>", line 922, in create_module
  File "<frozen importlib._bootstrap>", line 205, in _call_with_frames_removed
ImportError: DLL load failed: The specified procedure could not be found.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\user\AppData\Roaming\Python\Python36\site-packages\blpapi\__init__.py", line 4, in <module>
    from .internals import CorrelationId
  File "C:\Users\user\AppData\Roaming\Python\Python36\site-packages\blpapi\internals.py", line 42, in <module>
    _internals = swig_import_helper()
  File "C:\Users\user\AppData\Roaming\Python\Python36\site-packages\blpapi\internals.py", line 41, in swig_import_helper
    return importlib.import_module('_internals')
  File "C:\Program Files\WinPython-64bit-3.6.2.0Qt5\python-3.6.2.amd64\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
ModuleNotFoundError: No module named '_internals'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Users\user\AppData\Roaming\Python\Python36\site-packages\blpapi\__init__.py", line 9, in <module>
    raise debug_load_error(error)
ImportError: No module named '_versionhelper'

Could not open the C++ SDK library.

Download and install the latest C++ SDK from:

    http://www.bloomberg.com/professional/api-library

If the C++ SDK is already installed, please ensure that the path to the library
was added to PATH before entering the interpreter.

Answer 1

我做了两件事来解决类似的问题：

1-我安装了Microsoft Visual Studio和以下组件

• C++ /CLI支持
• VC++ 2015.3 v14.00 (v140)工具集，适用于桌面
• C++ x86和x64
• Visual C++ x86和x64

2-我手动将C++API\lib中的.dll文件(在我的例子中是blpapi3_32.dll和blpapi3_64.dll )复制到C:\windows\system32，系统使用的所有dll文件都在C：\windows\SYSTEM32中。

另外，我将C++API\lib中的dll文件复制到C:\blp\DAPI中，用旧文件替换新文件。

Answer 2

请将BLPAPI_ROOT环境变量设置为blpapi C++ SDK所在的位置。

Answer 3

另一种选择是使用conda，正如here和here所讨论的那样。

如果你使用conda，你不需要担心下载C++软件开发工具包和正确配置BLPAPI_ROOT。在conda-forge通道中，可以使用以下命令完成此操作

conda install -c conda-forge blpapi