I want to be able to download data from Sierra Charts via a spreadsheet for analytical purposes. Say that I want to download IB high and IB Low from an indicator I have on my chart for last 100 days or so.. I cannot figure out how to get it to my excel sheet.

Can anyone help?

Thanks,

Wolf

If you use the Spreadsheet Study study, you can set 'Use Excel' to Yes and the data will be outputted directly to Excel. This option is available but not recommended by Sierra.
You could also Copy/Paste from a spreadsheet study's spreadsheet to Excel.
Both of these options have number of rows limitations:
-max number of rows that can be copied.
-max setting of Number Of Rows might not cover 100 days on an intraday chart.

There is a cumbersome workaround for copying a large number of rows:
-Scroll the chart into the past, start a Chart Replay, then press Pause. This will align the right-most price bar to row 3 and allow you to see further into the past with rows below.

If you are not using VB, or graphs, you probably don't need to use Excel. The calculation could be done directly on the spreadsheet study's spreadsheet, or on a standalone spreadsheet. If you are using the Old Spreadsheets version, you can reference between spreadsheet study spreadsheets and standalone spreadsheets.

tomgilb 

If you use the Spreadsheet Study study, you can set 'Use Excel' to Yes and the data will be outputted directly to Excel. This option is available but not recommended by Sierra. You could also Copy/Paste from a spreadsheet study's spreadsheet to Excel. Both of these options have number of rows limitations: -max number of rows that can be copied. -max setting of Number Of Rows might not cover 100 days on an intraday chart. There is a cumbersome workaround for copying a large number of rows: -Scroll the chart into the past, start a Chart Replay, then press Pause. This will align the right-most price bar to row 3 and allow you to see further into the past with rows below. If you are not using VB, or graphs, you probably don't need to use Excel. The calculation could be done directly on the spreadsheet study's spreadsheet, or on a standalone spreadsheet. If you are using the Old Spreadsheets version, you can reference between spreadsheet study spreadsheets and standalone spreadsheets.

Thanks.. I see date and time is posted in some syntax I cannot recognize like 41950.6045. How do I decipher that?

THanks

Traderwolf 

Thanks.. I see date and time is posted in some syntax I cannot recognize like 41950.6045. How do I decipher that? THanks

The integer is the number of days since 1/1/1900, and the decimal is the percentage of the day since midnight.
If you format the cell for Date, it will visually convert it for you.

I don't know if this topic is still active or has been answered

However, if you want to download data (for me /CL, /6E) you can use the "Write Bar Data To File" study

It will create a text file with comma separated values in the Data Folder ie CLH5-BarData.txt

Keep in mind it downloads data exact same as chart settings and date range ie M5 last 20 days

I just finished downloading /CL 6-15-2014 through 2-6-14 for Globex to New York

In this case it is 1800 to 07:59:59 and 0800 to 16:59:59

I'm comparing Globex OHLC to New York OHLC

After you've done this either make hidden the study or remove and add it each time you need it (I think because it's a "study.")

-Bill