Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
viewing newly created access queries in excel via msquery | Excel Discussion (Misc queries) | |||
I cannot refresh all of the queries in my spreadsheet | Excel Discussion (Misc queries) | |||
Workbook with 20+ queries of Access is TOO BIG | Excel Discussion (Misc queries) | |||
Web queries & Yahoo! Finance | Excel Discussion (Misc queries) | |||
change data source for many queries at once? | Excel Worksheet Functions |