SuperCharting
Sign in Get started Account Open charts

Learn / Features

Chart data export: download bars and indicator values as a CSV file

Chart data export in SuperCharting: download a chart's bars and every visible indicator value as a CSV file for Excel, Google Sheets or your own research.

Chart data export saves what a chart shows as a CSV file: one row per bar with its time, open, high, low and close, followed by a column for every indicator plot on that chart. In SuperCharting it is Download chart data… in the Manage layouts menu, and the file opens directly in Excel, Google Sheets or any tool that reads CSV.

What the CSV file contains

The file has a header row and then one row per bar:

ColumnContent
timethe bar's time, in UTC, as a Unix timestamp or ISO time
open, high, low, closethe bar's prices
one column per indicator plotthe plot's value on that bar, titled with the plot's name

Some details that matter when you work with the file:

The file is named after the symbol and interval, for example NSE_RELIANCE, 1D.csv or NSE_NIFTY, 15.csv.

The Download chart data dialog

The dialog has two choices:

Times are always UTC. An NSE bar that opens at 09:15 IST appears as 03:45 UTC; add 5 hours 30 minutes in your spreadsheet to show Indian time.

How to export chart data in SuperCharting

  1. Open the chart you want, for example NSE:NIFTY on 1 day.
  2. Add the indicators whose values you need, for example RSI and a 50-period EMA, and add Volume if you want volume in the file.
  3. Scroll back on the chart until it shows the start date you need.
  4. Click the small arrow next to the layout name in the top toolbar (Manage layouts) and choose Download chart data….
  5. Pick the Chart (in a layout with several) and the Time format (UTC).
  6. Click Download. The CSV file is saved by your browser.

This is done in a desktop browser; on a phone screen the Manage layouts menu is hidden.

Example: daily range statistics for NIFTY

Export NSE:NIFTY on 1 day with ISO time. In a spreadsheet, add a column =(C2-D2)/E2*100 for the day's high-to-low range as a percentage of the close (columns C, D and E being high, low and close). Average it over the last 250 rows and you have the typical daily range for the past year, a number many traders use to size stops and to judge whether today is unusually quiet or wild. Past ranges describe the past; they do not promise the same range tomorrow.

Exporting your own calculated values

Any value a script plots becomes a column. If you need a number that no built-in indicator gives you, write a short Pine-compatible script in the Script Editor, add it to the chart, then export. This one plots the bar's range and the 14-bar ATR as a percentage of the close, plus the volume:

//@version=6
indicator("Export helper", overlay=false)
rangePct = (high - low) / close * 100
atrPct = ta.atr(14) / close * 100
plot(rangePct, "Range %", color.teal)
plot(atrPct, "ATR %", color.orange)
plot(volume, "Volume")

The CSV then has the columns Range %, ATR % and Volume next to the prices. The Pine Script editor guide shows how to save and add a script.

Good uses for exported data

Market data from broker feeds is licensed for your own use. Keep exported files for your own research rather than publishing them.

Frequently asked questions

How many bars can I export?

As many as the chart has loaded, up to 40,000 per chart. Scroll back to load more before exporting.

Why is there no volume column?

Volume is exported through the Volume indicator. Add Volume from Indicators, then download again.

Are the times in my time zone?

No. The file always uses UTC, whatever time zone the chart shows. Convert in your spreadsheet if needed.

Can I export indicator values only for the visible range?

The file holds every loaded bar. Filter the rows by date in your spreadsheet.

Can I export the trades from the Strategy Tester?

This dialog exports bars and indicator plots. The list of trades is shown in the Strategy Tester itself.

Try it on a live chart

SuperCharting runs in your browser: charts, Pine-compatible scripts, the Strategy Tester, alerts and the screener, with Indian and global markets.

Create a free account More guides