Automating pulling data from a website
If someone wanted to automate pulling info from a website..http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?symbol=fdo and pull one line of data, populate it with the symbol in excel...then run with a different symbol and pull the same line of data, populate....how would someone do that. Doing a Web Query doesn't really accomplish what I'm trying to do. Is there a initial way to direct my research on how to figure this out? There are many stock templates that pull price data on stocks, but this data is a little different. I'd love suggestions from anyone.
| Attachment | Size |
|---|---|
| EXCEL EXPERT TEMPLATE GROK MSN-altered.xls | 191.5 KB |
Try changing the following
Try changing the following string...the last three characters are the symbols.
http://moneycentral.msn.com/investor/invsub/analyst/earnest.asp?symbol=fdo
Please explain it further with help of an xl sheet to help me understand it further.
further explanation
Thanks. Yes, changing the last letters is an important part.
Well...the ideal flow would follow a simple vlookup.
In column A, have a list of stock symbols (or an input to search a stock symbol). Then a macro of some kind that tells excel to go out to the web site...change the last letters on the url address to match the stock symbol and return a line of data from that web site for that specific stock symbol. Then do it for the next stock symbol.
Does that concept make sense? This would be an ideal solution. I just don't know if it's possible.
Yes, this is very much
Yes, this is very much possible through VBA. If you want then you can share the code that you might have to accomplish that for one symbol. The same code can be modified to do it repeatedly for any number of symbols.
Yes possible
Would anyone out there have an example of a simple excel spreadsheet that does a similar thing so that I could look at the code and try to configure to my situation?
Visit this url for the
Visit this url for the solution to your problem. I have customised the code as per you requirement.
http://excelexperts.com/web-query-solution
Download excel sheet and see how it works.
I just came across your
I just came across your website and have a similar question to the previous one. Could you explain how to pull daily returns for a given ticker symbol from yahoo finance (via historical prices) and automatically insert them into a spreadsheet?
WOW. Thank you
I am so appreciative. I don't know if it worked, but I attached an excel file to the thread. It is a hacked version of the beautiful thing you did. If you can see it, can you see how I have replicated the concept and now have a list of stock symbols. Is there a way to type in a lot of symbols, click, the get data and have it return multiple stocks at once. You are so kind to do any of this and I can't tell you how much I appreciate the quick template you did already. even if no more...THANKS for what you did.
In the solution to your post
In the solution to your post I had tried to illustrate how you can extract data from the Web with changing input.
To make it work exactly to your requirement you need to put all the symbols at one place and run a loop and use the function that I provided in the solution. You should be able to do it if you know VBA.
The solution needs is a bit of involvement. If you want a solution completely fitting your requirement then please goto
http://excelexperts.com/contact
your old post on pulling data from a website
Can this work on websites that require a login and security question to be accessed?
Sorry, it doesn't.
Sorry, it doesn't.