capm

capm

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):

capm

Sub ValorCuota()
'
' ValorCuota Macro
'

    ' Turn off all features
    'BestPractices (0)
    
    ' Declare variables
    ' Workbooks and worksheets

capm

Principles of Adult Behavior

1. Be patient. No matter what.
2. Don’t badmouth: Assign responsibility, not blame. Say nothing of another you wouldn’t say to him.
3. Never assume the motives of others are, to them, less noble than yours are to you.
4. Expand your sense of the possible.
5. Don’t trouble yourself with matters you truly cannot change.
6. Expect no more of anyone than you can deliver yourself.
7. Tolerate ambiguity.
8. Laugh at yourself frequently.

capm

Private Sub Auto_Open()
    Call FXSBS
End Sub
Attribute VB_Name = "capmFunctions"
'XXXXX
Public Function RightToLeftChar(InputData As String, InputChar As String) As String
    '
    RightToLeftChar = Right(InputData, Len(InputData) - WorksheetFunction.Find("|", WorksheetFunction.Substitute(InputData, InputChar, "|", Len(InputData) - Len(WorksheetFunction.Substitute(InputData, InputChar, "")))))

End Function

capm

Sub FXSBS()
'
' FXSBS Macro
'
    ' Declare variables
    Dim wbMain As Workbook
    Dim wsMain As Worksheet
    Dim urlFX As String
    Dim dateStart As Date, dateEnd As Date
    ' Internet objects

capm

#####
## Load packages
#library(gdata)
library(readxl)
library(data.table)
library(tidyr)
library(magrittr)
library(SIT)

#####

capm

Function DateMultiFunction(InputDate As String, InputType As Integer) As String
    ' 0: True or False
    ' 1: Replace date
    ' 2: Extract string

    ' Declare variables
    Dim regEx As New RegExp
    Dim strPattern As String
    
    '

capm

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console