Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

DOWNLOAD DATA FROM BLOOMBERG AND IMPORT THEM INTO ALTERYX

MT
5 - Atom

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.

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

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
5 - Atom

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
22 - Nova
22 - Nova

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
5 - Atom

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
7 - Meteor

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

Labels