Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Highlighted
Not applicable

Qlikview and Bloomberg

Is it possible to link directly to Bloomberg to have put share prices on a Qlikview dashboard?

Thanks,

Nic

1 Solution

Accepted Solutions
MVP
MVP

Re: Qlikview and Bloomberg

Bloomberg is well aware of the risk of exposing their very valuable asset like their data on the internet. So first of all they have made sure that if you electronically/automatically download the data in a way without using it via the provided UI of the browser - you are in fact commiting a criminal offence... Secondly they have been smart enough not to provide this as a simple standard HTML table. For that reason it is hard to use QlikView to screenscrape/webscrape the data from the website.

This might very well be technically possible but will most likely demand quite an effort if you are not proficient in this kind of work before. Those that do it use specialized tools like PhantomJS. I wouldn't advice anyone to do it on a site that is warning about criminal prosecution.

7 Replies
oknotsen
Honored Contributor III

Re: Qlikview and Bloomberg

If Bloomberg offers that data on their website in an HTML table, it should even be very easy (so the answer being yes).

May you live in interesting times!
Not applicable

Re: Qlikview and Bloomberg

So for instance, if I wanted to replicate the graph on the this website, what would the process be?

http://www.bloomberg.com/quote/QK9:GR

oknotsen
Honored Contributor III

Re: Qlikview and Bloomberg

If you have access to the (complete) source data of that thing: Yes. But you probably have not.

So what you could do is start "grinding" that information by scheduling (for example) a daily reload to get the exchange rate information of that (or any) website and start storing it into a QVD. Build up history. Next thing is start building a chart based on that historic information.

Might be easier to just get / buy that historic information from somewhere though.

May you live in interesting times!
MVP
MVP

Re: Qlikview and Bloomberg

Bloomberg is well aware of the risk of exposing their very valuable asset like their data on the internet. So first of all they have made sure that if you electronically/automatically download the data in a way without using it via the provided UI of the browser - you are in fact commiting a criminal offence... Secondly they have been smart enough not to provide this as a simple standard HTML table. For that reason it is hard to use QlikView to screenscrape/webscrape the data from the website.

This might very well be technically possible but will most likely demand quite an effort if you are not proficient in this kind of work before. Those that do it use specialized tools like PhantomJS. I wouldn't advice anyone to do it on a site that is warning about criminal prosecution.

Re: Qlikview and Bloomberg

Google are bit more open:

LOAD Date,

     Open,

     High,

     Low,

     Close,

     Volume

FROM

[https://www.google.co.uk/finance/historical?csv&q=NASDAQ%3AQLIK]

(html, codepage is 1252, embedded labels, table is @4);

;

But do check the legals if you are going to do it for business purposes..

Not applicable

Re: Qlikview and Bloomberg

Thanks all for your help on this!

I think I'll use the Google Finance Table!

Re: Qlikview and Bloomberg

.... but don't forget to check the legals..................

Community Browser