Found this wonderful file from Excel Clout. Only one problem. To make it perfect, I need 3 more columns of data updated automatically: stock exchange, shares outstanding, and price-to-sales ratio (ttm). I have highlighted the columns red that need to be updated automatically. Let me know if I need to provide further clarification.
Thanks,
David
Where is the data located for the 3 columns you are trying to populate?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
The data is web scraped from Yahoo.com/finance. Straight from the stock quote via the stock symbol.
Then what do you need help with exactly?
The first 20 columns update automatically (black font). I need the last 3 columns to do so as well (red font). I hand entered the information in the first stock symbol (ABT) just as an example.
Anyone willing to give it a shot?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks