Christian Portocarrero Moreno capm

Bloomberg API with Python

Requirements

Windows 10 x64.
Latest version of Anaconda.

Setting up the environment

First, we need to install Visual Studio Build Tools in the Bloomberg terminal. You can get the latest version of VS Tools 2019 here. VS Tools allow us to compile and package applications from source.

After installing VS Build Tools, you should update your anaconda packages. Use the following code on your Anaconda Powershell Prompt (run it with admin privileges):

	Sub ValorCuota()
	'
	' ValorCuota Macro
	'

	' Turn off all features
	'BestPractices (0)

	' Declare variables
	' Workbooks and worksheets