Support Board

Date/Time: Sat, 20 Apr 2024 13:24:41 +0000

Post From: own research spreadsheet

[2023-05-26 02:08:36] Link To Thread - Link To Post [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.