Yahoo Data Downloads
Yahoo had a API which allowed the download of a lot of user-selectable data into a CSV file, for up to 200 stocks at a time. Unfortunately, this API was discontinued in November 2017.
There is an alternative Yahoo source, though less convenient. The following URL will provide a lot of data for VOD.L and BARC.L:
query1.finance.yahoo.com/v7/finance/quote?symbols=VOD.L,BARC.L
The data is returned in a JSON structure, which really requires the use of a programming language such as VBA (Visual Basic for Applications) or Python.
Any number of stock symbols (1000 or more) can be appended to the end of the URL, separated by commas.
There is an alternative Yahoo source, though less convenient. The following URL will provide a lot of data for VOD.L and BARC.L:
query1.finance.yahoo.com/v7/finance/quote?symbols=VOD.L,BARC.L
The data is returned in a JSON structure, which really requires the use of a programming language such as VBA (Visual Basic for Applications) or Python.
Any number of stock symbols (1000 or more) can be appended to the end of the URL, separated by commas.