Stock Market Share Price Download

PeterFenton

New Member
Joined
Mar 22, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Hi, Found the site with a google search and the question I have wasn't quite answered by other questions already raised.

So I want to download prices ( ok to be 15 minutes delayed ) for the FTSE100 , 250 , AIM etc

London Stock Exchange has this Table - FTSE 100 FTSE constituents | London Stock Exchange which is the sort of info I need for each index , but the only way I have found to download is manually ok for the FTSE100 as only 6 pages, however FTSE250 is 12 and AIM 42 I think so I haven't bothered with these.

Is there a way to automate the download as would be good to get away from manual download.

thanks

PF
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Just to bump this one as I've seen it viewed a few times .

Is it to difficult to achieve ?

PF
 
Upvote 0

Forum statistics

Threads
1,214,991
Messages
6,122,628
Members
449,095
Latest member
bsb1122

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top