multiple share prices

[deniztopcu]

Please help for the code I wrote to download Multiple Stock Prices at once.
Ringing for Single Share. However, it is not working for many shares.







One Stock working: One_Stock.xlsx dosyasını indir - download
Multiple Stock Not working: https://www.dosya.tc/server36/y8ix7y/multiple_Stock.xlsx.html

 

[deniztopcu]

Birden Fazla Hisse Senedi Fiyatını tek seferde indirmek için yazdığım kod için lütfen yardım edin.
Tek Paylaşım için Çalıyor. Ancak, birçok hisse için çalışmıyor.







One Stock çalışıyor: One_Stock.xlsx çok indir - indir
Çoklu Stok Çalışmıyor: https://www.dosya.tc/server36/y8ix7y/multiple_Stock.xlsx.html

CrossLink : Download multiple share prices

 

[Error 1004]

Dear Deniz.
Your function is working good for 1 symbol. If you would have a proper url list then you can invoke your function. I think you need a LOOP between all of your tables and records to create a proper URL list . Check the solution in my post. It may help also in your case.

 

[deniztopcu]

Thank you for your answer, but as I'm introductory powerquery, I couldn't figure out how to adapt this example to my own work.


1-) 1 symbol query result.
2-) Symbol List
3-) Quarter Price(Close) Download link
4-)multiple results. (the result i was looking for)


I'm not good at coding so I hope it's a magic touch. I would be very pleased.

thanks...



One Stock working: One_Stock.xlsx dosyasını indir - download
Multiple Stock Not working: https://www.dosya.tc/server36/y8ix7y/multiple_Stock.xlsx.html