Extract data from Yahoo Finance

Hello Everyone, I hope you are all well. I would like to extract this data(attached image) from the stock page of multiple companies for example: Apple. When I try to do it, it always gives me weirdly formatted data that doesn’t even properly show the data. Can anyone get this working and share their work? Much appreciated.

image|449x297

Hi @kkarbassian

You want to extract all the data from the Image.

Can you please send the text file in preserve format?

Regards
Gokul

Thanks for your prompt reply Gokul. The data I want to extract is not in a text file but on yahoo finance. This is the link I used: (Apple Inc. (AAPL) Stock Price, News, Quote & History - Yahoo Finance). If you scroll down to summary, you should be able to find it.

@kkarbassian

If you are using new version of studio then click on table extraction and click on the previous close, so you will prompt as below

If you are using old version then use DataScrapping

Hope this may help you

Thanks

1 Like

I’ve done this already and when I exported it to excel it was really messy and broken. Is it possible for you to try to do it? I can’t see where i’m going wrong.

Hi

You can try with Data Scrapping Method and Extract table

Here is the Workflow
Dummy.xaml (18.0 KB)

@kkarbassian
Hope it will work

Regards
Gokul