I received questions about how to create spreadsheets in Sierra chart, so here it goes, long thread. This is my process.

We will use 2 charts, 1 chartbook. Chart 1 is a time candle with various hi/lo time period studies for whatever you are looking at, I used 30 second candles.

Now how I prefer to do things is go to a daily candle chart and overlay the studies, this reduces the amount of data cleaning I need to do before analyzing, otherwise it would show OR row on every candle row. "Study/Price Overlay" is how I overlay studies.

Find your study you want and overlay it, rename it so it’s easier to find in the "short name:" section

After overlaying all the studies that you want, it will look similar to this on your daily candle chart, if you don’t rename it then all of your studies will look like the highlighted one and it can get confusing. Add this "spreadsheet study" to your daily candle chart.

Change the chart region to 1, hide the study, and make sure you get the amount of rows you want. If you do smaller time frame candles, you’ll obviously need to change the amount of rows. When you click apply, it will add a tab at the bottom called defaultspreadsheetstudy

And here is what some of the areas will look like, this area is the RTH daily candle open/hi/lo/close, I am not using this data, I am using overlaid data so scroll right..

And you’ll find this, but it’s not showing up for the opening range? See all the zeros?

If you go into settings and change the start time to 1 second after open, they will show up. I am not using candle data so idc about start or end time here. only that studies are properly overlaid.

And here they are! Copy the sheet by clicking on the red box, right clicking and copying. Transfer it over to google sheets or excel and start writing formulas.

You can use this in so many ways, this is just one example. You could find this information using 5 minute candles too without studies (see pic) but this way is just easier for me to get what I need with less cleaning as everything is already separated by daily lines.