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.
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 : )
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?
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.
Perfect, I will look into it. Thank you very much for your help. I will let you know if I managed to do it.
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.