This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've read similar posts about this issue, however I did not fully understand the answers. This is my situation:
- I would like to import Bloomberg data directly into Alteryx (I have licenses for both)
- Currently I use Excel and the Bloomberg API to retrieve data from Bloomberg and import it into Excel. However, I'm trying to reduce the number of steps to get data into Alteryx so I want to remove Excel from this equation.
I believe I should use the ''Run Command'' tool for this in Alteryx, however I can't quite configure it (I am new to the whole Data Science scene). So, as an actual example, let's say I would like to retrieve the stock prices for Apple in the first 4 months of the year. In Excel this would be done using the command: =BDH("AAPL US EQUITY","PX_LAST",20170101,20170501).
1) Would this be possible in Alteryx using the ''Run Command'' tool and how would I frame such a command in Alteryx?
2) Is this possible without any coding? I can't access any coding software at work since I'n not allowed to install anything - and requesting it will take weeks.
I don't get why Alteryx wouldn't have a connector to bloomberg preconfigured. People who can pay for bloomberg can definitely pay for the software and not having a guide for this seems to be a great way to not close a lot of incremental sales. Are management really this clueless? This seems a large market opportunity they've whiffed on.