Data mine table data from webpages into Excel
- or -
Post a project like this2928
$$
- Posted:
- Proposals: 3
- Remote
- #1105506
- Awarded
Description
Experience Level: Intermediate
Hi, if I had an Excel sheet with every stock listed on the London Stock Exchange in column A (as per the "Name" column here... http://tools.morningstar.co.uk/uk/stockquickrank/default.aspx?Site=uk&LanguageId=en-GB) I would like some vba code / macro that would locate and copy the "Normalized EPS p" (5 values) for each stock and paste them into the 5 cells to the right of the company name. For example if I had 1pm PLC in cell A1, cells B1:F1 would have 0.74, 1.47, 383.09, 3.55 and 3.72 in them respectively.
The Normalized EPS p can be found by clicking the name of the stock in the link above, navigating to Financials & Ratios and it's in the Income Statement table.
I would like the macro to repeat this for all the stocks, so I'd end up with an excel sheet with the EPS data in the 5 columns for all stocks down to row 1897, or whatever it happens to be at the time.
Thanks for your help!
The Normalized EPS p can be found by clicking the name of the stock in the link above, navigating to Financials & Ratios and it's in the Income Statement table.
I would like the macro to repeat this for all the stocks, so I'd end up with an excel sheet with the EPS data in the 5 columns for all stocks down to row 1897, or whatever it happens to be at the time.
Thanks for your help!
James F.
100% (1)Projects Completed
1
Freelancers worked with
2
Projects awarded
100%
Last project
10 Apr 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies