Grabbing historical data from web

[tiredofit]

I am trying to get FTSE100 data from day 1 to present day.

This is the website I am using:

https://finance.yahoo.com/quote/%5EFTSE%3FP%3DFTSE/history?period1=757382400&period2=1603152000&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true

I tried getting the data using Power Query as follows:

Data -> Get Data -> From Web

Paste in website link

Click OK

Choose Table2

Click Load

All I get back is 100 rows of data from 1/6/2020 to 19/10/2020.

How can I get the rest of the data?

Thanks

 

[Matt Allington]

My guess is there is some limit on the site. What happens when you do the same in a browser? you may have to find another source, or write a query that retrieves 100 rows at a time.

 

[sandy666]

Loading more data... will disappear immediately if you achieve last row of 100 and next 100 will be loaded
If you want to see that you need too block scripts and you'll see picture above but it will not load the next 100, so unblock scripts and you'll see next 100
imho, they are not user friendly scripts

 

[tiredofit]

My guess is there is some limit on the site. What happens when you do the same in a browser? you may have to find another source, or write a query that retrieves 100 rows at a time.

The data is loaded over a certain time period, say 1 hour. But when I try to retrieve it via PQ, I still only get 100 rows.

View attachment 24588
Loading more data... will disappear immediately if you achieve last row of 100 and next 100 will be loaded
If you want to see that you need too block scripts and you'll see picture above but it will not load the next 100, so unblock scripts and you'll see next 100
imho, they are not user friendly scripts

Thanks for the info.

 

[sandy666]

You are welcome

 

[karim00000000]

View attachment 24588
Loading more data... will disappear immediately if you achieve last row of 100 and next 100 will be loaded
If you want to see that you need too block scripts and you'll see picture above but it will not load the next 100, so unblock scripts and you'll see next 100
imho, they are not user friendly scripts

can you please clarify more ? i have same problem and can't find solution