ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Web queries (https://www.excelbanter.com/excel-worksheet-functions/121771-web-queries.html)

Heine

Web queries
 
Hello everybody,

I wondered if anyone has some experience working with web queries as a
source for data import. What are the typical problems one faces? I had
an idea of trying to import tables from different bookmakers
stockbrokers etc to compare their live odds, quotes etc. Are there any
special requirements for the web pages etc? Would it at all be possible
and somewhat simple? Ideas and thoughts on this will be much
appreciated.

Best regards,

Heine


John Bundy

Web queries
 
Its easy, the easiest thing to do is check what is sent to the servers when
you make a request, and change it to suit.
e.g
yahoo for example is easy
http://finance.yahoo.com/q?s=f
f is Ford's symbol

You can retrieve data like that or just web query, typically you only need
to do it like this if there are passwords involved

"Heine" wrote:

Hello everybody,

I wondered if anyone has some experience working with web queries as a
source for data import. What are the typical problems one faces? I had
an idea of trying to import tables from different bookmakers
stockbrokers etc to compare their live odds, quotes etc. Are there any
special requirements for the web pages etc? Would it at all be possible
and somewhat simple? Ideas and thoughts on this will be much
appreciated.

Best regards,

Heine



Don Guillett

Web queries
 
To expand on this
http://finance.yahoo.com/q?s=f,msft,ibm


--
Don Guillett
SalesAid Software

"John Bundy" wrote in message
...
Its easy, the easiest thing to do is check what is sent to the servers
when
you make a request, and change it to suit.
e.g
yahoo for example is easy
http://finance.yahoo.com/q?s=f
f is Ford's symbol

You can retrieve data like that or just web query, typically you only need
to do it like this if there are passwords involved

"Heine" wrote:

Hello everybody,

I wondered if anyone has some experience working with web queries as a
source for data import. What are the typical problems one faces? I had
an idea of trying to import tables from different bookmakers
stockbrokers etc to compare their live odds, quotes etc. Are there any
special requirements for the web pages etc? Would it at all be possible
and somewhat simple? Ideas and thoughts on this will be much
appreciated.

Best regards,

Heine






All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com