Login Page - Create Account

Support Board

Date/Time: Thu, 01 Jun 2023 02:30:30 +0000

[User Discussion] - own research spreadsheet

View Count: 95

[2023-05-25 15:04:19]
MarcOh - Posts: 136
Hi folks,

Could an experienced user assist me in creating my own spreadsheet?.
I already tried it via "spreadsheet study", bu the abundance of cells and data are too cpu intensive.
more specific: "daily ohcl singlepoints" in tpo chart,so i can evaluate IB high and low in combination with rth high and low in one excel file.

Please take a quick look at the attached files.

Tank you very much!

imageScreenshot_6.png / V - Attached On 2023-05-25 15:01:11 UTC - Size: 141.39 KB - 25 views
[2023-05-26 02:08:36]
tomgilb - Posts: 3631
If your analysis is limited to comparing the RTH IB to the RTH HL, try this:

- Add a chart with these settings, e.g.:
Bar Duration: 0-30-0
Session Times: 09:30:00 to 09:59:59
this will give one bar per day of the IB.

- Add another chart with these settings, e.g.:
Bar Duration: 0-390-0
Session Times: 09:30:00 to 15:59:59
this will give one bar per day of the RTH.

- Add the Daily OHLC study to each chart, hide SG1 and SG4.

- Add the same-named Spreadsheet Study study to each chart.
each chart will have its own sheet, and each row will be one day, for easy comparison.

- Go to Spreadsheet >> Add Sheet, and give it a unique name.
this will open a blank sheet that is not associated with a chart.
On this blank sheet, reference the Daily OHLC studies on each sheet, e.g.:
Cell A1: =Sheet1!A3
Cell B1: =Sheet1!ID1.SG2@3
Cell C1: =Sheet1!ID1.SG3@3
Cell D1: =Sheet2!ID1.SG2@3
Cell E1: =Sheet2!ID1.SG3@3
where Sheet1!A3 is the Date, Sheet1!ID1 is the IB, and Sheet2!ID2 is the RTH HL
You can copy/paste row 1 to rows below, but unfortunately, you will have to manually edit each formula.
Now you can copy/paste the entire sheet to Excel.

If you don't want to use the added blank sheet, you could just copy/paste each of the HL columns from each spreadsheet sheet to Excel.
[2023-05-26 09:06:10]
MarcOh - Posts: 136
I will check this out later on. Thank you so much my friend. sy.

[2023-05-29 09:38:41]
MarcOh - Posts: 136
happy memorial day,

there we go. looks good so far. I would like to take this opportunity to thank you once again for your time!

imageScreenshot_1.png / V - Attached On 2023-05-29 09:35:00 UTC - Size: 44.54 KB - 8 views

To post a message in this thread, you need to log in with your Sierra Chart account:


Login Page - Create Account