Web Query - importing data from a specific site

[John19]

I'm trying to create a new web query to import currency rates from a specific web page at: Döviz Kuru |Güncel Döviz Kurlar


The data I need is at the bottom of the page under the title: "Döviz Kurları" - which means currency rates in Turkish.




I manage to import the page but without the rates quotes at the bottom of the page.


can anyone please help.


thank you


question also posted at:
http://www.mrexcel.com/forum/excel-q...ml#post4369254

[MarvinP]

Hi John,

I'm learning more about Power Query, a tool that is already in Excel 2010. I believe it has the feature you seek.
I with I was better at it to show you how to use it but read about it at:

https://bennyaustin.wordpress.com/20...erqueryimport/ and/or
http://devinknightsql.com/2013/08/07...uery-extracts/

[John19]

this has worked great!

thank you

[John19]

spoke too soon!

I managed to download the information, but I can't get it to refresh? any idea?

thanks

[John19]

spoke too soon!

I managed to download the information, but I can't get it to refresh? any idea?

thanks