Forum Discussion

deniztopcu's avatar
deniztopcu
Brass Contributor
May 23, 2022
Solved

Multiple stock Price download

Hello,

This is in need of help. I am not proficient in M ​​language. I am trying.

I think there is a problem in this part.

-------------------------------------------------- -------------------------------------------------- -------------

 

I want to get a result like in the picture.

 

thanks

 

  • Hi deniztopcu 

     

    Assuming I understood the attached Power Query solution should do what you want

     

    Notes:
    - In the Query Options, Privacy Levels  are ignored to avaoid a Firewall error that would not be easy to fix in your scenario (let me know if this is really an issue)
    - It seems ARASE has no data before last quarter in 2021

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Hi deniztopcu 

     

    Assuming I understood the attached Power Query solution should do what you want

     

    Notes:
    - In the Query Options, Privacy Levels  are ignored to avaoid a Firewall error that would not be easy to fix in your scenario (let me know if this is really an issue)
    - It seems ARASE has no data before last quarter in 2021

    • deniztopcu's avatar
      deniztopcu
      Brass Contributor
      Hi Lz.
      Thank you. It gave the desired result.
      Can we find a solution other than "ignoring Privacy Levels".
      I don't know, How dangerous can it be for me.
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor

        You're welcome deniztopcu 

         

        Re.

        - Can we find a solution other than "ignoring Privacy Levels" - I don't know

        See my previous reply
        How dangerous can it be for me

        If you only pulls the prices to your Excel sheet there's no risk

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Hi deniztopcu 

     

    Please re-share your files with i.e. with OneDrive, Google Drive... The links you provided are obviously not secured. Here is what I get after clicking on the Download button:

     

Resources