Home >> Support Board

Support Board

Date/Time: Fri, 26 Apr 2024 14:21:12 +0000

How to Post a Message for Support

[User Discussion] - own research spreadsheet

View Count: 237

[2023-05-25 15:04:19] #1 [Go To First Post]
MarcOh - Posts: 162
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! m.


Screenshot_6.png / V - Attached On 2023-05-25 15:01:11 UTC - Size: 141.39 KB - 71 views

[2023-05-26 02:08:36] #2 [Go To First Post]
Sawtooth - Posts: 3976
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] #3 [Go To First Post]
MarcOh - Posts: 162
I will check this out later on. Thank you so much my friend. sy. M.

[2023-05-29 09:38:41] #4 [Go To First Post]
MarcOh - Posts: 162
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! M.


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

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