Extract data from Yahoo Finance

Help Studio
, , , , ,
1

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

2

Hi @kkarbassian

You want to extract all the data from the Image.

Can you please send the text file in preserve format?

Regards
Gokul

3

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.

4

@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

image
image2199×1004 396 KB

If you are using old version then use DataScrapping

Hope this may help you

Thanks

1 Like
5

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.

6

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