I am uploading a file with a clearer explanation of what I'm wanting. I'm an investor without much Excel knowledge and want someone to write a Macro for me incorporating a Web Query so that I can input a column of 75 or so stock symbols in Column A, run the macro, and have a spreadsheet with the info that I'm looking for imported: The average "Analyst Rating" for the stock in Column B, and the "Number of Analysts Following" the stock in Column C. [RATS! The WordPad note is too big to upload. Hopefully, you get the gist of this.]
20 freelanceria on tarjonnut keskimäärin 80 $ tähän työhön
Hi Jerry, This is pretty easy for me. I can have this done in an hour. I am an excel vba expert and have been doing web queries/web scraping for over 11 years now! Kind regards Nash
Can do this for You. I did something like You want before for my own home-accounting project in excel, where I needed to periodically recalculate total value of stocks that I had based on data from company's website.