Options for Downloading Daily OHLCV Market Data

Summary

The document asks about alternatives for downloading daily market data containing date, open, high, low, close, and volume fields into a spreadsheet. Its answer names several routes: retrieving prices with a Python finance library and exporting them to CSV, using a finance service directly in Excel, or using spreadsheet integrations from market-data providers. It also mentions a data-reader library as another possible route.

This is practical data-acquisition guidance for building a historical price file, rather than an analysis of trading methods or price behavior. The examples do not compare data quality, coverage, update frequency, licensing, or reliability, and the answer gives no evidence that each named service meets the requester’s needs. Data availability and spreadsheet features can vary by instrument and provider, so users should check the fields and date range returned before relying on an export for research.

Key ideas

• Daily OHLCV history can be retrieved programmatically and exported as a CSV file.
• Spreadsheet integrations from financial data services offer another way to obtain historical prices.
• The document names multiple possible sources but does not compare their coverage or data quality.
• Users should verify returned fields and date ranges before using downloaded data in research.

Tags

# Is there another data download program available like Q Collector Expert For DTN IQ Feed or from any other data source?


# Is there another data download program available like Q Collector Expert For DTN IQ Feed or from any other data source?












Is there another data download program available like Q Collector Expert For DTN IQ Feed or from any other data source? I am looking for a program that saves “Date” “Open” “High” “Low” “Close” ”Volume” Daily Data to an excel csv spreadsheet.

Q Collector seems to be Out Of Business and can’t be reordered.

## Answer by João (score 0)

https://quant.stackexchange.com/a/85346

Yahoo finance via Python to CSV:

```
import yfinance as yf

ticker= "^GSPC"
start_date = "2020-10-04"
end_date = "2025-10-04"

prices = yf.download(ticker, start=start_date, end=end_date)

prices.columns = prices.columns.droplevel(1)

prices = prices.reset_index()
prices.to_csv('SPX.csv', index=False)
```

You can also use YF directly on Excel

Bloomberg `BDH=` excel function, or `<AAPL>`, `<GPO>` then export to excel.

Refinitiv more or less the same..

Barchart I think they have some Excel connection

```
pandas_datareader
```

Example1 Example2

Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.