Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA Macro to Import Web data into Excel: how to create a list of stock prices?

0

Hi,

I am making a stock quote list in an Excel spreadsheet. I used your tutorial* to enter the first stock price in an excel cell and it worked! (I changed the stock price to appear in cell A1 instead of a message box) However, at the moment I do only have 1 stock price and my goal is to make a list of stock prices which I can update by just running the macro once.

What do I have to change to get not only 1 stock price, but multiple imported at once?

(I have no VBA coding experience, but know how to do minor changes to the code)

Thanks in advance,

Tom

* https://www.teachexcel.com/excel-tutorial/2189/vba-macro-to-import-web-data-into-excel?nav=yt

Answer
Discuss

Answers

0
Selected Answer

Honestly, I wouldn't use this to get a large list of Stock prices, I just used Stock Prices as an example so that it would be a data point that is often updated, but now I think that maybe I should have used a different example.

If you are in a later version of Excel, just  use Excels Data Types to import a large list of Stock prices and other related data and have it updated.

You basically just input ticker symbols in a column and select them and go to the Data tab and click the Stocks data type. After that you can click a drop down menu and select the data you want to view.

This may require you updating your version of Excel but it is a great new feature.

Here is a tutorial from Microsoft on this feature: Stock prices in Excel

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login