Forum Discussion

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. -------------------------------------------------- ----------...

BI & Data Analysis

excel

Formulas and Functions

power bi

Lorenzo
May 24, 2022
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
CombinedSymbols_deniztopcu.xlsx35 KB

Lorenzo

Silver Contributor

May 24, 2022

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

CombinedSymbols_deniztopcu.xlsx35 KB

deniztopcu
Brass Contributor
May 24, 2022
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
  Silver Contributor
  May 24, 2022
  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
  - deniztopcu
    Brass Contributor
    May 24, 2022
    Hi Lorenzo
    Thank you so much. For your efforts in this thread. A very positive result for me.