data extraction from yahoo finance

[deniztopcu]

hello everyone
finding and editing from a forum previously does not open this query anymore.
I couldn't understand if the reason is from yahoo or in the query.

Also, the following query is very complex, is it possible to make a simpler query?

___Dnz.xlsm dosyasını indir - download

 

[James006]

Hi,

For Power Query and yahoo finance, have a look at:

How to Get Stock Quotes From Yahoo Finance Using Power Query - HowtoExcel.net

You don't need to know how to use macros or any sort of API access to get stock prices quickly and easily into Excel!

howtoexcel.net

 

[deniztopcu]

Thank you. but this is not what i want.

 

[deniztopcu]

I progressed in this way but could not continue.

xxx.xlsm dosyasını indir - download