DOWNLOAD DATA FROM BLOOMBERG AND IMPORT THEM INTO ALTERYX

[MT]

Hello Community, I am a beginner on Alteryx, and I am struggling with an issue while automating a process. Basically, I want to move a process that I have been running on excel, to Alteryx. To do this, I need to extract data from Bloomberg and currently I use Excel and the Bloomberg API to retrieve data from Bloomberg and import it into Excel. I read some old posts and a guide regarding "how to build a connector", but for a beginner it is not explained in details. Furthermore, I cannot find anything regarding Bloomberg specifically. So, I was wondering if anyone has experienced the same problem and managed to solve it, maybe going through some tutorials or videos that I am not aware of. Thanks in advance for your help.

[atcodedog05]

Hi @MT 

If you already have the API you can setup download tool to download the data/file. Below links might be helpful to you.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Download/ta-p/29583 

https://community.alteryx.com/t5/Engine-Works/REST-API-In-5-Minutes-No-Coding/ba-p/8137

Hope this helps : )

[MT]

Thanks, but actually the problem is that I have an API for Bloomberg and I don't know how to get the URL, since the Download tool asks for that. Furthermore, if I use the download tool, will it work when the workflow will be uploaded to the server?

[atcodedog05]

Hi @MT 

You said you are currently running on excel. Guessing its a macro, the excel might have all the configurations somewhere since it would also need these info.

And yes this workflow would work even after it goes to server.

[MT]

Perfect, I will look into it. Thank you very much for your help. I will let you know if I managed to do it.

[Yongcan]

When you say "Excel and the Bloomberg API" , is it Excel Add-In and pulling data via Excel function like below?
BDP: (Bloomberg Data Point) imports a single data point of current data.
BDH: (Bloomberg Data History) returns the historical data for a selected security.
BDS: (Bloomberg Data Series) imports a set of bulk data such as peers.

You properly need work out the best way to pull data within your organization via Bloomberg licensed service there are lots interface/ protocole, no need still use Excel and can be python etc. 

And when you talking about API in this community, most of people would think you are talking about something like below.

https://www.openfigi.com/api