Automatically extract website data to a spreadsheet

[Corried]

Hello, Thank you for sharing..

I am looking for courses on how to automatically extract data from a website to an excel spreadsheet.

The excel file contains fifty links. Each link has the same process, to create a stock market report for fifty companies. Use macro and chrome to generate data.

Can anyone show me a step by step process on how I can do this?

Please watch the video and Excel workbook below to learn more.

Example STOCK REPORT CARD

Sheet2 CORRIE STOCK REPORT CARD Websites Top 100,Company,Symbol,P/E,Price,Sales Growth Yr Over Yr,Sales, Revenue, Net Income in B=billion or M=million,52-Week Low & High,5 Year High & Low,Market Cap; # Shares,Debt/Equity Ratio,Net Profit,Company: Insider Trading,Operating Margins,Description,New...

docs.google.com

I hope you all understand.

Cheers

 

[Corried]

I ran it today and got an error at D2.
I will try to find out what is happening during the week.

Hello Worf, Any headways...

 

[Worf]

I am using an old laptop which cannot properly run the code.
Is the last version still working for you?

 

[Corried]

I am sorry to say. I did get an error.

Please view the image below.

On msn.com, I no longer is seeing the pop-up window.
Can this caused the error?

 

[Worf]

I think we reached a dead end. The table below shows the XPath for the price element, which can belong to the green or red class.

The strings do not follow a pattern, normally the HTML is static, but this is not the case here.

I do not know how to solve this situation.

 

[Corried]

I think we reached a dead end. The table below shows the XPath for the price element, which can belong to the green or red class.

The strings do not follow a pattern, normally the HTML is static, but this is not the case here.

I do not know how to solve this situation.

View attachment 65992

Thank you, Worf, for your support for the many weeks you have tried to solve this problem.

My conquest will continue to find the answer. Once I found the answer, you will be the 1st one to know.

Please for give me, there is one more request. If you are comfortable, of course.
How can I explain my problems to an excel professional to understand? or
How can I construct my wording to make sense and for them to see the bigger picture?

Thanks in advance

Cheers

 

[Corried]

I think we reached a dead end. The table below shows the XPath for the price element, which can belong to the green or red class.

The strings do not follow a pattern, normally the HTML is static, but this is not the case here.

I do not know how to solve this situation.

View attachment 65992

Hello Worf.

I am sorry I've to disturb you. I have searched multiple platform for my issues. Nothing.
Even went on upwork.com. Nothing.

Just checking if you can recommend to someone else.

Thanks in advance

XPath for the price element which belong in green or red class. Strings don't follow pattern normally the HTML is static, but that's not the case here

Thank you for taking the time to read my problem. For a couple of weeks, I've worked with Worf on how we can scrap stock data on https://www.msn.com/en-xl/money on Mr. Excel https://www.mrexcel.com...

stackoverflow.com

 

[Worf]

Hello

You cross-posted correctly by supplying the link here. SO is a strong forum but unfortunately there was no answer.

If I can think of anything, I will let you know.

 

[Corried]

Hello

You cross-posted correctly by supplying the link here. SO is a strong forum but unfortunately there was no answer.

If I can think of anything, I will let you know.

Thank you Worf. Nice to hear from you. I was thinking if Google Sheets can work. I am seeking both paid and free forum. Nothing. I'm currently chatting with someone on Upwork. They same it may take sometime to find the answer, using google sheet...

 

[Worf]

Hi

I had an idea that may or may not work…

Question: the P/E metric seems to have disappeared from the summary page, can you check that?

 

[Corried]

Hi

I had an idea that may or may not work…

Question: the P/E metric seems to have disappeared from the summary page, can you check that?

Hello Worf.

I am glad to meet you again.

Some companies P/E may not show the companies P/E. depend on how the company is doing, you may see on the summary page. However, to confirm same, please view the following:

Summary >> Analysis >> Price Ratios >> Company

Above you may see any given company P?E. whether if it is blank, have a numeral value or it may not even have a P/E tab...