Hello folks.
I have a pretty tough Excel puzzle that I hope you guys can help me
decode. I created a Web query that downloads Yahoo Fianance's Analyst
Estimates for any given stock.
I need it to extract most of the data from the "Revenue Est" table.
Sounds easy, but the location of the data might change after a refresh.
So it sounds like a I need to do some sort of lookup... Also sounds
easy, but there is a table very similar to my "Revenue Est" table
("Earnings Est") that is making it hard to do a lookup. Also, my query
automatically merges cells, so I'm a tad thrown off by that too.
It's kinda hard to explain, so it might be easiest to check out my
attachment to see exactly what I need. Please note the "web query" and
"ideal output" worksheets.
I am using Excel for Mac. I do not have the "New Web Query" option like
I do in my Windows verison, so I guess I'm stuck using a iqy file and
crazy lookups. I would greatly appreciate a push in the right direction
to figure out the crazy lookups.
Thank you guys so much for any help/advice.
Richard
+-------------------------------------------------------------------+
|Filename: help!.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5241 |
+-------------------------------------------------------------------+
--
rkhuntjr
------------------------------------------------------------------------
rkhuntjr's Profile:
http://www.excelforum.com/member.php...o&userid=25577
View this thread:
http://www.excelforum.com/showthread...hreadid=573342