Forum Discussion

deniztopcu's avatar
deniztopcu
Brass Contributor
Aug 02, 2023

downloading multiple "unadjusted price or adjusted price" on web site power query

hello I want to download Quarterly Price information. But I couldn't handle it from the power query. I want your help on this.

 

want this result



https://www.isyatirim.com.tr/tr-tr/analiz/hisse/Sayfalar/Tarihsel-Fiyat-Bilgileri.aspx

unadjusted price : Düzeltilmemiş Fiyat
adjusted price      :Düzeltilmiş Fiyat  

 

excel
power bi

3 Replies

  • deniztopcu's avatar
    deniztopcu
    Brass Contributor
    Aug 04, 2023

    As a result of the searches I made, I saw that it was taken with these codes.

    https://www.mustak.org/sirket-bilancolarini-toplu-halde-indirelim/#lightbox-image-0/0/

    https://www.isyatirim.com.tr/_layouts/15/Isyatirim.Website/Common/Data.aspx/HisseTekil?hisse=[SYMBOL]&startdate=29-12-2023&enddate=29-12-2023


    How to find these codes in the "review" section of the site. and in which "code language" these codes are written.

    • deniztopcu's avatar
      deniztopcu
      Brass Contributor
      Aug 03, 2023
      yes, before I opened the topic, I tried "url" in excel, but my request did not yield any results.
      That's why I wanted to move the topic to the forum.
      Thank you very much for your answer, I hope there is another way.
      I still need help.

Resources