Excel Download for FTSE100/250?

[98elise]

Years ago I downloaded a spreadsheet of the FTSE100, with 1 row per stock + all major financial metrics as columns (EPS, PE Ratio, Yield etc.). It might have been on the old Motley Fool forums

I can't seem to find similar wirh current data so does anyone know if there is a site where I can download it. The data is all freely available, just not in a simple table.

[GTPork]

Easy viewable online: https://www.tradingview.com/stock-screener/

Downloading to excel usually requires a paid subscription on this or similar stock screeners

[Mogul]

If you have a 365 subscription, you might be able to get hold of data directly though Excel…

I had a little play with this last year but gave up when it couldn’t find the funds I was interested in but the FTSE100 should all be there..

https://answers.microsoft.com/en-us/msoffice/forum...

[98elise]

GTPork said:

Easy viewable online: https://www.tradingview.com/stock-screener/

Downloading to excel usually requires a paid subscription on this or similar stock screeners

Thanks, that's exactly what I'm looking for.

I might be able to grab the data from the screen.

[98elise]

Mogul said:

If you have a 365 subscription, you might be able to get hold of data directly though Excel…

I had a little play with this last year but gave up when it couldn’t find the funds I was interested in but the FTSE100 should all be there..

https://answers.microsoft.com/en-us/msoffice/forum...

I'll have a play with that as well. I assume That would give me live data rather than a download.

I just want to use the data to adjust my pension and ISA investments, but it's something I'll need to repeat every 6 months or so.

[paulrockliffe]

98elise said:

Mogul said:

If you have a 365 subscription, you might be able to get hold of data directly though Excel…

I had a little play with this last year but gave up when it couldn’t find the funds I was interested in but the FTSE100 should all be there..

https://answers.microsoft.com/en-us/msoffice/forum...

I'll have a play with that as well. I assume That would give me live data rather than a download.

I just want to use the data to adjust my pension and ISA investments, but it's something I'll need to repeat every 6 months or so.

You don't need a subscription, every version of Excel in the last decade has Power Query and can connect to Web APIs and Web Pages. If you can find a suitable source, it's reasonably simple - there are blog posts that walk you through it - to get Excel to grab the data for you.

If you put, "stock prices api excel template" into Google there are hundreds of options there.

[basherX]

paulrockliffe said:

98elise said:

Mogul said:

If you have a 365 subscription, you might be able to get hold of data directly though Excel…

I had a little play with this last year but gave up when it couldn’t find the funds I was interested in but the FTSE100 should all be there..

https://answers.microsoft.com/en-us/msoffice/forum...

I'll have a play with that as well. I assume That would give me live data rather than a download.

I just want to use the data to adjust my pension and ISA investments, but it's something I'll need to repeat every 6 months or so.

You don't need a subscription, every version of Excel in the last decade has Power Query and can connect to Web APIs and Web Pages. If you can find a suitable source, it's reasonably simple - there are blog posts that walk you through it - to get Excel to grab the data for you.

If you put, "stock prices api excel template" into Google there are hundreds of options there.

Yes, but if you do already have the subscription the STOCKS data type is the easiest route to data.