Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to pull stock information from Yahoo by using the "web
query" feature. Normally, I use the "new web query" method which brings up the browser, I navigate over and select the table that I'm interested in. However, I want to make that more dynamic. I've created a *.iqy file that pulls information for a stock symbol entered into a specific cell. My problem is that it pulls the entire page - I only want the table (I can see the "check box" if I do it the other way) that has the prices. I'm assuming that (if you look at the msft examples) it has something to do with the lines following the URL. I can't find any information on what those lines mean. Am I on the right track? Does anyone know how to either modify the browser method to accept different parameters or specify a table in the *.iqy file? Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Web Queries | Excel Discussion (Misc queries) |