Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to link directly to Bloomberg to have put share prices on a Qlikview dashboard?
Thanks,
Nic
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.
If Bloomberg offers that data on their website in an HTML table, it should even be very easy (so the answer being yes).
So for instance, if I wanted to replicate the graph on the this website, what would the process be?
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.
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.
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..
Thanks all for your help on this!
I think I'll use the Google Finance Table!
.... but don't forget to check the legals..................