Extracting Financial Data From A Web-Based Source

Excel macros

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

The other day, I received a comment from a reader:

“how can i import EV/EBITDA into excel spreadsheet and to make it in a way that it will updated automatically. let’s say from a website like www.advfn.com”

Basically, he wanted to have a list of stocks and gather data from that specific website. That seemed like a challenge I was up for:) It should actually be fairly easy to do. First off, I created a sheet with a list of symbols. Then I created a tab where the web query would be done.

Then, I only needed to create a loop that would:

-go through each name
-do the web query for that ticker
-do a vlookup to find that information

So let’s do this step by step:

#1–go through each name

#2-do the web query for that ticker

#3-do a vlookup to find that information

#4-publish that info

Here is the final result! You can download the file here

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.