Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Pull Data from Bloomberg

Inactive User
Not applicable

Is there a way to use Bloomberg credentials to pull data from Bloomberg, clean it up and produce a .tde file for Tableau?

9 REPLIES 9
Cristian
9 - Comet

Ask blockspring to add bloomberg as web data service

https://www.blockspring.com/tableau

 

Regards,

Cristian.

Cristian
9 - Comet

FYI.

 

Web Data Connector

Loading...
With the Web Data Connector SDK, you can unlock a world of data that's available over the web. In addition to using the dozens of data connectors that are already available in Tableau, you can now create your own web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
 

https://community.tableau.com/community/developers/web-data-connectors

 

http://www.theinformationlab.co.uk/2015/07/27/5-things-to-know-about-the-tableau-9-1-web-data-connec...

 

jdunkerley79
ACE Emeritus
ACE Emeritus

You could do something using the Bloomberg Server API (http://www.bloomberglabs.com/api/documentation/) to create a command you could call from the Run Command.

 

I dont have access to it anymore but it's quite easy to make a command which downloads a grid of data which Alteryx could read in.

 

A lot of legal restrictions on distributing Bloomberg data normally.

Inactive User
Not applicable

Thanks Cristian, will explore the WDC option for Bloomberg data..

Inactive User
Not applicable

Thanks jdunkerley79,  Checked the Bloomberg API details. I believe, I have to choose the right API for the service needed and pass on the right arguments. If possible, please pass on any sample workflows to pull Bloomberg data. It will very very helpful.

Joe_Mako
12 - Quasar

We have have built a connector to the Bloomberg API, you can download a free trial once you click the Subscribe button at:
https://www.labrosenblatt.com/

 

Once installed, here is a workflow with sample use cases:
https://www.labrosenblatt.com/s/SampleBloombergWorkbook.yxmd

DataPrepChad
10 - Fireball

Hi @Joe_Mako, looks like the download is just the .yxmd, and doesn't include the custom tool.  Any chance you could export the entire thing and link the yxzp with the macro included?  

 

Thanks! 

 

 UPDATE: I see that you have to sign up in order to get the download.  Only issue now is that I am getting the error "Failed to start BBG session".  Ideas? 

 

adurgan
5 - Atom

Hi Joe, 

 

Thanks for your fantastic connector and before I start thank apologies as I am very much an alteryx beginner.

 

I'm struggling to connect an excel book as an input into your connector rather than a text file. I am getting the below error message. 

 

Designer x64 The Designer x64 reported: InboundNamedPipe::ReadFile: Not enough bytes read. The pipe has been ended. ¶

 

Both the excel book and the workflow are attached.

 

Does the connector only take text files or am I just being slow?

 

Thanks in advance,

 

Alex

 
mattd17
7 - Meteor

@Joe_Mako Ignorant question maybe, but does your bloomberg connector pull just equity ticker data or is every index and economic indicator also available for download?

 

Thanks,

Matt

Labels