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
***************************************************