Forum Discussion
deniztopcu
May 23, 2022Brass Contributor
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
- LorenzoSilver 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- deniztopcuBrass ContributorHi 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.- LorenzoSilver 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 meIf you only pulls the prices to your Excel sheet there's no risk
- LorenzoSilver 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:
- deniztopcuBrass Contributorthanks for the warning.
I made the change.- LorenzoSilver Contributor