Skip to main content

Export data

The OpenBB Terminal offers a variety of ways to export financial data. This can be to a text-based file - XLSX, CSV or JSON - or as images - PNG, JPG, PDF and SVG.

To export as a spreadsheet, xlsx, add --export xlsx to the command.

/stocks/load AAPL -s 2010-01-01 --export xlsx

Which creates:

Export Example

Specifying the Filename​

Instead of the default filename, it can be specified. Exporting as a csv this time:

/stocks/load AAPL -s 2010-01-01 --export apple.csv

Filename Example

Specifying a Target Sheet Name​

With the xlsx option, --sheet-name allows multiple datasets to be saved to the same file. For example:

/stocks/load AAPL -s 2010-01-01 --export apple.xlsx --sheet-name Market Data

Then enter the fa (Fundamental Analysis) menu. Copy and paste the code below to follow along. This requires an API key from FinancialModelingPrep which you can obtain for free. Please have a look here.

fa
income --source FinancialModelingPrep -l 10 --export apple.xlsx --sheet-name Income Statement
balance --source FinancialModelingPrep -l 10 --export apple.xlsx --sheet-name Balance Sheet
cash --source FinancialModelingPrep -l 10 --export apple.xlsx --sheet-name Cash Flow Statement

This generates a file for AAPL, with market data from 2010-01-01 until now, as well as the income, balance and cash flow statements from the last ten years.

Sheet Name Example

Export Directly From Charts​

See the interactive charts page for instructions.

On this page