SOLVED

Multiple stock Price download

Occasional Contributor

Hello,

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

Expression.Error.pngResult_null.png

I think there is a problem in this part.

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

 

I want to get a result like in the picture.

multiple results..PNG

 

thanks

 

9 Replies

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:

 

_Screenshot.png

thanks for the warning.
I made the change.
best response confirmed by deniztopcu (Occasional Contributor)
Solution

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

There was a little mistake (no impact on the result) in one query. Revised version uploaded in my previous reply
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.

@deniztopcu 

 

Attached is the same approach not ignoring Privacy Levels

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

Hi @L z.
Thank you so much. For your efforts in this thread. A very positive result for me.
Glad I could help & Thanks for providing feedback